Re: Problem with VB-DirectODBC selecting

From: Wolfgang(dot)Fuertbauer(at)ebewe(dot)com
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>, pgsql-odbc-owner(at)postgresql(dot)org, w(dot)fuertbauer(at)eunet(dot)at
Subject: Re: Problem with VB-DirectODBC selecting
Date: 2002-03-12 15:19:06
Message-ID: OF2AEE5F55.5971392C-ONC1256B7A.005400D0@ebewe.co.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


On 12.03.2002 03:58:00 pgsql-odbc-owner wrote:
>Wolfgang(dot)Fuertbauer(at)ebewe(dot)com wrote:
>>
>> On 09.03.2002 10:00:42 "Hiroshi Inoue" wrote:
>> >> -----Original Message-----
>> >> From: Wolfgang(dot)Fuertbauer(at)ebewe(dot)com
>> >>
>> >> Hi,
>> >>
>> >> i have a problem with the following SQL-Statement:
>> >>
>> >> Select Groessen from Weg where Bsnr = 14957 and Znr = 1 and wegkz =
1;
>> >>
>> >> when executing it via direct-odbc in VB it gives me the error-nr:
3146
>> >>
>> >> the VB-Code:
>> >> ------------
>> >> Set myConn = myWs.OpenConnection("", _
>> >> dbDriverNoPrompt, _
>> >> False,_
>> >> "ODBC;dsn=PostgreSQL;uid=postgres;pwd=;")
>> >> sql = "Select Groessen from Weg where Bsnr = 14957 and Znr = 1 and
wegkz
>> =
>> >> 1"
>
>Could you add other dummy columns(not text) to the select list ?

OK, I'll try that;

did you ever see an error-message:
O1SO3: [Microsoft][ODBC Cursor Library] No Records updated or deleted -
3146

Best regards
Wolfgang

>
>regards,
>Hiroshi Inoue
>
>> >> Set rs = myConn.OpenRecordset(Sql, _
>> >> dbOpenSnapshot, _
>> >> dbExecDirect, _
>> >> dbOptimistic)
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly

Browse pgsql-odbc by date

  From Date Subject
Next Message Booth, Robert 2002-03-12 23:58:03 Automating Setup
Previous Message Hiroshi Inoue 2002-03-12 02:58:00 Re: Problem with VB-DirectODBC selecting