Database Query Probs

[Brett]

I had the following script working fine VG 5.1.3310 and now doing a client install using VG 5.2.1011 i am getting the following errors when dbquery uses an UPDATE SQL command. Any ideas? TIA

 

161332.62 5 RVreplace end: [uPDATE CALLV SET CALLINUSE = 'T' WHERE LINENO = 5]

161332.62 5 db About to execute a Modify type operation [uPDATE CALLV SET CALLINUSE = 'T' WHERE LINENO = 5]

161332.64 5 ERROR 5.2.1011 DB Execute: 3146,ODBC--call failed.

161332.64 5 rv add [update Call in Use_RowCount]{0}

161332.65 5 db DBEngine.Error -3035:S1000: [Microsoft][ODBC dBase Driver] Operation must use an updateable query.:ODBC.Database

161332.66 5 db DBEngine.Error 3146:ODBC--call failed.:DAO.Database

161332.67 5 TimeoutClear

161332.68 5 [DbQuery StoreName] DB Query

161332.69 5 db ODBC mode used

161332.71 5 db About to execute a Retrieve type operation [sELECT ST_NAME FROM STOREV]

161332.72 5 db [DbQuery StoreName] row count=1

161332.73 5 rv add [DbQuery StoreName_RowCount]{1}

161332.73 5 db get RecordsetGetRowsMax

161332.74 5 db get 999 records. (row count=1)

161332.75 5 db update RVs

161332.76 5 db about to close dbDbqDatabase

161332.76 5 db going down path [True]

[SupportTeam]

Are you using same database and ODBC driver? (what are they?)

Is it possible that maybe some database table definitions or user login permissions are a bit different on the new system?

[Brett]

Are you using same database and ODBC driver? (what are they?)

 

Yes, dbase (Microsoft dBase Driver (*.dbf))

 

Is it possible that maybe some database table definitions or user login permissions are a bit different on the new system?

 

Table definitions have not changed and login permissions are the same.

 

I need this going today. help?

[Brett]

Will the registration code that you gave me for 5.2.1011 also work for 5.1.3310?

[Brett]

the only differences i can find which is the likely problem is that it worked with windows2000 service pack 4 hence later odbc drivers and not working with service pack 1 hence earlier odbc drivers. BUT there is software that is already installed on this computer that will not work with the odbc drivers installed with sp4 but works fine with sp1.

 

so moving to a different computer which means i will be sending you another email for a new registration code for the new computer which will have sp4 installed.