|
Question about substitution |
Posted in 20th, 01/2005 12:31 by brandc.rd |
Hi,
When entering a query in DB MAnager, I see you can use a ? (question mark) to ask for values like
select * from a_table where a_value = ?
then it asks what is the value for a_value, but
for the query as follows
select * from ? where a_value = 10
it just asks for a value, not spesifying a spisific tag for the
?, my questions is thus can I assign a tag to each ? and how.
thanks
Cecil
Cecil Brand / ufs |
Re: Question about substitution |
Posted in 20th, 01/2005 02:03 by support |
Hi,
It would be better to use the parameters specifications, like this:
SELECT * FROM @@table@@ where ...
The DBManager will ask for table and replace @@table@@ with the value you entered. If you want to use quotes you need to insert the quotes, like this:
SELECT * FROM `@@table@@` where ...
This will work the same way.
Best Regards,
Support / DBTools Software |
Re: Question about substitution |
Posted in 21th, 01/2005 03:56 by brandc.rd |
Thx this was presisly what I was looking for.
Thx for the help
Cecil
Cecil Brand |
Legends
Topic has Replies
Topic With no Replies
|
|
|