I have a session and a table view, when a session load, the data should be appeared according to user logname. May i know how to write the session script to filter the content according to user logname?

Hi,

The user log-in name is saved in a predefined variable called "logname$". In your session you will have to Filter the records where the user filed = logname$

I hope it helps,

- George

;)Thanks for your reply.

Now i wish to filter the records according to logname$ once the screen loaded. May i know the script to generate that? The screen shot i have attached in previous time.


From
Yen ling

Hi,
You can use function query.extend.where() as shown below:
query.extend.where("ttmmm999.xxxx = " & logname$)
tt = package, mmm = module, 999 = table and xxxx = field for user ID
Hope it helps you.

- Rahul

the predefined variable query.extension can be used to

As an alternative to coding you can also use authorizations to prevent rows of data showing by value.

Hi Support,

May i know how to apply the script when the screen loaded into my programming script? Here i attach a file with the programming script and screen layout for your reference.

Appreciate your help. Thanks.

After i have written the script into the before program, the error message prompt when i compile the session.

Try this:
query.extend.select("tffam991.faur = " & chr$(34) & logname$ & chr$(34))

I wrote the script in the before program section and i compiled the session and the error message pop up.

Try this:
query.extend.select("tffam991.faur = " & chr$(34) & logname$ & chr$(34))

I guess Mark supposed to:

query.extend.where("tffam991.faur = " & chr$(34) & logname$ & chr$(34))

Just a Tip, instead of chr$ you can use the function quoted.string()

after all, guess it wont work. "logame$" have no valid value...

try this

query.extend.where("tffam991.faur = :"&logname$)


or you can built a string.

domain tcmcs.str100 ext.where

ext.where = "tffam991.faur = "&logname$
query.extend.where(ext.where)


debug it and see if the syntax its correct