I don't excute SQLFetchScroll(SDK fuction)

Posted by Legacy on 01/22/1999 12:00am

Originally posted by: Kyong Bae Park

How to use SQLFetchScroll(); fuction.

If you know mail me

please....

I don't excute SQL_FETCH_FIRST.

Hwo to.....

please tell me....

please........

Reply

How to visit certain records?

Posted by Legacy on 01/20/1999 12:00am

Originally posted by: yu weidong

I feel it very well.But I don't know how to visit certain records
with the class code.I try to add the member function Move(int index)
just as that CRecordSet in VC++,but I failed.Could someone show
a example code,thanks lots!
Yu weidong
Shanghai,China

Reply

Adding "GetNumColumns" method

Posted by Legacy on 11/09/1998 12:00am

Originally posted by: Mike Turner

This code is a great alternative to recordset.

I needed to get the number of columns.  I offer this method to add to SQLDirect:

//Get number of columns

int CSQLDirect::GetNumColumns()

{

	UCHAR ucOwner[256];

	SWORD swScale;

	SDWORD wColLen;

    // Get the total # of columns in this query.

	SQLColAttributes( m_hStmt,0,SQL_COLUMN_COUNT,ucOwner,256,&swScale,&wColLen );

	int nMaxCols=(int)wColLen;

    return nMaxCols;

}

It would also be nice to get the number of records without looping through the fetch and manually
counting.  Anyone have that method??

--Mike

Reply

Good idea, but works only on strings

Posted by Legacy on 11/05/1998 12:00am

Originally posted by: Ernst Versteeg

Its a good start. But the code supports only strings.
I need other types too.

Reply

examples?

Posted by Legacy on 10/09/1998 12:00am

Originally posted by: John

I'm just starting out with MFC but some SQL background and this looks preferable to me to using CRecordset methods. Could you provide some examples?

Let's say I have an ODBC data source named "dude" with one table "stuff" that has a key field and a value. The keys being just numbers 1-10 and I want to reset the values for all values between 6 and 8. How would I go about that with this class?

Reply

A doubt

Posted by Legacy on 10/05/1998 12:00am

Originally posted by: Srikanth

Hi,

THese have been great ventures frm u..!!

Well I have a question to ask...!!

MFC supports Mapi, possibly if we check the MAPI support icon during the creation of the application..

This now automatically adds a menu item under the file menu.
So when ever we need to initiate the mapi process, we need to go thru the file menu and then to the mail send option..!!

I want the same to he handled on a customized event, say on a left button click..!!

How do we implement this..!! I tried posting a message to the document on the event, but d'nt work..!!

Can u please help me out!!

Thanks in anticipation
Srikanth

Reply

Comments