If you use optemistic locking with ADO, Update raise an exception if the data was changed by another user. You can then show your user the version and decide if...

Try adding "Auto Translate=False" to your connection string.

Many thanks to tushardighe.

I did not understand the syscolumns table a doing more reading on it now.

Avron

AJ Ahrens wrote:

You can get the constraint name FROM sysobjects WHERE xtype = 'C' AND WHERE parent_obj =  the [id] FROM sysobjects WHERE [name] = 'WebRsLog'.

It is all has to be...

Jordan, You wrote:

"Another possibility......but this doesn’t work when two users attempt to access the same row at the same time."

You can try to lock by "UPDATE table SET lock=1 WHERE...

Thanks Magnaley2000.

Better to cache all unchanged data (if not in Giga's) in the IIS memory.

THANKS - Its working.

I will start learning more about grouping today.

Going back to test it

Not realy care.

anny accurance is good. just one accurance of each row that have those distinct values.

sorry, this is not what i ment.

when i do: "SELECT DISTINCT price_num, serv_prlv, agent_num FROM allocdet ORDER BY price_num, serv_prlv, agent_num".

this get me the correct lines.

but i want ALL the...

If the table has:

alloc_num, price_num, serv_prlev, agent_num, ...other fields

--------------------------------------------------------------------------------------

1 , 127 , 1 , 0 , ......, ....

2 , 127 , 1 , 0...