Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update BackEnd form vfp.net toolkit
Message
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Visual FoxPro Toolkit pour .NET
Titre:
Update BackEnd form vfp.net toolkit
Divers
Thread ID:
00671827
Message ID:
00671827
Vues:
47
Can I update the sql backend using the vfptoolkit? I keep bombing in the following code:
Dim iLoginCount = txtLoginCount.Text + 1
Dim cDateTime As String
Dim lcConnectionString As String
Dim lcSQL As String
Dim oConn As OleDb.OleDbConnection
Dim docID As String
cDateTime = VFPToolkit.dates.DateTime.ToString

lcConnectionString = "provider=sqloledb.1;server=cqi-termserv;uid=ctore;pwd=cqi;database=ctore"
docID = txtUserName.Text
lcSQL = "Update dbo.coPer set loginCount = " & iLoginCount & ", LastLogin= '" & cDateTime & "' where coPerID=" & docID

'Connect to the Database, execute the query and disconnect

oConn = VFPToolkit.vfpData.SqlConnect(lcConnectionString)
VFPToolkit.vfpData.SqlExecute(oConn, lcSQL)   <== This is the line that bombs, Cannot find table 0
VFPToolkit.vfpData.SqlDisConnect(oConn)
But it all works if I put it in a try/catch
        'Connect to the Database, execute the query and disconnect
        oConn = VFPToolkit.vfpData.SqlConnect(lcConnectionString)
        Try
            VFPToolkit.vfpData.SqlExecute(oConn, lcSQL)
        Catch
            ' continue
        Finally
            VFPToolkit.vfpData.SqlDisConnect(oConn)
        End Try
Thanks for any help

Kirk
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform