DBohner-(db)
Legendary Poster
My turn to plea for guidence....
Is there a way to append a where clause to the end of a select statement for an application?
Ideally – what I’m looking for is a way to append data selection to the end of an Application’s Select statement – similar to the same way that Row Security is appended to the end of an application (or UBE)’s select statement.
Without security
Select * from file where QBE is true
With Security
Select * from file where (QBE is true) and (Security clause is true)
The append SQL functions inside the application do not nest the selection criteria - the OR statement voids everything on either side of the OR... I need to be able to NEST a complex OR statement inside brackets - like what Row Security appends.
What I need – is a way to nest an additional Where Claus to the statement, the same way security does – maintaining the original content of the select <font color="red">)AND( </font> the appended selection criteria of a client’s choice.
HELP?
(db)
------------------------------------------
Daniel Bohner
ExistingLight, LLC
http://www.existinglight.net
[email protected]
[email protected]
Home Office: 208.467.3316
mobile: 208.250.1917
fax: 208.246.3425
------------------------------------------
XBOX Gamer-Tag: drbohner
MSN IM: [email protected]
Yahoo IM: [email protected]
------------------------------------------
Is there a way to append a where clause to the end of a select statement for an application?
Ideally – what I’m looking for is a way to append data selection to the end of an Application’s Select statement – similar to the same way that Row Security is appended to the end of an application (or UBE)’s select statement.
Without security
Select * from file where QBE is true
With Security
Select * from file where (QBE is true) and (Security clause is true)
The append SQL functions inside the application do not nest the selection criteria - the OR statement voids everything on either side of the OR... I need to be able to NEST a complex OR statement inside brackets - like what Row Security appends.
What I need – is a way to nest an additional Where Claus to the statement, the same way security does – maintaining the original content of the select <font color="red">)AND( </font> the appended selection criteria of a client’s choice.
HELP?
(db)
------------------------------------------
Daniel Bohner
ExistingLight, LLC
http://www.existinglight.net
[email protected]
[email protected]
Home Office: 208.467.3316
mobile: 208.250.1917
fax: 208.246.3425
------------------------------------------
XBOX Gamer-Tag: drbohner
MSN IM: [email protected]
Yahoo IM: [email protected]
------------------------------------------