Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Syntax problem to insert a date
Message
De
19/01/2006 11:16:08
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Titre:
Syntax problem to insert a date
Divers
Thread ID:
01088456
Message ID:
01088456
Vues:
62
I am having a syntax problem when inserting a date in my SQL. Anyone can know what this is causing that?
        loDataProvider.ParameterClear()
        ldDate = Date.Now
        loDataProvider.oParameters.Add("@AddUser", Framework.App.nNoMember)
        loDataProvider.oParameters.Add("@AddDate", ldDate)
        loDataProvider.oParameters.Add("@ModUser", Framework.App.nNoMember)
        loDataProvider.oParameters.Add("@ModDate", ldDate)
        loDataProvider.oParameters.Add("@Detail", "This is my detail")
        loDataProvider.oParameters.Add("@Command", "Test")
        If loDataProvider.SQLInsert("INSERT INTO WebService " + _
         "(AddUser,AddDate,ModUser,ModDate,Detail,Command,Result) VALUES " + _
         "(?,?,?,?,?,?,""String"")", Framework.App.aConnection(1)) = False Then
            MessageBox.Show(Framework.App.cError + loDataProvider.cSQL)
        End If
Basically, this provides a data type mismatch. This is an insertion into a VFP table. AddDate and ModDate are datetime fields. What am I missing?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform