What about using a numeric data type with fixed decimal location as a primary key?
________________________________ From: [email protected] <[email protected]> on behalf of [email protected] <[email protected]> Sent: Wednesday, November 8, 2023 6:07 PM To: [email protected] <[email protected]> Subject: RE: [RBASE-L] - Where do I set my Vars? If I understand correctly, by Universal Key you mean a Primary Key with Foreign keys linked. I personally would not use a real or double type as Primary key, precisely because of the problems you are encountering. You can have the same value generated at different time and depending on how is computed can default to a different valuer, or two different values that default to the same value. All my primary keys, and by extension foreign keys, have the type INTEGER or TEXT. Now, if you want to change the type, you need to go to all the linked tables, disable the primary/foreign link to the primary table an rename them to a temporary name. Then, you can go to the primary table and change the type to what ever you need it to be, and the n go back to the secondary tables and change the name back to the original at which time they will adopt the new type and then re-ink them to the primary table, makes sense? There is a rename command, but if I recall correctly, will not work with linked columns. If you are going to do this, I would suggest converting your REAL values to INTEGER and use them as the primary key. At one time, I had the need to change the text length of several primary columns and their corresponding foreign columns in numerous tables as the needs changed. I wrote a program where you would select the name of the primary table, primary key and the new length and the application would do the entire process described above automatically. If you need to do this once, you can do it manually; however, if you have multiple occurrences, writing a program to do it would be the best way. Javier, Javier Valencia, PE 14315 S Twilight Ln Olathe, KS 66062 913-915-3137 From: [email protected] <[email protected]> On Behalf Of Lin MacDonald Sent: Wednesday, November 8, 2023 3:02 PM To: [email protected] Subject: Re: [RBASE-L] - Where do I set my Vars? Sadly, that's about when I wrote this! It is a Universal Key attached to several other tables so I can't really change it to a double, I guess Lin On Wed, Nov 8, 2023, at 12:43 PM, 'Karen Tellef' via RBASE-L wrote: Welcome to the not-so-wonderful world of the "REAL" datatype. Long ago in DOS days that was the only datatype (other than currency) that allowed decimals. Unfortunately it isn't real accurate IMO (pun intended). Most of us switched all those Real numbers to the DOUBLE datatype. With Double, a 104.31 is always stored and displayed exactly as 104.31. With Real, internally that number may be stored as something like 104.309187983. So depending on your display formatting, you could get different representations to the screen. Looks like the 000.## type of formatting might be truncating. In my example, it would display as 104.30 or 104.309 even tho the number is actually 104.31. Someone else suggested using the ROUND function if you know how many decimal places you want displayed. Karen On Wednesday, November 8, 2023 at 01:47:25 PM CST, [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> wrote: Hello Razzak, Thank you - that is what I was looking for. I knew there was a simple solution. I am getting a strange output though: the real number stored is 104.31 000.## prints as 104.30 000.### prints as 104.309 This is an unusual situation where the number stored could possibly be 4 numbers to the left of the decimal and 3 to the right (we have never had more than 2 to the right) thanks for the help! Lin On Tuesday, November 7, 2023 at 7:57:30 PM UTC-8 Razzak Memon wrote: Lin, Here's how ... Please take a look at the attached illustration. * Open the report in Report Designer * Right-click on the Variable Object and select Display Format * Under the Display Format option change the Display Format to 0.000 * Click on the [OK] button to save the Display Format * Click on the [Preview] Tab to preview while still in Report Designer * Save the report and close the Report Designer That's all there is to it! I hope it helps! Very Best Regards, Razzak [https://groups.google.com/group/rbase-l/attach/3c656e7487c2d/image.png?part=0.1&view=1] On 11/07/2023 8:53 PM EST Lin MacDonald <[email protected]<mailto:[email protected]>> wrote: This will sound silly, but I am working on a system that I wrote several years ago, but can't remember most of what I wrote! I have a report that prints a Var (type: Real) It is now printing it with 7 places after the decimal point. I need it to print a max of 3 places. Where do I set the number of places? I honestly can't rmemeber! Lin -- 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/1c446867-f6d4-49b8-adc4-3252ed914b4b%40app.fastmail.com<https://groups.google.com/d/msgid/rbase-l/1c446867-f6d4-49b8-adc4-3252ed914b4b%40app.fastmail.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/c065ed53-23d4-4581-baa4-11a2e5034242n%40googlegroups.com<https://groups.google.com/d/msgid/rbase-l/c065ed53-23d4-4581-baa4-11a2e5034242n%40googlegroups.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/1942164164.930636.1699476193291%40mail.yahoo.com<https://groups.google.com/d/msgid/rbase-l/1942164164.930636.1699476193291%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/c022b428-2852-45c0-bb15-d0acaa5c2fee%40app.fastmail.com<https://groups.google.com/d/msgid/rbase-l/c022b428-2852-45c0-bb15-d0acaa5c2fee%40app.fastmail.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/0fb501da1298%24668608c0%2433921a40%24%40vtgonline.com<https://groups.google.com/d/msgid/rbase-l/0fb501da1298%24668608c0%2433921a40%24%40vtgonline.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/DM4PR10MB5918D74A426E497A133C72A6C8AFA%40DM4PR10MB5918.namprd10.prod.outlook.com.
