TUniTable and the SQL property in Design Time
Posted: Sun 20 Jan 2013 17:20
Hello,
I would like to use an SQL in Designtime which exceeds the simple version that TUniTable is giving me.
I have 2 tables and like to have a join with them in design time to be able to set up a DBGrid with some selected Fields.
Is what TUniTable gives me if i select a table name.
I would like to use:
Is this possible in design time for TUniTable?
I have been searching in the component in design time, but the code editor of the SQL is read only and whatever i try with the fields above it, nothing works like i want it to.
I would like to use an SQL in Designtime which exceeds the simple version that TUniTable is giving me.
I have 2 tables and like to have a join with them in design time to be able to set up a DBGrid with some selected Fields.
Code: Select all
Select * From TableA
I would like to use:
Code: Select all
Select * From TableA, TableB
Where TableA.externalID = TableB.ID
I have been searching in the component in design time, but the code editor of the SQL is read only and whatever i try with the fields above it, nothing works like i want it to.