Search results for query: *

Hi all I have a spreadsheet with a Calender object which returns a selected date via the linked cell property. I then need to use this selected date to perform a vlookup on a second spreadsheet. I know the vlookup code is correct as when I manually type the date into the linked cell, the lookup...

Help! I have just one user who keeps on getting this message when trying to access a table (paradox). I have read quite a bit about this error and understand it to be something about the BDE and not a programatical error as I first thought. What I need is the help of someone who has come across...

Hi all, In my application there are numerous reports all created with QuickReport. These are all stored in DLL's to keep the size of my application down and they all work fine. One of my users however, called a report which previewed on screen correctly. When he came to print the report however...

Is there anyway in SQL of searching a field without case sensitivity? For example: Select * from MyTable where Surname = "MacDougal" would return exactly the same results as Select * from MyTable where Surname = "Macdougal" and all other capitalisation variations of the...

I am having a little problem using a query to return a set of results from a paradox table. Hopefully somebody can point out what I am doing wrong. BookQuery.SQL.Clear; BookQuery.SQL.Add('Select * from Bookings'); BookQuery.SQL.Add('where BOOKDATE >= ' + QuotedStr(RangeStart))...

Is there a command to empty a queries results like EmptyTable? At the moment I am using the delete command in a loop as there is never more than ten records retrieved but every other time I try to run the procedure, I receive an "Update failed" message. Does anybody have any ideas...

I am receiving the following error when trying to edit a record in an IBQuery. "feature is not supported BLOB and array data types are not supported for compare operation" The following SQL code is used to select the record to edit. Select * from Bookings where BOOKING =...

I have converted the old TTable components in my application to TIBTable components, but I am actually seeing a decrease in speed thus far! I am sure that this is because to get the system running, I had to replace my old FindKey statements with locate which is a lot slower! What would be the...

Stage III of the masterplan! I now have the database created, the code of my application is beginning to take shape, all should be well! I am however stuggling to setup the system across the network! I have setup Interbase on a networked machine and transferred my Database to there. This is...

Hello again, How does Interbase handle Indexes? I have managed to create a database, convert my dbf files and altered the code of my program accordingly (see my other post here). The only problem I am getting now is that every time my program tries to set an index, it is returning the error...

I have been researching Client Server relationships on the internet and believe that Interbase is a possibilty! I have my application (written in Delphi) which already uses quite a few SQL Queries to access my .dbf files (most searching however is done using the indexes and FindKey). My...

Hello all, problem time again! I have written my application which is accessing several large tables (10,000 + records) and a host of smaller tables (all of them are .dbf files). The application is installed on several machines in an office and the datapath is changed on all machines bar one so...

Hello again My application is all but done now, however I have discovered that it barely runs under Win95/98/ME (Win32 API error). From all the research I have done this morning I have discovered that the problem is down to Win95,98 & ME only allocating a certain amount of memory for handles...

Hi all, I have a large DBase containing a list of invoices which is linked to a customers table via a unique Custoomer Number. On my screen there is a DBGrid showing the customers info and a listview in report style to show the corresponding invoices which are displayed when the user selects a...

I am a programmer and recently received a call from a company which purchased an application about two years ago. At the time they had been extremely specific about what it should and shouldnt do. These guidelines were strictly followed and they have now discovered that there is actually a bug...

Hi all, Because quickreports combined with all the code required to generate my reports adds so much to the executable size, I have set up every report as a DLL. The DLL's are called using the following code var Listing : procedure (My Variable); MyLib : THandle; begin MyLib :=...

Does anybody know if it is possible to make a column in a stringgrid contain a simple mask. I have a grid containing a few fields and the last one will always be a date field as follows. TITLE FORNAMES SURNAME DOB Mr Fred Bloggs 01/01/1956 Mrs Freda...

Hi all, I can successfully call my DLL's and run their code then close them using the loadlibrary, getprocaddress procedures absolutely fine. My problem is that one of these DLL's creates two integer values which need to be returned to my main application and as I only started creating DLL's on...

Hi I have just written my first DLL using the examples both in the delphi help pages and in past posts on these boards (many thanks McMerfy). I have it working fine using the following code. hLib := LoadLibrary('C:\MyFolder\Reports.dll'); if (hLib <> 0) then begin try @MyProc :=...

My program is working fine when running under Delphi and users can install it fine. They can also run it fine once installed, providing they arent using Win98! Some Win98 users are having problems when they try to run the program. Before the program is created it returns a win32 error. I have...