Using quoted fieldnames

[cjmoore]

In a TOracleDataset is there a way to get it to use quoted fieldnames in the SQL it generates on a post (insert or update)?

The problem I have is one of the field names in a table is mixedcase (the rest are uppercase) and I get an invalid fieldname error when an update is posted.

TIA
Cary.

[This message has been edited by cjmoore (edited 02 August 2001).]

 

[Marco Kalter]

The TOracleDataSet does currently not support mixed case column names, unless you handle all DML yourself in the OnApplyRecord event handler. This may be a lot of work though, if all your tables have mixed case column names.

You could alternatively rename the columns, or use a view to change the column names.

------------------
Marco Kalter
Allround Automations

 

[cjmoore]

I thought that might be the answer, the short-term fix I've removed the field from the Oracledataset's that update it and have added code to apply updates manually.

In the longer term I'll rename the column when there's a major release to be packaged.

Thanks,
Cary.