Eugen.Konkov@... wrote:

> I ask only to match 'myTable' and 'fieldID' when I query it by
> select fieldID from myTable
>
> and when table chema is:
> create table "myTable" (
> "fieldID" integer
> );
>

Your problem is that you create the table case-sensitive (quoted
tablename), but your select doesn't use quotes and so is not case-sensitive.


--
Magnus