🚀 go-pugleaf

sorry my mistake:
no is a reserverd word. I should have figure it out

"yufufi" <yufufi@hotmail.com> wrote in message
news:3f05226f@newsgroups.borland.com...
> 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
>
>
>