Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using ADO with foxpro front-end
Message
From
17/09/2002 02:12:30
 
 
To
16/09/2002 22:48:08
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00701058
Message ID:
00701103
Views:
15
Hi Nancy,

Actually, you *can* bind controls to field values of ADO recordsets. You're right, the forms won't be ADO aware but you can manually enter a field value as a ControlSource if you know that recordset will be preent at runtime. However, you still need a mechanism to update the current field values back to the source database or refresh the local values.

>>Hi all,
>>can VFP6 handle ADO recordsets to populate the forms? or do you have to step through the recordset and copy to a foxpro table/cursor?
>
>Yes, you can *use* ADO recordsets, but you can't bind controls to them. Whether you convert them to cursors or whether you make your forms ADO aware is a design choice. If you have control over the design and it's a new project, it's probably best in the long run if you use an n-tier approach rather than tying your forms to data directly, regardless of the format.
>
>Are you using, or could you use, a framework?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform