> I looked at another recent post ("SQL Statement" by Golden (03-30-02)) that
> had a similar question with Paradox aliases.

> Unfortunately I could not get the suggestions to work with Access MDB files
> and I cannot find any other references at this time.

> New to Delphi, I worked in app dev for Progress Software (www.progress.com)
> I am more than likely missing something obvious to many of you.

> The SQL statement is in form1.query1.SQL.  I'm assuming this could just as
> easily go in a procedure?

> Any ideas/suggestions and pointers to reference works much appreciated.

> Regards,

> Jef Fowler

> Thank you, but I am still getting errors.

> I added the tablename and fieldname ie.
> "C:\..\DB1.MDB".TABLEA.FIELD1 = "C:\...\DB2.MDB"TABLEB.FIELD2

> Actual code..
> select * from socparent
> where "F:\program

> Get a
> "General SQL error
> Syntax error in PARAMETER clause."

> I have been through the code and eliminated a couple of typos
but same
> error.