Path: csiph.com!news.mixmin.net!aioe.org!.POSTED!not-for-mail
From: =?UTF-8?B?R3VscMKu?= <gulp@hotmail.it>
Newsgroups: it.comp.java
Subject: hsql
Date: Fri, 16 Oct 2015 19:06:40 +0200
Organization: Aioe.org NNTP Server
Lines: 20
Message-ID: <mvravk$tfs$1@speranza.aioe.org>
NNTP-Posting-Host: 5tPekrDgiV1/HwS+G/cH6A.user.speranza.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-15; format=flowed
Content-Transfer-Encoding: 8bit
X-Complaints-To: abuse@aioe.org
User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:38.0) Gecko/20100101 Thunderbird/38.3.0
X-Notice: Filtered by postfilter v. 0.8.2
X-Mozilla-News-Host: news://news.readfreenews.net:119
Xref: csiph.com it.comp.java:8625

Qualcuno del ng usa hsql?

Questa funziona:
String sql="Select * from \"fornitori\"";

questa no:
String sql="Select * from \"fornitori\" order by Ditta";

Questa no:
String sql="Select * from \"fornitori\" Where Tip='L'";

entrambe segnalate come errore di sintassi o object not found Ditta 
oppure Tip

Eppure sono campi entrambi presenti in tabella.
Qualche suggerimento?

-- 
Gulp®
(forse mi sono perso qualcosa :))