Home » Forums » DBManager General
 
Question about substitution (920 previews)
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
Question about substitution (920 previews)
Legends

Topic has Replies
Topic With no Replies
 
Home » Forums » DBManager General