General information
Category:
Coding, syntax & commands
I have the following SQL view statement:
SELECT Customer.c_id, Articlesend.c_orderid, Articlesend.d_sent,;
Articlesend.l_resend, Articlesend.i_quantity, Customer.c_first_name,;
Customer.c_last_name, Customer.c_suffix, Customer.c_title,;
Customer.c_street1, Customer.c_street2, Customer.c_city,;
Customer.c_state, Customer.c_zip_code, Customer.c_zip_suffix,;
Articlesend.c_product_id, Customer.c_organization,;
Orders.c_order_id AS orderid, Orders.d_order_date;
FROM subscription!articlesend INNER JOIN subscription!orders;
FULL JOIN subscription!customer ;
ON Orders.c_id = Customer.c_id ;
ON Articlesend.c_orderid = Orders.c_order_id;
WHERE SUBSTR(Articlesend.c_product_id,1,3) = ?c_region_id;
AND EMPTY(Articlesend.d_sent) = .T.;
OR (Articlesend.l_resend = .T.)
On the update criteria I have Articlesend.c_orderid as the key and articlesend.d_sent and articlesend.l_resend as the write to fields. This seems to work fine when I am only working with one record that exists in the articlesend table but when I have multiple record I get update conflict error 1585. The situation is this in the articlesend table I can multiple records which I want to update put am only pulling out info from the customer table for label creation. The view is table buffered. Any ideas on what I am doing wrong here.
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