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] <[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
On 11/07/2023 8:53 PM EST Lin MacDonald <
[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].
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].
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].
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].
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].
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>.
