Viewing 12 posts - 1 through 12 (of 12 total)
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...
January 12, 2005 at 4:04 am
Try adding "Auto Translate=False" to your connection string.
January 12, 2005 at 4:00 am
Many thanks to tushardighe.
I did not understand the syscolumns table a doing more reading on it now.
Avron
October 14, 2004 at 1:51 am
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...
October 11, 2004 at 5:37 am
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...
October 22, 2003 at 7:43 am
Better to cache all unchanged data (if not in Giga's) in the IIS memory.
October 13, 2003 at 12:11 am
THANKS - Its working.
I will start learning more about grouping today.
November 25, 2002 at 10:08 am
Not realy care.
anny accurance is good. just one accurance of each row that have those distinct values.
November 25, 2002 at 9:36 am
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...
November 25, 2002 at 9:21 am
If the table has:
alloc_num, price_num, serv_prlev, agent_num, ...other fields
--------------------------------------------------------------------------------------
1 , 127 , 1 , 0 , ......, ....
2 , 127 , 1 , 0...
November 25, 2002 at 8:58 am
Viewing 12 posts - 1 through 12 (of 12 total)