Click here to Skip to main content
15,867,141 members
Home / Discussions / Database
   

Database

 
AnswerRe: Clear database contents Pin
-Dr_X-15-Feb-07 11:06
-Dr_X-15-Feb-07 11:06 
AnswerRe: Clear database contents Pin
Member 9615-Feb-07 11:12
Member 9615-Feb-07 11:12 
GeneralRe: Clear database contents Pin
Zoltan Balazs15-Feb-07 11:18
Zoltan Balazs15-Feb-07 11:18 
GeneralRe: Clear database contents Pin
Member 9615-Feb-07 11:29
Member 9615-Feb-07 11:29 
GeneralRe: Clear database contents Pin
Zoltan Balazs15-Feb-07 11:33
Zoltan Balazs15-Feb-07 11:33 
GeneralRe: Clear database contents Pin
Member 9615-Feb-07 11:39
Member 9615-Feb-07 11:39 
GeneralRe: Clear database contents Pin
Zoltan Balazs15-Feb-07 11:42
Zoltan Balazs15-Feb-07 11:42 
GeneralRe: Clear database contents Pin
Member 9615-Feb-07 11:47
Member 9615-Feb-07 11:47 
Zoltan Balazs wrote:
I have, but I store only the last version of the DB.


That's fine, that's what I do. When my user logs in, the required db schema set in my app is checked against the db's stored schema number.

If the db has a higher number my app exits with a warning that it's out of date.

If the db has a lower number my app triggers a schema update that goes through a big switch statement and executes each newer schema level update until it matches the program's required version.
GeneralRe: Clear database contents Pin
Zoltan Balazs15-Feb-07 11:52
Zoltan Balazs15-Feb-07 11:52 
Questionautocomplete using large lookup table Pin
AndrusM15-Feb-07 8:52
AndrusM15-Feb-07 8:52 
AnswerRe: autocomplete using large lookup table Pin
-Dr_X-15-Feb-07 10:55
-Dr_X-15-Feb-07 10:55 
GeneralRe: autocomplete using large lookup table Pin
AndrusM16-Feb-07 3:09
AndrusM16-Feb-07 3:09 
AnswerRe: autocomplete using large lookup table Pin
Keith Worden16-Feb-07 6:08
Keith Worden16-Feb-07 6:08 
GeneralRe: autocomplete using large lookup table Pin
AndrusM16-Feb-07 6:16
AndrusM16-Feb-07 6:16 
GeneralRe: autocomplete using large lookup table Pin
Keith Worden16-Feb-07 6:23
Keith Worden16-Feb-07 6:23 
QuestionTransaction on Dataset in ADO.net Pin
Neeraj_Maurya15-Feb-07 5:37
Neeraj_Maurya15-Feb-07 5:37 
AnswerRe: Transaction on Dataset in ADO.net Pin
Colin Angus Mackay15-Feb-07 13:47
Colin Angus Mackay15-Feb-07 13:47 
Questiongetting data from the DB Pin
minkinin15-Feb-07 2:25
minkinin15-Feb-07 2:25 
AnswerRe: getting data from the DB Pin
Member 9615-Feb-07 11:42
Member 9615-Feb-07 11:42 
QuestionTrigger examples needed Pin
Saira Tanwir14-Feb-07 14:28
Saira Tanwir14-Feb-07 14:28 
AnswerRe: Trigger examples needed Pin
subai14-Feb-07 18:11
subai14-Feb-07 18:11 
AnswerRe: Trigger examples needed Pin
Colin Angus Mackay14-Feb-07 22:39
Colin Angus Mackay14-Feb-07 22:39 
QuestionDelete row Pin
kani9814-Feb-07 11:23
kani9814-Feb-07 11:23 
AnswerRe: Delete row Pin
subai14-Feb-07 18:10
subai14-Feb-07 18:10 
QuestionAlter table query issue Pin
Saira Tanwir14-Feb-07 5:59
Saira Tanwir14-Feb-07 5:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.