One way to do this is to provide a Microsoft Access-based front end. It has a very nice query builder and will attach to any ODBC source. It's not Web-based but it can certainly do the job.
- James.
Alan Wolfe <[EMAIL PROTECTED]> wrote:
Alan Wolfe <[EMAIL PROTECTED]> wrote:
in our apps we have a few settings where the user's access is determined by an sql clause that follows them arround.for instance if a user was only supposed to have access to accounts that started with "01.0" the sql clause for that user would be something like:and sget(accountno,4,1)='01.0'right now, we are having to update all the users' clauses ourselves, but it would be nice to be able to give the users a way to do this themselves so it was off our plates and on theres.The problem is that the sql clauses can be pretty intricate with or's and and's and parenthesis so it's hard to make up an interface for this, especialy one that would be intelligable to non programmers.Has anyone done anything like this before? Any nice imaginative solutions out there? (:________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
->|- Diodeus, noun: the Greek God of diodes, as opposed to Typos, the Greek God of typing mistakes. He keeps moving the keys on me.
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
