From: Cary B. O'Brien <cobrien@access.digex.net>
To: applixware-list@applix.com
Cc: pgsql-interfaces@postgresql.org
Subject: ODBC interface problem W/ Applix Data (was Re: AWL: Another Data Editing Problem [was Re: Editing problem in Data])
Date: Wed, 11 Nov 1998 12:21:09 -0500 (EST)
Message-ID: <199811111721.MAA19784@access2.digex.net> (raw)
In-Reply-To: <3649B84D.586F452D@recco.de>
> "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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: cobrien@access.digex.net, applixware-list@applix.com
Subject: Re: ODBC interface problem W/ Applix Data (was Re: AWL: Another Data Editing Problem [was Re: Editing problem in Data])
In-Reply-To: <199811111721.MAA19784@access2.digex.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox