TUniTable and the SQL property in Design Time

[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.

[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.