>I have a local cursor ( search ). I have an external ODBC data source with a particular table that I would like to INNER JOIN with based on a projectID field in my local cursor.
>
>Is it possible in an SQLPREPARE() to specify a JOIN condition with a local cursor or am I pushing this too far ? If it is possible, what might the syntax look like ?
>
>Thanks
Bruce,
I think your best bet is to create a temp. table on your backend database, send the data from your local cursor, and then do the SQL on backend.
HTH
regards
Ian