Hmmm... don't know if that's a problem or not, but I would mention that I
don't think I have ever once used an FK on a temp table. Try removing it and
just use a manual check of the data before adding it to the perm table?
Karen
-----Original Message-----
From: Jim Belisle <[email protected]>
To: [email protected] <[email protected]>
Sent: Mon, Aug 5, 2019 5:25 pm
Subject: [RBASE-L] - internal lock
<!-- #yiv8867619103 _filtered #yiv8867619103 {font-family:"Cambria
Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv8867619103
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv8867619103
{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} #yiv8867619103
#yiv8867619103 p.yiv8867619103MsoNormal, #yiv8867619103
li.yiv8867619103MsoNormal, #yiv8867619103 div.yiv8867619103MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri",
"sans-serif";} #yiv8867619103 a:link, #yiv8867619103
span.yiv8867619103MsoHyperlink {color:blue;text-decoration:underline;}
#yiv8867619103 a:visited, #yiv8867619103 span.yiv8867619103MsoHyperlinkFollowed
{color:purple;text-decoration:underline;} #yiv8867619103
p.yiv8867619103MsoAcetate, #yiv8867619103 li.yiv8867619103MsoAcetate,
#yiv8867619103 div.yiv8867619103MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma",
"sans-serif";} #yiv8867619103 span.yiv8867619103EmailStyle17
{font-family:"Calibri", "sans-serif";color:windowtext;} #yiv8867619103
span.yiv8867619103BalloonTextChar {font-family:"Tahoma", "sans-serif";}
#yiv8867619103 .yiv8867619103MsoChpDefault {} _filtered #yiv8867619103
{margin:1.0in 1.0in 1.0in 1.0in;} #yiv8867619103 div.yiv8867619103WordSection1
{} -->When creating new products I use an existing product, edit the parts
used in the new product in a TEMP table then insert the new product and parts
into the proper tables. In order to make sure I am not inserting bad parts
(parts not in the system yet) I over the weekend add a FK to the temp table on
the parts column in the temp table and also made it not null. This worked fine
with no problems when I tested this on my backup DB on my local drive.
However when using this method today on the server, I ran into an internal lock
situation when running the code. Is it not wise to use FKs for temp tables
created on the fly? I have not run into this before. James Belisle
Making Information Systems People Friendly Since 1990 --
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/DM6PR02MB45393FD249866BFDE6132D32A0DA0%40DM6PR02MB4539.namprd02.prod.outlook.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 on the web visit
https://groups.google.com/d/msgid/rbase-l/922514639.1731411.1565096216819%40mail.yahoo.com.
