DeveloperBarn Forums

Go Back   DeveloperBarn Forums > Databases > Microsoft Access

Discuss "Slow Concat Code" in the Microsoft Access forum.

Microsoft Access - Microsoft Access is a database for small to medium applications. Learn tips and tricks and best database practices here.


Closed Thread « Previous Thread | Next Thread »
 
LinkBack Thread Tools Display Modes
  #21 (permalink)  
Old May 6th, 2008, 02:02 AM
don94403's Avatar
Moderator


 
Join Date: Mar 2008
Location: San Mateo, CA, USA
Posts: 43
Thanks: 2
Thanked 3 Times in 3 Posts
Blog Entries: 2
Rep Power: 1
don94403 is on a distinguished road

Awards Showcase
Microsoft Access PHP 
Total Awards: 2

Default

Aww shucks, guys! Thanks! Can I use you as references??
Sponsored Links
  #22 (permalink)  
Old May 6th, 2008, 02:08 AM
don94403's Avatar
Moderator


 
Join Date: Mar 2008
Location: San Mateo, CA, USA
Posts: 43
Thanks: 2
Thanked 3 Times in 3 Posts
Blog Entries: 2
Rep Power: 1
don94403 is on a distinguished road

Awards Showcase
Microsoft Access PHP 
Total Awards: 2

Default

BTW, do you like my new avatar? I'm the one on the left.
  #23 (permalink)  
Old May 6th, 2008, 07:30 AM
jmurrayhead's Avatar
Your Lord & Master

 
Join Date: Mar 2008
Location: Reston, VA, USA
Posts: 530
Thanks: 14
Thanked 38 Times in 37 Posts
Blog Entries: 2
Rep Power: 1
jmurrayhead is on a distinguished road

Awards Showcase
Microsoft .Net Microsoft SQL Server Microsoft Windows Classic ASP 
Total Awards: 4

Default

Quote:
Originally Posted by don94403 View Post
Aww shucks, guys! Thanks! Can I use you as references??
Certainly! And the avatar rocks
__________________
jmurrayhead
Did I help you out? Make me popular by clicking the icon!

If you found a post helpful, please click the button in the lower right-hand corner of the post.

Powered by ASP.Net
  #24 (permalink)  
Old May 6th, 2008, 08:30 PM
don94403's Avatar
Moderator


 
Join Date: Mar 2008
Location: San Mateo, CA, USA
Posts: 43
Thanks: 2
Thanked 3 Times in 3 Posts
Blog Entries: 2
Rep Power: 1
don94403 is on a distinguished road

Awards Showcase
Microsoft Access PHP 
Total Awards: 2

Default

Thanks. Actually, at this stage of my life, I think the next time I will need references will be for St. Peter! But I'm not expecting to need that for some time yet.
  #25 (permalink)  
Old May 8th, 2008, 07:19 AM
AOG123's Avatar
Lightning Master

 
Join Date: Mar 2008
Location: Fortress Of Solitude
Posts: 75
Thanks: 6
Thanked 20 Times in 15 Posts
Rep Power: 1
AOG123 is on a distinguished road

Awards Showcase
Microsoft Access 
Total Awards: 1

Default

Thanks for your input on this,.. i am still reviewing my options,. but your schema makes sense however, how do you propose adding lines to the order without having to add each part 2x 3x etc to give a total

Thanks DON
__________________
If i helped you, make me famous by clicking the
  #26 (permalink)  
Old May 8th, 2008, 12:10 PM
sbenj69's Avatar
Moderator

 
Join Date: Mar 2008
Posts: 73
Thanks: 18
Thanked 20 Times in 15 Posts
Rep Power: 1
sbenj69 is on a distinguished road

Awards Showcase
Microsoft Windows Microsoft Access 
Total Awards: 2

Default

maybe this will give you an idea or two. I will delve into this later if I get a chance.
Attached Files
File Type: zip Consolidate2.zip (22.8 KB, 6 views)
  #27 (permalink)  
Old May 8th, 2008, 12:19 PM
AOG123's Avatar
Lightning Master

 
Join Date: Mar 2008
Location: Fortress Of Solitude
Posts: 75
Thanks: 6
Thanked 20 Times in 15 Posts
Rep Power: 1
AOG123 is on a distinguished road

