Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO RecordSet without a connection
Message
From
25/01/2002 17:41:17
 
 
To
25/01/2002 17:33:21
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Miscellaneous
Thread ID:
00609675
Message ID:
00610884
Views:
14
Thanks.

Since this is in VB, how would I translate the "Array" function or do I just create a foxpro array?

Dan

>It's possible. See http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q196029
>
>>>
>>>Here is a simple example of doing this:
>>>
This.oDetlRS = CreateObject("ADODB.Recordset")
>>>With This.oDetlRS.Fields
>>>	.Append("FileName", adChar, 15)
>>>	.Append("Process_id", adInteger)
>>>EndWith
>>>This.oDetlRS.Open
>>>After this you can use AddNew to populate the recordset.
>>>
>>> If you would rather use a batch update, you need to persist an empty recordset obtained from the backend so that you won't need a connection in order to open and populate the rs at the client, and when you send it to the DLL you can BatchUpdate all rows at once. HTH
>>
>>
>>Have you ever created an empty shape? Just today I was thing about using the MSHFlexGrid which requires a shape. I'm not using ADO to get the data so I thought about creating and empty shape and filling it from Fox cursors.
>>
>>Can that be done?
>>
>>Dan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform