>yes
>
>
>
>but i want when i do my tableupdate, the line will be inserted
If the CA is updatable the line will be inserted after you do TableUpdate().
If the record is not inserted you break some SQL Server rules, so you must check for errors:
INSERT INTO CA ....
IF NOT TableUpdate(1,.t.,[CA Alias here])
AERROR(laError)
MessageBox(laError[1,2])
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.