Welcome, Guest. Please Login.
04/19/24 at 22:41:22
News:
Home Help Search Login


Pages: 1
Send Topic Print
BKICMSTR field question. (Read 1349 times)
bradyj2
Browser
*


Who's responsible??

Posts: 4
Gender: male
BKICMSTR field question.
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.
Back to top
 
 
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: BKICMSTR field question.
Reply #1 - 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)
 
 Smiley
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Pages: 1
Send Topic Print