Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

datawindow procedure sql2000

Status
Not open for further replies.

Rottdpogs

IS-IT--Management
Jul 17, 2001
86
CN
please advice. im having "data-conversion resulted overflow" eror, im creating a datawindow (stored procedure). thanks in advance.
 
Are you using any non-Powerbuilder supported datatypes in the result set?

Matt

"Nature forges everything on the anvil of time
 
mbalent, im not using any non-powerbuilder supported datatypes. actually if i use adaptive server anywhere database engine, it works fine. but if switch to sql server 2000 im receiving "data-conversion resulted overflow" error. im creating datawindow using a stored procedure. please advice, thanks in advance.
 
Rottdpogs,

Can you call the SQL Server stored procedure via MS Query Analyzer passing the exact same data parameters to the query? MS SQL Server may be encountering a data conversion problem which has nothing to do with PB.

Good Luck.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top