Tracey Maule wrote:
> unfortunately your help didnt help because i am stuck with 
> needing two where clauses from 3 tables, and interbase will 
> not allow joins in subqueries
> looks like i will be changing 1540 records by hand

This is where SQL doesn't work and where the old fashioned
non-client/server way of coding file access will work best.  I'm not
familiar with Interbase but I presume you can access records manually
based on seeding a specific index and looping through whatever records
or tables you need.  You just have to write a bit of code.

Regards,
Ross.
---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/

Reply via email to