Roman,

You can scan the cursor for IsSelected and create a comma delimited list of primary keys. Then, use that list in an IN (lcList) clause of the next query. Or you can create a stored proc that takes that comma delimited list as a parameter. Something like that.

HTH,
Chad


>Client app: VFP8
>Server DB: SQL 2000
>
>There is a SQL table. I get data from that table into VFP cursor by SQLEXEC(). I add 1 field on the fly "1 AS IsSelected". The cursor is a datasource for a grid. Grid rows have checkboxes. Checkboxes column is bound to IsSelected field. User can make multiple choice by checking those checkboxes on and off. I need to run a query on another SQL table based on user selection.
>
>How would I pass user selection back to SQL? What are my options?
>
>Thanks.