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

ODBC interface problem W/ Applix Data (was Re: AWL: Another Data Editing Problem [was Re: Editing problem in Data])

From: "Cary B(dot) O'Brien" <cobrien(at)access(dot)digex(dot)net>
To: applixware-list(at)applix(dot)com
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: ODBC interface problem W/ Applix Data (was Re: AWL: Another Data Editing Problem [was Re: Editing problem in Data])
Date: 1998-11-11 17:21:09
Message-ID: 199811111721.MAA19784@access2.digex.net (view raw or flat)
Thread:
Lists: pgsql-interfaces
> "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
> 

pgsql-interfaces by date

Next:From: Ken J. WrightDate: 1998-11-11 18:09:42
Subject: money format
Previous:From: Gene Selkov Jr.Date: 1998-11-11 16:56:16
Subject: Re: [INTERFACES] need information about storing methods

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