🚀 go-pugleaf

1)
I'm connecting to an access db with ADOConnection component
connection string = Provider=Microsoft.Jet.OLEDB.4.0;Password="";User
ID=Admin;Data Source=H:\My Projects\Hfbc\db\maindb.mdb;Mode=Share Deny
None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry
Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet
OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet
OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet
OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet
OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica
Repair=False;Jet OLEDB:SFP=False

I query the db and check the results from dbgrid
Interestingly

SELECT * FROM something WHERE no=2 returns nothing
                                                    WHERE no<3 returns first
2 row (no=1,2)
                                                   WHERE no>1 returns
nothing
                                                    WHERE no<5 returns first
4 row
                                                     WHERE name='someone'
returns correct result

What might be the problem??

2)after
SELECT no FROM sometable;
FieldByName("no") gives the error "Field no not found"
but
after
SELECT * FROM sometable;
FieldByName("no") works smoothly??

Thanx a lot

Furkan Fidan