🚀 go-pugleaf

Erik,

I read your answer but I do not understand how to connect to a table in an
ACCESS database. Could you explain
how to > Associate it with the Database > ?


thanks,


Jur van Oerle



"Erik Bakker" <Nieuws@bakkertjes.demon.nl> schreef in bericht
news:bqht0c$1u2$1@reader08.wxs.nl...
> Drop an TQuery on your form
>
> Program in an event:
> Query1.Active := false; // otherwise you can't modify
> Query1.SQL.Clear;
> Query1.SQL.Add ('Select * from....)
> Query1.SQL.Add ('where ...');
> Query1.SQL.open; // for an select, for other SQL use Query1.SQL.ExecSQL;
>
> Now you have the results in the Query1 and you can use the cursor to read
> them
>
> for i := 0 to Query1.RecordCount -1 do
>     Query1.FieldByName ('tax').asinteger := 17;
> etc.
>
> Regards, Erik.
>
>
> Ralph Wesseling <Ralph@REMOVEnumberworks.com> schreef in berichtnieuws
> 3fba8fab$0$58714$e4fe514c@news.xs4all.nl...
> > Hello,
> >
> > I am a bit new to database programming so I may be asking the obvious
> here.
> >
> > I have an Access database  (myDatabase) that contains a number of
queries
> > (e.g. Query_Basis_For_TAX_INVOICE). I would like to get the underlying
SQL
> > statement form these queries and use it inside my Delphi App. Can any
one
> > provide me with an example to do this?
> >
> >
> > Help would be most appreciated
> >
> >
> > Ralph
> >
> >
>
>