August 7, 2007 at 10:22 pm
Hello,
I have SQL Server 2000 Developer Edition with SP4 installed on my dev machine and have PowerBuilder 6.0/6.5... I'm trying to issue a simple select * against one of the tables of a database, and I get in return the following message:
select error: Data-conversion resulted in overflow... So I click ok and no rows comes up, then if I try again or hit refresh on the data manipulation grid option (PB6), they do come up...
I fear that this is causing my application (already compiled) to crash, not sure about this, since is not returning any message on execution time...
Can somebody please advice,
Thanks,
-ramr.
August 9, 2007 at 1:00 am
Not all that familiar with current version of PowerBuilder but that particular error sounds like a client rather than SQL Server error - is it possible that your application is attempting to convert a character field (e.g. varchar, char, nvarchar) into a number or that your database is using/contains a datatype not supported by PowerBuilder (like suspect there would be a unicode data type).
Joe
September 11, 2007 at 10:30 am
I'm sory; I dont speak english...
Example :
SQLCA.AutoCommit = True
dw_1.Retrieve()
SQLCA.AutoCommit = False
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply