Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's wrong with Recordset?
Message
From
10/09/2004 11:46:18
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
10/09/2004 11:23:40
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Miscellaneous
Thread ID:
00941045
Message ID:
00941080
Views:
12
Of course there is but recordcount returning -1 suggest either provider doesn't support it or it's a forward only cursor.
Might it be that it's forward only and as you bind to flexgrid you get to last record? Not sure really. Try your do while ... enddo before binding if you haven't already.
Cetin


>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform