>I must be doing something wrong....... Here's my code:
>
>CREATE SQL VIEW grid;
> AS SELECT glacnt, gltdes, glamnt, credit, noshow;
> FROM gldent;
> WHERE gldent.batchno = glhent.batchno;
> AND gldent.glseqno = glhent.glseqno;
> ORDER BY gldent.batchno, gldent.glseqno
>
>When the above code is executed, I receive the message - No database is open or set as the current database.
You need a DBC to store the view info in, that's the way all views work. You can either do OPEN DATA mydbc, SET DATA to mydbc with an already existing one, or you can create a temp DB on the fly...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.