×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Global data

Global data

Global data

(OP)
Ok I'll get right to the case. I have a Window that is designed for loging in. The window uses the table USER_PROFILE whose primary key is K_USER and it consists of 2 attributes : USR:NAME and USR:PASSWORD. The window is called by a menubar item. Another menubar item is calling a browse procedure that uses a table TRANSACTION_ACCOUNTS for File browsing list box and USER_PROFILE in Other tables. 1 USER_PROFILE can have multiple  TRANSACTION_ACCOUNTS. Now how do I make it so that after i enter the NAME and PASSWORD in login window I can see the matching transaction accounts in the browse procedure? I would put the name and password in global variables through the login window and call that data from the browse procedure by:

USR:NAME = GLO:NAME
USR:PASSWORD = GLO:PASSWORD
GET(USER_PROFILE,KOR:K_KOR)
IF Errorcode()
message('Error')
.

I don't get an error message but when I insert a record It doesn't show on the browsebox but the record is inserted.
 
I know It's a noob question and I'm sorry. Please help  

RE: Global data

(OP)
GET(USER_PROFILE,USR:K_USER)*

RE: Global data

Hi!

You need to RANGE limit the Browse Box (in Browse Properties) to limit the records to just the GLO:Name. I assume you have an unique key in TRANSACTION_ACCOUNTS starting with TRN:Name. Ideally the Browse Box should be using that key for displaying data.

If you are not familiar with Clarion, I would suggest you start with studying the examples under the Examples folder to understand the different template and their choices. There are some tutorials also as part of the help. Asking questions here is going to be a VERY LONG way of learning Clarion.

Regards
 

RE: Global data

(OP)
I figured out that i must use range filters and it works but not the raght away, I have to switch betwen tabs for the range limits to start working

RE: Global data

(OP)
Nevermind, it works now. Thanks anyway!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close