Skip site navigation (1) Skip section navigation (2)

Re: Broken sql string?

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Mark A(dot) Taff'" <mark(at)libertycreek(dot)net>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Broken sql string?
Date: 2002-02-19 20:01:32
Message-ID: FED2B709E3270E4B903EB0175A49BCB10475B5@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers
 
-----Original Message-----
From: Mark A. Taff [mailto:mark(at)libertycreek(dot)net] 
Sent: 19 February 2002 17:01
To: Dave Page
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: [pgadmin-hackers] Broken sql string?


My apologies for not sending this to the list originally.  Allow me to
elaborate.  I am working on a `View Designer` similar to the interface that
SQL Server uses to create new views.  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).
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.
 
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. 

 I've just committed a fix for this.
 
Regards, Dave.

pgadmin-hackers by date

Next:From: Dave PageDate: 2002-02-19 20:04:22
Subject: Re: [GENERAL] MDB 2 POSTGRESQL MIGRATION PROBLE
Previous:From: Jean-Michel POUREDate: 2002-02-19 19:53:28
Subject: Pseudo modification of views and triggers (again)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group