ASP.NET

insert into two tables

Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Sep 2009

Posts: 10

Reputation: marangajared is an unknown quantity at this point

Solved Threads: 0

marangajared marangajared is offline

Offline

Newbie Poster

insert into two tables

Oct 9th, 2009

Hi. on my form, the field are entered depending on availability. some fields are mandatory while others are optional. The mandatory fields are inserted into one table called Receipt while the optional ones are saved in the other table called receiptLine. When all the fields are filled in, then the two tables are updated. Otherwise when only the necessary fields are filled, the first table is not filled. instead an error is raised which is "String or binary data would be truncated. The statement has been terminated."

Look at the form below. The second panel is the one that is optional,
How should I solve it?

Thank you

•

Join Date: Aug 2007

Posts: 182

Reputation: Kusno is an unknown quantity at this point

Solved Threads: 15

Kusno

Offline

Junior Poster

Oct 12th, 2009

•

Originally Posted by marangajared

Hi. on my form, the field are entered depending on availability. some fields are mandatory while others are optional. The mandatory fields are inserted into one table called Receipt while the optional ones are saved in the other table called receiptLine. When all the fields are filled in, then the two tables are updated. Otherwise when only the necessary fields are filled, the first table is not filled. instead an error is raised which is "String or binary data would be truncated. The statement has been terminated."

Look at the form below. The second panel is the one that is optional,
How should I solve it?

Thank you

Try to check your fields table structure....Need to enlarge the columns width

NEVER NEVER NEVER GIVE UP

•

Join Date: Oct 2009

Posts: 6

Reputation: shenulal is an unknown quantity at this point

Solved Threads: 2

shenulal

Offline

Newbie Poster

Oct 13th, 2009

hai,
is the receipt field is of nvarchar type. Increase the datatype size and try. (for testing you can provide nvarchar(max) and then adjust the size needed for your application).

Thanks,
Shenu