| Author |
Topic |
|
Michael71
Posting Yak Master
126 Posts |
 Posted - 2006-10-19 : 10:48:31
|
| When I insert data in my table, it don't update untill I click on the "!" execute button. I need my table to update as sonn as I insert information in there. Could some one tell me how to do this. Thanks. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-10-19 : 11:00:30
|
| Not sure what you are talking about? From where are you inserting data?Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
Michael71
Posting Yak Master
126 Posts |
Posted - 2006-10-19 : 11:34:12
|
| I'm inserting data at the top of ReportID 77; the next one will be 78. After I insert...I just want the database just to instantly update...with out me having to press "!" execute. Is it a way you can do this?ReportID expenseReportDate expenseStartDate77 10/3/2006 10/13/2006 |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-19 : 11:46:43
|
once the data is inserted, the database is actually updated. "with out me having to press "!" executeWhat tool are you using ?
KH |
|
|
|
Michael71
Posting Yak Master
126 Posts |
Posted - 2006-10-19 : 13:10:17
|
| I'm using SQL Server Enterprise and InfoPath to Insert the data in the database. Hey khtan, I found out that info path allows me to format the database and the query works just find. I just need to update the database immediately. As soon as data goes in there. I'm having to click "!" execute...could it be that me database isn't running...I don't know SQl inside and out.. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-19 : 13:23:24
|
| What is meant by having to press ! to execute? ! is not a SQL Server function, so where is this execute option?Tara Kizer |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-10-19 : 13:24:31
|
| This is more likely an Infopath problem, not SQL Server. You can't get SQL Server to update each column as you enter them into the InfoPath form, nor would you want to. As khtan pointed out, the ! button is what actually sends the data to SQL Server, until then you're just filling out a disconnected form. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Michael71
Posting Yak Master
126 Posts |
Posted - 2006-10-19 : 14:33:07
|
| That's the answer I was looking for robvolk...this must be a infopath issue. Thanks. I need to study more SQL Server.I can't get SQL Server to update each column as you enter them into the InfoPath form, nor would you I want to. |
|
|
|
|
Immediate Updating a Table