X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id A8A0DD9ED2;
	Tue,  4 Oct 2005 07:42:23 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 64486-04; Tue,  4 Oct 2005 10:42:18 +0000 (GMT)
Received: from ls405.htnet.hr (ls405.htnet.hr [195.29.150.97])
	by svr1.postgresql.org (Postfix) with ESMTP id 34EBAD9B47;
	Tue,  4 Oct 2005 07:42:16 -0300 (ADT)
Received: from ls422.t-com.hr (ls422.t-com.hr [195.29.150.237])
	by ls405.htnet.hr (0.0.0/8.12.10) with ESMTP id j94AgIWl021850;
	Tue, 4 Oct 2005 12:42:18 +0200
Received: from ls422.t-com.hr (localhost.localdomain [127.0.0.1])
	by ls422.t-com.hr (Qmlai) with ESMTP id 4EF1D988045;
	Tue,  4 Oct 2005 12:42:18 +0200 (CEST)
X-Envelope-Sender: zlatko.matic1@sb.t-com.hr
X-Envelope-Sender: zlatko.matic1@sb.t-com.hr
X-Envelope-Sender: zlatko.matic1@sb.t-com.hr
X-Envelope-Sender: zlatko.matic1@sb.t-com.hr
Received: from ls422.t-com.hr (localhost.localdomain [127.0.0.1])
	by ls422.t-com.hr (Qmlai) with ESMTP id 2DF97988042;
	Tue,  4 Oct 2005 12:42:18 +0200 (CEST)
Received: from zlatkovyfkpgz6 (ao9-m271.net.t-com.hr [195.29.41.31])
	by ls422.t-com.hr (Qmlai) with SMTP id AA42D8B804A;
	Tue,  4 Oct 2005 12:42:16 +0200 (CEST)
Message-ID: <000101c5c8d0$4a2fb340$1f291dc3@zlatkovyfkpgz6>
From: =?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@sb.t-com.hr>
To: <pgsql-odbc@postgresql.org>, <pg-interfaces@postgresql.org>,
	<pgsql-interfaces@postgresql.org>, <pgsql-general@postgresql.org>
Subject: Unbound text box, Text > 255 characters, MSAccess/PostgreSQL
Date: Mon, 3 Oct 2005 01:14:57 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0006_01C5C7B7.DEA512F0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.296 required=5 tests=[AWL=-0.093,
	DATE_IN_PAST_24_48=0.302, HTML_40_50=0.086, HTML_MESSAGE=0.001]
X-Spam-Level: 
X-Archive-Number: 200510/95
X-Sequence-Number: 84324

This is a multi-part message in MIME format.

------=_NextPart_000_0006_01C5C7B7.DEA512F0
Content-Type: text/plain;
	charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

Hello.
I have the following problem with MS Access/PostgreSQL combination:
There is a form in Access that has an unbound text box, used for =
entering a commentary of a batch of records.
There is a DAO Append Query that has a parameter that is passed from the =
text box using parameter of DAO QueryDef object.=20
I adjusted B7 parameter (Text as LongVarchar) in connection string (ODBC =
driver) to 1, so that Access links PostgreSQL Text fields as Memo fields =
in Access. The intention was to be able to enter unlimited length =
commentary into the field.
But, although I can enter unlimited text by using bound text box in some =
other forms, in this particular form I can't use bound control, so I =
need to pass text from  UNBOUND control to the linked table by using DAO =
or ADO code. It seems that DAO query can't accept Memo as parameter, but =
only text. If my text exceeds length of 255, I have an VBA error 3271. =
If text in unbound text box is shorter that 255 everything is OK.

So, is there any way to pass text of length >255 from unbound text box =
to Memo field of linked PostgreSQL table, by using DAO or ADO ?

Thanks in advance,

Zlatko
------=_NextPart_000_0006_01C5C7B7.DEA512F0
Content-Type: text/html;
	charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-2">
<META content=3D"MSHTML 6.00.2900.2722" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hello.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have the following problem with MS=20
Access/PostgreSQL combination:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>There is a form in Access that&nbsp;has =
an unbound=20
text box, used for entering a commentary of a batch of =
records.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>There is a DAO Append Query that has a =
parameter=20
that is passed from the text box using parameter of DAO QueryDef object. =

</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I adjusted B7 parameter (Text as =
LongVarchar) in=20
connection string (ODBC driver)&nbsp;to 1, so that Access links =
PostgreSQL Text=20
fields as Memo fields in Access. The intention was to be able to enter =
unlimited=20
length commentary into the field.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>But, although I can enter unlimited =
text by using=20
bound text box in some other forms, in this particular form I can't use =
bound=20
control, so I need to pass text&nbsp;from&nbsp; UNBOUND&nbsp;control to =
the=20
linked table&nbsp;by using DAO or ADO code. It seems that DAO query =
can't accept=20
Memo as parameter, but only text. If my text exceeds length of 255, I =
have an=20
VBA error 3271. If text in unbound text box is shorter that 255 =
everything is=20
OK.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>So, is there any way to pass text of =
length &gt;255=20
from unbound text box to Memo field&nbsp;of linked PostgreSQL table, by =
using=20
DAO or ADO ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Zlatko</FONT></DIV></BODY></HTML>

------=_NextPart_000_0006_01C5C7B7.DEA512F0--