Re: VDB 7.0 SQL Designer hanging

Article View: borland.public.vdbase.data.sql

Article #1499

Back to borland.public.vdbase.data.sql Previous Next

#1499

From: Rick Fath
Date: Wed, 17 Dec 1997 00:00

32 lines
1653 bytes

Romain

maybe I was unclear, I do not get the opportunity to create SQL. it hangs when

I select the first table for a query. The field list is never returned, today
I
selected a remote table and after 4 minutes VDB sent me a message that an
internal error had occured and that I should exit VDB ?

Rick


Romain Strieff [TeamB] wrote:

> In article <3497443D.2D58B827@hotmail.com>, rfath@hotmail.com says...
> >
> > The new query designer keeps hanging when I choose a remote table from
> > the SQL designer. I am connecting to Sybase and DB2 with ODBC drivers. I
> > can view the tables from the navigator with no problems. It always
> > "hangs,  hour glass" on large tables with many fields. Smaller tables
> > seem to work but take a long time to load? Any thoughts this
> > is a real show stopper for me?
> >
> Depending on your SQL expression it could try to create (sort) a readonly
> temptable which could be hundreds of MB if you accidently got a poor
> choice.
>
> --
> Romain Strieff [TeamB]
> A few VdB utilities at:
> http://ourworld.compuserve.com/homepages/RStrieff/

Technical Details

Message-ID: <349859B5.F8FD4C7A@hotmail.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <3497443D.2D58B827@hotmail.com> <MPG.f01dda730e1f59a98a1db@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,72bc0966b294b805
X-Google-Attributes: gidff5a1,public
From: Rick Fath <rfath@hotmail.com>
Subject: Re: VDB 7.0 SQL Designer hanging
Date: 1997/12/17
Message-ID: <349859B5.F8FD4C7A@hotmail.com>
X-Deja-AN: 299152457
Content-Transfer-Encoding: 7bit
References: <3497443D.2D58B827@hotmail.com> <MPG.f01dda730e1f59a98a1db@forums.borland.com>
Content-Type: text/plain; charset=us-ascii
Organization: None
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message