Re: Problem with VB-DirectODBC selecting

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