1. EuSQL Dash Bug
- Posted by cklester <cklester at yahoo.com> Oct 13, 2005
- 445 views
Matt, remember that problem I was having with EuSQL adding spaces around commas? It is doing that to dashes, also. Helllp! :) -=ck "Programming in a state of EUPHORIA." http://www.cklester.com/euphoria/
2. Re: EuSQL Dash Bug
- Posted by Matt Lewis <matthewwalkerlewis at gmail.com> Oct 17, 2005
- 452 views
cklester wrote: > > Matt, remember that problem I was having with EuSQL adding spaces around > commas? It is doing that to dashes, also. Helllp! :) In preprocess_sql(), replace the first while loop with this:
-- ensure proper spacing of equality operators for tokenization ix = 1 in_quote = 0 while ix <= length( sql ) do if sql[ix] = '\'' then in_quote = not in_quote elsif not in_quote and find(sql[ix], ";><=()+-*/" ) then if ix < length(sql) and find(sql[ix+1],"<>=;") then ix += 1 else sql = sql[1..ix-1] & 32 & sql[ix] & 32 & sql[ix+1..$] end if ix += 1 end if ix += 1 end while
Matt Lewis