Click here to Skip to main content
14,636,898 members
Home » Discussions » Database
   

Database

 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23519-Apr-20 3:33
MemberUranium-23519-Apr-20 3:33 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan19-Apr-20 4:11
mveRichard MacCutchan19-Apr-20 4:11 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23519-Apr-20 4:39
MemberUranium-23519-Apr-20 4:39 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan19-Apr-20 4:52
mveRichard MacCutchan19-Apr-20 4:52 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23519-Apr-20 16:37
MemberUranium-23519-Apr-20 16:37 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan19-Apr-20 21:46
mveRichard MacCutchan19-Apr-20 21:46 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23519-Apr-20 23:05
MemberUranium-23519-Apr-20 23:05 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan19-Apr-20 23:35
mveRichard MacCutchan19-Apr-20 23:35 
Yes, but that has nothing to do with creating a valid SQL statement. The textbox is provided by the user, so your code should verify that it contains valid data. You then take the validated text and store into one of the SQL Parameters which get passed in to he execution module. Do not assume that the user knows what he or she is doing and just accept whatever they type. Many times it will be wrong, mist-typed, not understanding what is required, etc.
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23520-Apr-20 9:44
MemberUranium-23520-Apr-20 9:44 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan20-Apr-20 21:36
mveRichard MacCutchan20-Apr-20 21:36 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard Deeming21-Apr-20 0:35
mveRichard Deeming21-Apr-20 0:35 
Questioncomplicated SQL Join request from two server Pin
Member 1473386615-Apr-20 21:11
MemberMember 1473386615-Apr-20 21:11 
AnswerRe: complicated SQL Join request from two server Pin
Richard Deeming16-Apr-20 0:08
mveRichard Deeming16-Apr-20 0:08 
GeneralRe: complicated SQL Join request from two server Pin
Member 1473386616-Apr-20 2:36
MemberMember 1473386616-Apr-20 2:36 
GeneralRe: complicated SQL Join request from two server Pin
Richard Deeming16-Apr-20 2:48
mveRichard Deeming16-Apr-20 2:48 
GeneralRe: complicated SQL Join request from two server Pin
Member 1473386616-Apr-20 3:04
MemberMember 1473386616-Apr-20 3:04 
QuestionGetting data from simple SQLite table returns NULL Pin
Uranium-23511-Apr-20 23:02
MemberUranium-23511-Apr-20 23:02 
AnswerRe: Getting data from simple SQLite table returns NULL Pin
Richard MacCutchan11-Apr-20 23:19
mveRichard MacCutchan11-Apr-20 23:19 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Uranium-23512-Apr-20 8:26
MemberUranium-23512-Apr-20 8:26 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Mycroft Holmes12-Apr-20 12:29
professionalMycroft Holmes12-Apr-20 12:29 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Uranium-23512-Apr-20 14:28
MemberUranium-23512-Apr-20 14:28 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Uranium-23512-Apr-20 17:25
MemberUranium-23512-Apr-20 17:25 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Richard MacCutchan12-Apr-20 21:45
mveRichard MacCutchan12-Apr-20 21:45 
QuestionSQL Login Failed Message Pin
Kevin Marois8-Apr-20 19:12
professionalKevin Marois8-Apr-20 19:12 
AnswerRe: SQL Login Failed Message Pin
Richard Deeming9-Apr-20 0:27
mveRichard Deeming9-Apr-20 0:27 

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.