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

Re: comparing rows

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: Magnus Hagander <mha(at)sollentuna(dot)net>
Cc: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, The Hermit Hacker <scrappy(at)hub(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: comparing rows
Date: 2000-08-04 09:15:11
Message-ID: 398A899F.939515AC@mascari.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Magnus Hagander wrote:
> 
> Can somebody enlighten me as to *when* Access creates a query that has
> "=null" in it?
> 
> I just tried to reproduce it, and I failed.
> 

The problem appears (just from a quick look at the mail archive)
to manifest itself when Access generates queries to handle Forms
processing. Below is a sample issue that people had when using
Access 97 w/PostgreSQL:

------------------------------------------------------
From: mmw(at)paradise(dot)net(dot)nz 
To: pgsql-interfaces(at)postgresql(dot)org 
Subject: Access ODBC worries 
Date: Thu, 12 Aug 1999 16:44:41 +1200 (NZST) 

Hi All

I have been battling with a problem now for days. I have a linked
form in Access 97 to linked tables to a PGSQL backend via ODBC.
The code works well, but after the form has been on the screen
for about 20 minutes idling or doing something (makes no
difference) then all hell breaks loose.  The computer tries to
requery the form data from the backend in a very strange way. 
The odbc log file output at the bottom of this message explains
the problem in greater detail.

...

<ODBC log follows>

...

------------------------------------------------------------
hdbc=91652364, stmt=91555964, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=92605260, parameters_allocated=1
statement_type=0, statement='SELECT "Toplevel time
recordal"."oid" FROM "Toplevel time
recordal" WHERE ("File link" =  ? ) ORDER BY "Startdate"  DESC '
stmt_with_params='SELECT "Toplevel time recordal"."oid" FROM
"Toplevel time recordal"
WHERE ("File link" =  NULL ) ORDER BY "Startdate"  DESC '
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=1
cursor_name='SQL_CUR0575087C'
----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: 
parser: parse error
at or near "null"'

------------------------------------------------------

I'll attempt to provide an easily repeatable operation, but the
problem *does* exist in Access 97.

Mike Mascari

In response to

pgsql-hackers by date

Next:From: The Hermit HackerDate: 2000-08-04 14:43:17
Subject: Re: comparing rows
Previous:From: Magnus HaganderDate: 2000-08-04 08:12:57
Subject: RE: comparing rows

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