Karen, I'm going with the rebuild, my clients cannot mess with database manipulation because it is a compiled app. I do have a place where they can rebuild using unload all.
Tom Hart On Wed, Mar 5, 2025, 2:56 PM 'Karen Tellef' via RBASE-L < [email protected]> wrote: > 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 > <https://www.google.com/maps/search/1142+S+Diamond+Bar+Blvd+%23+442+Diamond+Bar+CA+91765-2203?entry=gmail&source=g> > Diamond Bar CA 91765-2203 > <https://www.google.com/maps/search/1142+S+Diamond+Bar+Blvd+%23+442+Diamond+Bar+CA+91765-2203?entry=gmail&source=g> > > <https://www.google.com/maps/search/1142+S+Diamond+Bar+Blvd%0D%0A++++++++++++++++++++++++++%23+442+%0D%0A+++++++++++++++++++++Diamond+Bar+CA%0D%0A++++++++++++++++++++++++++91765-2203?entry=gmail&source=g> > > [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 > <https://groups.google.com/d/msgid/rbase-l/CABX9BNc3AiApSrsV3R1ubY%3Dr%3Ddacmu8ES%3D%2BjjBCubkTNZjE6eA%40mail.gmail.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 visit > https://groups.google.com/d/msgid/rbase-l/em5f3ad685-2503-4e85-8ba1-8ed34d85d5b2%40685cf91f.com > <https://groups.google.com/d/msgid/rbase-l/em5f3ad685-2503-4e85-8ba1-8ed34d85d5b2%40685cf91f.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 visit > https://groups.google.com/d/msgid/rbase-l/CABX9BNcN8ik3ErYT7UaKwH%2BAh0QrZ6t2HZoBH%2BUE9Gin1YYJOQ%40mail.gmail.com > <https://groups.google.com/d/msgid/rbase-l/CABX9BNcN8ik3ErYT7UaKwH%2BAh0QrZ6t2HZoBH%2BUE9Gin1YYJOQ%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > > > > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> > Virus-free.www.avast.com > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> > <#m_8442763528451547927_m_-1639631777641644779_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > -- > 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 > <https://groups.google.com/d/msgid/rbase-l/6079bf47-a10e-4bef-be25-691ca013f205%40wi.rr.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 visit > https://groups.google.com/d/msgid/rbase-l/CABX9BNcuTGQ6C3TxjpR%2BLi1PMi1Ceqn0wJVN15c8XpXT6Dz1BA%40mail.gmail.com > <https://groups.google.com/d/msgid/rbase-l/CABX9BNcuTGQ6C3TxjpR%2BLi1PMi1Ceqn0wJVN15c8XpXT6Dz1BA%40mail.gmail.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 visit > https://groups.google.com/d/msgid/rbase-l/2125789496.485799.1741208164404%40mail.yahoo.com > <https://groups.google.com/d/msgid/rbase-l/2125789496.485799.1741208164404%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 visit https://groups.google.com/d/msgid/rbase-l/CABX9BNcFzGAWW_CbN7NZsLteaV2YzT1o%3DPHgePuhyzfK33D1-A%40mail.gmail.com.
