Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
C# Community
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Database
Database General Discussion
How to call a query in Access that contains a custom variable?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="zecche" data-source="post: 4098" data-attributes="member: 1731"><p>Hi. I have a table and an update query in MS Access that updates to the table when it is beinb run. The result of the update query comes from a function that I have added as a module to the MS Access db. For intance, </p><p></p><p>Update Tbl SET field.Tbl = FunctionXYZ(aug1, aug2, aug3)</p><p></p><p>I can run this query with no problem in Access, but I can't seem to run it if I were to call it as stored procedure with the following line:</p><p></p><p>intResult = objcommand.ExecuteNonQuery()</p><p></p><p>Basically, VB.NET can't recognised FunctionXZY and therefore returns an error.</p><p></p><p>Is there another way to go around it if VB.NET indeed cannot call such a type of update query? Thank you very much.</p><p></p><p>Zecche</p></blockquote><p></p>
[QUOTE="zecche, post: 4098, member: 1731"] Hi. I have a table and an update query in MS Access that updates to the table when it is beinb run. The result of the update query comes from a function that I have added as a module to the MS Access db. For intance, Update Tbl SET field.Tbl = FunctionXYZ(aug1, aug2, aug3) I can run this query with no problem in Access, but I can't seem to run it if I were to call it as stored procedure with the following line: intResult = objcommand.ExecuteNonQuery() Basically, VB.NET can't recognised FunctionXZY and therefore returns an error. Is there another way to go around it if VB.NET indeed cannot call such a type of update query? Thank you very much. Zecche [/QUOTE]
Insert quotes…
Verification
Post reply
Home
Forums
Database
Database General Discussion
How to call a query in Access that contains a custom variable?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Accept
Learn more…
Top
Bottom