Skip site navigation (1) Skip section navigation (2)

Re: [ODBC] what gives: SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE

From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
To: "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ODBC] what gives: SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE
Date: 2008-06-11 19:07:31
Message-ID: 396486430806111207t399e3ec3y34ea86aa5c5d7889@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-odbc
On Wed, Jun 11, 2008 at 11:17 AM, Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> wrote:
>>         Tagables.Parameters(0) = oldtags("devicetype")
>>         Set tagableRS = Tagables.Execute
>>         tagableid = tagableRS("tagableid").Value
>
> Please add
>          tagableRS.Close()

Your advice worked perfectly. Thank you very much!




-- 
Regards,
Richard Broersma Jr.

Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

In response to

pgsql-odbc by date

Next:From: Richard BroersmaDate: 2008-06-11 19:36:17
Subject: Re: ODBC escape convert error
Previous:From: Hiroshi InoueDate: 2008-06-11 18:49:21
Subject: Re: ODBC escape convert error

pgsql-admin by date

Next:From: Dombi AttilaDate: 2008-06-11 22:55:12
Subject: Data Type Conversion, get simple data types
Previous:From: Steve CrawfordDate: 2008-06-11 16:11:21
Subject: Re: Disk Space issue

pgsql-general by date

Next:From: Tom LaneDate: 2008-06-11 20:20:17
Subject: Re: Missing chunk number on a view?
Previous:From: Keaton AdamsDate: 2008-06-11 18:39:53
Subject: Missing chunk number on a view?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group