Viewing 15 posts - 21,916 through 21,930 (of 26,484 total)
foxjazz (3/18/2009)
let me give some datapartnumber, producttype, sequence
7401,belt,1
7432,belt,2
8401,hose,1
8422,hose,2
This is the table.
inert a record (8403,hose,?)
after a resequence you would have
8401,hose,1
8402,hose,2
8422,hose,3
Before I write any code, plus I have work to do here...
March 18, 2009 at 10:57 am
Chris Morris (3/18/2009)
foxjazz (3/18/2009)
{} is much better than BEGIN BEGIN BEGIN BEGIN END END END END
Heh quite possibly - but the count of BEGIN - END pairs goes right down...
March 18, 2009 at 10:41 am
foxjazz (3/18/2009)
partnumber, producttype, sequence
After inserting part in the table we need to resequence the sequence number which depends on the partnumber.
so select partnumber...
March 18, 2009 at 10:37 am
foxjazz (3/18/2009)
{} is much better than BEGIN BEGIN BEGIN BEGIN END END END END
For you, perhaps. I find BEGIN END just fine. Remember I did come from a...
March 18, 2009 at 10:32 am
Selfless plug -- One of the articles now referenced in my signature block is actually mine, though it is based off Jeff's work.
March 18, 2009 at 10:24 am
foxjazz (3/18/2009)
It's been an adventure this week, I still don't have a computer from the recent crash...
March 18, 2009 at 10:16 am
Copying and pasting code from the forum, the code becomes double spaced and it loses it formatting (indention for one).
March 18, 2009 at 9:14 am
Bob, I'll join you in cutting foxjazz some slack, but there needs to be a bit more from him than just dropping the insults.
First, a simple apology for calling me...
March 18, 2009 at 9:03 am
kevin.reynolds (3/18/2009)
--------------------------------------------------------------------------------
I feel Im running the risk of being lynched, but I agree in general with foxjaaz.
Im a database developer but I too am frustrated with the snail pace at...
March 18, 2009 at 8:08 am
I don't know yet. It's hard to tell if he is a Vader or an Emperor. If you tried to run his code he provided it is missing...
March 17, 2009 at 11:25 pm
Bob Hovious (3/17/2009)
This can easily be done with a setbase solution????????????
Yes it can, Fox. 🙂 Don't be amazed. We do this for...
March 17, 2009 at 11:16 pm
I'm sure it is a lesson in futility. I seriously doubt that foxjazz will ever admit defeat and apologize to us all for his lack of true understanding of...
March 17, 2009 at 11:13 pm
As I mentioned above, here is a second version of the code. It is quite possible that both of these may return different results. I have no idea...
March 17, 2009 at 10:46 pm
foxjazz (3/17/2009)
Some things just have to be looped. Like for instance, sequence numbers.
but we will...
March 17, 2009 at 10:31 pm
Even though you are missing code from your setup script, missing an important table from your setup script, didn't provide ANY test data or expected results based on that data,...
March 17, 2009 at 10:25 pm
Viewing 15 posts - 21,916 through 21,930 (of 26,484 total)