That's it! Thanks Karen!
I pasted 14 rows from the ss and INSERTED 14 rows into the temp table.
Apparently the Tabs & CRLFs are hidden? Whatever...
It works - needed a quick fix and that did it.
On 7/15/2021 2:12 PM, 'Karen Tellef' via RBASE-L wrote:
SET VAR vTab = (CHAR(009))
SET VAR vPartList = (SRPL(.vPartList, .vTab, ",", 0))
SET VAR vCRLF = (CHAR(013) + CHAR(010))
SET VAR vPartList = (SRPL(.vPartList, .vCRLF, ",", 0))
Parse and INSERT:
SET VAR vItemCount INTEGER = (ITEMCNT(.vItemCodes))
SET VAR vCurrentPos INTEGER = 1
WHILE vCurrentPos < vItemCount THEN
SET VAR vItemCode = (SSUB(.vItemCodes,.vCurrentPos))
INSERT INTO tVORReport (Item) VALUES (.vItemCode)
SET VAR vCurrentPos = (vCurrentPos + 1)
ENDWHILE
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/3979b234-b92a-973b-beb7-e3d27a1bcf0e%40wi.rr.com.
