ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Access General Issues >> BKICMSTR field question.
http://www.istechforum.com/YaBB.pl?num=1257268055

Message started by bradyj2 on 11/03/09 at 10:07:35

Title: BKICMSTR field question.
Post by bradyj2 on 11/03/09 at 10:07:35

I'm working on making a product catalog, and I'm trying to narrow down the products that will be listed.

Anyway, without going into too much detail, I'm trying to figure out how to update a couple of fields in the BKICMSTR file which will help me narrow down the number of products.

Those fields are:
BKIC_PROD_USLYR
BKIC_PROD_USYTD

They appear to have some old data stored in them, and I couldn't figure out a way to get these fields to update.

Title: Re: BKICMSTR field question.
Post by Kelloggs on 11/03/09 at 11:00:17

1.- Contact ISTECH Support and make sure that those fields are not being use by DBA/EVO
2.- Use your play company to test it
3.- Use the Pervasive Control Center, or a MS Access pass-through query

UPDATE BKICMSTR
SET BKIC_PROD_USLYR=1,
BKIC_PROD_USYTD=1
WHERE BKIC_PROD_CODE LIKE 'Red %'

This sql statement will update all Products that start with Red (Red Apples, Red Bananas, Red Oranges, etc, etc)

:)

Kelloggs