Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLEXEC with blank dates
Message
De
25/03/2005 10:46:27
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
25/03/2005 09:59:39
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP2
Database:
Visual FoxPro
Divers
Thread ID:
00999138
Message ID:
00999156
Vues:
35
>I am using SQLCONNECT and SQLEXEC to connect to and insert records into SQL and VFP tables. When I do a SQLEXEC with an insert into and one of the fields being inserted is a blank date where I set the field ={} I get an error from aerrors from the vfp tables ONLY that states "[Microsoft] [ODBC Visual FoxPro Driver] Data Type mismatch."
>
>What am I doing wrong ?
>
>Thanks For Your Help !
>Stephen J. Hunt

Stephen,
What's exact insert command? This is not an expected error to see.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform