quote:

No pages were found containing "with".

Hallway

 

Prod: 8202M1

Test: 8202M4

Repository:

 

OS:

 

Outputs:

 

 

 

 

quote:

When you create a DEFINE or COMPUTE that doesn't reference any real fields you associate it with a field using WITH.

 
-SET &ECHO=ALL;

SET BYDISPLAY = ON 

DEFINE FILE CAR
RANDOMFIELD/I11 = 1
END

TABLE FILE car
SUM SALES
RANDOMFIELD
COMPUTE RANDOMFIELDTOO/I11 = LAST RANDOMFIELDTOO + 1;
BY COUNTRY
BY RANDOMFIELD
BY CAR 
BY MODEL
ON TABLE RECOMPUTE
END
 

Hallway

 

Prod: 8202M1

Test: 8202M4

Repository:

 

OS:

 

Outputs:

 

 

 

 

quote:

Oh, we found it. It's just that someone that's inexperienced, and doesn't know the keyword WITH is used in context with virtual field creation, shouldn't have to know to search for "Using Virtual Fields" to find what they need. They should be able to type "WITH" and get to where they need to.

Hallway

 

Prod: 8202M1

Test: 8202M4

Repository:

 

OS:

 

Outputs:

 

 

 

 

 
DEFINE FILE CAR
CNTR1/D2 WITH COUNTRY = CNTR1+1;
CNTR2/D2 = CNTR2+1;
END
TABLE FILE CAR
PRINT
CNTR1
CNTR2
MODEL
CAR
BY COUNTRY
END
 

 DEFINE FILE CAR
CNTR1/D2 WITH COUNTRY = CNTR1+1;
CNTR2/D2 = CNTR2+1;
END
TABLE FILE CAR
PRINT
CNTR1
CNTR2

END  

quote:

Originally posted by Addy:
When you use WITH option the value changes when the field value associated to it changes:
In the below example CNTR1 and CNTR2 has the same expression but behaves very different.
Also if you want to create just the virtual fields without using any actual table column you can use WITH

Hallway

 

Prod: 8202M1

Test: 8202M4

Repository:

 

OS:

 

Outputs:

 

 

 

 

DEFINE FILE CAR
CNTR1/D2 WITH COUNTRY = CNTR1+1;
CNTR2/D2 = CNTR2+1;
END
TABLE FILE CAR
PRINT
-*CNTR1
CNTR2
MODEL
CAR
BY CNTR1 BY COUNTRY
END
 
-*Duplicate DEFINE isn't needed.
-*DEFINE FILE CAR
-*CNTR1/D2 WITH COUNTRY = CNTR1+1;
-*CNTR2/D2 = CNTR2+1;
-*END
TABLE FILE CAR
PRINT
CNTR1
CNTR2
END