Page 1 of 1

TUniTable and the SQL property in Design Time

Posted: Sun 20 Jan 2013 17:20
by heerdinm
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.

Code: Select all

Select * From TableA
Is what TUniTable gives me if i select a table name.

I would like to use:

Code: Select all

Select * From TableA, TableB
Where TableA.externalID = TableB.ID
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.

Re: TUniTable and the SQL property in Design Time

Posted: Mon 21 Jan 2013 11:07
by AlexP
Hello,

The TUniTable component is designed for work with separate tables or views, and it doesn't allow to use user queries in design-time. If you want to use your query, you should use TUniQuery instead of TUniTable, or create a view that uses your query in the DB and specify it in the TUniTable.