Multi Step Error

[Guest_imported]

I have a very strange problem with a multi step error.

I can overwrite fields in my MySQL database as long as they are shorter than the values already entered!

If they are longer I get a multi step error.

I have checked all the data types etc. etc. and their all OK.

I am overwriting the data not updating i.e.

sql = "SELECT * from blah where blah=blah"

connection here

rs.AddNew
rs("Regiment&quot = string
Save Recordset

If the string is shorter than what is already in the field it works fine it is only when the string i am trying to input is longer i get a multi step error.

Could it be to do with mysql's attempt at eliminating whitespace?

 

[piti]

hi

what do you mean with overwriting and not updating?
the sql query you posted will not update/overwrite anything as it is a select statement
post the relevant sql code so we can look at it and determine the prob

as i suppose you are using myodbc (recorset reminds me on vb) - the myodbc release notes contain this know bug:
"Some times client side cursor type (adUseClient) generates error 'multi-step generated error' when performing result set add, update or delete. But the same should work fine when using server side cursor (adUseServer) from MyODBC 3.51.03 version.

 

[Guest_imported]

It is an overwrite, the select selects everything, then the rs.AddNew replaces it in the recordset and then it gets saved.

I tried to change the cursor location, that didnt make any difference.

 

[piti]

well i have not used mysql through myodbc so you'll probably need to wait for somebody who knows something about it

sorry m8

 

[UBfoolin]

I am having the same type of problem. My field will accept 45 chars of data, but not 46. The field is defined as varchar(100) not null.

Have you found a solution?

Thanks.