Hi,
In Base, when the database (i.e. the odb file) is created by connecting to a csv
file, it seems that you can not use arithmetic operators on fields in a SELECT
clause ; oddly enough, you can use trigonometric functions, for instance.
For example, SELECT "name", "value" + 5 AS "Result" FROM "Table1" will give a
blank result for "Result" if the source if a csv file or a spreadsheet, but will
work fine with an HSQL database engine. SELECT "name", SIN("value") AS "Result"
FROM "Table1" will work, whatever the source is.
Is this a bug or a feature ?
Cheers,
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
