Subject Re: [IBO] FOR UPDATE ????
Author cgar1136
Ok. Thanx Helen, just wondering about the fact's of the statement
because i'd see it at one "Technical Information Sheet" in the IBO
website... thanx for the tips... = :-)

Now i have a question :


>IBO
> implements techniques to make output sets *appear* to be updatable. In
> summary, this involves identifying the unique key of an output set and
> constructing update, insert and delete statements for each output
row that
> you choose to perform such an operation on, whenever the dataset's
> RequestLive property is True

Ok, so based in this fact, should be possible that i can resort the
dataset at the client side by any field that i want, without have to
refetch all the cursor from the server with a different "order by"
statement??... is that possible???... i mean the unique keys wouldn't
be affected by a simple "re-sort" operation and at many cases this is
very practical... i've see that with the IBO native controls (Grids)
this is easy, but what about the TDataset Compatibles??... i would
like to can re-sort a TIBOQuery asociated to an InfoPower Grid or a
ReportBuilder pipeLine...

Until now i've been using some VCL "MemoryDataSet's" to can make this
trick but it's a little inneficient because i need to move all the
data from a IBOQuery to my MemoryDataset and can reorder the records
at the way i need, but this eats a lot of time when the number of
records it's bigger and bigger, and the memory consumed for this is
too much... so if i could reorder the rows in the IBOQuery itself with
the data that the cursor have and don't need to go to the server for
the same data just for a different order, this would make my life a
lot more easy...

Thanx