0

I have a settings table 'SettingTab' and a Number column 'nSlNo (int)' to generate primary key of two tables 'Tab1' and 'Tab2'. How to implement this without any number conflict when access setting table at same time by two tables.

nvogel
  • 24,981
  • 1
  • 44
  • 82
rgb
  • 143
  • 3
  • 15
  • 1
    the solutions seems to be in your tags, don't do it, use a auto generated value. – bummi Oct 15 '14 at 14:05
  • I'm not sure if I understand your problem, but maybe a sequence could help? Could you explain your issue with some example data? – NickyvV Oct 15 '14 at 14:25

1 Answers1

0

I used SQL scope or Begin-Commit Transaction. When I started accessing Setting table sent a Update command to the Setting table. So the table was locked till the Commit. By this way I avoid the Conflict.

rgb
  • 143
  • 3
  • 15