Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select * won't with dirty buffers.
Message
From
31/05/2002 17:45:46
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
30/05/2002 13:52:23
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00663134
Message ID:
00663695
Views:
23
>Hi All
>
>I ran into a new one to me. I am going against a Sybase database on this project and my framework is using only SQL passthrough. I set cursor buffering to 5 so I can find any changed columns using getnextmodified() and getfldstate(). What I have just found is if I have inserted data into a cursor (recno < 0) that vfps select statement can't retrieve the data. Is there a way around this?
>
>Thannks for your help.

SQL wouldn't work but xBase commands would do. Consider using GetNextModified(), svan..endscan, copy to array etc.
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
Next
Reply
Map
View

Click here to load this message in the networking platform