Does ...
(COUNT(dlrname)) IN dealer WHERE activelines CONTAINS .vactivelines AND
dlrnum > 'cf000' +
AND ((activelines CONTAINS .vactivelines AND &activetype < .vmonend) +
OR (activelines1 = 'n' AND &canceltype > .vmonstart +
AND &activetype < .vmonstart))
work at the R> ?
From: Dan Goldberg <[email protected]>
To: "[email protected]" <[email protected]>
Date: Tue, 17 Dec 2019 18:34:29 +0000
Subject: [RBASE-L] - using & in set var or select into statement
I am trying to use variable values for column names in set var and select
statement and it gives me the error
-ERROR- An expression cannot begin with binary operator (2150)
If I replace the & variables with the column names it works.
Here is my set var command.
SET VAR vnumdlrs = (COUNT(dlrname)) IN dealer +
WHERE activelines CONTAINS .vactivelines AND dlrnum > 'cf000' +
AND ((activelines CONTAINS .vactivelines AND &activetype < .vmonend) +
OR (activelines1 = 'n' AND &canceltype > .vmonstart +
AND &activetype < .vmonstart))
Any blues clues on how I can do this?
Dan Goldberg
--
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/2E4830CEC16615458329D3D83342F8D0011ECC99F6%40exchange11.
--
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/WC20191217190038.710089%40jjcalibrations.com.
