• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 487
  • Last Modified:

call an sql function in vb6

how can i call a sql fucntion from vb6? pls give me a sample query
0
AnnaJames77
Asked:
AnnaJames77
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
a function from sql is part of a query:
select dbo.yourfunction(123) 

Open in new window

or, if the argument comes from a table/column;:
select dbo.yourfunction(table.column) from table 

Open in new window


I presume you know how to run (sql) queries from VB ...
0
 
AnnaJames77Author Commented:
thankyou angell..i will try
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now