Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

urgent help needed with command parameter

Status
Not open for further replies.

ub1234567

Programmer
Dec 4, 2008
69
0
0
US
Hi,

i am passing three parameter in my sql command.

when i put sample database parameter value in command then it works fine.
but when i replicaing that value with ?parameter and passing parameter externally then it does not give me any results.

pls geive me suggestion
 
What are the datatypes of the parameters? What type of database are you using?
Strings definitely need to have a single quote around the braces of the parameter for them to work:

customer.country = '{?Parameter}'

~Brian
 
Please do not double post!

Did you create the parameter in the command screen?
 
yes i created parameter in command editor.
but it does not works.

i also removed that command parameter and puted into record selection
but it also does not work.

pls provide me suggestion.
your help will be appriciated
thanks in advance
 
You are not providing sufficient information for anyone to help. Please show the content of your command and identify the datatype of the parameter you set up within the command.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top