Just note that you can't make SSN an integer. It's possible that the SSN begins with a "0"!!! In all the DBs I have that have a SSN, it's stored as a 9 digit Text with no dashes. That is my PK or index column. On some, I was smart enough to include a computed column to do: ( SGET(ssn,3,1) + '-' + SGET(ssn,2,4) + '-' + SGET(ssn,4,6) )
Karen -----Original Message----- From: Randyp <[email protected]> To: [email protected] Sent: Mon, Dec 6, 2021 11:38 am Subject: Re: [RBASE-L] - X.5E Upgrade woes At this point it might make more sense to change your field to an integer 9-digit field and a primary key. All your reports and forms can be set to automatically format adding hyphens in the expected locations. If you like to see that column with dashes, it can easily be done with a computed column, or by creating a view. I believe that will simplify everything in the future, and solve the conversion issues you describe. Having a simple and consistent approach will pay off long term. All the best, Randy Peterson Sent from my iPhone On Dec 6, 2021, at 7:11 AM, 'Jim Belisle' via RBASE-L <[email protected]> wrote: <!--#yiv7343992787 _filtered {} _filtered {} _filtered {} _filtered {}#yiv7343992787 #yiv7343992787 p.yiv7343992787MsoNormal, #yiv7343992787 li.yiv7343992787MsoNormal, #yiv7343992787 div.yiv7343992787MsoNormal {margin:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv7343992787 a:link, #yiv7343992787 span.yiv7343992787MsoHyperlink {color:blue;text-decoration:underline;}#yiv7343992787 p.yiv7343992787ydpb94b386fyiv9237759478ydp2337bee1yiv9032529628msonormal, #yiv7343992787 li.yiv7343992787ydpb94b386fyiv9237759478ydp2337bee1yiv9032529628msonormal, #yiv7343992787 div.yiv7343992787ydpb94b386fyiv9237759478ydp2337bee1yiv9032529628msonormal {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv7343992787 p.yiv7343992787ydpb94b386fyiv9237759478ydp2337bee1yiv9032529628ydp9fa440c4yiv7101949078msonormal, #yiv7343992787 li.yiv7343992787ydpb94b386fyiv9237759478ydp2337bee1yiv9032529628ydp9fa440c4yiv7101949078msonormal, #yiv7343992787 div.yiv7343992787ydpb94b386fyiv9237759478ydp2337bee1yiv9032529628ydp9fa440c4yiv7101949078msonormal {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv7343992787 p.yiv7343992787ydpb94b386fyiv9237759478ydp2337bee1yiv9032529628ydp9fa440c4yiv7101949078ydp96fd43fayiv5041470401msonormal, #yiv7343992787 li.yiv7343992787ydpb94b386fyiv9237759478ydp2337bee1yiv9032529628ydp9fa440c4yiv7101949078ydp96fd43fayiv5041470401msonormal, #yiv7343992787 div.yiv7343992787ydpb94b386fyiv9237759478ydp2337bee1yiv9032529628ydp9fa440c4yiv7101949078ydp96fd43fayiv5041470401msonormal {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv7343992787 span.yiv7343992787EmailStyle23 {font-family:"Times New Roman", serif;color:#1F497D;font-weight:normal;font-style:normal;text-decoration:none none;}#yiv7343992787 .yiv7343992787MsoChpDefault {font-size:10.0pt;} _filtered {}#yiv7343992787 div.yiv7343992787WordSection1 {}#yiv7343992787 _filtered {} _filtered {} _filtered {}#yiv7343992787 ol {margin-bottom:0in;}#yiv7343992787 ul {margin-bottom:0in;}-->Patti, It maybe someone else can guide you better than myself. I just did a quick adaptation on a form, I added the table columns and form variables in a test DB, and got the results you had wanted. I did not use the var in other fields or calculations and did no further testing. Sorry if I steered you wrong. James Belisle Making Information Systems People Friendly Since 1990 <image001.jpg> From: 'Patti Jakusz' via RBASE-L <[email protected]> Sent: Sunday, December 5, 2021 2:09 PM To: [email protected] Subject: Re: [RBASE-L] - X.5E Upgrade woes Whoops, no it's not saving it with the dashes. I think when you convert a database, it doesn't really modify the way any forms work until you edit and save a form again using the new version. Patti On Sunday, December 5, 2021, 03:03:14 PM EST, 'Patti Jakusz' via RBASE-L <[email protected]> wrote: Hello Javier, I think Jim Belisle solved that issue for me. I must have found a glitch in Rbase 10 and my formatted data was saved in the table with the dashes, despite the format mask being wrong. I was using 000\-00\-0000;0; Now that I'm using 10.5E, it seems to work differently. But it is still saving the data in the table with the dashes - all 11 characters, which is what I wanted. Now that I'm writing this email, I realized it's still not working like one would expect, but then things always ork screwy for me. Patti On Sunday, December 5, 2021, 01:17:54 PM EST, <[email protected]> wrote: A couple of thoughts about it First, your code remind me of the time when memory was at a premium and we had to sue shorthand to save memory and storage; that is no longer the case A while back, I took the time to rewrite a lot of my old code to adapt to the new standards and to make it so is legible and easy to follow by any one working on the code. I would start by rewriting the code to include the new syntax IF vssnum IS NULL THEN SET VAR vCase = NULL ELSE SET VAR vCase = CASENUM IN CASEID WHERE SSNUM = .vssnum ENDIF I believe R:Style, when properly configure will do a lot of it for you. Now a couple of question: Is vssnum defined before the snippet above and if so, how is it defined or is this the value entered in the form? Can your TRACE the code and see: What is the value of vssnum before you hit the first line If it is not NULL, what is the value of vssnum and vCase before and after you execute line 4? Is it retrieving the right information for vCase? This should give you an idea of where the value is changed, at least in the code provided. Also, if you are always using just 9 digits for SSN, why do you have the column defined as being 11 characters? Javier, Javier Valencia, PE 913-915-3137 From: 'Patti Jakusz' via RBASE-L <[email protected]> Sent: Saturday, December 4, 2021 11:54 AM To: [email protected] Subject: Re: [RBASE-L] - X.5E Upgrade woes I have traced it and watched the variable vssnum. That is how I knew that the dashes were missing. I made a mistake in my first email. I set the variable vssnum=SSNum when I defined variables, and then I used vssnum in my EEP. I attached a screen snip from the form and my variables, then one from the formatting of the field, then one of my eep. The eep doesn't work because my dashes are not in vssnum. On Saturday, December 4, 2021, 12:24:13 PM EST, 'Jim Belisle' via RBASE-L <[email protected]> wrote: 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 <image001.jpg> 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]> wrote: Patti, Some questions: - 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. - 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. <image002.png> <image003.png> 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 <image001.jpg> From: 'Patti Jakusz' via RBASE-L <[email protected]> Sent: Saturday, December 4, 2021 9:46 AM To: [email protected];[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]> 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]> 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/906679540.2411960.1638577982742%40mail.yahoo.com. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/605141476.2763414.1638631589311%40mail.yahoo.com. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/SA0PR02MB743407D26337FAA6BA35A2FFA06B9%40SA0PR02MB7434.namprd02.prod.outlook.com. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/SA0PR02MB7434D58A12EEE936A7AFFDDFA06B9%40SA0PR02MB7434.namprd02.prod.outlook.com. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/991830414.2780526.1638640426198%40mail.yahoo.com. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAAJSLg7oNRZpGlQFgUi0LDrEBAAAAAA%3D%3D%40vtgonline.com. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2018637820.580298.1638734586435%40mail.yahoo.com. -- 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/SA0PR02MB7434650BEF3847C57DB21C13A06D9%40SA0PR02MB7434.namprd02.prod.outlook.com. -- 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/1E3F1542-15FA-4174-A3B8-B521A7B1088C%40ctags.com. -- 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/459192907.1063638.1638812647398%40mail.yahoo.com.
