Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What's wrong with Recordset?
Message
De
10/09/2004 11:46:18
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
10/09/2004 11:23:40
Information générale
Forum:
Visual FoxPro
Catégorie:
Contrôles ActiveX en VFP
Divers
Thread ID:
00941045
Message ID:
00941080
Vues:
14
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform