Information générale
Catégorie:
Codage, syntaxe et commandes
I'm having trouble appending records to an AS400 table using SQL. My code looks something like this:
**Send records to AS400
CREATE SQL VIEW icsmctlpf_sql REMOTE CONNECTION edi_devo AS ;
SELECT *;
FROM CCEDI.ICSMCTLPF Icsmctlpf
USE icsmctlpf_sql IN 0
SELECT icsmctlpf_sql
=CURSORSETPROP('KeyFieldList','snd_id','snd_batch')
=CURSORSETPROP('SendUpdates',.T.)
The first CURSORSETPROP() command, results in an error stating that "No table is open in the current work area." However, the ALIAS() and SELECT() commands indicate that the correct table is indeed selected. I wondered if the issue somehow results from the fact that the AS400 uses a combination of several fields as the key. Fox help states that the keyfieldlist parameter is a comma delimited list of key fields so it should allow several.
Any help on this would be greatly appreciated.
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