Stored procedures and CRecordSet - C / C++ / MFC Discussion Boards

CDataGrid

vancouver7774-Nov-03 7:01

vancouver777

4-Nov-03 7:01

Is there any way to hight light or select a whole row in CDataGrid.

Thanks in advance.

Shin

Pausing a download thread

Todd Smith4-Nov-03 6:14

Todd Smith

4-Nov-03 6:14

What happens to the socket connection when you pause a download thread?

What features should you have in your download thread so you can pause & resume the download? Should you just kill the download during pause and restart it when you resume?

Todd Smith

Re: Pausing a download thread

valikac5-Nov-03 6:18

valikac

5-Nov-03 6:18

There are sevearal solutions. Client socket status depends on the server. Some server may disconnect it. Others keep the connection alive.

Kuphryn

Problem with notepad and Edit box

Deepak Samuel4-Nov-03 4:34

Deepak Samuel

4-Nov-03 4:34

Hi ,
i have a Editbox the contents of which are save to a notepad file.The Edit box is a multiline one and on initialization displays a two line message.I use
str.Format("DATE:\r\n TIME:\r\n");
when I open the notepad file I find the \r being replaced by a new character (somthing like a rectangle).
how to avoid this.
is there any other way to print a multiline message in a edit box without using \r\n?

Thanks

Deepak Samuel.

Re: Problem with notepad and Edit box

David Crow4-Nov-03 4:44

David Crow

4-Nov-03 4:44

Deepak Samuel wrote:
save to a notepad file

I assume you meant text file, as "notepad file" is meaningless. Are you using a CStdioFile object?

Deepak Samuel wrote:
str.Format("DATE:\r\n TIME:\r\n");

As long as the edit control has the ES_MULTILINE style, this will work.

Deepak Samuel wrote:
is there any other way to print a multiline message in a edit box without using \r\n?

No.

When writing to text files, take into account that the newline character (0x0A) is translated to a byte pair (0x0D, 0x0A), and when reading from text files, the byte pair (0x0A, 0x0D) is translated to a single 0x0A byte.

Five birds are sitting on a fence.
Three of them decide to fly off.
How many are left?

Network/Internet : Catching file-requests ..?

Led4-Nov-03 4:21

Led

4-Nov-03 4:21

Ola!

