Hi,

if i execute this statement:

select 'prova&ciao' as field1
from anaimb0f

this is what i get:

field1: prova

but if I execute this statement:

select 'prova&&ciao' as field1
from anaimb0f

this is what i get:

field1: prova&&ciao


The problem is that I need to have one & in my select because it's an html link that users have to click.

Could you please take a look at it?

Thanks,
Lorenzo

Hello

1) AnyDAC recognizes '&' and '!' as macros marker. To disable macro processing set ResourceOptions.MacroCreate and MacroExpand to False. More about that:
www.da-soft.com/anydac/docu/Preprocessing_Command_Text.html

2) Still the best is to use parameters instead of literals.

Wow i did not know about this functionality!!

thank you so much.

Lorenzo

I also would like to use parameters but in this case I cannot (at least i don't think i can) because the purpose of this program is that a user can insert a query in a txt, the program will get the txt and execute the query.

Just a question...fortunately in this project I do not need macros.

But what if I need macros and I also need to have a string composed with the '&' ?

I think it would be great to have a way to skip macro conversion just in a particular situation like mine...

do you think it's could be possible in the future?

If you need to execute a query, which is not under your control, then you should turn off macro processing. If you going to provide the query by your self, then you can double the '&', AnyDAC will leave only single '&' from each two.

Hi,
thanks for answering.

However if I do:

Adquery1.Close;
Adquery1.SQL.text := 'select "prova&&ciao" as field1 from anaimb0f';
Adquery1.Open;

I see two && into the tdbgrid, not one.

Am I doing something wrong?

Probably you see 'field1' and not 'prova&&ciao' ?

this is what i see with

Adquery1.SQL.text := 'select "prova&ciao" as field1 from anaimb0f';

this is what i see with

Adquery1.SQL.text := 'select "prova&&ciao" as field1 from anaimb0f';

Ok, I see. The '&' has special handling:
- &<name> - macro name;
- && - substituted as is - '&&'.
This is done because in many DBMS the '&&' is an operator. So, AnyDAC understands '&&' as operator and not as escaped '&'.

So, in your case you should turn off macro processing. When you will need to specify a command with a macro inside, then you should turn on macro processing.