ISTech Support Forum - Sequence order in external program

Welcome, Guest. Please Login.

	05/08/25 at 12:43:09 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Manufacturing

‹ Previous topic | Next topic ›

Pages: 1

Sequence order in external program (Read 1071 times)

David Waldmann

Active Member

Live to work, or
work to live?

Posts: 1919
Gender: male

Sequence order in external program
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?

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11

IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 784
Gender: male

Re: Sequence order in external program
Reply #1 - 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?

Wink

Kelloggs

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

David Waldmann

Active Member

Live to work, or
work to live?

Posts: 1919
Gender: male

Re: Sequence order in external program
Reply #2 - 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;PvClien
tEncoding=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=?)

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11

IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 784
Gender: male

Re: Sequence order in external program
Reply #3 - 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)

cry

Kelloggs

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 784 Gender:	Re: Sequence order in external program Reply #4 - 04/30/15 at 07:25:23 sorry forgot the most important ORDER BY It is fix it now hehehe
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1919 Gender:	Re: Sequence order in external program Reply #5 - 04/30/15 at 07:41:36 Tried the first example and it seems to work fine. Thanks!
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › Manufacturing

‹ Previous topic | Next topic ›