Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vk18
Posting Yak Master
146 Posts |
 Posted - 2006-10-20 : 18:52:52
|
| Hello Friends,If the user enters '3' in the one of the text box on the form then i need to add 3 rows in the table.How do i check the condition that how much value user entered in the text box.Thx |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-20 : 19:27:40
|
[code]-- @rows is what the user input in the text boxinsert into sometable(somecol, . . .)select somevalue, . . .from F_TABLE_NUMBER_RANGE(1, @rows)[/code]F_TABLE_NUMBER_RANGE is here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47685
KH |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-10-21 : 01:07:59
|
| >>If the user enters '3' in the one of the text box on the form then i need to add 3 rows in the table.Why?If the user enters 100000000000, then you want to enter as many rows?Can you explain more in detail?MadhivananFailing to plan is Planning to fail |
|
|
|
vk18
Posting Yak Master
146 Posts |
Posted - 2006-10-21 : 01:30:13
|
quote:
Originally posted by madhivanan
>>If the user enters '3' in the one of the text box on the form then i need to add 3 rows in the table.Why?If the user enters 100000000000, then you want to enter as many rows?Can you explain more in detail?MadhivananFailing to plan is Planning to fail
There is no way User will enter 100000000000, Hardly from 1 to 25.This is one of the internal application. |
|
|
|
|
|
|
Adding Rows to a table