[Firebird-devel] COMMENT ON docs

2014-07-28 Thread Simonov Denis
In ddl.txt wrote ... 4) Allow comments in database objects. (Claudio Valderrama C.) Proposed syntax for testing: COMMENT ON DATABASE IS {'txt'|NULL}; COMMENT ON basic_type name IS {'txt'|NULL}; COMMENT ON COLUMN table_or_view_name.field_name IS {'txt'|NULL}; COMMENT ON {PROCEDURE |

Re: [Firebird-devel] COMMENT ON docs

2014-07-28 Thread Adriano dos Santos Fernandes
On 28/07/2014 10:58, Simonov Denis wrote: In ddl.txt wrote Ok. Thanks. Adriano -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a

Re: [Firebird-devel] COMMENT ON docs

2014-07-28 Thread Dalton Calford
I wonder - is there anyway via sql to get access to the comments other than via the system tables? Shouldn't there be something like a DESCRIBE statement as a corollary to COMMENT ON? A DESCRIBE DDL or DESCRIBE DEPENDENCIES giving a standard tool via sql for database developers would be perfect

Re: [Firebird-devel] COMMENT ON docs

2014-07-28 Thread Dalton Calford
that is isql only - try it in any other tool. On 28 July 2014 12:12, Adriano dos Santos Fernandes adrian...@gmail.com wrote: On 28/07/2014 12:08, Dalton Calford wrote: I wonder - is there anyway via sql to get access to the comments other than via the system tables? show comments?

Re: [Firebird-devel] COMMENT ON docs

2014-07-28 Thread Adriano dos Santos Fernandes
On 28/07/2014 13:40, Dalton Calford wrote: that is isql only - try it in any other tool. Show me where is such type of command in the SQL standard, or I will be against it. Not because I think everything should be in the standard, but because I think it would be artificial. The only thing

Re: [Firebird-devel] COMMENT ON docs

2014-07-28 Thread Dmitry Yemanov
28.07.2014 20:57, Dalton Calford wrote: Has any work been performed on implementing schema/synonyms/larger object identifiers? Nope, as far as I'm aware of. It was proposed for v4 but so far I don't see anybody jumping in with lots of interest... Dmitry

Re: [Firebird-devel] COMMENT ON docs

2014-07-28 Thread Carlos H. Cantu
Title: Re: [Firebird-devel] COMMENT ON docs So, let me understand this. (a) the plan is to block/remove access to the system tables Afaiu, you will not be able to change the system tables, but will still be able to access (read) them. []s Carlos http://www.firebirdnews.org FireBase

Re: [Firebird-devel] COMMENT ON docs

2014-07-28 Thread Dimitry Sibiryakov
28.07.2014 20:20, Dalton Calford wrote: So, let me understand this. (a) the plan is to block/remove access to the system tables Write access, not read. (b) functionality will not be added until it is in the sql standard, even though we are not implementing everything that is currently

Re: [Firebird-devel] COMMENT ON docs

2014-07-28 Thread Dmitry Yemanov
28.07.2014 22:20, Dalton Calford wrote: So, let me understand this. (a) the plan is to block/remove access to the system tables Wrong, at least in the short term. Currently we're trying to block *write* access to the system tables, no more than that. (b) functionality will not be added

Re: [Firebird-devel] COMMENT ON docs

2014-07-28 Thread Dimitry Sibiryakov
28.07.2014 20:39, Dmitry Yemanov wrote: I don't think you can have/use schemas without recompiling all those thousands of existing applications and/or their underlying database connectivity libraries. It depends on what you have on mind saying can use schemas. -- WBR, SD.

Re: [Firebird-devel] COMMENT ON docs

2014-07-28 Thread Dalton Calford
Hi Dmitry On 28 July 2014 14:39, Dmitry Yemanov firebi...@yandex.ru wrote: Yes, it's actively developed. No, it doesn't support schemas. I don't think you can have/use schemas without recompiling all those thousands of existing applications and/or their underlying database connectivity