Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP Date to SQL DateTime
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01205160
Message ID:
01205472
Vues:
15
>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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform