Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

How to count elements inside DB

Created by: adrian_botez at: 10/21/2015 4:29 PM (10 Replies)

Rating (1)

Thanks 1

Result pages:: |; 1 | 2; |

11 Entries

Entries per page: 10 | all

10/21/2015 4:29 PM	Rate (0)
adrian_botez Bronze Member Joined: 2/19/2013 Last visit: 9/26/2023 Posts: 184 Rating: (8)	Hello guys. I am trying to read some fragmented labels from a scanner an I need to know the last occupied possition inside the DB so I can join the last received data with the first one. How can this be done using AWL? Thanks.

Suggestion To thank Quote Answer

10/21/2015 5:55 PM	Rate (0)
IBN-Service Posts: 8946 Rating: (997)	Use a pointer that you refresh after any new entry.
IBN-Service Posts: 8946 Rating: (997)
Suggestion To thank Quote Answer

10/21/2015 9:47 PM	Rate (0)
adrian_botez Bronze Member Joined: 2/19/2013 Last visit: 9/26/2023 Posts: 184 Rating: (8)	I don´t think it will work. Imagine that my DB has 29 bytes, and I receive 24 from the scaner. I want to count the 24 bytes and to say...y have 24 bytes occupied and 5 free... I don´t know how this can be done.
	Last edited by: adrian_botez at: 10/21/2015 9:47:17 PM
Suggestion To thank Quote Answer

10/22/2015 10:26 AM	Rate (0)
adrian_botez Bronze Member Joined: 2/19/2013 Last visit: 9/26/2023 Posts: 184 Rating: (8)	Any help ? Any example about how to do it?
	Last edited by: adrian_botez at: 10/22/2015 10:27:04 AM
Suggestion To thank Quote Answer

10/22/2015 10:38 AM	Rate (0)
mopS04 Platinum Expert Joined: 3/5/2014 Last visit: 8/5/2022 Posts: 5521 Rating: (1035)	adrian_botez I don´t think it will work. Imagine that my DB has 29 bytes, and I receive 24 from the scaner. I want to count the 24 bytes and to say...y have 24 bytes occupied and 5 free... I don´t know how this can be done. hi, for this you have to reset the whole DB before writing to it, or better, If you receive the bytes from scanner, copy it to an other DB and then reset the receiving-DB. Then use a loop in STL or SCL for counting every byte that has a value >0 till one byte is "0" hope this helps, regards,
	FCK WAR! Be nice!
Suggestion To thank Quote Answer

10/22/2015 11:45 AM	Rate (0)
adrian_botez Bronze Member Joined: 2/19/2013 Last visit: 9/26/2023 Posts: 184 Rating: (8)	I´m not so good using pointers. can you put an example?

Suggestion To thank Quote Answer

10/22/2015 1:29 PM	Rate (0)
adrian_botez Bronze Member Joined: 2/19/2013 Last visit: 9/26/2023 Posts: 184 Rating: (8)	I will attach here an example. My data start from dbb22. I need to move it byte by byte until I find B#16#00. Attachment example.jpg (174 Downloads)

Suggestion To thank Quote Answer

10/22/2015 1:51 PM	Rate (1)
mopS04 Platinum Expert Joined: 3/5/2014 Last visit: 8/5/2022 Posts: 5521 Rating: (1035)	CALL "BLKMOV" SRCBLK :=P#DB800.DBX 22.0 BYTE 29 RET_VAL:=#retval DSTBLK :=P#DB801.DBX0.0 BYTE 29 L B#16#0 T #fillval CALL "FILL" BVAL :=#fillval RET_VAL:=#retval BLK :=P#DB800.DBX 22.0 BYTE 29 U E 0.0 //FP M 0.0 SPBN m3 AUF DB 801 L 0 T #val L 29 T #schleife next: L #schleife SLW 3 LAR1 L DBB [AR1,P#0.0] L 0 <>I SPBN m2 L #val L 1 +I T #val m2: L #schleife L 1 -I T #schleife L 0 >=I SPB next L #val T DB802.DBW 38 m3: BEA in DB802.dbw38 you will find the number of written bytes. regards,
	FCK WAR! Be nice!
Suggestion To thank Quote Answer

10/23/2015 12:19 PM	Rate (0)
adrian_botez Bronze Member Joined: 2/19/2013 Last visit: 9/26/2023 Posts: 184 Rating: (8)	Ok. It works. Thx you!

Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users Min_Moderator

10/28/2015 8:44 AM	Rate (0)
adrian_botez Bronze Member Joined: 2/19/2013 Last visit: 9/26/2023 Posts: 184 Rating: (8)	I will try to complicate things here. The function works fine, but what if I will like to count 20 positions in the DB, then jump 20 positions and then count 20 positions more?

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on