First, for security reasons, do not use a query parameter as the selection
criteria in a situation like this. The user can change that to anything
they like. Not secure at all!
In the Data Source, set the Where parameter Field to SSNum, the condition to
"equals (=)", the type to "Expression" and set the Parameter Source to
"CCGetUserID()".
This will set the grid datasource to display all records for that one
UserID. The selection will be completely managed on the server side where
the user can't fiddle with it at all.
--
DonB
logging at
http://www.gotodon.com/ccbth, and blogging at
http://ccbth.gotodon.net
"Brady" <
Brady@forum.codecharge> wrote in message
news:640eafc090d14b@news.codecharge.com...
> I have an editable Grid I created with the wizard and when a user logs in
I want
> the Grid to open up only that persons monthly information on it.
Codecharge
> examples show select from a list of items I have no problem with that. I
need a
> one to one.
>
> Example
> -A user logs in. The UserID session number 100023 which is the employees
> primarly key value. I have an editable grid that has the following to
retrieve
> the information
>
> SELECT SSNum, monthy_status, [date], complete
> FROM Monthly_table1
> WHERE SSNum = '{UserID}'
>
> I have a textbox on the page and the UserId is coming across. I set the
default
> value to CCGetUserID()
>
> I tried making this field hidden and have "WHERE SSNum = {textbox1} but
that
> didnt work.
>
> All I get back is the first person info in the database.
>
> If anyone can help I would appreciate it. Thanks B
> ---------------------------------------
> Sent from YesSoftware forum
>
http://forums.codecharge.com/
>
