I want to create a query that lookup certain fields from Builder to PostgreSQL.
I've placed a table and datasource on my form with a query with SQL:
'SELECT * from MYTABLE;' There is definitely nothing wrong with the connection to the database, but my problem is, it seems that when the result are displayed (in a Grid) it only displays certain fields. It's almost as if it displays only the non-varchar fields.
If anyone has a solution for this, it would be greatly appreciated.