Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query remote data
Message
 
 
To
15/09/2005 14:21:17
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01050017
Message ID:
01050035
Views:
13
>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?
>
You can use XML as shown in Re: Sending a list from vfp Message #829213
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform