Bernie - I just tried it and it seems to work just fine for me - make sure your view is defined with alias column names and not just "*" -
CREATE VIEW viewname (columnlist) + AS SELECT columnlist + FROM tablename + WHERE clause Make sure if you have any GRANT/REVOKE rights assigned on the table that you also grant full rights on the new view. Sami > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bernard Lis > Sent: Wednesday, August 18, 2004 10:17 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - RE: Syntax for setting a condition for the 3rd table > in a 4 table form > > > Hi Sami, > I originally did it that way, but I couldn't edit it in the form. > Bernie > ----- Original Message ----- > From: "Sami Aaron" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Wednesday, August 18, 2004 9:24 AM > Subject: [RBG7-L] - RE: Syntax for setting a condition for the > 3rd table in > a 4 table form > > > > Bernie - > > > > You could create a one-table view based on the third table that includes > > your WHERE clause. Then on your form include the view rather than the > > table. A one-table view should be editable. > > > > Sami > > > > ------------------------------------------ > > Sami Aaron > > Software Management Specialists > > 19312 W 63rd Terr > > Shawnee KS 66218 > > 913-915-1971 > > mailto:[EMAIL PROTECTED] > > www.softwaremgmt.com > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Bernard Lis > > > Sent: Tuesday, August 17, 2004 10:48 PM > > > To: RBG7-L Mailing List > > > Subject: [RBG7-L] - Syntax for setting a condition for the > 3rd table in > > > a 4 table form > > > > > > > > > Here is my edit command: > > > > > > edit using customer arrange invhist by billdate=d, arrange OrdHdr by > > > orderdt=d where custno=.cno > > > > > > I want to select only those rows from OrdHdr where status in > ('S','E','C') > > > What would be the correct syntax to accomplish this? > > > > > > Bernie Lis > > > > > > > > > > > > > > > > > > > >
