Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor
Message
From
15/01/2014 04:49:02
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
14/01/2014 20:30:46
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Cursor
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01591784
Message ID:
01591896
Views:
33
>Sorry Tore, I misstated the problem - there are no errors on the other hand it has no visible effect
>I assumed the query table would open up to allow edit after the readwrite command.

It becomes visible only when you try to change a value in your cursor and don't get an error. Mind you, it doesn't change anything in the source table(s) - your changes live only as long as the cursor lives. It may change the source tables if you went through certain steps (there's a way to make cursor updatable back to the source table, even if it's on a SQL or other server, and it includes setting many properties, like table to update, source field names, primary key name).

And, ahem, there's no query table. The cursor is a cursor, a table-like entity which behaves generally like a table (has alias, buffers, recno() and other alias-related functions work on it) but does not necessarily exist on disk, and if it does, it's a randomly named .tmp file, which vanishes (along with any indexes) as soon as you close the cursor.

The other significant difference: you can have one structural index on a readonly cursor; on readwrite, you can have as many as you want.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform