Help!
Firstly, I'm a complete Progress novice so please excuse my igonrance - my background is mainly MS Sql Server and Oracle with Visual Basic frontends!
Well, here goes - I'm connecting to our Progress v9 database using Visual Basic 6.0 via an ADO connection that uses the Microsoft OLE DB Provider for ODBC datasources. Everything is fine and dandy, I can retrieve records etc but I can't update records. I can populate an ADO recordset with a record from the Progress DB but I can't update it. I get an ODBC error message that cryptically tells me I have a Syntax Error! This occurs when I issue the .update command against the recordset. If I issue an SQL UPDATE statement directly (in the form ADOConnection.Execute(SQL Statement) everything is fine and the record is duly updated. I can get away with using this methodology of updating the records but I really wanted to use an ADO recordset because I wanted to use proper record locking etc.
Does anybody have any experience with ADO, Merant ODBC and Visual Basic???? Any help would be *greatly* appreciated!
Firstly, I'm a complete Progress novice so please excuse my igonrance - my background is mainly MS Sql Server and Oracle with Visual Basic frontends!
Well, here goes - I'm connecting to our Progress v9 database using Visual Basic 6.0 via an ADO connection that uses the Microsoft OLE DB Provider for ODBC datasources. Everything is fine and dandy, I can retrieve records etc but I can't update records. I can populate an ADO recordset with a record from the Progress DB but I can't update it. I get an ODBC error message that cryptically tells me I have a Syntax Error! This occurs when I issue the .update command against the recordset. If I issue an SQL UPDATE statement directly (in the form ADOConnection.Execute(SQL Statement) everything is fine and the record is duly updated. I can get away with using this methodology of updating the records but I really wanted to use an ADO recordset because I wanted to use proper record locking etc.
Does anybody have any experience with ADO, Merant ODBC and Visual Basic???? Any help would be *greatly* appreciated!