🚀 go-pugleaf

Graham,

Did you install Oracle's ole db provider from http://technet.oracle.com for use
with ADO or are you using a different provider??

John

Graham Reeds wrote:

> 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/