Sqlite Help
Posted: Tue Feb 28, 2017 4:40 pm
Hello,
Does anyone knows how we get all records from a table even if we don't ask for it?
but our table has many more values
how can we still show them?
Yes the category.name and category.budget are the only one we need to show
Thanks
Dummy1912
Does anyone knows how we get all records from a table even if we don't ask for it?
Code: Select all
as you can see we ask for some existing value from the table category Dim attributes As String = "category.name,category.budget"
Dim whereClause As String = "ledger.Monthid='" & sMonth & "' AND ledger.yearid ='" & sYear & "'"
Dim fromClause As String = "LEFT JOIN category ON ledger.category=category.id" 'we only get 1 value because we asked for it.
Dim empls As SQLiteDataReader = DataBase.executeQuery("SELECT " & attributes & " FROM ledger " & fromClause & " WHERE " & whereClause & " ;")
Code: Select all
but nothing do :('tried
Dim attributes As String = "*,category.name,category.budget"
but our table has many more values
how can we still show them?
Yes the category.name and category.budget are the only one we need to show
Thanks
Dummy1912