Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

login question

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
Currently when I log in to a forms application,
my user_id and name are displayed on my the corresponding item boxes but after insert or select transactions. I usually hit the clear button to reset the canvas.
Once I do this, all values in the canvas, including my user_id and name are cleared allowing me to start new transaction.
So right now, I usually close the application and re-open to have my user_id and name displayed.
My question is, is there a way to make my user_id and name persistent?
For instance, if you have a date item on a data block, you can set a default value for the date meaning that even if you hit the clear button, the value of date is still visible until you overtype it.
In other words, is there a way to set the items to stay visible even if I hit the clear button?
The only time I want the user_id and name to disappear from screen is if I close the form I application.
Is this possible?
 
Put them in a seperate control block, and use clear block instead of clear form.
 
thanks lewisp for responding.
There is a problem with doing it the way you suggested. The current user needs to have the ability to make changes, and save those changes including the id and name of the user who made the changes.
So if I create a seperate control block, then the id and name of the user that makes any changes won't be saved anymore once you click the save button.
One thing I thought about doing is creating global variable but don't know where to put the code, eg pre-form, post-text-item?
Any suggestion on this?
 
Insert or update the user ID and name in your table using PRE-INSERT or PRE-UPDATE triggers. You could use these to copy the name to hidden database fields, or to directly INSERT or UPDATE the table.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top