select query
lazarus / 16-Databases

----------------------------------------------------------------------
Hansvb · 2015-05-01 20:45

The next query does not work when the table has a Oracle geometry
column.

Code: [Select]SQL.Text := 'select * from TABLE_NAME';
How to generate a sql.text string with all the columns without the
geometry column?

----------------------------------------------------------------------
LacaK · 2015-05-03 17:13

Can you enumerate all other columns (excluding geometry one) instead
of * ?

F.e.: SQL.Text := 'select column1, column2, column3 from TABLE_NAME';