Recent content by jhu

Thanks for your reply. I'm using the query in combination with a union: select from [TABLE] union select 0 from [TABLE] In this situation is a NUMBER(3). Can't I get scale/precision info from the first select?

Hi, I've got a strange situation here: If I create a persisting field (in TOracleDataset) based on SELECT FROM [TABLE] I get an TIntegerField. So far so good. If I change the SQL statement into SELECT 1 AS FROM [TABLE] and re-open the dataset, I get an error like: Type mismatch for field ''...