Newsgroups : Borland : borland.public.delphi.rtl.win32 : 2006 Feb : Problems with Variant type
| Subject: | Problems with Variant type |
| Posted by: | "Frederico Pissarra" (fredericopissar..@gmail.com) |
| Date: | Mon, 20 Feb 2006 01:35:35 |
I'm having a strange problem with JET and Excel...
In the code below:
---%<----------------%<-----------
while not ds.Eof do
begin
if ds.FieldByName('Column1').AsString = '' then
...
...
ds.Next;
end;
---%<----------------%<-----------
Where ds is the dataset used to access Excel via ADO (Jet).
Every 3rd row of my sheet the application informs "Invalid floating point
operation" where there is no floating point operation beging made!!!
The column in my sheet is formated as "Text"...
Any ideas?
Thanks a lot
Frederico Pissarra
frederico@vgainfo.com.br