FiveTech Support Forums

Dear All,

I need to set password to hide data..

with oGet:lPassword := .T. //char type works OK [u:cg9em8ml]but in numeric type it's not.[/u:cg9em8ml]

How to do in in numeric get?

Regards,
Frances

You need to convert the numeric value as character string and GET and take its VAL() after the get.

nageswaragunupudi wrote:You need to convert the numeric value as character string and GET and take its VAL() after the get.

Dear RAO,

It's much better this way..

if data hidden from certain user

• oGet:oGet:Picture := "XXXXXXX.XX"
• oGet:Disable()

else

-oGet:oGet:Picture := oGet:cPicture
- oGet:Enable()

endif

Regards,
Fraxzi

Fraxzi,

I'm not clear. What does the picture "XXXXXXX.XX" do to the display?

James

Dear James,

The picture 'XXXXXXX.XX" on the numeric get will replace the display value to "XXXXXXX.XX" instead of "9999999.99" or say a value of 12,999.45
This is a workaround since oGet:lPassword := .T. works only for char type.

This is selective scenario wherein some user must not see that field value. If I change the style from resource to 'password' then it will show '*.' and selective
display will not be applicable.

Character '*' has special meaning to picture so I used 'X'.

Regards,
Frances

Francis,

Thanks for the clarification.

If you are using a database object you could modify the Load() method to blank out any fields that were not authorized for the current users security. The advantage to this is that the database object could be used anywhere without the restricted data showing (e.g. dialogs, browses, reports, etc.) and without any changes to the coding for the dialogs, browses or reports.

Of course, if you are not already using a database object this will require code changes.

Regards,
James

Dear Mr. James,

Thank you for the added info. I appreciate it.

I will look into database object.. my alias are from SQL 'select' I will try it with database object.
Right now, I am using variable to manipulate fields from SQL Alias.

I will compare.

Regards,
Frances

The picture 'XXXXXXX.XX" on the numeric get will replace the display value to "XXXXXXX.XX" instead of "9999999.99" or say a value of 12,999.45

Francis,

Are you using recordsets or a SQL database driver? If recordsets, then I am not sure you can do what I suggested.

Hmm. With a recordset you might be able to create a record class that would read from the recordset and filter out the secure fields. This would work with a dialog, but it would really slow down a browse or report since you would have to create a record object for each record in the recordset.

I would have to think about this more...

Regards,
James

nageswaragunupudi wrote:

The picture 'XXXXXXX.XX" on the numeric get will replace the display value to "XXXXXXX.XX" instead of "9999999.99" or say a value of 12,999.45

Nice idea

James Bott wrote:Francis,

Are you using recordsets or a SQL database driver? If recordsets, then I am not sure you can do what I suggested.

Hmm. With a recordset you might be able to create a record class that would read from the recordset and filter out the secure fields. This would work with a dialog, but it would really slow down a browse or report since you would have to create a record object for each record in the recordset.

I would have to think about this more...

Regards,
James