Opening The Records..

Legacy Poster

• 2014年12月04日 00:06

Hi,

 

Im new to bartender,  I have a database with over 3million EAN codes with prices and descriptions within it. I have a prompt setup the user keys in EAN,  But every time they key in EAN code  bartender keeps coming up with opening the records which then takes 3-5 minutes to print label every time.

 

Any suggestions?

 

Regards

KEith

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • 2014年12月04日 02:36

  That's a lot of records.. What database (SQL etc) do you use? Does Use client cursor in Database connection setup > Option helps?

  How long would it take if you get the same data by VB Script etc - when you tested like below?

  http://forums.seagullscientific.com/index.php?/topic/2673-return-a-recordset-from-an-sql-query/

  0

請登入寫評論。