The following is true in UniVerse. I don't know whether UniData works the same, but it would be worth investigating.
If the dictionary entry for SCANNED has MCU as the conversion specification (field 3 in a UV 'D' or 'I' type), then you could do SELECT ITEM.FILE WITH SCANNED EQ <<R,Scan Barcode>> and the query engine will run the literal through the conversion code before comparing it. If the dictionary entry does not have the MCU conversion code and you can't add it without breaking something else, you could specify it in the SELECT statement: SELECT ITEM.FILE WITH SCANNED CONV 'MCU' EQ <<R,Scan Barcode>> However, it appears that using the R-type inline prompt will not work (at least, at UV 9.4) with the CONV phrase - only the first item entered is run through the conversion. To get around it you could create a synonym of SCANNED with the MCU conversion in the dictionary and use it in the SELECT statement instead of SCANNED. Mark -----Original Message----- From: Martin Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, June 17, 2005 1:53 PM To: [email protected] Subject: Re: [U2] [UD] In-Line Prompting - UniData 5.1.7 > I am trying to utilize In-Line Prompting with conversion code MCU using the > following syntax, without much luck. > > 001: PA > 002: SELECT ITEM.FILE WITH SCANNED EQ <<R,Scan Barcode,(MCU)>> > 003: LIST ITEM.FILE SCANNED REQUIRE.SELECT <<...snip...> The conversion code element of an inline prompt checks that the conversion can be applied to the data. It does not return the converted data. Therefore, this probably isn't going to do what you want. Try... 001: PA 002: SELECT ITEM.FILE WITH SCANNED EQ EVAL "UPCASE(<<R,Scan Barcode>>)" 003: LIST ITEM.FILE SCANNED REQUIRE.SELECT or something similar. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
