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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0011ECC99F6%40exchange11.

Reply via email to