Patti, You state in the first question, "I set a variable vss = SSNum in an eep that is run when you exit the SSNum field". Could you show me the SET VAR command for this variable?
Also I would trace your form so you can look at the variable vss and see what it looks like as you go through the form fields. This way you can see if the var is correct on the exit EEP and if it is correct, see when it changes. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: 'Patti Jakusz' via RBASE-L <[email protected]> Sent: Saturday, December 4, 2021 10:55 AM To: [email protected] Subject: Re: [RBASE-L] - X.5E Upgrade woes Yes, the de clerk is only entering digits. No, the table field has no formatting. It is just a text field 11 characters long. It always worked ok and it still is saved correctly in the table. In the data-entry form, it displays the number with the formatting, and it saves it in the table with formatting. But it's in between those events where it looses the dashes. And in never did in previous versions. I use SSNum in other parts of the form to look up and plug in other info so the DE clerk doesn't have to enter it. But it suddently has no dashes until after we hit save. On Saturday, December 4, 2021, 11:39:03 AM EST, 'Jim Belisle' via RBASE-L <[email protected]<mailto:[email protected]>> wrote: Patti, Some questions: 1. Is the entry person entering the info using just the numerical SS#. Ex. I enter 123456789 but the form is formatted so it shows 123-45-6789. 1. Does the table field where the SS# is saved also have the same format so the info will always show the numerals with the dashes? Below you will see the table column (testcompute) is a computed column using the expression that combines in this instance two columns in the table. [cid:[email protected]] [cid:[email protected]] In your table I would think, if the entry person just enters the numerals of the SS#, the table column in a text field that is also a computed column. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: 'Patti Jakusz' via RBASE-L <[email protected]<mailto:[email protected]>> Sent: Saturday, December 4, 2021 9:46 AM To: [email protected]<mailto:[email protected]>; [email protected]<mailto:[email protected]> Subject: Re: [RBASE-L] - X.5E Upgrade woes CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or opening attachments. Problem #1 below. It is losing the formatting anytime I use SSNum in the variable definitions in the whole form. It saves it with the dashes. It displays it with the dashes, but everywhere else it is without dashes. Help. I have dozens of forms that use the SSNum as a means for lookups from another table. I hope there is a fix. Patti On Saturday, December 4, 2021, 10:35:08 AM EST, 'Patti Jakusz' via RBASE-L <[email protected]<mailto:[email protected]>> wrote: I need to clarify #2 problem below. It didn't stop in the middle of printing a report. I ran a command file and I set output filename with screen and had Echo on. It disconnected in the middle of printing a line in my file. It disconnect halfway thru printing someone's SS#. Patti On Friday, December 3, 2021, 07:34:48 PM EST, 'Patti Jakusz' via RBASE-L <[email protected]<mailto:[email protected]>> wrote: Hello Rbase Pros, We just finally upgraded from Rbase X to X.5 Enterprise and now I have problems. 1) I have forms that have formatted fields, using Input format masks. Our SSNum has dashes in it and it's stored that way in the database. I have a form where people enter the data for women referred to our program. SSNum shows up on the screen with dashes. When I save it in the table it has dashes. But when I use use it in an eep before saving the record, the dashes are gone. I set a variable vss = SSNum in an eep that is run when you exit the SSNum field. This is the point where the dashes disappear. I need to use it for the next field, which has a pop-up menu using .vss I know I can fix it by adding more code, but I hate to think of all the places this might occur. Is this a bug? Does it have a fix? Has anyone else experienced this? (I know I'm the only person in the world who stores SS# with dashes, but I do.) This worked fine in all previous versions. 2. We now have a remote server, instead of one on-site. Rbase disconnects users from the database at random times. It has nothing to do with inactivity. I've had it disconnect me in the middle of printing a line in a report. It happens in the middle of data-entry. They enter a bunch of small records. Then the next record there is no connection to the database. It's crazy. The server says we are not being dropped. But Rbase says we are. Anyone else have this problem? Thank you!! Patti -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/906679540.2411960.1638577982742%40mail.yahoo.com<https://groups.google.com/d/msgid/rbase-l/906679540.2411960.1638577982742%40mail.yahoo.com?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/605141476.2763414.1638631589311%40mail.yahoo.com<https://groups.google.com/d/msgid/rbase-l/605141476.2763414.1638631589311%40mail.yahoo.com?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/SA0PR02MB743407D26337FAA6BA35A2FFA06B9%40SA0PR02MB7434.namprd02.prod.outlook.com<https://groups.google.com/d/msgid/rbase-l/SA0PR02MB743407D26337FAA6BA35A2FFA06B9%40SA0PR02MB7434.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer>. ________________________________ -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/SA0PR02MB7434D58A12EEE936A7AFFDDFA06B9%40SA0PR02MB7434.namprd02.prod.outlook.com.
