(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › @XUS Syntax error with brackets
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic @XUS Syntax error with brackets (Read 564 times)
Peter
Member
*
Offline


No personal text

Posts: 22
Joined: Jan 7th, 2004
@XUS Syntax error with brackets
Mar 26th, 2006 at 12:13pm
Print Post Print Post  
Hi

I'm just revisiting a database for stocktaking that I haven't used for a while. It seems that the change to 1.13 is causing a syntax error. I'm using the @XUS function to create a picklist. Some of the items in the picklist have brackets () in them, and I'm not able to search on those items - am getting a Syntax Error. Is there an easy way around this please?

Thanks in advance

Peter
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: @XUS Syntax error with brackets
Reply #1 - Mar 26th, 2006 at 3:15pm
Print Post Print Post  
Quote:
Hi

I'm just revisiting a database for stocktaking that I haven't used for a while. It seems that the change to 1.13 is causing a syntax error. I'm using the @XUS function to create a picklist. Some of the items in the picklist have brackets () in them, and I'm not able to search on those items - am getting a Syntax Error. Is there an easy way around this please?

Thanks in advance

Peter


Parenthesis are significant in a Sesame search, they have meaning. To find a parenthesis that is in the results put a backslash in front of the parenthesis. In other words, if a LE has "(Paris)" in it, you can search for that with "\(P.."

This is generally true of the characters that have significance to a Sesame search.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
Peter
Member
*
Offline


No personal text

Posts: 22
Joined: Jan 7th, 2004
Re: @XUS Syntax error with brackets
Reply #2 - Mar 27th, 2006 at 9:29am
Print Post Print Post  
Thanks for such a quick response - much appreciated

Peter
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge