Global data

[NotProfessional]

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 USRASSWORD. 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
USRASSWORD = GLOASSWORD
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

 

[NotProfessional]

GET(USER_PROFILE,USR:K_USER)*

 

[ShankarJ]

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

 

[NotProfessional]

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

 

[NotProfessional]

Nevermind, it works now. Thanks anyway!