From: | Scot Loach <sloach(at)SANDVINE(dot)com> |
---|---|
To: | 'Hiroshi Inoue' <Inoue(at)tpf(dot)co(dot)jp> |
Cc: | "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: 64-bit type in SQLBindParameter |
Date: | 2002-10-25 01:38:40 |
Message-ID: | FE045D4D9F7AED4CBFF1B3B813C85337E5F30F@mail.sandvine.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Thanks for your reply.
Does this mean that I need to convert the integer into a character buffer
(using sprintf() for example) and use the character buffer in the
SQLBindParameter statement?
That doesn't seem to work when I try it, I get the same result.
scot.
-----Original Message-----
From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
Sent: Thursday, October 24, 2002 7:42 PM
To: Scot Loach
Cc: 'pgsql-odbc(at)postgresql(dot)org'
Subject: Re: [ODBC] 64-bit type in SQLBindParameter
Scot Loach wrote:
>
> Is it possible to use 64-bit types for bound queries?
>
> Here's my setup:
> FreeBSD 4.7
> UnixODBC 2.2.0
> PostgreSQL 7.2.1
> PostgreSQL/UnixODBC driver 7.2.1
>
> I'm using the BIGINT type for my column.
> The program below prints out the error message:
>
> [unixODBC]Error while executing the query;
> ERROR: parser: parse error at or near ")"
>
> It works if I change the SQL_BIGINT to SQL_INTEGER, but
> it only uses 32 bits of the number in that case.
>
> #include <stdio.h>
> #include <sql.h>
> #include <sqlext.h>
>
> main()
> {
> SQLHENV env;
> SQLHDBC dbc;
> SQLINTEGER val = 0;
> unsigned long long ll = 6000000000;
>
> SQLAllocEnv(&env);
> SQLAllocConnect(env, &dbc);
> SQLConnect(dbc, (SQLCHAR*)"my_db", SQL_NTS, (SQLCHAR*)0, 0, (SQLCHAR*)
0,
> 0);
> SQLCHAR sql[] = "INSERT INTO my_table (my_column) VALUES (?)";
>
> HSTMT hstmt;
> SQLAllocStmt(dbc, &hstmt);
> SQLPrepare(hstmt, sql, SQL_NTS);
> SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_DEFAULT, SQL_BIGINT,
> 0, 0, &ll, 0, &val);
SQL_C_DEFAULT for SQL_BIGINT is SQL_C_CHAR.
You can't specify SQL_C_SBIGINT(UBIGINT) for the C Data Type
under the driver.
regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/
From | Date | Subject | |
---|---|---|---|
Next Message | andres javier garcia garcia | 2002-10-25 13:36:31 | Fwd: connection fails |
Previous Message | Hiroshi Inoue | 2002-10-24 23:42:11 | Re: 64-bit type in SQLBindParameter |