How to update values on database

[ye]

Hello,

I am using the database connectivity toolset and I am trying to change values of an existing database.
I used the "Update" command- (Update Tests Set TestDate = "05/29/2005 11:39:40" where (testInd = 2))
but got an error -2.14722E+9: . Invalid string: specified field does not exist or contains an unsupported character
I don't know what in means- the field must exist since the command "Select testInd,TestDate From Tests" worked just fine!!

what to do??

thanks for your help- Yael

[PauloM]

Hi,

I don't know if it depends of the database (what are you using?) that you are using, but I think that strings are limited by ' and not by ", have you tried this?

Hope this helps,
Paulo

[ye]

Thanks alot-
you solved my problem!!!
yael