From: "Cary B. O'Brien" <cobrien@access.digex.net>
Message-Id: <199811111721.MAA19784@access2.digex.net>
Subject: ODBC interface problem W/ Applix Data (was Re: AWL: Another Data
	Editing Problem [was Re: Editing problem in Data])
To: applixware-list@applix.com
Date: Wed, 11 Nov 1998 12:21:09 -0500 (EST)
Cc: pgsql-interfaces@postgresql.org
In-Reply-To: <3649B84D.586F452D@recco.de> from Wolfgang Ocker at "Nov 11,
	98 05:16:13 pm"
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

> "Cary B. O'Brien" wrote:
> > >[ Editing problem in Data ]
> 
> > This is how editing works for me
> > 
> >         Select Database
> >         Select Table
> >         Do query
> >         Click on Padlock (Or edit -> enable editing)
> >                 (Insert, commit, and red zero w/ cross become active)
> > [...]
> 
> Same here. But if I make a value empty (with backspace) and move on to another
> row, a dialog is displayed indicating: 
> 
> 	S1000: [TCX][MyODBC]parse error near 'where Nr = 20' at line 1
> 
> The MySQL database server logs this request:
> 
> 	update customers set City = where Nr = 20 ;
> 
> I would expect:
> 
> 	update table set City = '' where Nr = 20 ;
> 
> [ But I'm no SQL nor database expert ]
> 
> Any ideas? [ RedHat 4.2, MySQL 3.21.32a, Applixware 4.4.1 ] Is it an
> Applixware or an MySQL problem?
> 

Hmm... I see the same thing using Data and PostgreSQL.  I'm not sure which
side of the interface the problem is on.  I'll forward this to the
pgsql-interfaces list.

-- cary


> Thanks,
> Wolfgang
>