Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO recordsets and VFP
Message
General information
Forum:
Visual FoxPro
Category:
Object Oriented Programming
Miscellaneous
Thread ID:
00457793
Message ID:
00458220
Views:
17
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>Like the MSFlexGrid?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>
>Yes, but there are others, too - the hierarchical flex grid, the datagrid control (msdatgrd.ocx), and several third party products that bind to ADO recordsets.
>
>But, as you point out, this can make your app pretty ActiveX-heavy. Which is why I still think that dumping the ADO recordset data in and out of a cursor makes more sense, in more cases, for grid manipulation.
One issue is converting ADO FieldTypes to the receiving grid field types. The ADO RS does define fields as character(30) or Numeric. The RS structure designations vary with the source data. Example, RS returns a different type definition for a SQL field having 2 decimals, as compared to the definition it may return for a DBF. Check files (COM/DCOM/OLE) for the ADO Query Analyzer. I am not sure, but I suspect that and ADO connection (Record source) can forward update or insert (or pass data to a stored procedure). I'll try that later tonight.

But in many shops, using PT, the cursor is more or less for navigational support. Typically, Inserts and Update are done one record/row at a time.
HTH
Imagination is more important than knowledge
Previous
Reply
Map
View

Click here to load this message in the networking platform