CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 Somebody got the Stored Procedure call to work

Print topic Send  topic

Author Message
Carsten Webering
Posted: 03/11/2003, 1:31 AM

Hello

I'm trying to get Stroed Procedure Call to work but got the following error
msg:
The parameter type is set to Control. If it set to URL I get another
message.

Can't execute SPCommand
SPCommand sql='{ ? = call unpsPartyInsert;1 ( ?, ?, ?, ? ) }'
startPos='0'
fetchSize='0'
connection='Connection1'
Parameters:
param1 : value is null type: INTEGER scale: 0
param2 : value is null type: CHAR scale: 0
param3 : value is null type: SMALLINT scale: 0
param4 : value is null type: TIME scale: 3
param5 : value is null type: TIME scale: 3
=== SQLException ====
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]Cannot insert the value NULL into column 'enabled', table
'UNPS.dbo.Party'; column does not allow nulls. INSERT fails

Regards Carsten Webering


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.