March 11, 2008 at 9:37 am
I made a change in a PowerBuilder datawindow, which included dropping the old field, resizing it, and re-adding it to the datawindow. When the field was re-added, PB changed its name to include the table name as a prefix. (the field is status_comments, from the Grants table. It was called just status_comments in the dw before, now it is called grants_status_comments. PB made this name change, not me. The application blew up when it could not find a field called grants_status_comments, so I had to change a script that used the name to include grants_ in front of the field name. So far no problem. This may not be part of the problem actually, I don't know, even though it seems that the comments field is the culprit.
The database error comes when I attempt to save data on the screen while the application is running. I get an error saying:
Database error # -402 SQLSTATE = 37000
[Microsoft][ODBC SQL Server Driver][SQL Server] The data types char and text are incompatible in the equal to operator.
The field has not changed except for the size, which I increased from 5000 to 6000.
Any clue?
March 11, 2008 at 9:43 am
The data types char and text are incompatible in the equal to operator
Sounds like a data type was changed and your application no longer works with whatever comparison/join it was doing on those two columns.
First things first, if you know the names of the columns, check out their data types. Do you have management studio installed? Simply drill down to the database -> table -> columns -> what are the data types of the two columns being called from the application? One should be char, and one should be text, according to the error above.
Regardless, looks like you're going to have to change your text column back to a char, or whatever it was prior (I'd recommend looking at a prior days backup if you don't have any type of revisioning/source control in place).
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply