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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-18 : 09:52:06
|
| Carina writes "Hi!I have an application that reads data from a database with four tables. One way to add data into the database is through the webapplication. An other way is througt automatic tranfer from other systems. I´m using a stored procedure when I read data from one table and insert it into an other table. I can do this successfully. BUT...the web application doesn´t read the data from the table that comes from other systems, just the data from the web application. This is because there is a function in an ASP file that updates the tables when adding it from the web.How can I call this function through my stored procedure??Thank you very muchThis is important to meBest regards//Carina" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-06-18 : 09:57:04
|
| Rather than have your ASP execute embedded sql, you should move the insert logic into stored procedure and have the ASP execute that stored procedure.Be careful with the word 'function' as that means something in SQL Server other than how you are using it.<O> |
 |
|
|
|
|
|
call a function??