thanks SirJust an additional point:
I work with fairly large databases and I do as Erel described, but only read the ROWID of the records into the hidden table. The Forward and Previous button clicks then use the ROWID in another reader command to get all the fields just for that one record.
Works a treat and gives good performance! (was originally Erel's suggestion as I remember)
Geoff.
forgot to ask: your statem. If your data is not too large...The Reader object in SQL library is a forward only reader.
If your data is not too large you can use Command.ExecuteTable and read all the data to a table which could be hidden.
Each button should be handled in his Button_Click event.
Store in a global variable the current row change it in the buttons events.
Hi WmC,
What do you mean by check filter data? As Klaus said it is really not clear.
How long do you think the database should be?
To display the data in the table you must set the FontColor different to the backcolor. In your code both are white !?I had a second look at your program.
To display the data in the table you must set the FontColor different to the backcolor. In your code both are white !?
You can filter the table, I would suggest that you put the filter on another form with a second table. You can have a look here:
http://www.b4x.com/forum/german-forum/1421-expense-tracker.html and here http://www.b4x.com/forum/share-your-creations/2136-wine-cellar-manager.html Both programs are similar.
The difference with your example is that the choices are made with predefined parameters in ComboBoxes. This makes the filtering much easier.
It could perhaps be interesting in your program to set predefined choices for certain colomns.
Best regards.
schön, wieder von Dir zu hören und Danke für deine schnelle Antwort zum letzten Post.
Help with Database Bugs
Hi
I need Assistance with Database Bugs.
Everything works OK except three things:
- Sort: Area/Material/Datum
- Find: Clicking the Find Button does not bring Results
- Saving the Data: also does not wish to make me happy.
- If this would only run, I would be a very happy old Man…
What am I doing wrong? still longing for the answer that hits it on the head...
Thanks to all for Helping me on this! I do appreciate all the :sign0085: that we Receive! Please do not let me down, on this one
Best regards:sign0013:
WmC
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?