DilbertPCer
Programmer
In Migrating pbls from PB9 to PB10 the new PBL compiled OK and an exe was created.
When it was run in the IDE it displayed the table data correctly.
No data was saved or updated.
Now the PB9 application gives a "Database Problem 2 select error database processing error" when it tries to display data from the same table.
So, it seems the PB10 application corrupted the data in the PB9 table.
This is probably because PB10 is Unicode whereas the original table data was DBCS in PB9.
Apparently, I have missed some setting in either Powerbuilder or in the SYC Sybase Adaptive Server Enterprise to prevent this corruption.
Our Adaptive Server Enterprise version is 11.5.1, I think.
We are not using any new version of the SYC ASE, yet.
Does anyone more capable in this type of conversion and/or more capable in SYC ASE have some suggestions or leads for me.
Presently I am re-reviewing my documentation.
When it was run in the IDE it displayed the table data correctly.
No data was saved or updated.
Now the PB9 application gives a "Database Problem 2 select error database processing error" when it tries to display data from the same table.
So, it seems the PB10 application corrupted the data in the PB9 table.
This is probably because PB10 is Unicode whereas the original table data was DBCS in PB9.
Apparently, I have missed some setting in either Powerbuilder or in the SYC Sybase Adaptive Server Enterprise to prevent this corruption.
Our Adaptive Server Enterprise version is 11.5.1, I think.
We are not using any new version of the SYC ASE, yet.
Does anyone more capable in this type of conversion and/or more capable in SYC ASE have some suggestions or leads for me.
Presently I am re-reviewing my documentation.