Search results for query: *

Dear Experts I need to do a small automation for one my client. He does online business, as soon as he invoiced a customer, he should communicate this invoice to the courier company. The courier company has send us the following php based api could anyone help me to convert this into foxpro...

Thank you Chriss, I am using the max function because the sql auto increment just jump by 1000 for some of my tables, and I could not eliminate this. Chriss as I mentioned I check for the OBDC related errors while issuing the connection handle using the try and catch then catch the error. Thanks.

Thank your Mike for your valuable comment and advice. I am checking the connection handle at the beginning for other errors using try and catch method and assume only network related errors could occur during the insert/update process that's why I do this in a loop. BTW, could you please...

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...