Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-11 : 14:02:05
|
| Ritu writes "I have a database made in sybase10.2. There accounting entries have been made from the financial year 1997-98. i.e.April1997 - March 1998 given the year code 02April1998 - March 1999 given the year code 03April1999 - March 2000 given the year code 04April2000 - March 2001 given the year code 05April2001 - March 2002 given the year code 06April2002 - March 2003 given the year code 07.How can I lock my database so that the user can make entries can only be made in the year code 07 and no entries made till the year code can be deleted or modified." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-12 : 04:14:36
|
| You can put a trigger on the table to error any entries for the wrong year.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Database locking