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

Database

 
AnswerRe: The Best Free Database for real-time data storing and querying Pin
Eddy Vluggen26-Jan-21 12:36
professionalEddy Vluggen26-Jan-21 12:36 
QuestionDatabase ADO exception on adding new record Pin
Peter Mortier16-Oct-20 4:21
Peter Mortier16-Oct-20 4:21 
GeneralRe: Database ADO exception on adding new record Pin
Richard MacCutchan16-Oct-20 4:53
mveRichard MacCutchan16-Oct-20 4:53 
AnswerRe: Database ADO exception on adding new record Pin
CHill6016-Oct-20 5:18
mveCHill6016-Oct-20 5:18 
GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier19-Oct-20 1:58
Peter Mortier19-Oct-20 1:58 
AnswerRe: Database ADO exception on adding new record Pin
Peter Mortier19-Oct-20 2:00
Peter Mortier19-Oct-20 2:00 
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov19-Oct-20 7:07
Victor Nijegorodov19-Oct-20 7:07 
GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier20-Oct-20 8:40
Peter Mortier20-Oct-20 8:40 
OK, so I changed my code to something like this :
C++
_CommandPtr pCmd;
pCmd.CreateInstance(__uuidof(Command)); 
pCmd->ActiveConnection = pConn; 
pCmd->CommandText = "Insert into [table] ([value]) values (1)";
pCmd->Execute();


Now in the table is an autoincrement ID which I need for use in a linked table.
Does the pCmd->Execute() return a recordset and if so what's in it?
Or is there another way to get the data of the just added record?

I find very few information on this topic.
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov20-Oct-20 9:29
Victor Nijegorodov20-Oct-20 9:29 
QuestionDatabase design and custom query for this use case ? Pin
karengsh13-Oct-20 23:17
karengsh13-Oct-20 23:17 
QuestionShould I store files in a database? Pin
Member 1260015012-Oct-20 22:37
Member 1260015012-Oct-20 22:37 
AnswerRe: Should I store files in a database? Pin
Richard Deeming12-Oct-20 22:54
mveRichard Deeming12-Oct-20 22:54 
QuestionMYSQL Pin
Member 147129666-Oct-20 10:21
Member 147129666-Oct-20 10:21 
AnswerRe: MYSQL Pin
ZurdoDev6-Oct-20 10:34
professionalZurdoDev6-Oct-20 10:34 
QuestionDatabase scripts version control process/strategy? Pin
Member 1363071429-Sep-20 6:06
Member 1363071429-Sep-20 6:06 
AnswerRe: Database scripts version control process/strategy? Pin
David Mujica29-Sep-20 7:48
David Mujica29-Sep-20 7:48 
AnswerRe: Database scripts version control process/strategy? Pin
ZurdoDev29-Sep-20 9:05
professionalZurdoDev29-Sep-20 9:05 
QuestionSimple Database design Pin
fdanos23-Sep-20 20:23
professionalfdanos23-Sep-20 20:23 
AnswerRe: Simple Database design Pin
Victor Nijegorodov23-Sep-20 20:54
Victor Nijegorodov23-Sep-20 20:54 
AnswerRe: Simple Database design Pin
Mycroft Holmes24-Sep-20 12:18
professionalMycroft Holmes24-Sep-20 12:18 
QuestionWhy does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 2:35
professionalfd97507-Sep-20 2:35 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
Jörgen Andersson7-Sep-20 4:18
professionalJörgen Andersson7-Sep-20 4:18 
GeneralRe: Why does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 21:14
professionalfd97507-Sep-20 21:14 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
ZurdoDev21-Sep-20 7:03
professionalZurdoDev21-Sep-20 7:03 
QuestionHow to use a FileInfo control to add a filename to an Access database Pin
rodgerm25-Aug-20 14:51
rodgerm25-Aug-20 14:51 

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.