Re: installing ncoci8 in BDS2006

Yes, I did have to make changes, in NCOciDB, about line 1722, I had to
add a few more types to the dt2ot variable:

Something Like:

dt2ot: array [TFieldType] of TOCIVarDataType = (
otUnknown, otString, otSmallInt, otInteger, otInteger,
otUnknown, otFloat,
otBCD, otBCD, otDateTime, otDateTime, otDateTime, otRaw, otRaw,
otInteger, otLongRaw, otLong, otUnknown, otUnknown, otUnknown,
otUnknown,
otUnknown, otCursor
{$IFDEF OCI_D4}
, otChar, otUnknown, otInteger, otUnknown, otUnknown,
otUnknown, otNestedDataSet
{$ENDIF}
{$IFDEF OCI_D5}
, otBLOB, otCLOB, otUnknown, otUnknown, otUnknown, otUnknown
{$ENDIF}
{$IFDEF OCI_D6}
, otUnknown, otUnknown
{$ENDIF}
, otUnknown, otUnknown, otUnknown, otUnknown
);


I cant get prepared queries to work. Is something like this possible:

q.sql.text := 'select * from atable where id = :id';
q.prepare;
q.params[0].asVariant := 42;
q.open;

I get an error on .open saying the param is of unknown type. anyone
run across this?


-Andy

.