Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: James Frye
  Where is James Frye?
 Wilmington
 North Carolina - United States
 James Frye
 Tags
Subject: Help with MS SQl newbie
Thread ID: 253326 Message ID: 253326 # Views: 61 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, February 11, 2010 7:03:26 PM         
   


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.



COMPLETE THREAD
Help with MS SQl newbie Posted by James Frye @ 2/11/2010 7:03:26 PM
RE: Help with MS SQl newbie Posted by Borislav Borissov @ 2/11/2010 7:09:31 PM
RE: Help with MS SQl newbie Posted by Stefan Wuebbe @ 2/11/2010 7:09:48 PM
RE: Help with MS SQl newbie Posted by Cetin Basoz @ 2/12/2010 1:15:17 PM
RE: Help with MS SQl newbie Posted by James Frye @ 2/17/2010 5:29:23 AM
RE: Help with MS SQl newbie Posted by Anders Altberg @ 2/17/2010 12:51:37 PM
RE: Help with MS SQl newbie Posted by Cetin Basoz @ 2/17/2010 10:22:35 PM
RE: Help with MS SQl newbie Posted by Anders Altberg @ 2/17/2010 11:35:27 PM
RE: Help with MS SQl newbie Posted by Anders Altberg @ 2/17/2010 11:36:33 PM