On Mon, 2002-06-17 at 20:25, Scot Wilcoxon wrote: > I've seen a few comments of people encountering this problem, but not > yet a solution: > > Upper case field names in commands are forced to lower case and then not > found. > > I was able to create a table with a field called "ABC". > > "SELECT ABC FROM mytable;" > emits the error > "no such attribute or function abc"
If it is possible, you will have a much easier time if you change you schema to use case folded names EG: CREATE TABLE Foo ( ... ) rather than: CREATE TABLE "Foo" ( ... ) otherwise.. You will need to change your code to quote all references to the name: EG: $q = 'SELECT * from "Foo"'; If you don't put ["]'s around the object identifier, it gets case folded to lower case. -- David Stanaway
signature.asc
Description: This is a digitally signed message part
