PC Review


Reply
Thread Tools Rate Thread

calling/using a sql server scalar valued function

 
 
John
Guest
Posts: n/a
 
      4th Oct 2010
I have a button on the main form for submitting the information. But,
part of the process is to see if the user exceeded their purchase
limits. The DBA has provided a scalar-valued function that returns
the information based on the userid that is passed into it. Below is
the if statement line that would use it. The rest of the IF works
when I put numbers in for testing. Now it is time to go to the
sqlserver for the info.

If Me.Subtotal.Value > "scalar-valued function result goes here" Then

Never had to use/call one of these before. How does one go about
calling a scalar-valued function in access07 to get the return value
which is a decimal?

Thanks.
John
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
calling a scalar function in sql from vb Rayne Microsoft VB .NET 0 17th Sep 2007 10:44 PM
SQL Scalar Valued function in VBA for a Access Project (ADP) =?Utf-8?B?cm9nZ2U=?= Microsoft Access VBA Modules 4 1st Aug 2007 07:40 PM
Scalar-Valued UDF Function =?Utf-8?B?R3JlZw==?= Microsoft Access ADP SQL Server 2 21st Sep 2006 04:56 AM
Debuging Scalar-Valued Function in Visual Studio with date parameters Shannon Broskie Microsoft ADO .NET 3 23rd Jul 2004 08:14 PM
Calling a Table Valued MSSQL Function from C# Abhishek Srivastava Microsoft C# .NET 1 9th Oct 2003 02:43 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:41 PM.