TOraQuery limited field number?
Posted: Thu 05 Oct 2006 10:49
Hello,
I have a problem with fetching all fields from each record of Oracle Spatial.
There are no problems with field names and a part of geometry field.
Problems start with SDO_ELEM_INFO - there are 100 fields imported using TOraQuery (there should be olny 3 - well there are 3. The rest is NULL)
The same happens with SDO_ORDINATE_ARRAY. No matter how many coordiantes there are, TOraQuery always fetches 100 fields. Even (what is my biggest concern) when there are more of them.
Do you know how to get all the fields?
What about TOraSQL? Could I use it instead of TOraQuery?
PS. I'm using BCB 6, data is imported from EasyLoader and is imported corrently according to iSQL*PLUS
I have a problem with fetching all fields from each record of Oracle Spatial.
There are no problems with field names and a part of geometry field.
Problems start with SDO_ELEM_INFO - there are 100 fields imported using TOraQuery (there should be olny 3 - well there are 3. The rest is NULL)
The same happens with SDO_ORDINATE_ARRAY. No matter how many coordiantes there are, TOraQuery always fetches 100 fields. Even (what is my biggest concern) when there are more of them.
Do you know how to get all the fields?
What about TOraSQL? Could I use it instead of TOraQuery?
Code: Select all
do{
POINT_X = QUERY->Fields->Fields[++j]->AsFloat;
POINT_Y = QUERY->Fields->Fields[++j]->AsFloat;
}while(jFieldCount-1);