Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can SQL Cursor update existing table?
Message
From
11/03/2004 14:43:41
N. Lea
Nic Cross Enterprises
Valencia, California, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00885304
Message ID:
00885334
Views:
21
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform