1. GH kumar
  2. PowerBuilder
  3. Monday, 08 October 2018

hai experts,

i have a product table which contains a column barcode_id  and want to print it using label datawindow type presentation , I created a window which has one datawindow control (dw_1)  wich have a dataobject d_barcodelabel and have a retrieval argument of barcodeid, a Retrieve button and  two single line edit controls(sle_barcode) , one for barcode_id and the other single line edit for number of copies(sle_copy) .when you type sle_barcode with
for eg: UT100000 and (sle_copy) is 50 and click on retrieve button. i want to display 50 times UT100000 in label datawindow control. How to achieve this ? 

regards

kumar

GH kumar Accepted Answer Pending Moderation
0
Votes
Undo

Thanks Rene for the response ,

Does anybody have a solution for SQL Anywhere Database?

regards

kumar 

Comment
Check out the sa_rowgenerator() SP.
  1. Arthur Hefti
  2. Monday, 8 October 2018
There are no comments made yet.
  1. Monday, 8 October 2018
  2. PowerBuilder
  3. # 1
René Ullrich Accepted Answer Pending Moderation
0
Votes
Undo

If you want to print 50 labels you need 50 rows. If all labels should contain the same value you have to insert the same value for all columns.

You could copy the retrieved rows to get the number of rows you want.

Or your find a way to get the number of duplicate rows from your database.

Here an example that should work with oracle:

SELECT ...FROM yourtable,     (SELECT 1 FROM DUAL CONNECT BY LEVEL <= :number_of_rows)WHERE barcode_id = :id
Comment
There are no comments made yet.
  1. Monday, 8 October 2018
  2. PowerBuilder
  3. # 2
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.