General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi!
Use NVL() function to replace null valies with characters.
To define view in code use:
CREATE SQL VIEW ViewName AS SqlSelectStatement
>How does one get around the limitations of the view designer? For example:
>
>I am defining a wiew that is a right join, but I want a character field to be character, not null, in the cursor when there was nothing there. Tried using an expression, but don't know how to give it a name. Ideally, I would like to just define the SQL and then define all the "extras" (defining updateable fields etc) graphically. Tried to hack the DBC... oops, it became unretrievably corrupted.
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