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 |
|
sidduselig
Starting Member
1 Post |
 Posted - 2002-11-29 : 04:12:47
|
| sidhu writes,how to insert the values of one table to another tableas and when one of the field value of first table is entered in the visual basic form text box, firing triggers.for ex:. the table-one contains slno,cno,cdate,ctype,cyear....and table-two contains cno,cdate,ctype,cyear,pname...so when the value of cno is entered in the text box of visual basic form, its value should insert in table-one and also insert/update the table-two firing trigger when inserting/updateing table two.pl.help...its very needed.sidduselig |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-29 : 07:25:15
|
| Have you looked at crate trigger in bol?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-11-29 : 07:30:42
|
What's a crate trigger? Something new in the latest patch?  |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-29 : 08:07:08
|
| It's the thing on the side of the crate which sql server documentation is delivered in.Press it and bol springs out.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
sql triggers