MSQuery property

ReManfredi · Post by **ReManfredi** » Thu 15 Oct 2009 15:03

Hi,
i've SDAC 4.80.51.

Is there the possibility to set a "Prefix" name of a table in MSQuery component?

Example:

In SQLInsert i have "
INSERT INTO NAMEOFTABLE
(NAMEOFFIELD)
VALUES
(:PARAM1)".

I WOULD, IN A PROPERTY OF THE COMPONENT, ADD A TABLE PREFIX LIKE:

MSQuery1.TablePrefix := 'XXX';

FOR THAT, IN RUNTIME, THE QUERY BECOME "INSERT ... XXXNAMEOFTABLE ...."

THANKS

Challenger · Post by **Challenger** » Fri 16 Oct 2009 10:42

Please take a look at macros.

ReManfredi · Post by **ReManfredi** » Fri 16 Oct 2009 14:13

I will try that. Thx