hi, guys i have a question, i'm working on a form with a FireDAC connection to a DB and the form have to insert new fields in the table, but we use a view so the problem is that i have to obtain the script of that view to add the new field, have someone work with something like this, or some hint??
Yes. And then just hardcode the query you need.
ReplyDeleteAnd if you need users being able to freely attach their own extra data, they indeed better do it with the additional table.
Tables in RDBMSes are expectee to have static, almost fixed number of columns and fluid, often changing number of rows. If you users are expected to often add/delete extra data values - then those values are to be rows not columns.
Remember, you only can modify a table structure 255 times in FB before row version tag overflows.
Arioch The yes, the problem is that I don't think that would be user's friendly and of course they won't add 255 fields in the table, I'll discuss it tomorrow and I'll show all your advices thank you again arioc
ReplyDeleteIt is responsibility of your program to make the visual representation of the database "user friendly".
ReplyDeleteIt is also responsibility of it to make data structure Firebird-friendly.
Closing the gap, building the bridge between user-friendly and database-server-firendly that is what your program is.
If firebird could have readymade user-friendly data structures there would just be no place for your program itself :)