Information générale
Catégorie:
Codage, syntaxe et commandes
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.
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