General information
Title:
A clean way to do this - join cursor with SQL
We're converting our VFP app to a dbc-less VFP -> SQL Server application. On one of the forms, during a data entry session, the user adds new customers. One requirement is to keep track of the customer records added during the data entry session so that the user can go back to any of those records during the session. The implementation before was to store the keys in a cursor, then when the user wanted to see a list of those they added during the session we'd do a SELECT joining that cursor with the customer table.
Now, using SQL passthru (no DBC, so no views) any suggestions how to provide that same functionality? We've discusses a number of ideas, but looking for other suggestions. We don't want to bring down the entire customer table from SQL with passthru.
Thanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only