JCF
|
| Posted: 03/05/2002, 3:03 PM |
|
Hi All
I have a Grid the I have added a where clause, eg. SITENUM = '$SITENUM'
The $SITENUM I have in session var = This all work fine but when the user
selects a record, presses update, makes some changes and saves the record.
When it comes back to the Grid it lists all the records it does not use my
added where clause?
How do I get the where clause to stay in place?
thanks
JCF
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 03/06/2002, 2:58 AM |
|
Try to use Form/Input tab for this task.
Add SITENUM , and set it's type to "session"
--
Alex
CodeCharge Developer
"JCF" <jcf@mail.org> wrote in message
news:a63ish$c3a$1@news.codecharge.com...
> Hi All
>
> I have a Grid the I have added a where clause, eg. SITENUM = '$SITENUM'
>
> The $SITENUM I have in session var = This all work fine but when the user
> selects a record, presses update, makes some changes and saves the record.
>
> When it comes back to the Grid it lists all the records it does not use my
> added where clause?
>
> How do I get the where clause to stay in place?
>
> thanks
>
> JCF
>
>
|
|
|
|
JCF
|
| Posted: 03/07/2002, 8:31 AM |
|
Thanks Alexey
I got this working by using the session var.
Now I have another snag - I have a table which contains Work Orders, Each
Work Order has a Dept number.
People by their login rights should only see certain Depts - For example
techs should only see the Dept that they belong two. I have coded the
SecRights var as a session var - This is established at login time.
I compare this to the Dept Number using the '&' operator. Bitwise AND
Operator.
I have used this in the Where clause as describe below - Which works great
for the first time but after a Delete, Insert or Update the Grid goes back
to the complete list.
If I use the solution below - There is no choice for '&' compare?
Is there any way around this?
JCF
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:a64sp2$ogt$2@news.codecharge.com...
> Try to use Form/Input tab for this task.
> Add SITENUM , and set it's type to "session"
>
> --
> Alex
> CodeCharge Developer
>
>
> "JCF" <jcf@mail.org> wrote in message
>news:a63ish$c3a$1@news.codecharge.com...
> > Hi All
> >
> > I have a Grid the I have added a where clause, eg. SITENUM = '$SITENUM'
> >
> > The $SITENUM I have in session var = This all work fine but when the
user
> > selects a record, presses update, makes some changes and saves the
record.
> >
> > When it comes back to the Grid it lists all the records it does not use
my
> > added where clause?
> >
> > How do I get the where clause to stay in place?
> >
> > thanks
> >
> > JCF
> >
> >
>
>
|
|
|
|
|
