I create a temp view (uses two tables with common columns) that is used as the driving table in a report. In the past, I never had this error show up. These are var created within the report.
[A screenshot of a computer Description automatically generated] I use a var that bring up a DATE and that var shows as correct. Here is the varible. SELECT transdateoh INTO vtransdate ivtd FROM orderrows WHERE COUNT = LAST I can enter into the view and there are plenty of rows.James Belisle I looked up the explanation on one of the variables. I do not understand the explanation. "If you want to use a wildcard character as a text character in the LIKE string, specify the ESCAPE character in place of CHR in the syntax. In the string, use the ESCAPE character in front of the wildcard; R:BASE ignores the ESCAPE character and treats the wildcard as a text character. An ESCAPE character can only be followed by a wildcard or another ESCAPE character." Any guidance would be appreciated. Jim -- 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/LV3PR02MB995918875B2F9C211C700B2AA0672%40LV3PR02MB9959.namprd02.prod.outlook.com.
