Hi,
I place this here in the tips-section as it cost me quite some time and work to correct "nice" tablenames.
My testserver is a Linux system. I have exported everything and it's running on a windows server now - no problem. But when I tried the other way around, getting the "live"-system back to my test-setting I had quite a lot of problems, all of those because of case sensitivity of Linux (and thus: MySQL tablenames!)
For this I strongly suggest,
-> that you name your tables with lowercase only !
-> that you name your views in the database with lowercase only (as you might later create a pseudo-table in AppGini with that same name)!
Example: Not like this: My_Table . But like this: my_table.
Take care and hopefully do not repeat my mistake
Olaf
name your tables and views in lower case
name your tables and views in lower case
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view