General information
Category:
Coding, syntax & commands
The view you create must reside in a database. Create a dummy database and open it before creating your view.
HTH
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only