INSERT INTO customers VALUES ("C0001","Acme Corp","info@acme.com",1250.00) Show records:
BROWSE Create a CDX index and set an order: visual foxpro 9 made simple pdf best
THISFORM.DataSession.DataEnvironment1.YourCursorTable.TABLEUPDATE(.T.) Example Add button: INSERT INTO customers VALUES ("C0001","Acme Corp","info@acme
INSERT INTO invoices (invoiceid, custid, invdate, total) ; VALUES (STR(TTOD(TODAY()),6), "C0001", DATE(), 0) Add items and recalc total: INSERT INTO customers VALUES ("C0001"
DEFINE CLASS MyApp AS Custom PROCEDURE Init WAIT WINDOW "App started" TIMEOUT 1 ENDPROC ENDDEFINE o = CREATEOBJECT("MyApp") Use TRY/CATCH for safe updates:
CREATE TABLE customers ; (custid C(5), ; name C(50), ; email C(80), ; balance N(10,2)) Add a record:
INSERT INTO customers VALUES ("C0001","Acme Corp","info@acme.com",1250.00) Show records:
BROWSE Create a CDX index and set an order:
THISFORM.DataSession.DataEnvironment1.YourCursorTable.TABLEUPDATE(.T.) Example Add button:
INSERT INTO invoices (invoiceid, custid, invdate, total) ; VALUES (STR(TTOD(TODAY()),6), "C0001", DATE(), 0) Add items and recalc total:
DEFINE CLASS MyApp AS Custom PROCEDURE Init WAIT WINDOW "App started" TIMEOUT 1 ENDPROC ENDDEFINE o = CREATEOBJECT("MyApp") Use TRY/CATCH for safe updates:
CREATE TABLE customers ; (custid C(5), ; name C(50), ; email C(80), ; balance N(10,2)) Add a record: