editable grid / updateable view

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

editable grid / updateable view

I get that FR uses either information about PK, UQ, or rdb$db_key to determine if
a given statement's resultset is updateable (in grid).

But what about a view that should, in theory, be updateable? Are there any
heuristics that would make sense? Is there anything we could do to make that

I guess that even if FR knew a view was naturally or unnaturally (extra triggers
defined) updateable, it still needs PK/UQ information so as to generate its update
statements, and FB doesn't have a way to track/report that... and I would hate to
suggest introducing special syntax/hints (something like the matching() clause,
but for FR's benefit.)


Sponsored by Intel(R) XDK
Develop, test and display web and hybrid apps with a single code base.
Download it for free now!
Flamerobin-devel mailing list
[hidden email]