Awards Showcase
Microsoft Access 
Total Awards: 1

Default

thanks sbenj,.. we're both on the same wave here,..

I've been trying exactly this for the last hour,. hoping to get the missing lines in,

for example,.. in your sample,.. the first concated request is

Code:
RequestNum	Part Number	ID #
4	            NAS1097D5-6        4, 18
Notice how Request Num 18 isn't showing,.. i'm hoping to get also

Code:
RequestNum	Part Number	ID #
18	            NAS1097D5-6        4, 18
and a return of all 196 lines.
  #28 (permalink)  
Old May 8th, 2008, 12:53 PM
sbenj69's Avatar
Moderator

 
Join Date: Mar 2008
Posts: 73
Thanks: 18
Thanked 20 Times in 15 Posts
Rep Power: 1
sbenj69 is on a distinguished road

Awards Showcase
Microsoft Windows Microsoft Access 
Total Awards: 2

Default

aha....ok, I will get to this later today.....now I have to build 3 laptop stands..... uggh

So now I know what it's doing..... I thought that might be what you were talking about.
  #29 (permalink)  
Old May 8th, 2008, 01:32 PM
don94403's Avatar
Moderator


 
Join Date: Mar 2008
Location: San Mateo, CA, USA
Posts: 43
Thanks: 2
Thanked 3 Times in 3 Posts
Blog Entries: 2
Rep Power: 1
don94403 is on a distinguished road

Awards Showcase
Microsoft Access PHP 
Total Awards: 2

Default

Quote:
Originally Posted by AOG123 View Post
Thanks for your input on this,.. i am still reviewing my options,. but your schema makes sense however, how do you propose adding lines to the order without having to add each part 2x 3x etc to give a total

Thanks DON
I'm not sure I fully understand your question, but there's no doubt that my approach would require somewhat more complicated table maintenance. My thought is that on a particular purchase order you might have numerous line items for the same vendor, and that, in some cases, the same part number might be ordered to satisfy more than one work order, so those would become separate line items, which is maybe what you were referring to. So a PO might look like this:
Code:
PO# 1234
Vendor ABC
Date: ...
     Part          Qty    WO#
1    PN12-J-15     100    WO789
2    PN43-Q-11      20    WO678
3    PN43-Q-11      35    WO678
...
That's what I had in mind, but I guess I see your point, that you would like to just order a qty of 55 of PN43-Q-11 as a line item. But then, wouldn't you have the problem of knowing what work orders you had purchased the items for? If PO#1234 took 3 weeks to deliver and you had more new work orders that required PN43-Q-11, how would you know which work orders should get the 55 that are delivered?

I'll give this some more thought, but the next few days I won't have time to devote to it.
  #30 (permalink)  
Old May 8th, 2008, 01:39 PM
AOG123's Avatar
Lightning Master

 
Join Date: Mar 2008
Location: Fortress Of Solitude
Posts: 75
Thanks: 6
Thanked 20 Times in 15 Posts
Rep Power: 1
AOG123 is on a distinguished road

Awards Showcase
Microsoft Access 
Total Awards: 1

Default

Thanks Don,... the good news is my tables stucture is almost a replica of your example,.. so theres room for mods,.

It's a shame that the requirements are so specific,. but as it stands i have wrote a new ultra fast concat function which adds the concat to a temp table on the be.mdb ,.. leaving me the problem of the breakdown,.. which is in the last post. Which is required to update the original request table.

I really appreciate your time on this,.. and it must be quite irritating to others as it all seems a little odd.
Closed Thread

  DeveloperBarn Forums > Databases > Microsoft Access

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


Sponsored Links

ASP.NET Resource Index
a directory of ASP.NET tutorials, applications, scripts, assemblies and articles for the novice to professional developer.

Free Web Directory
Including Chats and Forums Resources, Offer automatic, instant and free directory submissions.
URLZ Web Directory
URLZ Web Directory

Free Web Directory - Add Your Link
The Little Web Directory
Free Web Directory
Pegasus free web directory is a free directory organised by categories.

Web Directory & SEO Services
dirroot web directory


All times are GMT -4. The time now is 07:48 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.2.0
Copyright © 2008 DeveloperBarn.com

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46