Using parameter in command error

[ss7415]

i am doing a parameter on lot_nbr and part, they are both strings, in my command i have

QTY.PART ={?PART} AND QTY.LOT_NBR = {?LOT}

but the problem is when i enter the part and lot, it wont return any data unless i put ' ' at the beginning and end. Can i have it where the person doesnt need to enter ' ' when they enter the part and lot_nbr. i dont want to change it to a number because there are times the lot and part may have a letter or a -

 

[synapsevampire]

Sounds odd, it shouldn't require it.

What database, and have you checked on the server to see what is being passed?

Do you have to put quotes on both fields?

Just asa test, try:

QTY.PART like {?PART} + "%"
AND QTY.LOT_NBR = {?LOT} +"%"

Might be something in the ODBC driver which is mucking things up, but please don't post here with data issues woithout mentioning the database being used, and your Crystal version.

-k

 

[ss7415]

yeah its wierd, that didnt work, im using XI version 2 and oracle xi,

seems really wierd

 

[ss7415]

i got it to work QTY.PART ='{?PART}' AND QTY.LOT_NBR = '{?LOT}'

i put the ' ' around my parameter and it works