Sytze de Boer wrote: > Hi folk > > I have (IMHO) a neat search facility but a puzzling little problem. > Very basically, it comes up with a message SQL: statement too long > > It's ok if the sql string is around 700, but not at 900 > Does anyone know what the max is for myfields > > It goes like; select * from (malias) where at(mysearch,&myfields)>0 > > Sytze >
Hi Sytze! I can't recall the SYS() command, but I believe there's one that allows you to extend the SQL statement length. -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.