Information générale
Titre:
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)
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement