Hi,

I have looked at the Function documentation and I saw that I can convert from alphanumeric to numeric with EDIT command.

Here is my Code:

  

-SET &&SDTIN/I8 = EDIT(&DATAINIZ,'$$$$$$99999999');

 

where &DATAINIZ is 0000082007102.

The exception is:
(FOC318) A FIELD FORMAT IS NOT ALLOWED IN -SET: &&SDTIN/I8 = ED

Why the conversion does not works?

Note the disparate legths between 0000082007102 and $$$$$$99999999.

You might be trying to convert a blank to an integer.

Sorry the &DATAINIZ value is 00000082007102

quote:

FOC318) A FIELD FORMAT IS NOT ALLOWED IN -SET: &&SDTIN/I8 = ED

I think the error message is telling you, you can't use EDIT with -SET.

I'm sure the dialog manager experts, of which I am not, will have examples for you.

Good catch Leah.

One can not specify a format with a -SET in DM.

Regards

Change

SET &&SDTIN/I8 = EDIT(&DATAINIZ,'$$$$$$99999999');

to

SET &&SDTIN = EDIT(&DATAINIZ,'$$$$$$99999999'); 

Remember that EDIT has 2 abilities. One is to do simple substring and the other is to convert an alpha string to integer. The latter makes no sense in DM as variables are numbers by default.

You can use EDIT in DM to do substringing as L_G is actually trying to do. Do what Glenda has suggested by removing the format only put a dash (-) in front of the SET.

If you just wanted the alpha equivalent without the leading zeroes (I know you are cutting off the '8' as well) then you could use PTOA -

-SET &SDTIN = PTOA(0000082007102, '(P13)', 'A13');
-TYPE &SDTIN

T

Jimster has the answer (and Glenda the solution.) Here's the explanation: &vars referenced in the -SET statements don't really know that they are alpha or numeric. I know there are lots of different syntax used to make it appear that way (like the .A8.) and i'm sure there are exceptions (like dates) but for the most part, you can use them interchangeably in numeric or string functions AS LONG AS THE VALUE MATCHES THE FUNCTION'S SYNTAX.

If you tell WF to use an &var as a string (like in your example with an EDIT mask) it will. If you tell it to add one (-SET &SDTIN=&SDTIN + 1; ) it will (if the value contains no alpha characters.) No need to specify the format, and as you saw, it throws an error if you try that.

For example, if &VAR1 is equal to 12345, in a WHERE (or DEFINE or -SET) you could use
WHERE FIELDNAME EQ &VAR1 or
WHERE FIELDNAME EQ '&VAR1'
but if the value were 'Some Value' you would get an error with the first example.

Long answer to a short question, but I hope that helps.