This is a multi-part message in MIME format.
------_=_NextPart_001_01C8958D.6E07F2AE
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi,
I dont know much about databases, and I have a question
I've just installed PostgreSLQ.
Now I would like to get the number of rows selected via a ODBC SQL
statement in C++. I would like to know the amount before I do Fetch.
=20
This is a little example of what I do in c++:
selStr=3D"select * from layer where visible =3D 1");
rc =3D SQLAllocHandle(SQL_HANDLE_STMT, ConHandle, &StmtHandle);
if(rc =3D=3D SQL_SUCCESS)
{
SQLSetStmtOption(StmtHandle, SQL_CONCURRENCY,
SQL_CONCUR_READ_ONLY);
SQLSetStmtOption(StmtHandle, SQL_CURSOR_TYPE,
SQL_CURSOR_KEYSET_DRIVEN);
SQLSetStmtOption(StmtHandle, SQL_ROWSET_SIZE, m_rows);
rc =3D SQLExecDirect(StmtHandle, (SQLCHAR *)selStr,
SQL_NTS);
....
....
....
How do I know how many rows that was found??
Kind regards,
Paul Malm
------_=_NextPart_001_01C8958D.6E07F2AE
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7652.24">
<TITLE>get number of rows selected</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">Hi,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">I dont know much about databases, and =
I have a question</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">I've just installed PostgreSLQ.</FONT>
<BR><SPAN LANG=3D"sv"><FONT SIZE=3D2 FACE=3D"Arial">Now I would like to =
get the number of rows selected via a ODBC SQL statement in C++. I would =
like to know the amount before I do Fetch.</FONT></SPAN></P>
<P><SPAN LANG=3D"sv"><FONT SIZE=3D2 FACE=3D"Arial"> </FONT></SPAN>
<BR><SPAN LANG=3D"sv"><FONT SIZE=3D2 FACE=3D"Arial">This is a little =
example of what I do in c++:</FONT></SPAN>
</P>
<P><SPAN LANG=3D"en-us"> <FONT =
SIZE=3D2 FACE=3D"Courier New">selStr=3D"select * from layer where =
visible =3D 1");</FONT></SPAN>
<BR><SPAN LANG=3D"en-us"> =
<FONT SIZE=3D2 FACE=3D"Courier New">rc =3D =
SQLAllocHandle(SQL_HANDLE_STMT, ConHandle, =
&StmtHandle);</FONT></SPAN>
<BR><SPAN LANG=3D"en-us"> =
<FONT SIZE=3D2 FACE=3D"Courier New">if(rc =3D=3D =
SQL_SUCCESS)</FONT></SPAN>
<BR><SPAN LANG=3D"en-us"> =
<FONT SIZE=3D2 FACE=3D"Courier New">{</FONT></SPAN>
<BR><SPAN LANG=3D"en-us"> =
<FONT SIZE=3D2 =
FACE=3D"Courier New">SQLSetStmtOption(StmtHandle, SQL_CONCURRENCY, =
SQL_CONCUR_READ_ONLY);</FONT></SPAN>
<BR><SPAN LANG=3D"en-us"> =
<FONT SIZE=3D2 =
FACE=3D"Courier New">SQLSetStmtOption(StmtHandle, SQL_CURSOR_TYPE, =
SQL_CURSOR_KEYSET_DRIVEN);</FONT></SPAN>
<BR><SPAN LANG=3D"en-us"> =
<FONT SIZE=3D2 =
FACE=3D"Courier New">SQLSetStmtOption(StmtHandle, SQL_ROWSET_SIZE, =
m_rows);</FONT></SPAN>
<BR><SPAN LANG=3D"en-us"> =
<FONT SIZE=3D2 =
FACE=3D"Courier New">rc =3D SQLExecDirect(StmtHandle, (SQLCHAR *)selStr, =
SQL_NTS);</FONT></SPAN>
<BR><SPAN LANG=3D"sv"><FONT SIZE=3D2 FACE=3D"Arial">...</FONT></SPAN>
<BR><SPAN LANG=3D"sv"><FONT SIZE=3D2 FACE=3D"Arial">...</FONT></SPAN>
<BR><SPAN LANG=3D"sv"><FONT SIZE=3D2 FACE=3D"Arial">...</FONT></SPAN>
<BR><SPAN LANG=3D"sv"><FONT SIZE=3D2 FACE=3D"Arial">How do I know how =
many rows that was found??</FONT></SPAN>
</P>
<BR>
<P><SPAN LANG=3D"sv"><FONT SIZE=3D2 FACE=3D"Arial">Kind =
regards,</FONT></SPAN>
</P>
<P><SPAN LANG=3D"sv"><B><FONT SIZE=3D2 FACE=3D"Arial">Paul =
Malm</FONT></B></SPAN>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C8958D.6E07F2AE--
|
