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

Text as LongVarChar ?

From: Cedar Cox <cedarc(at)visionforisrael(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Text as LongVarChar ?
Date: 2001-08-16 11:06:23
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Ok, I've finally had my run in with 'Text as LongVarChar'.  Actually, I
did months ago and wrote it off as strange Access behavior.  What happens
is I open a recordset (ODBCDirect w/ dbExecDirect option) and the text
fields from the query are only good for one read.  This one read include
everything, such as watches and those little popups in the code view.  
For example, the control that is normally populated from this recordset
will come up empty if you have a watch on 'rst!textfield', because the
watch reads the recordset first.  This only happens with the text fields.  
The other numeric fields from the same rst work fine.  Now, surprise, I
unchecked 'Text as LongVarChar' and these text fields behave just like the
others.  The strange thing is that if you open the recordset with the
dbOpenSnapshot option, it works, regardless of 'Text as LongVarChar'. Can
someone explain this?  Is it actually Access strangeness?

(After writing this I looked and found that I have driver version


pgsql-odbc by date

Next:From: Dave PageDate: 2001-08-17 07:17:49
Subject: RE: ODBC merge module for Microsoft Installer
Previous:From: Arnaud ESPANELDate: 2001-08-16 09:48:05
Subject: Re: Postgresql 7.1.2 and StarOffice 5.2

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