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

Database

 
Rant[REPOST] how do i scan a image from a flat bed scanner using python and Microsoft access Pin
Richard Deeming18-Oct-18 3:28
mveRichard Deeming18-Oct-18 3:28 
AnswerRe: how do i scan a image from a flat bed scanner using python and Microsoft access Pin
CHill6018-Oct-18 4:50
mveCHill6018-Oct-18 4:50 
Generalthank you for your reply how you suggest i do it? Pin
Member 1401815918-Oct-18 20:52
Member 1401815918-Oct-18 20:52 
GeneralRe: thank you for your reply how you suggest i do it? Pin
CHill6021-Oct-18 2:20
mveCHill6021-Oct-18 2:20 
QuestionACCESS DATABASE OR PYTHON - SCANNING FROM A FLAT BED SCANNER Pin
Member 1401815918-Oct-18 0:41
Member 1401815918-Oct-18 0:41 
AnswerRe: ACCESS DATABASE OR PYTHON - SCANNING FROM A FLAT BED SCANNER Pin
Richard MacCutchan18-Oct-18 1:22
mveRichard MacCutchan18-Oct-18 1:22 
QuestionSQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Hotaxion8-Oct-18 21:58
Hotaxion8-Oct-18 21:58 
AnswerRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Richard Deeming9-Oct-18 2:15
mveRichard Deeming9-Oct-18 2:15 
Don't do it like that. As you've discovered, if two users hit "save" at the same time, they'll both get the same "last number", and overwrite each other's data.

Either use an IDENTITY column:
IDENTITY (Property) (Transact-SQL) | Microsoft Docs[^]
SCOPE_IDENTITY (Transact-SQL) | Microsoft Docs[^]

or a SEQUENCE:
Sequence Numbers | Microsoft Docs[^]



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Hotaxion9-Oct-18 15:20
Hotaxion9-Oct-18 15:20 
GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Victor Nijegorodov9-Oct-18 22:03
Victor Nijegorodov9-Oct-18 22:03 
GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Hotaxion14-Oct-18 17:20
Hotaxion14-Oct-18 17:20 
GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Richard Deeming10-Oct-18 7:57
mveRichard Deeming10-Oct-18 7:57 
GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Hotaxion14-Oct-18 17:23
Hotaxion14-Oct-18 17:23 
AnswerRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
CHill6017-Oct-18 5:05
mveCHill6017-Oct-18 5:05 
GeneralRe: SQL Header Detail Last Number Problem (overlap identity saving Details) Pin
Richard Deeming17-Oct-18 9:04
mveRichard Deeming17-Oct-18 9:04 
QuestionNeed good, easy to manage "mail merge" program, free or not Pin
Charles Wolfe7-Oct-18 21:39
Charles Wolfe7-Oct-18 21:39 
AnswerRe: Need good, easy to manage "mail merge" program, free or not Pin
Victor Nijegorodov8-Oct-18 8:32
Victor Nijegorodov8-Oct-18 8:32 
GeneralRe: Need good, easy to manage "mail merge" program, free or not Pin
Charles Wolfe9-Oct-18 19:47
Charles Wolfe9-Oct-18 19:47 
GeneralRe: Need good, easy to manage "mail merge" program, free or not Pin
CHill6017-Oct-18 8:45
mveCHill6017-Oct-18 8:45 
QuestionError passing MongoDB ObjectID back to .Net Core 2.1 Controller Pin
jkirkerx27-Sep-18 12:41
professionaljkirkerx27-Sep-18 12:41 
AnswerRe: Error passing MongoDB ObjectID back to .Net Core 2.1 Controller Pin
Nathan Minier28-Sep-18 1:19
professionalNathan Minier28-Sep-18 1:19 
GeneralRe: Error passing MongoDB ObjectID back to .Net Core 2.1 Controller Pin
jkirkerx28-Sep-18 8:02
professionaljkirkerx28-Sep-18 8:02 
GeneralRe: Error passing MongoDB ObjectID back to .Net Core 2.1 Controller Pin
jkirkerx28-Sep-18 8:17
professionaljkirkerx28-Sep-18 8:17 
GeneralRe: Error passing MongoDB ObjectID back to .Net Core 2.1 Controller Pin
Nathan Minier28-Sep-18 8:45
professionalNathan Minier28-Sep-18 8:45 
GeneralRe: Error passing MongoDB ObjectID back to .Net Core 2.1 Controller Pin
jkirkerx28-Sep-18 12:18
professionaljkirkerx28-Sep-18 12:18 

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.