Learn how to a build a cloud-first strategyRegister Now


How can I populate a parameter in an OLEDB select command?

Posted on 2004-11-15
Medium Priority
Last Modified: 2010-04-23
This is the select command text

        Me.OleDbSelectCommand1.CommandText = "SELECT Auto_ID, Last_Name, First_Name, Date_Created, Transaction_Type, Service_Type, Notes, Due_Date, SSN, Phone_Number, Address, City, State, Zip, Total_Charges, Total_Payment, Total_Balance, Created_By, Status, IsVoid FROM Transaction_Information WHERE (IsVoid = 0) AND (Auto_ID = ?)"

If i want to use a variable to populate the Parameter '?'
how would I use the Me.OleDbSelectCommand1.Parameters.Add command

and how would I go about changing the value and updating the parameters value?

Any Answers?
Question by:LCiaccio
  • 2

Accepted Solution

vinhthuy_nguyen earned 1000 total points
ID: 12591952
hi, may be you need this:      
       OleDbSelectCommand1.Parameters.Add("AutoID", OleDbType.Int);
       OleDbSelectCommand1.Parameters["AutoID"].Value =  ' get the value here
Hope this helps.

Author Comment

ID: 12592790
Your on the money....

Sorry I didn't respond sooner.... I fell asleep...Awake now...


Expert Comment

ID: 12594431
Happy programming, buddy.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question