ISTech Support Forum - Adding SO records from one db to another

Welcome, Guest. Please Login.

	05/02/24 at 23:33:08 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Crystal Reports, ODBC & Access › Access General Issues

‹ Previous topic | Next topic ›

Pages: 1

Adding SO records from one db to another (Read 783 times)

MJM Browser I love YaBB 1G - SP1! Posts: 3	Adding SO records from one db to another 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
Back to top	IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 785
Gender: male

Re: Adding SO records from one db to another
Reply #1 - 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

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

IP Logged

Pages: 1

ISTech Support Forum › Crystal Reports, ODBC & Access › Access General Issues

‹ Previous topic | Next topic ›