Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can SQL Cursor update existing table?
Message
De
11/03/2004 14:43:41
N. Lea
Nic Cross Enterprises
Valencia, Californie, États-Unis
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00885304
Message ID:
00885334
Vues:
22
Nothing that explicit. Basically just use the:

select * from customer_main_data ;
into cursor sql_customer_main_data

if the user modifies one field in the cursor sql_customer_main_data, then the customer_main_data table is open, and I guess the account name would be searched out and thus replace it somehow after it verified everything.

>If it is a cursor created by something like SQLEXEC(), then you have to use SQLEXEC() to send the UPDATE command back to the server. If this is a Remote View, then you can use TABLEUPDATE() to send the edited data back to the server. However, a cursor whose source table is in a DB like SQL Server or Oracle can be made updatable so you can use TABLEUPDATE() function.
>
>If you provide some more information about the DB, cursor, local or remote view, etc., we can provide a better [more complete] answer.
>
>>Hello,
>>
>>I was wondering. I have a huge customer table accessed by numerous people through terminal services. I am trying to change the format for lag and integrity of a table sake. I have certain data being extrated by sql-statement into a cursor. Now is it possible to have the cursor reference by to the original table when a change is made in the readwrite cursor? For instance, they change the phone number, the system would seek out the customer information in the original table and make the change with out problems?
>>
>>Thanks in advance.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform