MSQuery property
Posted: 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
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