Re: Problem with VB-DirectODBC selecting

On 12.03.2002 03:58:00 pgsql-odbc-owner wrote:
>Wolfgang.Fuertbauer@ebewe.com wrote:
>>
>> On 09.03.2002 10:00:42 "Hiroshi Inoue" wrote:
>> >> -----Original Message-----
>> >> From: Wolfgang.Fuertbauer@ebewe.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@postgresql.org so that your
>message can get through to the mailing list cleanly