Thread View: borland.public.interbase.ibconsole
8 messages
8 total messages
Started by Gelein van de Voorde
Tue, 12 Feb 2008 20:25
New beta release for IBConsole available (8.1.0.267)
Author: Gelein van de Voorde
Date: Tue, 12 Feb 2008 20:25
Date: Tue, 12 Feb 2008 20:25
12 lines
1073 bytes
1073 bytes
Added support for Global Temporary Tables and Updatable Views. For details see the revision history page. http://www.gvsnet.nl/ibconsole -- Gelein van de Voorde (IBConsole team) "The blossoms on an apple tree are standardized, and yet they are all different. That is how we, too, should learn to build." Alvar Alto
Re: New beta release for IBConsole available (8.1.0.267)
Author: joseph
Date: Wed, 13 Feb 2008 11:11
Date: Wed, 13 Feb 2008 11:11
22 lines
1334 bytes
1334 bytes
Thanks, Very much appreciated. Joseph "Gelein van de Voorde" <gelein@gvsnet.nl> wrote in message news:47b20ed3$1@newsgroups.borland.com... > Added support for Global Temporary Tables and Updatable Views. > For details see the revision history page. > http://www.gvsnet.nl/ibconsole > > -- > Gelein van de Voorde (IBConsole team) > > "The blossoms on an apple tree are standardized, > and yet they are all different. > That is how we, too, should learn to build." > > Alvar Alto
Re: New beta release for IBConsole available (8.1.0.267)
Author: joseph
Date: Wed, 13 Feb 2008 13:08
Date: Wed, 13 Feb 2008 13:08
42 lines
1896 bytes
1896 bytes
I have just downloaded the new version. When I go on the view and select data, I receive the following error: "Dynamic SQL Error. SQL Error Code = -104 Token Unknown - line 1, char 14, V_RoomRetentionCharge" where V_RoomRetentionCharge is the name of my view. joseph "joseph" <jpell@di-ve.com> wrote in message news:47b2d081@newsgroups.borland.com... > Thanks, > > Very much appreciated. > > > Joseph > > > "Gelein van de Voorde" <gelein@gvsnet.nl> wrote in message > news:47b20ed3$1@newsgroups.borland.com... > > Added support for Global Temporary Tables and Updatable Views. > > For details see the revision history page. > > http://www.gvsnet.nl/ibconsole > > > > -- > > Gelein van de Voorde (IBConsole team) > > > > "The blossoms on an apple tree are standardized, > > and yet they are all different. > > That is how we, too, should learn to build." > > > > Alvar Alto > >
Re: New beta release for IBConsole available (8.1.0.267)
Author: Gelein van de Voorde
Date: Wed, 13 Feb 2008 17:44
Date: Wed, 13 Feb 2008 17:44
12 lines
1121 bytes
1121 bytes
Joseph, Are you using SQLDialect 1? -- Gelein van de Voorde (IBConsole team) "The blossoms on an apple tree are standardized, and yet they are all different. That is how we, too, should learn to build." Alvar Alto
Re: New beta release for IBConsole available (8.1.0.267)
Author: Gelein van de Voorde
Date: Wed, 13 Feb 2008 20:29
Date: Wed, 13 Feb 2008 20:29
12 lines
1094 bytes
1094 bytes
Forgot to test with SQL dialect 1. I refreshed the MSwindow version. Hope to refresh the Linux version tomorrow. -- Gelein van de Voorde (IBConsole team) "The blossoms on an apple tree are standardized, and yet they are all different. That is how we, too, should learn to build." Alvar Alto
Re: New beta release for IBConsole available (8.1.0.267)
Author: joseph
Date: Thu, 14 Feb 2008 07:52
Date: Thu, 14 Feb 2008 07:52
25 lines
1457 bytes
1457 bytes
Yes I am. This does not happen on all views. Some views do work correctly. While others raise an "invalid database key". thanks Joseph "Gelein van de Voorde" <gelein@gvsnet.nl> wrote in message news:47b33a89$3@newsgroups.borland.com... > Joseph, > > Are you using SQLDialect 1? > > -- > Gelein van de Voorde (IBConsole team) > > "The blossoms on an apple tree are standardized, > and yet they are all different. > That is how we, too, should learn to build." > > Alvar Alto
Re: New beta release for IBConsole available (8.1.0.267)
Author: joseph
Date: Thu, 14 Feb 2008 12:38
Date: Thu, 14 Feb 2008 12:38
28 lines
1587 bytes
1587 bytes
Gelein, The error "Dynamic SQL Error. SQL Error Code = -104 Token Unknown - line 1...." has now disappeared, but I am still receiving "invalid database key" on some of my views. I think it has to do with views containing "group by" clauses. Thanks Joseph "Gelein van de Voorde" <gelein@gvsnet.nl> wrote in message news:47b36148@newsgroups.borland.com... > Forgot to test with SQL dialect 1. > I refreshed the MSwindow version. > Hope to refresh the Linux version tomorrow. > > -- > Gelein van de Voorde (IBConsole team) > > "The blossoms on an apple tree are standardized, > and yet they are all different. > That is how we, too, should learn to build." > > Alvar Alto
Re: New beta release for IBConsole available (8.1.0.267)
Author: Gelein van de Voorde
Date: Thu, 14 Feb 2008 19:43
Date: Thu, 14 Feb 2008 19:43
14 lines
1256 bytes
1256 bytes
Joseph, I'm afraid the updatable views need some more work. I can not produce the error you get. Can you help me by suplying the metadata of a view that is causing trouble. You can send it to my emailadress. -- Gelein van de Voorde (IBConsole team) "The blossoms on an apple tree are standardized, and yet they are all different. That is how we, too, should learn to build." Alvar Alto
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads