Recent content by Svanhooft

hi, A query could look like this: select * from table where datefield = Cast('04-19-2004' as Date) hope this helps Steph [Bigglasses]

Hi, if i'm correct there is a file within the bde files called bdeinst.dll. In this dll, the complete bde is present. I have writen a simple program to install the bde at the moment the program using the BDE is launched. function BDEInstalled: Boolean; begin Result := (dbiInit(nil) = 0) end...

hi, I made a demo with two forms. The first form has a button. In the onclick event of the button i show form2. Pressing enter on the second form closes the form2 returning to form1. The only thing i did was putting the next code into the onKeypress event of from2: procedure...

hi query is: select sum(Price) Total from Product result is Totalvalue := qry.FieldByname('Total').value; Steph [Bigglasses]

hi, The result is in : Name := qry.fieldbyname('Custname').value; After executing an query the result is like a table with the name of the TQuery object as the table name. Steph [Bigglasses]

hi, The date and time are updated on closing the database not on every writing event. If you want to see the date and time change close and open the database after the post. An alternative is to start using queries. You donn't have to open the database and the date and time are changed...

hi, If you use the BDE then you have to flush the buffers from the BDE. Include BDE in the uses file and then implement after the POST on the table the next command: DbiSaveChanges example: procedure TForm1.Table1AfterPost(DataSet: TDataSet); begin DbiSaveChanges(Table1.handle); end...

hi, dutil32 is a program made by borland along time ago and never been updated. Running this program rebuilds the database and in 99% of the cases the error is gone. The blob error occurs when there are problems with updating a table. In a network you get this error when you donn't force the...

hi, The error can be removed with the dtutil32 program. Steph [Bigglasses]

hi, Why use locate is you can do the same with a query: Select * from table where name = '%SMITH%' order by will give alle the people with SMITH in the name. Steph [Bigglasses]

hi, Experience and google. Steph [Bigglasses]

hi, I changed your code a bit and it is now working. procedure TForm1.createPage(); var t : TTabSheet; w : TWebBrowser; p : TPanel; begin t := TTabSheet.Create(PageControl1); with t do begin PageControl := PageControl1; Name := 'TabSheet' + IntToStr(pageN); Caption :=...

Hi, Queries donn't have indexes. Select * from Table where ssn = variable order by ssn Will return a table sorted by ssn and all the records with ssn equal to the variable. Variable could be an edit1.text. hope this helps Steph [Bigglasses]

Hi, This a way to change your hint completly. Create a new project with and put a button on the form, Set the hint to True. And replace the code of unit one the code beneath: // start unit Unit1; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms...

hi, ExtractFilePath will return the drivepath, Application.exename will return the name of the application. ExtractFilePath(Application.ExeName) + Application.ExeName Steph [Bigglasses]