Subject | Re: [IBO] FOR UPDATE ???? |
---|---|
Author | cgar1136 |
Post date | 2005-02-23T01:36:02Z |
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 :
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
because i'd see it at one "Technical Information Sheet" in the IBO
website... thanx for the tips... = :-)
Now i have a question :
>IBOrow that
> 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
> you choose to perform such an operation on, whenever the dataset'sOk, so based in this fact, should be possible that i can resort the
> RequestLive property is True
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