Abhilash J A

Abhilash J A

  • NA
  • 2.4k
  • 582.4k

SQLite query returning nothing - essue.

Dec 28 2016 1:51 PM
Hello everyone, 
 
I am using SQLite database for wpf windows application. But after using this query returning null. Here, Parameters are passing like this...
  1. string objImgNameArc = "Certificate,Forms";  
  2. string objUserIdArc = "3,2";  
  1. 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.
 

Answers (1)