James,

thank you.
I have lot of columns in table and lot of memory variables.
scatter memvar memo overwrites memory variables which have same names as table fields. So I cannot use it.

How to avoid existing memory variable destroying ?


>Andrus,
>
>I would not use append from and insert each row.
>
>

>select mytable
>scan
>  scatter memver memo
>  ?m.pk
>  insert into newrecords from memvar
>  skip in mytable
>endscan
>

>
>>I need to add records to a table in PostgreSQL server .
>>
>>I ceated a SPT cursor mytable and made it updatable.
>>It has row buffering enabled. VFP sends each row as separate INSERT command to backend.
>>
>>I use the following code to add records to sql server:
>>
>>

SELECT mytable
>>APPEND FROM dbf('newrecords')

>>
>>Some record violates referential integrity and this causes error
>>in APPEND FROM line
>>
>>Connectivity error: ERROR: insert or update on table
>>"mytable" violates foreign key constraint "mytable_customer_fkey"
>>
>>How to determine the record in newrecords table which causes this error ?
>>Which is best way to add many record so that the row caused error can be determined ?