I have a foxpro billing system, which is updating MS SQL database remotely. Following is a one of SQL INSERT I use when saving the billing;
chkTrn=SQLEXEC(ln,"INSERT INTO trnnumber (serial, _user, dt, module, remark, idn) VALUES ((SELECT ISNULL(MAX(serial)+1,1) FROM trnnumber),?muser...