Expert and SQL Queries

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

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by John Nordyke Wed, 05 Aug 1998 00:00

#80

Author: John Nordyke
Date: Wed, 05 Aug 1998 00:00

5 lines
850 bytes

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?

Re: Expert and SQL Queries

#81

Author: 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

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