No what I mean is I have an access application with usual things like tables, queries, reports etc. That is in place.
I want to be able to change an Access Query in Delphi using OLE. I.E change the query that is in the Access Application from with in a Delphi app I have, not using ADO but OLE Automation. On Mon, 2004-09-06 at 17:25, Like Magic wrote: > hi > just open it up in the sql design view - bang in ther sql you have - where > there are parameters put square brackets around them with the name with out > the semicolon > table names are the names as they appear in the table view screen(which may > different to the actual table if they are external links) > Fields are tablename.field > Access will give half intelligent answers to errors > > the other way is create a rough query with the tables in the normal design > view then change to the sql view and fine tune > > maurice > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of James Sugrue > Sent: Monday, 6 September 2004 4:34 p.m. > To: NZ Borland Developers Group - Delphi List > Subject: RE: [DUG] Delphi code to change Query from Access Application > > > Yeah, I want to change the code from Delphi, rather than Access. > > On Mon, 2004-09-06 at 15:53, Like Magic wrote: > > Hi, > > In Access you can change to sql design view which shows you the microsoft > > sql query. note you can optimise this considerably from what is shown. You > > will also need to check the passing of parameters to the query. > > > > Maurice > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of James Sugrue > > Sent: Monday, 6 September 2004 3:06 p.m. > > To: [EMAIL PROTECTED] > > Subject: [DUG] Delphi code to change Query from Access Application > > > > > > Does anyone have know how to change a Query from an Access application > > in Delphi code? > > > > Cheers > > > > _______________________________________________ > > Delphi mailing list > > [EMAIL PROTECTED] > > http://ns3.123.co.nz/mailman/listinfo/delphi > > > > > > _______________________________________________ > > Delphi mailing list > > [EMAIL PROTECTED] > > http://ns3.123.co.nz/mailman/listinfo/delphi > > _______________________________________________ > Delphi mailing list > [EMAIL PROTECTED] > http://ns3.123.co.nz/mailman/listinfo/delphi > > > _______________________________________________ > Delphi mailing list > [EMAIL PROTECTED] > http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
