Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Answer
SQLite query returning nothing - essue.
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Mani Kandan
7y
266
1
Reply
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.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
i have a mysql workbench but the database schema option are
how to compare given date and 1 day than current date