×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Strange but True.....!

Strange but True.....!

Strange but True.....!

(OP)
Hi,

We are using ACCPAC 5.0. We frequenty need to change our Bill of Material (BOM Tables) and manual operation to update each BOM item is time consuming.
We developed a VB6 routine to update BOM Tables (ICBOMH, ICBOMD). The VB routine is working fine when we check for the Items updated in BOM. (ACCPAC BOM Screen is showing the updated quanties of components that shows the ICBOMD table have been updated)

Strangly after running the assembles to produce the finished good the assemblies table contains the BOM component figues which were before updating the ICBOMD table.

We are using Pervasive SQL in Novell 5.0.

Any tip, comment will be highly appreciated.


ZAB





RE: Strange but True.....!

How are you updating the tables? Using the ACCPAC COMAPI or xAPI? Or are you using ADO/ODBC?

zemp

RE: Strange but True.....!

(OP)

Hi Zemp,

 Thanks for your response. We are using ADO/ODBC. Any solution in mind please.

Thanks

ZAB

RE: Strange but True.....!

I would recommend using the ACCPAC API. It uses the same views and therefore business logic that the ACCPAC interface uses. This will ensure that everything is being updated properly, ensures data integrity and will let you know if there are problems.

ADO/ODBC is obviously not updating something that needs to be updated (I am not sure what).

You could write a macro (COMAPI) or VB program that updates the necessary views (or tables). Start by recording a macro in ACCPAC when you are changing the required information manually. This will tell you the views and fields that need to be updated. You will have to make some additions to have it update more than one record, but that is not difficult.

Search this forum for some example code and explanations.

zemp

RE: Strange but True.....!

(OP)

Thanks Zemp, If you can provide some links to such VB Macro treads, I shall be grateful.

Thnaks

ZAB

RE: Strange but True.....!

Do a keyword search on 'xAPI' and/or 'COMAPI' and/or 'macro'. Second tab at the top of the page.

zemp

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close