Hi, I'm new to Dabo. I tried building a first app using AppWizard, but I'm faced with the following problem. If I try to perform a select query with the generated form on a column containing a space, the column name in the query isn't protected by double quotes and the query fail. Could you tell me what I did wrong?
My database is (SQLite): > CREATE TABLE contacts ( > ID INT PRIMARY KEY NOT NULL, > [First Name] TEXT, > [Last Name] TEXT, > Email TEXT > ); The generated query from the generated form is: select "contacts"."ID" as "ID", > "contacts"."First Name" as "First Name", > "contacts"."Last Name" as "Last Name", > "contacts"."Email" as "Email" > from "contacts" > where contacts.First Name = '' > limit 1000 Why isn't First Name quoted in the generated query? Is it a bug in Dabo, or is it a mistake I did? I'm using Dabo 0.9.4 on Windows 7, installed over EDP Python distribution. * * *Charles Brunet, B. Ing.* Webmestre. Étudiant à la maîtrise, génie informatique, Université Laval. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/CAJPgzxnWK-_gthYiTU2Hjf=tjv9uu+lunm2bryjux9+w2pd...@mail.gmail.com
