From: Andrus <eetasoft@online.ee>
To: pgsql-odbc@postgresql.org
Subject: Re: Data showing up as #Deleted in Access
Date: Fri, 2 Dec 2005 13:24:10 +0200
Message-ID: <dmpast$1nnt$1@news.hub.org> (raw)
References: <438F31C3.4020205@us.michelin.com>
<20051201184050.C803A9DD43B@postgresql.org>
<20051201195932.GA16735@soptik.pzkagis.cz>
<dmp74e$11ub$1@news.hub.org>
<20051202103824.GA21226@soptik.pzkagis.cz>
Ludek,
> Hmmm. I get idea right now. I'll try it againist MySQL. It's ODBC is
> open source so I can learn from it ...
> Please could you change your example to support MySQL ODBC?
> Maybe (or maybe not) it helps.
If you change the connection string in testsql.prg and remove WITHOUT OIDS
clauses in CREATE TABLE commands I think this sample must work with other
odbc drivers also.
Also, I do'nt know will mysql support CREATE temp TABLE clause. If it does
not temp can be removed also. So the TEXT command in testsql.prg may be
TEXT TO csql TEXTMERGE noshow
CREATE TABLE klient (
kood char(12),
nimi char(70),
info text);
CREATE UNIQUE INDEX klient_nimi_unique_idx ON klient(nimi);
CREATE temp TABLE dok( doktyyp char(1) );
insert into klient (kood,nimi) values ('AKU', 'Akuexpert O');
endtext
also the line in former testsql.prg
insert into testk (kood,nimi,info) values ('AKU', 'Akuexpert OÜ','')
should me changed to
insert into testk (kood,nimi,info) values ('AKU', 'Akuexpert O','')
to avoid possible issues with Ü character. After making changes main.exe
compiles and runs testsql.prg automatically.
I do'nt have mysql server access. Please re-confirm if you need that I must
verify this code in mysql. In this
case I must install mysql in my development computer. Or maybe there is some
mysql test server accessible over internet?
> So please be patient I'm doing everything I can
Thank you. I have one unchecked thought. If null instead of empty string is
passed as value to text type column, maybe the error does not occur.
Andrus.
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: eetasoft@online.ee, pgsql-odbc@postgresql.org
Subject: Re: Data showing up as #Deleted in Access
In-Reply-To: <dmpast$1nnt$1@news.hub.org>
* 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