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 ?
>
>regards,
>Hiroshi Inoue

That works;
the query:
select groessen, znr
from weg
where bsnr= 14597 and znr = 1 and wegkz = '1'

where groessen is fieldtype text and znr is fieldtype interger
causes no error.

best regards
wolfgang

>
>> >> 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