I just discovered sqleo and try it on a Derby database. it looks good but when applying a select to a table name with lower caps(ReferenceOuvrage) it give an error of table not found but with the table name with all caps (REFERENCEOUVRAGE). It seems that it considers all table names must be all caps. on table names qith all caps it works well.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am using the GUI querybuilder. I tested it in quote and it works. But using the GUI query builder i have to go to the syntax tab and manually correct the select putting quote for every table and field name. I guess it must be a small bug unless I have to set up all field names and table names in upper case to be able to use directly the querybuilder?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
View and moderate all "Technical questions" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
I just discovered sqleo and try it on a Derby database. it looks good but when applying a select to a table name with lower caps(ReferenceOuvrage) it give an error of table not found but with the table name with all caps (REFERENCEOUVRAGE). It seems that it considers all table names must be all caps. on table names qith all caps it works well.
are you using quotes for table name ?
select * from "ReferenceOuvrage"
or
select * from ReferenceOuvrage
should have different behavior ...
View and moderate all "Technical questions" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
I am using the GUI querybuilder. I tested it in quote and it works. But using the GUI query builder i have to go to the syntax tab and manually correct the select putting quote for every table and field name. I guess it must be a small bug unless I have to set up all field names and table names in upper case to be able to use directly the querybuilder?
could you try the Always Quote Identifiers
as described here
http://sqleo.sourceforge.net/guide/English_SQLeo_AdvancedHelp.htm#_Toc467095114
View and moderate all "Technical questions" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
Ok, it works fine. Thank you. It is a very practical tool.