X-Original-To: pgsql-odbc-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9A8A99DCAB2 for ; Fri, 2 Dec 2005 07:24:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51548-04 for ; Fri, 2 Dec 2005 07:24:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 43D2A9DCAAE for ; Fri, 2 Dec 2005 07:24:19 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 8157733691; Fri, 2 Dec 2005 12:24:21 +0100 (MET) From: "Andrus" X-Newsgroups: pgsql.interfaces.odbc Subject: Re: Data showing up as #Deleted in Access Date: Fri, 2 Dec 2005 13:24:10 +0200 Organization: Hub.Org Networking Services Lines: 47 Message-ID: References: <438F31C3.4020205@us.michelin.com> <20051201184050.C803A9DD43B@postgresql.org> <20051201195932.GA16735@soptik.pzkagis.cz> <20051202103824.GA21226@soptik.pzkagis.cz> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-RFC2646: Format=Flowed; Original To: pgsql-odbc@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/16 X-Sequence-Number: 6495 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.