SqlDbx Forum

jml

Member

Can't prompt for values

Why can't i get a prompt to appear. No matter what I try I get generic errors. The below command works in other sql applications, but not SqlDbx.

Thanks

AND e.EDITRANS_TYPE = '&Enter_type'

sqldbxhelp

Administrator

Re: Can't prompt for values

I am not sure what database you use, but looks like oracle.
If this is a case you do not need quotes
AND e.EDITTRANS_TYPE= &Enter_type

You will need to put quotes in popup dialog.
If you want SqlDbx to recognize what type of data and automatically do translation for you
then you can do something like this:

DEFINE Enter_type CHAR
SELECT * from table e where EDITRANS_TYPE=&Enter_type

and execute both statement as single batch