Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot update de cursor
Message
From
27/11/1998 11:12:25
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Cannot update de cursor
Miscellaneous
Thread ID:
00161955
Message ID:
00161955
Views:
51
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
Map
View

Click here to load this message in the networking platform