>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.

Why not just select the single record.. since you have a cursor with the PK... the user looks at the list, they select a record to display, you do a select where pk = ?cursor.pk and get that record.

You may have more traffic, but you are only pulling one record at a time this way.

BOb