Click here to Skip to main content
14,970,304 members
Home / Discussions / Database
   

Database

 
AnswerRe: The Best Free Database for real-time data storing and querying Pin
Gerry Schmitz30-Oct-20 8:40
mveGerry Schmitz30-Oct-20 8:40 
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
MemberPeter 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
MemberPeter Mortier19-Oct-20 1:58 
AnswerRe: Database ADO exception on adding new record Pin
Peter Mortier19-Oct-20 2:00
MemberPeter Mortier19-Oct-20 2:00 
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov19-Oct-20 7:07
MemberVictor Nijegorodov19-Oct-20 7:07 
According to Open Method (ADO Recordset) - SQL Server | Microsoft Docs:


It is not a good idea to use the Source argument of the Open method to perform an action query that does not return records because there is no easy way to determine whether the call succeeded. The Recordset returned by such a query will be closed. To perform a query that does not return records, such as a SQL INSERT statement, call the Execute method of a Command object or the Execute method of a Connection object instead.

GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier20-Oct-20 8:40
MemberPeter Mortier20-Oct-20 8:40 
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov20-Oct-20 9:29
MemberVictor Nijegorodov20-Oct-20 9:29 
QuestionDatabase design and custom query for this use case ? Pin
karengsh13-Oct-20 23:17
Memberkarengsh13-Oct-20 23:17 
QuestionShould I store files in a database? Pin
Member 1260015012-Oct-20 22:37
MemberMember 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
MemberMember 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
MemberMember 1363071429-Sep-20 6:06 
AnswerRe: Database scripts version control process/strategy? Pin
David Mujica29-Sep-20 7:48
MemberDavid 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
MemberVictor 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 

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.