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> > > [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.
