Hello fox experts,
I am trying to use SQL Server for the first time. I have read thru the post and really need a quick 'how to' on writing to sql server.
this code does not error, nor does it update the server:
Store ALLTRIM(customer.Name) To cName
Store Alltrim(customer.phone1) To cPhone1
Store Alltrim(customer.Comment) To cComment
Store Alltrim(customer.wrkphone) To cCophone
Store Alltrim(customer.Work) To cWork
NHANDLE = SQLCONNECT("sqlconnectIntranet")
NRESULT = SQLEXEC(NHANDLE, "INSERT INTO tasks (contact_fu, contact_or, contact_wo,contact_fa,contact_ur,user_id_assign_to);
VALUES (cName,cWork,cWorkphone,cPhone1,'Import from DT',1)")
=Sqlcommit(NHANDLE)
Any help would be greatly appreciated.
The best is yet to be.