I have a database that keep updating itself every 2 hours and I want to find a way to get the updated table without having to keep going to the database to obtain new tables each time the database is updated. Please, how do I about this in JMP?
Pour intérroger les données il faut soumettre une requête SQL.
Hormis requêter la table toutes les 2 heures pour avoir les dernières données fraîches, je ne vois pas trop comment faire.
If there are time stamps, the query might only need to fetch data more recent than the last time.
Yes, one solution could be to :
- query the table (SQL)
- save the data into jmp datatable
- keep the max(timestamp) and store it into jmp table for example
Next query :
- query the table (SQL) from max(timestamp) to now()
- then concatenate to previous data extraction
Then loop
