SQLite query returning nothing

SQLite query returning nothing - essue.

Hello everyone,

I am using SQLite database for wpf windows application. But after using this query returning null. Here, Parameters are passing like this...

string objImgNameArc = "Certificate,Forms";
string objUserIdArc = "3,2";

SELECT distinct Tble_Documents.Priority,Tble_Documents.UserId,Tble_UserSetUp.Function,Tble_UserSetUp.Department, Tble_UserSetUp.OrgCode, Tble_UserSetUp.FirstName|| ' ' ||Tble_UserSetUp.SurName as Fullname, Tble_Documents.Parent_File_Name, Tble_Documents.CreatedDate from Tble_Documents inner join Tble_UserSetUp on Tble_Documents.UserId = Tble_UserSetUp.Id where Tble_UserSetUp.UserType ='User' and Tble_UserSetUp.IsActive =1 and Tble_Documents.IsArchive = 1 and Tble_Documents.Parent_File_Name IN ('" + objImgNameArc + "') and Tble_UserSetUp.Id IN ('" + objUserIdArc + "')

Please help me.

Hi Abhilash,

I think the reason behind this is the value of objImgNameArc is not proper which is being passed in the query.

When you have

var objImgNameArc = "Certificate,Forms"

the resultant SQL query will be

SELECT distinct Tble_Documents.Priority,Tble_Documents.UserId,Tble_UserSetUp.Function,Tble_UserSetUp.Department, Tble_UserSetUp.OrgCode, Tble_UserSetUp.FirstName|| ' ' ||Tble_UserSetUp.SurName as Fullname, Tble_Documents.Parent_File_Name, Tble_Documents.CreatedDate from Tble_Documents inner join Tble_UserSetUp on Tble_Documents.UserId = Tble_UserSetUp.Id where Tble_UserSetUp.UserType ='User' and Tble_UserSetUp.IsActive =1 and Tble_Documents.IsArchive = 1 and Tble_Documents.Parent_File_Name IN ('Certificate,Forms') and Tble_UserSetUp.Id IN ('3,2')

I think objImgNameArc should have value "Certificate','Forms"

So now you have

var objImgNameArc = "Certificate','Forms"

With this your SQL Query will be as following

SELECT distinct Tble_Documents.Priority,Tble_Documents.UserId,Tble_UserSetUp.Function,Tble_UserSetUp.Department, Tble_UserSetUp.OrgCode, Tble_UserSetUp.FirstName|| ' ' ||Tble_UserSetUp.SurName as Fullname, Tble_Documents.Parent_File_Name, Tble_Documents.CreatedDate from Tble_Documents inner join Tble_UserSetUp on Tble_Documents.UserId = Tble_UserSetUp.Id where Tble_UserSetUp.UserType ='User' and Tble_UserSetUp.IsActive =1 and Tble_Documents.IsArchive = 1 and Tble_Documents.Parent_File_Name IN ('Certificate','Forms') and Tble_UserSetUp.Id IN ('3,2')

So changing value of objImgNameArc as above will solve your problem.

I hope this will be helpful to you.

Thanks and regards,

Chetan Ranpariya

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Chetan Ranpariya9y ago
Accepted answer
Hi Abhilash,

I think the reason behind this is the value of objImgNameArc is not proper which is being passed in the query.

When you have
var objImgNameArc = "Certificate,Forms"
the resultant SQL query will be
SELECT distinct Tble_Documents.Priority,Tble_Documents.UserId,Tble_UserSetUp.Function,Tble_UserSetUp.Department, Tble_UserSetUp.OrgCode, Tble_UserSetUp.FirstName|| ' ' ||Tble_UserSetUp.SurName as Fullname, Tble_Documents.Parent_File_Name, Tble_Documents.CreatedDate from Tble_Documents inner join Tble_UserSetUp on Tble_Documents.UserId = Tble_UserSetUp.Id where Tble_UserSetUp.UserType ='User' and Tble_UserSetUp.IsActive =1 and Tble_Documents.IsArchive = 1 and Tble_Documents.Parent_File_Name IN ('Certificate,Forms') and Tble_UserSetUp.Id IN ('3,2')
I think objImgNameArc should have value "Certificate','Forms"
So now you have
var objImgNameArc = "Certificate','Forms"
With this your SQL Query will be as following
SELECT distinct Tble_Documents.Priority,Tble_Documents.UserId,Tble_UserSetUp.Function,Tble_UserSetUp.Department, Tble_UserSetUp.OrgCode, Tble_UserSetUp.FirstName|| ' ' ||Tble_UserSetUp.SurName as Fullname, Tble_Documents.Parent_File_Name, Tble_Documents.CreatedDate from Tble_Documents inner join Tble_UserSetUp on Tble_Documents.UserId = Tble_UserSetUp.Id where Tble_UserSetUp.UserType ='User' and Tble_UserSetUp.IsActive =1 and Tble_Documents.IsArchive = 1 and Tble_Documents.Parent_File_Name IN ('Certificate','Forms') and Tble_UserSetUp.Id IN ('3,2')
So changing value of objImgNameArc as above will solve your problem.
I hope this will be helpful to you.

Thanks and regards,
Chetan Ranpariya