Re: Broken sql string?

[Dave Page]

�
<BLOCKQUOTE dir=ltr 
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; 
MARGIN-RIGHT: 0px">
  
  <FONT 
  face=Tahoma size=2>-----Original Message-----From: Mark A. Taff 
  [mailto:[EMAIL PROTECTED]] Sent: 19 February 2002 
  17:01To: Dave PageCc: 
  [EMAIL PROTECTED]: Re: [pgadmin-hackers] Broken 
  sql string?
  
  <FONT face=Arial color=navy 
  size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">My 
  apologies for not sending this to the list originally. <SPAN 
  style="mso-spacerun: yes">�Allow me to elaborate.<SPAN 
  style="mso-spacerun: yes">� I am working on a `View Designer` 
  similar to the interface that SQL Server uses to create new views.<SPAN 
  style="mso-spacerun: yes">� There are a great many unknowns right 
  now, and I need to get it working enough to find out what works and what won't 
  (the relationship diagram for example, is a big mystery right now).<SPAN 
  style="mso-spacerun: yes">� So, to speed up this process, I am 
  only writing the code that I have to; if I can recycle code from an existing 
  section, I am.� So one piece of 
  code I grabbed was the Display sub from 
  frmSQLOutput.
  <FONT face=Arial color=navy 
  size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">�
  <SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">The 
  code in the sub that parses the query to find the FROM clause of the statement 
  the user entered in the HBX is looking for " FROM " (with leading and trailing 
  space). �So if there is a CRLF 
  immediately before the `F` instead of a space, the routine fails to find the 
  `FROM` clause, and hence fails to find anything else, like the table 
  involved.<SPAN 
  class=444325619-19022002>�
<SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><FONT 
color=#0000ff>�I've just committed a fix for 
this.
<SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><FONT 
color=#0000ff><SPAN 
class=444325619-19022002>�
<SPAN 
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><FONT 
color=#0000ff>Regards, 
Dave.