Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: NCOCI8 feature plans
NCOCI8 feature plans
Posted: 2000/06/04 14:51
 
Hi All !
There is a time discuss, what should be a future of NCOCI8 <g>. Let me start:
- Filters (on server);
- Indexes (on client / on server);
- Enahanced cached updates support (track of changes in
multiple datasets, undo to any point in time);
- TOCITable;
- CURSOR PL/SQL parameters;
- Object extensions;
- Full Oracle8i scalability support:
- Migratable sessions;
- Multiple sessions per server process;
- Oracle8 IDE - debugging/reverse engineering/...;
RE: NCOCI8 feature plans
Posted: 2000/06/07 08:16
 
Hi !
I am woting for
- Indexes (on client / on server);
but I don't know what you mean by that.
It would be nice to have ordered data set
on client. Now, after edit, row stays in
the original position and that is great.
But, after insert in the ordered data set
new row is not ordered and you have to refresh to put the row in the order.
That is normal.
What do you mean by Indexes on client ?
- posibility to mark fields
FieldOrder=0 (not in order),
FieldOrder=1 (first field in order),
FieldOrder=2 (second field in order)...
and to have Insert behave like in desktop
databases + to be able to Resort fully
fetched dataset without requerying the server.
To be honest, I'am more than satisfied with
NCOCI8 0.7.5 feature list(for now). There is many features that I have to try and investigate. I have some problems :
1.When I sit on the PageDown in the Grid
on the large DataSet that is not fully fetched some time I get rows with garbage,after refresh data is normal. Maybe I did something wrong.
2. When scroling Master Detail is not updated properly, so in procedure TOCICustomQuery.RefreshParams;
I added: if Prepared then Unprepare;
before Open.

Anyway, the feature that I miss the most is the more detailed help file.
RE: NCOCI8 feature plans
Posted: 2000/06/07 11:54
 
>> Indexes (on client / on server);
I mean follows. TOCIDataSet will have propertys IndexDefs, IndexFieldNames, IndexName. So what NCOCI8 will do with it ..
- on client. If programmer turn on option "sort on client" NCOCI8 will maintain index on client and sort data without server. It may be usefull for maintain aggregates, data analysis, Master-detail support (using ranges) with CachedUpdates turned on.
- on server. NCOCI8 will transparently modify ORDER BY clause. In any case, that is way to TOCITable

About problems ...
1) Let you send me demo project, may be with exported table.
2) I will investigate this.

Also, i allready suggest, that next version will have:
- CURSOR PL/SQL parameters;
- MIDAS support.

But "Indexes" is allready next in order