Imar,

I am attempting to use the VB version of your three part article building layered web applications with the BugBase as a foundation.

I have an insert procedure that adds a new customer to the database. Upon the initial log in the insert works fine, when i go to add a second customer i get an error;

String or binary data would be truncated.
The statement has been terminated.
The 'bus_RCustomerInsertUpdate' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

If i log out and back in again the insert works fine. Any idea what could be causing this error.

If you want me to post some code let me know.

EC

Hi EC,

Indeed hard to tell without seeing any code. Can you post the code for bus_RCustomerInsertUpdate and the code that calls this procedure? In addition, some background on why this code is being called, and what you're trying to accomplish would help as well.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

All figured out, simple error in SP.

Appreciate it greatly your articles and that you do respond on these forums. Make it much easier to learn.

You're welcome.....

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.