Click here to Skip to main content
14,742,134 members
Home » Discussions » Database
   

Database

 
AnswerRe: The Best Free Database for real-time data storing and querying Pin
Eddy Vluggen46mins ago
professionalEddy Vluggen46mins ago 
QuestionDatabase ADO exception on adding new record Pin
Peter Mortier16-Oct-20 5:21
MemberPeter Mortier16-Oct-20 5:21 
GeneralRe: Database ADO exception on adding new record Pin
Richard MacCutchan16-Oct-20 5:53
mveRichard MacCutchan16-Oct-20 5:53 
AnswerRe: Database ADO exception on adding new record Pin
CHill6016-Oct-20 6:18
mveCHill6016-Oct-20 6:18 
GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier19-Oct-20 2:58
MemberPeter Mortier19-Oct-20 2:58 
AnswerRe: Database ADO exception on adding new record Pin
Peter Mortier19-Oct-20 3:00
MemberPeter Mortier19-Oct-20 3:00 
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov19-Oct-20 8:07
MemberVictor Nijegorodov19-Oct-20 8:07 
GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier20-Oct-20 9:40
MemberPeter Mortier20-Oct-20 9:40 
OK, so I changed my code to something like this :
_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 10:29
MemberVictor Nijegorodov20-Oct-20 10:29 
QuestionDatabase design and custom query for this use case ? Pin
karengsh14-Oct-20 0:17
Memberkarengsh14-Oct-20 0:17 
QuestionShould I store files in a database? Pin
Member 1260015012-Oct-20 23:37
MemberMember 1260015012-Oct-20 23:37 
AnswerRe: Should I store files in a database? Pin
Richard Deeming12-Oct-20 23:54
mveRichard Deeming12-Oct-20 23:54 
QuestionMYSQL Pin
Member 147129666-Oct-20 11:21
MemberMember 147129666-Oct-20 11:21 
AnswerRe: MYSQL Pin
ZurdoDev6-Oct-20 11:34
professionalZurdoDev6-Oct-20 11:34 
QuestionDatabase scripts version control process/strategy? Pin
Member 1363071429-Sep-20 7:06
MemberMember 1363071429-Sep-20 7:06 
AnswerRe: Database scripts version control process/strategy? Pin
David Mujica29-Sep-20 8:48
MemberDavid Mujica29-Sep-20 8:48 
AnswerRe: Database scripts version control process/strategy? Pin
ZurdoDev29-Sep-20 10:05
professionalZurdoDev29-Sep-20 10:05 
QuestionSimple Database design Pin
fdanos23-Sep-20 21:23
professionalfdanos23-Sep-20 21:23 
AnswerRe: Simple Database design Pin
Victor Nijegorodov23-Sep-20 21:54
MemberVictor Nijegorodov23-Sep-20 21:54 
AnswerRe: Simple Database design Pin
Mycroft Holmes24-Sep-20 13:18
professionalMycroft Holmes24-Sep-20 13:18 
QuestionWhy does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 3:35
professionalfd97507-Sep-20 3:35 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
Jörgen Andersson7-Sep-20 5:18
professionalJörgen Andersson7-Sep-20 5:18 
GeneralRe: Why does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 22:14
professionalfd97507-Sep-20 22:14 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
ZurdoDev21-Sep-20 8:03
professionalZurdoDev21-Sep-20 8:03 
QuestionHow to use a FileInfo control to add a filename to an Access database Pin
rodgerm25-Aug-20 15:51
Memberrodgerm25-Aug-20 15: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.