Subject | Interacting VFP Cursor with FireBird Tables using SQL Pass through |
---|---|
Author | Bhavbhuti Nathwani |
Post date | 2007-10-25T07:31:49Z |
Hi all
I have a local list of accounts PK in a VFP cursor. Based on which I
intend to do an SQL pass through and retrieve the account details from
FireBird table using something like this in the SQL Pass through:
SELECT * FROM mAccounts WHERE mAccounts.iID IN (SELECT iID FROM
curSelected)
here mAccounts is the FireBird table and curSelected is the VFP cursor.
Please advise how can I go about achieving this.
Thanks.
I have a local list of accounts PK in a VFP cursor. Based on which I
intend to do an SQL pass through and retrieve the account details from
FireBird table using something like this in the SQL Pass through:
SELECT * FROM mAccounts WHERE mAccounts.iID IN (SELECT iID FROM
curSelected)
here mAccounts is the FireBird table and curSelected is the VFP cursor.
Please advise how can I go about achieving this.
Thanks.