Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Date to SQL DateTime
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01205160
Message ID:
01205472
Views:
16
>I get no error code back.. and it creates the records ok

You did say in the previous message that you got error with '?", didn't you?

>Code is below and Doc_Date is a Dtae Time field in SqlServer
>
>
> myn = SqlExec(lnHandle,"Insert into Docs " +;
> "(Doc_ref, Doc_Type, Doc_from, Doc_to, Doc_Compan, Doc_Claim, Doc_MeetWi,;
> Doc_MeetAr, Doc_Subjec, Doc_Contac, Doc_Contnu, Doc_Safepa, Doc_Comm, Doc_relat,;
> Doc_Transm,Doc_Val,Doc_date)" + ;
> " VALUES('" + F01 + "','" + F03 + "','" + F04 + "','" + F05 + "','" + F06 + "','" + F07 + "','" +;
> F08 + "','" + F09 + "','" + F10 + "','" + F14 + "','" + F15 + "','" + F16 + "','" +;
> F17 + "','" + F19 + "','" + F20 + "'," + STR(F18,10,2) + "," +;
> DTOC(DATE()) +;
> ")")
>
It's impossible to read this code. I would strongly recommend to rewrite it using TEXTMERGE.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform