Board index » delphi » Problem with TADOQuery

Problem with TADOQuery

With ASA 8.0.1.4076.

I have 2 queries :

[1] = "Select aStringField from MyTable"
[2] = "Select * from MyTable"

I use "FieldByName('aStringField').AsVariant".
With [1], I obtain <varNull>
With [2], I obtain an empty string

The real value is <varNull>, so why [2] doesn't works ??????

Thanks for anyone can help me.

 

Re:Problem with TADOQuery


I found the cause : ASA Provider !!!

Now i use Microsoft ODBC Provider and it woks !!!

"Etienne NICOLAS" <nicet...@yahoo.fr> a crit dans le message news:
3e003...@newsgroups.borland.com...

Quote
> With ASA 8.0.1.4076.

> I have 2 queries :

> [1] = "Select aStringField from MyTable"
> [2] = "Select * from MyTable"

> I use "FieldByName('aStringField').AsVariant".
> With [1], I obtain <varNull>
> With [2], I obtain an empty string

> The real value is <varNull>, so why [2] doesn't works ??????

> Thanks for anyone can help me.

Other Threads