I'd like to write an app that logs all requested url's,
but I don't have a clue where to start.
(Microsoft has quite a lot of SDK's / API's, haven't been able to sort out what I need).

Preferrably I'd like to catch something like the http-header including the referrer. (** see edit-note below)

Anyone got any clue / hints in the right direction ?

Edit:
Thinking about it,
it would be even nicer to log *all* requests, not only http.
Ftp, rtsp etc would be sweet too !

Re: Network/Internet : Catching file-requests ..?

valikac4-Nov-03 5:39

valikac

4-Nov-03 5:39

One solution is a network monitor application. Check CodeProject code section.

Kuphryn

Stored procedures and CRecordSet

pankajdaga4-Nov-03 3:15

pankajdaga

4-Nov-03 3:15

Hi everyone,

I spend the whole night trying to make this work, but no luck! Maybe someone can help me out. I am literally pulling hairs out of my head.

I have the following SQL Stored procedure.

CREATE PROCEDURE UpdateTestVorgaenge
@TestName nVARCHAR(250),
@OutID int OUTPUT

AS
INSERT INTO Temp_TestVorgaenge_t (Name, Datum) values(@TestName, CURRENT_TIMESTAMP)
Select @OutID= @@IDENTITY

Now, I have a CRecordSet derived class and I want to use that to call this stored procedure.

here is what I do:

void DoFieldExchange(CFieldExchange* pFX)
{

pFX->SetFieldType(CFieldExchange::param);
RFX_Text(pFX, _T("TestName"), m_name);
pFX->SetFieldType(CFieldExchange::inoutParam);
RFX_Int(pFX, _T("OutID"), m_testVID);
}

And my Open statement looks like this...
CRecordset::Open(dynaset, _T("{CALL UpdateTestVorgaenge(?,?)}"), CRecordset::none);

But it throws an exception saying "Function Sequence error". Anyone has any ideas on how to make this work???

Thanks,

Sincerely yours,
Pankaj

Without struggle, there is no progress

Re: Stored procedures and CRecordSet

Chris Meech4-Nov-03 3:43

Chris Meech

4-Nov-03 3:43

Just guessing, but the second parameter is defined as an OUTPUT parameter, but in your c++ code, your setting the parameter as an 'inoutParam'.

Chris Meech

It's much easier to get rich telling people what they want to hear. Chistopher Duncan

But for a man, barbecuing eggplant and portobello mushrooms is a sure way to have people question your sexual orientation. Kuro5hin

Re: Stored procedures and CRecordSet

pankajdaga4-Nov-03 4:06

pankajdaga

4-Nov-03 4:06

Hi,

I have tried all sorts of combinations, but with no luck!...inout, outpurParam...
I think there must be something fundamentally wrong here. maybe it is not possible for record sets to return values...

Thanks,
Pankaj

Without struggle, there is no progress

Re: Stored procedures and CRecordSet

Michael P Butler4-Nov-03 5:34

Michael P Butler

4-Nov-03 5:34

I assume the stored procedure works if called through query analyzer?

Have you stepped into the Open function and found out which method is throwing the exception.

Is there any reason you are not using ADO. I find it much easier for calling stored procedures.

Michael

'Logic, my dear Zoe, merely enables one to be wrong with authority.' - The Doctor: The Wheel in Space

Re: Stored procedures and CRecordSet

pankajdaga4-Nov-03 6:14

pankajdaga

4-Nov-03 6:14

Hi,

Do not worry about it anymore. I am just going to use ExecuteSQL from CDatabase. Something really funky is happening with CRecordset. I think it is a problem when you use a stored procedure that does not return any records (like Insert or something). I am going to tackle this on a more relaxed day Big Grin | :-D

Thanks for the reply.

Sincerely,
Pankaj

Without struggle, there is no progress

Appwizard Project Settings

Eran4-Nov-03 2:49

Eran

4-Nov-03 2:49

Hi,

I have created custom appwizard for specified project.
I know how to change the compiler and linker settings with the
RemoveToolSettings and AddToolSettings methods.

How can i change the pre-link settings accordingly?

I haven't found anything on MSDN and the web.

Please help
Thanks

Confused | :confused:

CScrollBar SB codes

ns4-Nov-03 2:46

4-Nov-03 2:46

I find that when I drag the thumbtrack to the extereme left, I step into the SB_THUMBPOSITION: case, not SB_LEFT. So what action do i have to take to make the SB_LEFT triggger?
After that I hope to figure out what makes SB_PAGELEFT trigger.
Thanks,
ns

case SB_THUMBPOSITION: // Scroll to absolute position. nPos is the position
    {
        m_nScrollPos = nPos;

        bRecalc = TRUE;

        break;
    }
case SB_LEFT: // Scroll to far left.
    {
        m_nScrollPos = minpos;

        bRecalc = TRUE;

        break;
    }

how to delete, or rewrite

don7cry4-Nov-03 2:43

don7cry

4-Nov-03 2:43

help me, how to delete or rewrite with network share file, full control shared but not for everyone, it shared for only poweruser or administrator.
how to open one dialog to login with poweruser or administrator to delete and rewrite it.
thanks
(VC++ or C# language)

Nho'c Ti`

Re: how to delete, or rewrite

valikac4-Nov-03 5:42

valikac

4-Nov-03 5:42

Check out MSDN network API.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/ntwrkprot.asp

Kuphryn

StretchBlt function

El'Cachubrey4-Nov-03 2:14

El'Cachubrey

4-Nov-03 2:14

Hi I create in my application an memory device context and draw grid into one.In next step i copy (and simulatenly decrease dimention) this context on another device context(display) use StretchBlt function,before it i set HALFTONE in SetStretchBltMode.And all was fine.But when i try to do it in Win98 my grid draw badly(if i set thickness of line which i draw my grid, not enought big my grid dissappear completle).I think what SetStretchBltMode function was fail.

Anybody suggest me decision of this trouble.
Sorry for bad eanglish.

Thanks.

Re: StretchBlt function

Terry O'Nolley4-Nov-03 8:47

Terry O'Nolley

4-Nov-03 8:47

Are only some of your grid lines disappearing? if so:

StretchBlt works by removing columns and rows of pixels. It may be that some of the rows that StretchBlt removes are the rows (or columns) that contain your grid lines.

You could verify this by changing the destination DC dimensions in your StretchBlt call and see if different rows/columns end up disappearing.

Have you answered an MTQ? Check out the stats!

Encryption by A5/3 of GSM for voice

engahmadm4-Nov-03 2:10

engahmadm

4-Nov-03 2:10

Hallo all ,i am preparing for graduated project and this project is to take the voice from a mic and encrypt it then save it to a .wav file and then play it after decrypte the .wav file what i finished from the project takeing the voice and save it to a .wav file and play it agine and what i want now to encrypte the incoming voice and decrypte it , i have a document that describe the A5/3 algorith and more detials including a code but i can not understand it ,Please any one help me and if any one want the documents i will send it quicly.
PLEASE HELP ME.
engahmadm@yahoo.com

Re: Encryption by A5/3 of GSM for voice

Dominik Reichl4-Nov-03 9:41

Dominik Reichl

4-Nov-03 9:41

Have a look at this page for source code:
http://www.funet.fi/pub/crypt/cryptography/symmetric/a5/[^]

If you need more help, just drop me an email.

Dominik

_outp(0x64, 0xAD);
and
__asm mov al, 0xAD __asm out 0x64, al
do the same... but what do they do??
(doesn't work on NT)

How to write text to desktop

Emis4-Nov-03 0:47

Emis

4-Nov-03 0:47

Can anyone show mw how to write text to desktop, something like ative calendar.

Thank in advance.

Re: How to write text to desktop

Alexander ^M.,4-Nov-03 2:28

Alexander ^M.,

4-Nov-03 2:28

use transparent windows for example!

Don't try it, just do it! Wink | ;-)

Re: How to write text to desktop

Emis4-Nov-03 14:25

Emis

4-Nov-03 14:25

thank, i already did it, but how can i make it always on bottom? Confused | :confused:

Re: How to write text to desktop

Mil104-Nov-03 2:38

Mil10

4-Nov-03 2:38

An alternative is use GetDc(GetDsktopWindow())->DrawText("skjjkajsa",x,y,whatever the params....)

Re: How to write text to desktop

Emis4-Nov-03 15:06

Emis

4-Nov-03 15:06

hi,
i has just done like this
void CTestDlg::OnOK()
{
// TODO: Add extra validation here

CWnd *wnd = this->GetDesktopWindow();
CRect rect;
rect.top=300;
rect.left=300;
rect.bottom=rect.top+200;
rect.right=rect.left+200;

CDC *pDC = wnd->GetDC();
pDC->SetTextColor(RGB(255,255,255));
pDC->DrawText("test",rect,DT_CENTER);

// CDialog::OnOK();
}
but nothing happend.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.