🚀 go-pugleaf

Hello.

I have a problem retrieving the fieldnames of a table from Oracle8i Spatial
8.1.6 using Borland Builder 5.  The following code reads in 'normal' tables
perfectly, but fails when the table uses the MDSYS.SDO_GEOMETRY data type.
The error isn't Oracle specific, more Borland related, but I was wondering
if anyone had any ideas on why or similar problems?  The Find feature on
DEJA doesn't return any other similar problems, so I was wondering if anyone
could give me a helping hand.  The error message is 'ROW-00004: Invalid
column datatype.'

Stepping through with the debugger shows that the FieldCount isn't filled in
and so fails immeadiately.

The erroneous(?) piece of code:

  ...
  ADOTable->Active = false;  // turn table off
  ADOTable->TableName = TableName; // retrieved previously
  ADOTable->Active = true;  // turn it back on
  for (int i=0; i<ADOTable->FieldCount; i++) // fill the ListBox

CheckListBoxTFields->Items->Add(ADOTable->Fields->Fields[i]->FieldName);

Thanks.

-

Yours faithfully, Graham Reeds.
grahamr@omnieng.co.uk | http://omnieng.co.uk/