Newsgroups : Borland : borland.public.delphi.rtl.win32 : 2006 Feb : Problems with Variant type

www.cryer.info
Managed Newsgroup Archive

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

Replies:

www.cryer.info
Managed Newsgroup Archive