SqlDbx
You are not logged in.
Pages: 1
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'
Offline
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
Offline
Pages: 1