Re: Dev 2K: How to turn a .SQL file into a data block?

You need to create a view using the select statement.

IE: create view MyView as select stuff from MyTable;

You can then create a block based on the view....

Be forewarned though, If the view references more that one table YOU will need to code all inserts, updates, deletes.

Alex

John Haskins <76054.334_at_compuserve.com> wrote in message <7b4jtv$5b5$1_at_news-1.news.gte.net>...
>I have an existing .SQL file which performs a SELECT statement
incorporating
>a number of joins, calculations, and grouping. I would like to use the
>contents of this file as the basis of a read-only data block in
>Developer/2000. I have not been able to find how to do this. If anyone
can
>point me in the right direction, I would appreciate it immensely.
>
>I tried creating a data block manually, setting its type to FROM clause
>query, and placing the contents of the SELECT statment into the data
block's
>Query Data Source Name property. When I tried to build a layout from that,
>no column names appeared in the Layout Wizard, so I manual entered the
>column names and data types into the data block's Query Data Source Columns
>property. That didn't help...the Layout Wizard still doesn't show any
>columns for the data block. Without those, I cannot create a layout.
>
>The so-called help system provides no information about this, and Oracle's
>Developer/2000 Handbook does not address it either. This feature appears
to
>be totally undocumented!
>
>All assistance will be appreciated.
>
>
>
>
Received on Fri Feb 26 1999 - 01:54:39 CET