Re: Skipping fields in SQL*Forms V3

bigbod_at_cerberus.bhpese.oz.au writes:
>
> I am trying to set up a form which has a field in it which
> I want to skip ONLY if the user is entering a new record.
> This field is between other fields in the new record.
>

FoRMs v3 is nice in that it checks the grants table to see if the customer has the priviledges to update, insert, select, etc. all or specific fields. I know that I can grant UPDATE access to several fields to someone and when the FoRM runs Oracle flips the attribute on all of the other fields in the FoRM to NON-UPDATABLE.

So ... you might want to try this with your FoRM.

GRANT SELECT, INSERT(field1, field2, ... fieldn) ON <table_name> TO <customer>

Should save you alot of time ... the other obvious option would be to create an authorization table which is checked and if not allowed flip that field attribute off.

Mike Oswald                        _               o
Univ. Of NE Medical Center       ___\o_    __o    <|\
Computing Services/Telecomm      ~~~~~~  _ \<_     \
600 S. 42nd ST.                         (_)/(_)    /