From: | "Amanjit Gill" <amanjit(dot)gill(at)gmx(dot)de> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: ODBC + Dynamic cursors |
Date: | 2003-07-31 06:55:02 |
Message-ID: | 000c01c35730$aadd9180$0400a8c0@charite.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Dear Mr. Inoue,
- Keyset driven cursors did the trick
- Thank you for pointing out to set the attribute at the statement level
- SQLSetPos() functionality basically does what I want to.
Regards,
Amanjit Gill
Software Developer
Medical and Bioinformatics
UFK (Gynecology and Obstetrics)
University Clinic Charite
Berlin
-----Ursprüngliche Nachricht-----
Von: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] Im Auftrag von Hiroshi Inoue
Gesendet: Donnerstag, 31. Juli 2003 02:01
An: Amanjit Gill
Cc: pgsql-odbc(at)postgresql(dot)org
Betreff: Re: [ODBC] ODBC + Dynamic cursors
Amanjit Gill wrote:
>
> Hi, I have written a C++ ODBC wrapper that right now runs on
> Oracle,Access,SQL Server, Sybase. I am right now investigating
> PostgreSQL which we want to use instead of SQL Server.
>
> PostgreSQL Version: 7.33 (Cygwin/Windows XP) using ipc-daemon
> ODBC Version: 7.03.01.10
> OS: Windows XP Pro, SP1
>
> Synopsis:
> I basically open a connection to a db, create a statement,use a
> dynamic cursor via SQLSetConnectAttr (SQL_ATTR_CURSOR_TYPE,
> SQL_CURSOR_DYNAMIC),
Please set the SQL_ATTR_CURSOR_TYPE attribute for statement handles not
for connection handles. Also note that psqlodbc driver doesn't support
dynamic cursors. Please use keyset-driven or static cursors instead.
[snip]
> Another question: are positionable updates and deletes (which means
> SQLSetPos) possible with
> PostgreSQL at present (as mentioned in
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/
> ht
> m/odch12pr_2.asp) ?
No. What the driver supports is to update/delete/insert/.. a row
(rows) in a rowset using SQLSetPos(.., .., SQL_UPDATE/DELETE/ADD, ..
Positioned update/delete means updat/deleting a row in a rowset by
executing a query such as UPDATE/DELETE ... WHERE CURRENT OF .... Please
note that the examples in the page you specified are updat/deleting a
row using SQLExecute.
regards,
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.504 / Virus Database: 302 - Release Date: 24.07.2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.504 / Virus Database: 302 - Release Date: 24.07.2003
From | Date | Subject | |
---|---|---|---|
Next Message | muller.rgdsrh | 2003-07-31 07:19:19 | Install Problem with odbc-driver |
Previous Message | Hiroshi Inoue | 2003-07-31 00:00:45 | Re: ODBC + Dynamic cursors |