General information
Category:
Coding, syntax & commands
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only