Click here to Skip to main content
16,010,523 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Is MSVC++ Standard C++ Pin
Erik Funkenbusch17-Jul-01 13:18
Erik Funkenbusch17-Jul-01 13:18 
GeneralDrag Files into program Pin
#realJSOP17-Jul-01 1:58
professional#realJSOP17-Jul-01 1:58 
GeneralRe: Drag Files into program Pin
Simon Capewell17-Jul-01 2:29
Simon Capewell17-Jul-01 2:29 
GeneralRe: Drag Files into program Pin
Tomasz Sowinski17-Jul-01 2:34
Tomasz Sowinski17-Jul-01 2:34 
GeneralRe: Drag Files into program Pin
#realJSOP18-Jul-01 1:27
professional#realJSOP18-Jul-01 1:27 
GeneralRe: Drag Files into program Pin
Tomasz Sowinski18-Jul-01 1:48
Tomasz Sowinski18-Jul-01 1:48 
QuestionHoe To Set OBDC In Installshield? Pin
nemati17-Jul-01 1:19
nemati17-Jul-01 1:19 
GeneralCDatabase / SQLExecute / Finding ID Pin
Jimmy Ehrnström16-Jul-01 23:15
Jimmy Ehrnström16-Jul-01 23:15 
What I am trying to do is do is to add a new entry to a database table with an
SQL insert-statement, and then find the, by the DBMS, auto-assigned id for the new entry.

So far I've managed to accomplish this by first using the SQLExecute command,
followed by a select-statement to identify the id of the new entry.

Unfortunately I've stumbled across a table containing lots of dublicates,
where I've found no way to uniquely identify the new entry using a select-
statement.

Is there any other way than using a select-statement to find the id for my new
entry? The only one I can think of is looking for the highest id in the table,
and assume that this is the id I'm looking for. This, I feel, is kind of risky
though, since I'm not sure about how id's are assigned in the DBMS (Microsoft
SQL Server). If the DBMS decides to start reusing lower order id's my program
would stop functioning correctly.

Any advice would be much appreciated.

Thanks,

Jimmy Ehrnström
GeneralRe: CDatabase / SQLExecute / Finding ID Pin
Tomasz Sowinski16-Jul-01 23:23
Tomasz Sowinski16-Jul-01 23:23 
GeneralRe: CDatabase / SQLExecute / Finding ID Pin
Jimmy Ehrnström17-Jul-01 22:23
Jimmy Ehrnström17-Jul-01 22:23 
Generaljava.lang.NullPointerException Pin
NormDroid16-Jul-01 22:25
professionalNormDroid16-Jul-01 22:25 
GeneralDll cleanup problems Pin
16-Jul-01 20:59
suss16-Jul-01 20:59 
GeneralRe: Dll cleanup problems Pin
Michael Dunn17-Jul-01 7:10
sitebuilderMichael Dunn17-Jul-01 7:10 
GeneralMidi programming Pin
16-Jul-01 18:58
suss16-Jul-01 18:58 
GeneralRe: Midi programming Pin
Jim A. Johnson16-Jul-01 19:11
Jim A. Johnson16-Jul-01 19:11 
GeneralDrag and Drop For ListBox Pin
16-Jul-01 18:49
suss16-Jul-01 18:49 
GeneralRe: Drag and Drop For ListBox Pin
Michael Dunn16-Jul-01 19:40
sitebuilderMichael Dunn16-Jul-01 19:40 
Generalsending email Pin
Alex Griffing16-Jul-01 18:26
Alex Griffing16-Jul-01 18:26 
GeneralRe: sending email Pin
Jon Sagara16-Jul-01 19:15
Jon Sagara16-Jul-01 19:15 
GeneralUsing of ActiveX in SDI ... Pin
Hadi Rezaee16-Jul-01 18:11
Hadi Rezaee16-Jul-01 18:11 
QuestionHow can i get the dns server ip in w2k? Pin
adone16-Jul-01 17:02
adone16-Jul-01 17:02 
GeneralODBC help:how to set DSN of database automatically Pin
xiaolin16-Jul-01 16:49
xiaolin16-Jul-01 16:49 
GeneralRe: ODBC help:how to set DSN of database automatically Pin
16-Jul-01 20:57
suss16-Jul-01 20:57 
GeneralCapturing MOuse Move within a CListCtrl Pin
sankar16-Jul-01 16:28
sankar16-Jul-01 16:28 
GeneralRe: Capturing MOuse Move within a CListCtrl Pin
Michael Dunn16-Jul-01 17:03
sitebuilderMichael Dunn16-Jul-01 17:03 

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.