Hi Maynard,
it should be:
=CURSORSETPROP('KeyFieldList', 'snd_id,snd_batch')
Armin
>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.