Subject | TIB_Cursor and DB_KEY |
---|---|
Author | clivewalden |
Post date | 2006-06-08T16:28:11Z |
I am writing out a query to a comma seperated ASCII file.
SQL like:
SELECT A,B,C
FROM MYTABLE
I have
ReadOnly=True
RequestLive=False
Unidirectional=True
In spite of all of the above when I iterate through the fields:
for i := 0 to ibCursor.FieldCount-1
I get an extra field at the end which appears to be the DB_KEY field.
Question:
Is there some other property that will suppress the DB_KEY field as a
column OR is it safe to use ibCursor.FieldCount-2 in the iteration?
Thanks,
Clive.
SQL like:
SELECT A,B,C
FROM MYTABLE
I have
ReadOnly=True
RequestLive=False
Unidirectional=True
In spite of all of the above when I iterate through the fields:
for i := 0 to ibCursor.FieldCount-1
I get an extra field at the end which appears to be the DB_KEY field.
Question:
Is there some other property that will suppress the DB_KEY field as a
column OR is it safe to use ibCursor.FieldCount-2 in the iteration?
Thanks,
Clive.