Filter Records after logon

[skater007]

I'm soooo close.  How can I save my logon data so it can be used in a get new query when the main app is launched?

Thanks

Andy

P.S.  Yes I'm back

[Rob Nicol]

There are a few options. If you have many login parameters that are fetched from the database during login, then it's best to use the "logged On Data Row" concept. An example is in the LoginScreen example.

If you simply want to save the username and password. You can use the client.username and client.password variables.

To use either of the above in your "Get New" query, you can reference them as:
1) Logged On Data Row values are always accessible using the tablename and field name in the query string:
:tableName.fieldName:

2) Username and password variables stored in client.username and client.password are available with :USER: and :PASS:

[skater007]

That was far to simple.

 Thank you