create a new project,
create TIBDatabase, normally double clicking the IBDatabase1 should bring up Database connection editor, but it give me an error. TRegExpr exec: empty input string. A bug, OK.
so I setup DatabaseName with object inspector. I set it to "hello"
Double click the IBDatabase1 again, the database connection editor should show up correctly. browse for the database file, fill in user name and password, or even network connection if you know how to, you can click test first, or just skip to OK
I turned off LoginPrompt in object inspector.
create TIBTransaction, double click it, I like to use the "read committed" preset.
setup DefaultDAtabase to IBDatabse1 with Object inspector
Go back to IBDatabase1, set DefaultTransaction to IBTransaction1
create IBQuery, select IBDatabase1 in Database with object inspector. Right click IBQuery, select Edit SQL.
Pick the employee table, and click Generate SQL, and click OK.
set AllowAutoActivateTransaction to true with object inspector to.
You can set IBQuery to active at this point but the data won't be visible. The IBDatabase1 will prompt for login information as it is not using the saved password. I think it's a design choice made by IBX author.
Create a TDatasource from Data Access group. this thing bridge non visible data control to visible Windows controls. set it's DataSet to IBQuery1 with object inspector
Create a DBGrid, set it's DataSource property to DataSource1 with object inspector and the data is now shown