1. GH kumar
  2. PowerBuilder
  3. Monday, 8 October 2018 04:49 AM UTC

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

René Ullrich Accepted Answer Pending Moderation
  1. Monday, 8 October 2018 05:58 AM UTC
  2. PowerBuilder
  3. # 1

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.
GH kumar Accepted Answer Pending Moderation
  1. Monday, 8 October 2018 08:54 AM UTC
  2. PowerBuilder
  3. # 2

Thanks Rene for the response ,

Does anybody have a solution for SQL Anywhere Database?

regards

kumar 

Comment
  1. Arthur Hefti
  2. Monday, 8 October 2018 10:42 AM UTC
Check out the sa_rowgenerator() SP.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


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