General information
Title:
Cannot update de cursor
Hi everebody
I have a problem to update the cursor winth Visual Foxpro 5.0 when I updating two tables sequencialy. In development mode when the application is running, I have no error message, but in execute mode I have an error message "Cannot update the cursor"
the first table table is updating but the second not ....
This my code.
select so_customers
idcust = so_customers.cust_id
namcust = so_customers.cust_name
csa = so_customers.cust_csa
csr = so_customers.cust_csr
*
select so_master
m_so = so_master.So
m_po = so_master.Po
m_item = so_master.item
m_status = so_master.status
m_statdate = so_master.stat_date
*
select so_master
REPLACE so_master.cust_id WITH so_customers.cust_id
REPLACE so_master.customer WITH so_customers.cust_name
REPLACE so_master.cust_csa WITH so_customers.cust_csa
*
******* THIS TABLE IS NOT UPDATED *****************(ERROR MESSAGE"CANNOT UDATE THE CURSOR)
select so_status_orders
set order to
INSERT INTO so_status_orders (cust_id, cust_name, cust_csa, cust_csr, So, po, item, Status, Stat_date) ;
VALUES (idcust, namcust, csa, csr, m_so, m_po, m_item, m_status, m_statdate)
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