James,
this works in VFP 9 only. I need to run my application in VFP 7 since VFP 9 application does not start in Win 98.
Also, in case of backend error in INSERT command, VFP sends automatically a ROLLBACK command to backend. This discards all added rows (see other message).
How to fix those two problems ?
Andrus.
>How about Scatter name otable memo
>insert into mytable from name otable
>
>
>>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 ?
Andrus