Re: Expert and SQL Queries

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

Article #81

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

#81

From: Ken Mayer [TeamB]
Date: Thu, 06 Aug 1998 00:00

24 lines
1501 bytes

"John Nordyke" <jnord@ag.cyanamid.com> wrote:

>I have a sql query against multiple Oracle tables already saved.  The
>recordset is read-only.  I haven't found a way to use the form expert to
>build a form using this sql query, because Intrabuilder (C/S) immediately
>complains that "table is read only" whenever I launch the expert and feed
>it the sql file......any way around this?

Yeah -- don't use the sql designer. You end up with read-only for
anything that includes a WHERE clause, or an ORDER BY clause.

Instead, simply drag the table to the form surface from the navigator.
This creates a query object with the SQL property being a basic
"select * from tablename" (and the appropriate database stuff for your
Oracle connection). Then you can use the rowset's properties to set
the sequence (indexName) and any filters (where) ...

Ken

---
Ken Mayer [TeamB]
Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm

Technical Details

Message-ID: <35c8f686.2188081@forums.borland.com>

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

References: <01bdc075$76009c20$6522ad8d@jnord.ag.cyanamid.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101d9a,68fe028549e858f
X-Google-Attributes: gid101d9a,public
From: supportInfo@borland.com (Ken Mayer [TeamB])
Subject: Re: Expert and SQL Queries
Date: 1998/08/06
Message-ID: <35c8f686.2188081@forums.borland.com>
X-Deja-AN: 378357758
References: <01bdc075$76009c20$6522ad8d@jnord.ag.cyanamid.com>
Organization: Golden Stag Productions
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.intrabuilder.data.sql

Reply to Parent Message