Hi,

I can't explain, because I can't even reproduce it (however I haven't
W8. just W7).

You wrote that when you create table via FDB, everything works just
fine. So the problem is most likely related to the "other" data.

best regards
Pavel Cisar
IBPhoenix

Dne 16.8.2013 15:18, Dan Statham napsal(a):

>
>
> Good Morning!
>
> I have just started using Python and have discovered FDB. Super-duper!
> Now I can
> create a web interface for one of my applications.
>
> I am using the FDB 1.4 documentation to learn how to use FDB.
>
> A 'select * from table' returns all but the first record.
>
> A 'select * from table where id = x' returns an empty [].
>
> A 'select * from table where id < 4' returns [(2,),(3,)].
>
> I created a db & table using FDB then inserted some data. The 'selects'
> return
> the correct data.
>
> Can someone explain why this is happening?
>
> Windows 8 64bit, Python 3.3, FDB 1.4