Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursor
Message
 
À
15/01/2014 04:49:02
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Re: Cursor
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01591784
Message ID:
01591950
Vues:
31
many thanks dragan for clarification.
k

>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform