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 TryThanks for any help