×
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!
  • Students Click Here

*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

Getting different totals when exporting and cycling through a table

Getting different totals when exporting and cycling through a table

Getting different totals when exporting and cycling through a table

(OP)
Hi there,
I am trying to back up a table in Advantage 4.2 by using the xAPI code I developped (posted under ACCPAC Macro/VBA (http://www.tek-tips.com/gviewthread.cfm/lev2/78/lev3/80/pid/631/qid/616765)
I changed the views to correspond with the tables for this version of accpac. By using the fetch command, I get a total of 8600 records, but when I export the table from within Accpac, I get 8713 records... Anyone care to guess why there is such a descrepency?

Thanks
Xenzat

RE: Getting different totals when exporting and cycling through a table

Just a note, when you want to reference another thread, and provide a link, just type Thread631-616765. Tek-tips will format it as a hyperlink. This is the name of the thread found under its title (right above the 'forum' tab).

As far as your issue is concerned. Accpac export is probably looking at more tables that you have accessed. Therefore it may find more records. Accpac tends to export everything that is related to what you are exporting. With code we tend to pull/export only what we really need or think we need.

You will find lots of such issues when working with Accpac. Some serious, some not. I only wish there was some good documentaion of the accpac xAPI and COMAPI. Let me know if you find any.

Thanks and Good Luck!

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