getting data conversion resulted in overflow...

• Rafael Medina-474790

  SSC Veteran

  Points: 257

  More actions

  August 7, 2007 at 10:22 pm

  #197232

  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.

• Joe Clifford

  SSCrazy Eights

  Points: 8739

  More actions

  August 9, 2007 at 1:00 am

  #725626

  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

   

• Murat YURDAKUL

  SSC Rookie

  Points: 35

  More actions

  September 11, 2007 at 10:30 am

  #732854

  I'm sory; I dont speak english...

  Example :

  SQLCA.AutoCommit = True

  dw_1.Retrieve()

  SQLCA.AutoCommit = False