Mario - It may be easier for you to modify your view like this: (be sure to replace the word "viewname" with the actual name of your own view)
At the R> Prompt, type: OUTPUT viewname.vie UNLOAD STRUCTURE FOR viewname OUTPUT SCREEN this creates a text file with your view definition. You can use the R:BASE text editor or any other text editor to modify the view. Then, after you make your changes in the text file, delete the old view definition - at the R> Prompt you can type: DROP VIEW viewname then run your revised text file: RUN viewname.vie The Query menus were helpful but didn't always work as expected in complex view definitions. Please feel free to post another message on this list if you need more help. Sami ----------------------------------------------------------------- Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 mailto:[EMAIL PROTECTED] 913-915-1971 ----- Original Message ----- From: "Mario B�dard" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, November 25, 2003 10:01 AM Subject: [RBASE-L] - need help for query by def > > > > Hi, i'am sorry but my english is to bad. > > I hope someone can help me. I'Am a beginner user of RBase, it's Rbase 6.1. > > I want to create a view with Query by def. > The trouble i have, when i create a view with this where condition: > > WHERE > > T2.clientno = T1.clientno AND T3.loanid = T2.loanid AND T3.term_end = ( > select Max (term_end) from terms t5 where t5.loanid = T3.loanid) and > T2.inactive IS NULL > > > > ALWAYS Rbase change it for > > > T2.clientno = T1.clientno AND T3.loanid = T2.loanid AND T3.term_end IN > Max(term_end) from terms t5 where t5.loanid = T3.loanid > > Why ???? > > Thanks a lot > > Mario B�dard > > > >
