Current recordset does not support updating

Posted by / 25-Feb-2020 12:25

OLEDB.4.0; Data Source=" & txt Database Dir & "HRMDB. Command Type Cmd Text 'create and open record set POrst Data = New ADODB. billegge wrote: I'm pretty sure the ODBC driver does not implement the equivalent of delphi's "Request Live" (but I'm not the primary developer of the ODBC driver and might be mistaken). It seems what you are saying is that the ODBC driver, in general, does not allow live data.

Recordset Private Sub Do Update() 'make connection and open database db = New ADODB.

Command Text = "Select PODate, POLoc, POItem FROM Pur Ord " & _ "where PODate = #" & Selected Date & "# and POLoc = '" & str Loc & "' " & _ "AND POItem = " & CInt(str Item) POrst Data = C. I wish there was an example of someone reading a transaction file and updating a table (add, update & delete based on the transaction type). Thanks, Hexman On Mon, -0800, "Denny" OK, I looked at the examples in the SDK and other internet sources --- and now I'm even more confused.

Lock Type Lock Optimistic, True) End Sub Private Sub Update Process() C. Add New() OK, I looked at the examples in the SDK and other internet sources --- and now I'm even more confused.

Command Text = "Select PODate, POLoc, POItem FROM Pur Ord " & _ "where PODate = #" & Selected Date & "# and POLoc = '" & str Loc & "' " & _ "AND POItem = " & CInt(str Item) POrst Data = C. I get the error: An unhandled exception of type 'System. This may be a limitation of the provider, or of the selected locktype. I've stripped out much of the code, leaving the pertinent (I hope) info. The error appears to be quite self-explanatary, but I've read about the locktype an it seems correct. I just want to find out if the record is on file and if not, add it, otherwise I'll update it. Thanks, Hexman --------------------------------------------------------------------------------------------------- Imports System.

Lock Type Lock Optimistic, True) End Sub Private Sub Update Process() C. Add New() I've come up with an error which the solution eludes me. COMException' occurred in Additional information: Current Recordset does not support updating.

current recordset does not support updating-71current recordset does not support updating-56current recordset does not support updating-14

I have a website with some asp pages running off of a MS Sql db.