Recent content by sircalleba66

Thank you Sir Olaf, my Purchase Entry works, your explanations helps me a lot. Cris

Thanks Sirs, I will recheck my code.

Hello Sir actually here is my code: SQLSETPROP(_SCREEN.oApp.nConnectionHandle,"transaction",2) TEXT TO lcSql_UpdateInventory NOSHOW UPDATE detailinv SET Quantity = ?m.lnQty where prod_id = ?m.lcProd_id and lotno = ?m.lcLotno and expdate = ?m.lcExpdate ENDTEXT IF...

Oh btw I am using VFP and MySQL is my back end.

Hello, How to manage a data conflict if more than one users write at the same time of a particular record(s). Thanks

Thanks Sir It works. BTW Sir when to issue a SQLDisconnect command, after closing the form?

Actually Sir Mike, I am new to MySQL and I know I'll have to dig deeper into MySQL and I thought using MySQL as back end is not complicated. Thanks you very much.

Sir I tried you code but I've got an error alias 'curlast' not found.

Thanks for your quick reply. BTW I am using MySQL as backend.

Hello How can i get tha last insert id. my Code like this. SQLSetprop(_Screen.oApp.nConnectionHandle, 'Transactions', 2) TEXT to lcSQL noShow INSERT INTO customer(FirstName,LastName,Address,Phone,Email,CreditLimit,Company,CompanyAdd,CompanyPhone) VALUES (?.lcFname...