Very Computer

    I have used SP to insert and update a table record from VB6 through ADO
and DSN to SQL 7 sp1. The record seem added & fine under VB6. However, if I
opened the table from SQL enterprise manager and moved to the last row, the
record it not showing up. This happen on some of my tables.

    It there anything wrong on my data?

Thanks

Rick

Quote:> However, if I opened the table from SQL enterprise manager and
> moved to the last row, the record it not showing up.

This is because SQL does not mainatin records in the "order" you add
them, especially if indexed. Some clever person can no doubt give you a
technical explanation why, but take it from me it doesn't.

Seacrh the table fully to find your record.

* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!

    You are right, I found the record is not in-order, even it is a
autonumber record. I thought MSSQL's manager just like Access. Always put
the record into the last row.

Thanks

Rick

Quote:> > However, if I opened the table from SQL enterprise manager and
> > moved to the last row, the record it not showing up.

> Rick,

> This is because SQL does not mainatin records in the "order" you add
> them, especially if indexed. Some clever person can no doubt give you a
> technical explanation why, but take it from me it doesn't.

> Seacrh the table fully to find your record.

> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!