TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Abhilash J A
499
2.4k
600.3k
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...
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.
Reply
Answers (
1
)
i have a mysql workbench but the database schema option are
how to compare given date and 1 day than current date