ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Access General Issues >> Adding SO records from one db to another
http://www.istechforum.com/YaBB.pl?num=1091073533

Message started by MJM on 07/28/04 at 19:58:53

Title: Adding SO records from one db to another
Post by MJM on 07/28/04 at 19:58:53

Does anyone know a way to add records from the sales order database from one DBA company to another. ? Help would be appreciated.

MJM

Title: Re: Adding SO records from one db to another
Post by Kelloggs on 07/29/04 at 08:59:16

To Insert records to the SO header you can use the following query, but no idea about the SO Lines, there could be some issues with the SO index.

INSERT INTO TO_MYDB.BKARINV (BKAR_INV_NUM, BKAR_INV_SONUM)
SELECT
BKAR_INV_NUM,
BKAR_INV_SONUM
FROM FROM_MYDB. BKARINV WHERE BKAR_INV_NUM = XXXX

This query works with Pervasive SQL 2000 and up.

ciao,

Kelloggs