I'll play devil's advocate!
The only way to remove a previously-defined PK is an "alter table" command,
which of course cannot be safely done in multi-user mode. And you cannot
remove a PK that is referenced.
I will admit to something. If I need to make a table structure change at a
client, and they want it RIGHT AWAY, and the table has a non-referenced PK, and
they can't get all the users off (got all that?) I have resorted to dropping
the table (after unloading data to a file), bring in the new design, reload the
data, and tell myself "I will recreate the PK tonight when I can get the
database single-user". Don't make me say if I do always remember to do that
that very evening.... sometimes Post It notes just aren't big enough
Of course, another way-out thing that could possibly happen is if someone did
an "unload all" to rebuild the database and for some reason it failed at the
"alter table" command for the PK
Karen
On Wednesday, March 5, 2025 at 01:38:28 PM CST, Tom Hart
<[email protected]> wrote:
It is set to on. All the programs are exactly the same, other than data that
goes in
Tom Hart
On Wed, Mar 5, 2025 at 1:15 PM Doug Hamilton <[email protected]> wrote:
Hmm, curious:
STATICDB On or Off?
Doug
On 3/5/2025 12:56 PM, Tom Hart wrote:
It was on 1 column(Item number). The values for that column are populated from
a temp table using select.
Tom Hart
On Wed, Mar 5, 2025, 12:44 PM Bruce Chitiea <[email protected]> wrote:
Tom:
Just curious. Was that one PK value in one row? Multiple rows? The entire
column? Value accessed via variable?
Thanks, Bruce
Bruce A. Chitiea SafeSectors, Inc. 1142 S Diamond Bar Blvd # 442 Diamond
Bar CA 91765-2203
[email protected] (909) 238-9012 m
------ Original Message ------ From "Tom Hart" <[email protected]> To
[email protected] Date 3/5/2025 10:34:32 AM Subject [RBASE-L] - Lose a
PK
How do you lose a PK in a table? My program runs at about 10 different
locations and recently one location said a particular process was running very
slow. I got his app and thoroughly evaluated it, I mean autochk, pack, reload
and Rscope but should no errors. After pulling most of may hair out I looked
at the table in question and found the PK was missing. Finally got it resolved
and program runs fine. Just curious? Tom Hart --
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 visit
https://groups.google.com/d/msgid/rbase-l/CABX9BNc3AiApSrsV3R1ubY%3Dr%3Ddacmu8ES%3D%2BjjBCubkTNZjE6eA%40mail.gmail.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 visit
https://groups.google.com/d/msgid/rbase-l/em5f3ad685-2503-4e85-8ba1-8ed34d85d5b2%40685cf91f.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 visit
https://groups.google.com/d/msgid/rbase-l/CABX9BNcN8ik3ErYT7UaKwH%2BAh0QrZ6t2HZoBH%2BUE9Gin1YYJOQ%40mail.gmail.com.
| | Virus-free.www.avast.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 visit
https://groups.google.com/d/msgid/rbase-l/6079bf47-a10e-4bef-be25-691ca013f205%40wi.rr.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 visit
https://groups.google.com/d/msgid/rbase-l/CABX9BNcuTGQ6C3TxjpR%2BLi1PMi1Ceqn0wJVN15c8XpXT6Dz1BA%40mail.gmail.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 visit
https://groups.google.com/d/msgid/rbase-l/2125789496.485799.1741208164404%40mail.yahoo.com.
