Click here to Skip to main content
14,694,507 members
Home » Discussions » Database
   

Database

 
Questioncomplicated SQL Join request from two server Pin
Member 1473386615-Apr-20 22:11
MemberMember 1473386615-Apr-20 22:11 
AnswerRe: complicated SQL Join request from two server Pin
Richard Deeming16-Apr-20 1:08
mveRichard Deeming16-Apr-20 1:08 
GeneralRe: complicated SQL Join request from two server Pin
Member 1473386616-Apr-20 3:36
MemberMember 1473386616-Apr-20 3:36 
GeneralRe: complicated SQL Join request from two server Pin
Richard Deeming16-Apr-20 3:48
mveRichard Deeming16-Apr-20 3:48 
GeneralRe: complicated SQL Join request from two server Pin
Member 1473386616-Apr-20 4:04
MemberMember 1473386616-Apr-20 4:04 
QuestionGetting data from simple SQLite table returns NULL Pin
Uranium-23512-Apr-20 0:02
MemberUranium-23512-Apr-20 0:02 
AnswerRe: Getting data from simple SQLite table returns NULL Pin
Richard MacCutchan12-Apr-20 0:19
mveRichard MacCutchan12-Apr-20 0:19 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Uranium-23512-Apr-20 9:26
MemberUranium-23512-Apr-20 9:26 
no, that wasn't a copy & paste, it was a misspelling here, when I actually do it from my c# app it returns the column names (found a function to easily present col names and row data, so the columns are correct), and one row of empty data, just like in DB Browser

I just tried SELECT * FROM "main"."appinfo";

it returned <blank>, 0, <blank>

the middle number is supposed to be a 1

modified 12-Apr-20 14:39pm.

GeneralRe: Getting data from simple SQLite table returns NULL Pin
Mycroft Holmes12-Apr-20 13:29
professionalMycroft Holmes12-Apr-20 13:29 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Uranium-23512-Apr-20 15:28
MemberUranium-23512-Apr-20 15:28 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Uranium-23512-Apr-20 18:25
MemberUranium-23512-Apr-20 18:25 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Richard MacCutchan12-Apr-20 22:45
mveRichard MacCutchan12-Apr-20 22:45 
QuestionSQL Login Failed Message Pin
Kevin Marois8-Apr-20 20:12
professionalKevin Marois8-Apr-20 20:12 
AnswerRe: SQL Login Failed Message Pin
Richard Deeming9-Apr-20 1:27
mveRichard Deeming9-Apr-20 1:27 
GeneralRe: SQL Login Failed Message Pin
Kevin Marois9-Apr-20 6:42
professionalKevin Marois9-Apr-20 6:42 
GeneralRe: SQL Login Failed Message Pin
Kevin Marois9-Apr-20 7:05
professionalKevin Marois9-Apr-20 7:05 
QuestionSplitting large amounts of data in a table Pin
Pita322-Apr-20 10:25
MemberPita322-Apr-20 10:25 
AnswerRe: Splitting large amounts of data in a table Pin
Mycroft Holmes2-Apr-20 12:10
professionalMycroft Holmes2-Apr-20 12:10 
AnswerRe: Splitting large amounts of data in a table Pin
Gerry Schmitz2-Apr-20 19:29
mveGerry Schmitz2-Apr-20 19:29 
AnswerRe: Splitting large amounts of data in a table Pin
Victor Nijegorodov3-Apr-20 0:43
MemberVictor Nijegorodov3-Apr-20 0:43 
QuestionQuestion Regarding SQL Parameter Query Pin
Michele Smith31-Mar-20 10:14
MemberMichele Smith31-Mar-20 10:14 
AnswerRe: Question Regarding SQL Parameter Query Pin
ZurdoDev31-Mar-20 10:49
mveZurdoDev31-Mar-20 10:49 
AnswerRe: Question Regarding SQL Parameter Query Pin
Victor Nijegorodov1-Apr-20 2:35
MemberVictor Nijegorodov1-Apr-20 2:35 
AnswerRe: Question Regarding SQL Parameter Query Pin
Richard Deeming1-Apr-20 3:32
mveRichard Deeming1-Apr-20 3:32 
QuestionTrigger keeps inserting duplicates Pin
greatwhite131-Mar-20 8:48
Membergreatwhite131-Mar-20 8:48 

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.