Re: [dba-dev] Table names Uppercase a must? Strange things

2005-04-10 Thread Josh Berkus
People: > With Base tool 'Querys' created: > SELECT "idJour", "vonKto" FROM "JOUR" "JOUR" WHERE ( ( "vonKto" = > 'KASSE' ) ) > This select the data. > Twice "JOUR" ? Strange, but works. > All >"< in SQL are unnecessary, the system generates all (the first > comfort in this hard job). What's the l

[dba-dev] Table names Uppercase a must? Strange things

2005-04-10 Thread Wolfgang Schaible
Hi, All tables now created with uppercase names and with new release 1.9.91-1. With Base tool 'Querys' created: SELECT "idJour", "vonKto" FROM "JOUR" "JOUR" WHERE ( ( "vonKto" = 'KASSE' ) ) This select the data. Twice "JOUR" ? Strange, but works. All >"< in SQL are unnecessary, the system gene