Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 186
  • Last Modified:

print a big recorset

I have a big recordset that retrieves many data from a few tables of my database.
When I select the first and last client of the client table from whom I wish to print invoices the program stops responding.
When I select just a few clients it prints allright.
I'm using a matrix printer and VB 6.0 with the print object.
Is the buffer of the printer to short for the amount of data?
Is the recordset to big?
Should I put those records in a temporary table and print each of a time instead of a recordset?

Thanks
0
asimoes
Asked:
asimoes
1 Solution
 
rsaicragCommented:
Try using.. "Transaction"
BeginTrans,CommitTrans or you can try putting it in Type Record or Collection.

A Lot of reasons why your program stops responding it's because maybe you have a lot of procedures or your code has lots of workaround or you never closes an object "Set myvar=nothing" , try to simplify your code...
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now