Vb Script Problem Reading Databases

Legacy Poster

• 2015年01月22日 09:26

I am having a problem with a VB Script. 
 
I am trying to select a value from a table and if it doesn't exist I want the default to be "UK".  The tables STOCKTABLE  & CREDTABLE are linked by the PRIMARYSUPPLIER (field) - this can be blank.  If no supplier exists or the DEPARTMENT is not FINISHED (4th item in list - no3) I want the result to print UK. If a supplier exists and the goods are FINISHED, I want the results to show the Country of Origin (CREDTABLE.COUNTRY).
 
I have attached the code, as you can see I have tried a few possibilities and variations.

 

 

 

Help would be very much appreciated.

 

Lynne

0

• 

  Canguita

  ★ BarTender Hero ★

  • 2015年02月10日 10:06

  Hello Lynne,

   

  I contacted you by email as you emailed directly to our Technical Support.

   

  I would like to know if you can send us your BarTender label file and your database file, or unless your BarTender label file. Checking your VB script, It seems OK (not efficient as you are creating redundant information, so you can improve your code, but the code is OK), in fact the test is giving you UK as result. However, I would like to have your label to check your configuration, as I think that you will need to write your code in OnNewRecord() event script.

   

  Thanks,

   

  Carlos

  0

請登入寫評論。