>>CREATE CURSOR Test (Fld1 int, Fld2 C(20)) >>INDEX ON Fld1 TAG Test CANDIDATE >>APPEND BLANK >>*** Something happens here and the user quit the application >> >>*** Next time S/He needs to insetr new record: >>APPEND BLANK && BOOOOOOOOOOOOOOOOOOOOOOM >> >> >>*** But with this: >>CREATE CURSOR Test (Fld1 int, Fld2 C(20)) >>INDEX ON Fld1 TAG Test CANDIDATE >>INSERT INTO Test VALUES (2,-2) && BOOOOOOM, but no record is inserted >>INSERT INTO Test VALUES (2,[asasa]) >> >> >>*** Also: >>CREATE CURSOR Test (Fld1 int, Fld2 C(20)) >>INDEX ON Fld1 TAG Test CANDIDATE >>APPEND BLANK >>INSERT INTO Test VALUES (2,[asasa]) >>BROW NORMAL >>>
INSERT INTO Test (; Field1,; Field2,; Field3 ; ); VALUES; (; Expr1,; && Field1 Expr2,; && Field2 Expr3; && Field3 )