I have been working on a Sqlite data base with now over 100 records. I switched to 1000 records and it worked the first time and I added more records 6 more records now when I go back to add more records it only shows 100 records. Also the Query I am using shows the same image and the images are different.
Any ideas
Hi Joe,
This is Wappler related. Maybe restart Wappler may help.
Where the images are shown, do you happen to have a [0] in the code? If so, then you have picked the wrong value, you need to pick the value from the repeat area.
Hello Ben
I have reset the Wappler program
I have refreshed the db.
I have changed a record, updated to 1000 records and saved the database (this now shows 1000 records and the records from 100 to 105.
reloaded the page and had the same problem. This all worked just fine until I heit 100 + records.Everything else is correct from the database ( mfg, model, name, short description, upc, msrp price and the link for the button
found some dup entries and removed them.
Still same problem
This is where the problem starts, the query uses the image of the first record that does not have a Location loaded. This does not make any sense to me.
So it looks like I may need help with a flow for check if db has data, then skip the data
I may not show up in the Database Manager, it does not mean that the records are not there. Have you tried a SQLite client like DB Browser for SQLite?
Hello Ben
With your help I found the problem the dynamic attributes images source got changed to:
<img class="card-img-top" alt="Card image cap" dmx-bind:src="'/uploads/images/products/'+serverconnect_rd.data.query.data[0].category_id+'/'+serverconnect_rd.data.query.data[0].image">
I did not change the code for a long time at that time it worked.
Strange! I may have a few gremlins running around in my system.
Did you do a tutorial that I may be able to use for flows?
Thanks again
I have never got the Database Manager to show anything other than the first 100 records. Just assumed it was either a bug or me misunderstanding how it should work
Ben
It must be a bug, My SQLite studio shows all 101 records. The problem is that if you have more than 100 records and ask to show 1000 that selection does not stick when saved, you need to change a record and save with 1000 showing and you can keep going, that is the work around but it is a pain.
You can get the complete list and try the filter component on the client side to filter what you are looking.
Juan
Thanks, I was not trying to find a product. I am adding records to the database. Next to filter is records it shows 100 and at record 101 you can not see that record until you change the number of records to 1000.
When you close the database and reopen it you are back at 100 records and only the first 100 records show until you change it again.
do you mean the database table viewer in Wappler showing 100 records only?
That is the default indeed and can be changed to 1000 but temporally for the view only.
As for the web site live view it depends on the query type you are using, for paging it displays just the first page, full query should display all.
Hello George
Thanks for the update. Why only temp. on the amount of records when you have more than 100 records?, and when you are still adding records it would be nice to not have to change the record count.
The Wappler database table view is meant to just give you quick peek on your database. if retrieving thousands of records it will make it very slow.
So we implemented a limit (that you can change temporarily) and also advanced filtering if you need to search for specific records. So it is all light weight and fast
2 Likes