Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's wrong with Recordset?
Message
From
10/09/2004 11:23:40
 
 
To
10/09/2004 11:08:46
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Miscellaneous
Thread ID:
00941045
Message ID:
00941065
Views:
12
Cetin,
No ways... I check oRecordset.CursorLocation = 2 (adUseServer). No ways to change it to 3 because Recordset is already open when ActiveX initialized. Also.. no ways to use Connection, Recordset is property of ActiveX.. which has data after GetDirList() call done.
Why FleXGrid.DataSource display right records and data? Is there way to work with Server side ADO recordset?

Thanks
Denis


>If you can touch connection object before it creates recordset :
>
>oConnection.CursorLocation = 3
>
>If you can touch recordsert object before it's opened :
>oRecordSet.Cursorlocation = 3
>
>Cetin
>
>>Cetin,
>>Would be nice to know how can I create clientside cursor.
>>This recordset is property of FTPX Activex control. When GetDirList() method done this recordset contains files and directories on FTP server.
>>I try loRecordset.Clone() - it bring error...
>>What should I do?
>>
>>Thanks
>>
>>>Create a clientside cursor (recordcount would then show actual recordcount). Next do not code like that, IMHO :
>>>
>>>loRecordset.MoveFirst()
>>>DO WHILE !loRecordset.EOF
>>>  ?loRecordset.Fields("Name").Value
>>>  loRecordset.MoveNext()
>>>ENDDO
>>>
Cetin
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform