Thomas Hemmer

Background color of PageControl widget

Silly me, I should have used the REPLY button instead of blowing up the whole thread - sorry. Back to the subject: Understood as far as the table view is concerned (like the above image). But what if you are running an application defined form, e. g. the "Client" one in your "factures" example? Up to now, I have not managed to find something similar there.

Merci beaucoup pour vôtre aide, je vais rester patient jusqu'alors ;-)

sorry for my ambiguity... What I meant was some way to locate a specific record within a table (i. e. make it the selected one) via some lookup mechanism. Currently we have controls for locating first, last, previous and next record; what I am looking for is one that allows locating a certain record quickly. Imagine you wish to edit the data of one of several thousand customers - using the "factures" example you would have to navigate there step by step using the "next" button, wouldn't you? Looking...

Please find attached the sqlite3 DB file. FYI: import from CSV file does not work either for me (regardless of whether the datetime field is formatted according to SQL standard (2020-01-30) or as a localized string (30.01.2020)). Hope this won't boil down to my own stupidity... ;-) Update: while inspecting the resulting .NSB file after import using SQLite Studio I found out that the import itself work pretty well; seems as if there were some problem while rendering on the "Data sheet" tab.

Currently I am missing a standard search mechanism which aids in locating a certain record (e.g. query-by-example or some kind of search button within the navigator widget which opens a list-of-values window with filtering possibilities). As even the demo projects seem not to provide such a facility I strongly suppose that it's not yet available. Have I overlooked something?

Please find attached the sqlite3 DB file. To be honest, I have not yet tried the "export to csv, then import to NSBase" procedure.

Currently I am missing a standard search mechanism which aids in locating a certain record (e.g. query-by-example or some kind of search button within the navigator widget which opens a list-of-values window with filtering possibilities). As even the demo projects seem not to provide such a facility I strongly suppose that it's not yet available. Have I overlooked something?