Breadcrumbs

[Dummy1912]

Hello,

Does anyone knows how we get all records from a table even if we don't ask for it?

Code: Select all

 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 & " ;")

as you can see we ask for some existing value from the table category

Code: Select all

'tried
 Dim attributes As String = "*,category.name,category.budget"           

but nothing do :(

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

[CodenStuff]

It should just be

Code: Select all

Dim attributes As String = "*"

..to get all records.

[Dummy1912]

Hello,

must it be that easy
i only get 1 record :(

Code: Select all

 Dim attributes As String = "*"
Dim empls As SQLiteDataReader = DataBase.executeQuery("SELECT " & attributes & " FROM category ")

if i only use this part then i get all records

[un kn0 wn]

Hello,

must it be that easy
i only get 1 record :(

Code: Select all

 Dim attributes As String = "*"
Dim empls As SQLiteDataReader = DataBase.executeQuery("SELECT " & attributes & " FROM category ")

if i only use this part then i get all records

That's probably because there is only one record which matches the parameters in you WHERE clause.

[Dummy1912]

Hi Un kn0wn

Long time no see
how are you.


Yeah i think you might be right about this part
i will have a look into it

Cheers