You need to take a step back and realize that you are not working with a
physical table here.
You are working with an SQL server that puts the records anywhere
(physically) it pleases.
We only have the concept of a dataset which is returned via a SELECT
statement.
You need to design and implement a way to emulate this if it is what you
really need.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <rodrigueztang@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, August 01, 2001 11:05 PM
Subject: [IBO] Physical position in a table.


Do you have explain better the concept to me but I need to recover of
a lot of record from the table in the same way as they were entered
in the DBGRID.

For example a user initially enters 5 records in a DBGrid and makes
COMMIT. So, it recovers them and the DBGRID shows them as they were
entered, but if the user inserts a record between the second and
third record (position), when it makes COMMIT and reload all records,
DBGrid show the record at end of dbgrid. Why?


--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> There really isn't such a concept as a physical position in a table
in SQL.
> You would have to have a sort designated and then maintain values
so that it
> fell within your predefined sort position.
>
> HTH,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: <rodrigueztang@c...>
> To: <IBObjects@y...>
> Sent: Wednesday, August 01, 2001 10:42 PM
> Subject: [IBO] (unknown)
>
>
> Hi
>
> I tested IBO. I have any question:
>
> It's possible insert a record in any position of the DBGRID (except
> at the end) and that the same DBGrid Position's is conserved in the
> physical table.
>
>
> For example
>
> In the DBGRID In the Table
>
> Record
>
> 1 1
> 2 2
> 5 New Record 5 New Record
> 3 3
> 4 4
>
>
> Thanks
>
>
> José Rodríguez
> Venezuela.
>
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/