ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> Sequence order in external program
http://www.istechforum.com/YaBB.pl?num=1430394790

Message started by David Waldmann on 04/30/15 at 04:53:10

Title: Sequence order in external program
Post by David Waldmann on 04/30/15 at 04:53:10

We recently discovered a widespread error in our routings. The way we fixed it was to export them (DE-A), make the corrections, and import them to the temp file (DE-D). We then deleted ROUTING and copied BKRTEMTR to ROUTING.

In Evo everything appears fine (Seq & Op numbers there and sorted properly), but we use an Excel spreadsheet to do our quoting. It looks at the ROUTING table to pull in the processes and they come in in apparently random order. We re-indexed ROUTING but it didn't make any difference.

Any suggestions as to what the problem is?

Title: Re: Sequence order in external program
Post by Kelloggs on 04/30/15 at 07:02:01

Evo's window has the right sorting order: SKU, Seq, Oper ASC, and that is accomplish by code
If ms excel does not have a sorting order, it will use the evo's table sorting order.
If you take a look to key05, this is what you will see : SKU, Type, Est Line, Oper.

A sorting porting ca be insert into your sql query.
How are you importing your data? VBA? MS QUERY?

;)

Kelloggs

Title: Re: Sequence order in external program
Post by David Waldmann on 04/30/15 at 07:11:30

I should add that it worked fine before we created the new ROUTING table.

I'm not sure how we're importing the data. I just spec'd what I needed to happen and the guru figured it out how to do it.

This is the Connection String:
DSN=DBAVH;ServerName=SBSR2.1583;ServerDSN=DBAVH3;ArrayFetchOn=1;ArrayBufferSize=8;TransportHint=TCP:SPX;ClientVersion=11.20.015.000;CodePageConvert=1255;PvClientEncoding=CP1255;PvServerEncoding=CP1252;

This is the Command Text:
SELECT ROUTING.MTRO_CODE, ROUTING.MTRO_OPER, ROUTING.MTRO_OPERDESC, ROUTING.MTRO_WC, ROUTING.MTRO_PARTSHR, ROUTING.MTRO_SETUPHRS
FROM DBAVH.ROUTING ROUTING
WHERE (ROUTING.MTRO_CODE=?)

Title: Re: Sequence order in external program
Post by Kelloggs on 04/30/15 at 07:21:42

The sorting portion is missing, unfortunately the parenthesis are unknow to me. So I am going to guess here.

you can try this:

SELECT ROUTING.MTRO_CODE, ROUTING.MTRO_OPER, ROUTING.MTRO_OPERDESC, ROUTING.MTRO_WC, ROUTING.MTRO_PARTSHR, ROUTING.MTRO_SETUPHRS
FROM DBAVH.ROUTING ROUTING
WHERE (ROUTING.MTRO_CODE=?) ORDER BY MTRO_CODE, MTRO_OPER ASC

OR

SELECT ROUTING.MTRO_CODE, ROUTING.MTRO_OPER, ROUTING.MTRO_OPERDESC, ROUTING.MTRO_WC, ROUTING.MTRO_PARTSHR, ROUTING.MTRO_SETUPHRS
FROM DBAVH.ROUTING ROUTING
WHERE (ROUTING.MTRO_CODE=? ORDER BY MTRO_CODE, MTRO_OPER ASC)

:'(

Kelloggs

Title: Re: Sequence order in external program
Post by Kelloggs on 04/30/15 at 07:25:23

sorry forgot the most important ORDER BY
It is fix it now

hehehe

::)

Title: Re: Sequence order in external program
Post by David Waldmann on 04/30/15 at 07:41:36

Tried the first example and it seems to work fine.

Thanks!

;D