Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
6
Reply
cycles to read lines in sql and c#
antonio sanchez
Sep 15 2016 6:17 PM
347
Reply
hello all
I have a search button where I have the following query
select A.BELNR_ID,A.BELPOS_ID,A.ItemCode,A.ItemName,A.MENGE,B.SalPackUn,B.PicturName from BEAS_FTPOS A
Inner Join OITM B on A.ItemCode = B.ItemCode
where A.BELNR_ID = '@ORDENDEPRODUCCION'
which requires loading a label with information from my office.
but sometimes my production order me back several lines of data
BELNR_ID
BELPOS_ID
ItemCode
ItemName
MENGE
10290
10
809133SA3B-A
LH POCKET BACK COVER FR PG05
100
10290
20
809123SA3B-A
RH POCKET BACK COVER FR PG05
100
10290
30
829123SA3B-A
RH POCKET BACK COVER RR PG05
100
10290
40
829133SA3B-A
LH POCKET BACK COVER RR PG05
100
I have 4 rows of labels, my question is how I can do or take to cycle when pressing seek me send this information to the labels that I have separately
EXAMPLE:
label 1
809133SA3B-A
LH POCKET BACK COVER FR PG05
100
label 2
809123SA3B-A
RH POCKET BACK COVER FR PG05
100
label 3
829123SA3B-A
RH POCKET BACK COVER RR PG05
100
label 4
829133SA3B-A
LH POCKET BACK COVER RR PG05
100
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
6
)
Next Recommended Forum
Null Model (urgent)
How to return serilaizer json string?