call oracle pl/sql procedures with cursors as outputparameters - C / C++ / MFC Discussion Boards

First Prev Next

Re: question on recv() function

zecodela8-Aug-02 15:53

zecodela

8-Aug-02 15:53

thanks!
so, do you know how can i control when the recv() return? or, it is in random manner?
pls give me some idea!
jim

Irregular fatal error

s_k7-Aug-02 23:42

s_k

7-Aug-02 23:42

Hi,
I have very big Visual C++ project I undertook after the other programmer. Now, I found out irregular fatal errors. Windows write something like "....instruction on address blahblah....memory cant be written...". I really cant go through source code and find possible problems because it is really big project. So how can I fix it ?? I say again, this error is very irregular and sometimes, the program finishes its work perfectly...I am very confused. Is there any way to find the error ? I have VC++ 6.0.
Thanks in advance, any suggestion will be appreciated !

Celebrate Mr. Cesilko!

Re: Irregular fatal error

Tomasz Sowinski8-Aug-02 0:57

Tomasz Sowinski

8-Aug-02 0:57

You'll need some automated error detection tool, like BoundsChecker or Purify. The problem smells like heap corruption or writing past the end of array.

s_k wrote:
sometimes, the program finishes its work perfectly

Forget about it. Treat your app as a 2-engine plane with first engine totally broken. Second may fail any moment now leading to disaster.

Tomasz Sowinski -- http://www.shooltz.com

What is "scratch" and why can everything be made from it?

Re: Irregular fatal error

s_k8-Aug-02 23:34

s_k

8-Aug-02 23:34

Thanks for your reply!
But, where can I get BoundsChecker, trial version, because I havent got money enough to buy commercial version...?

Celebrate Mr. Cesilko!

how to get location like VB's "app path"

nss7-Aug-02 23:22

nss

7-Aug-02 23:22

in VB theres the app path that you can tack on before the filename. How can you automatically detect your location in VC?
Thanksd,
ns

Re: how to get location like VB's "app path"

Ravi Bhavnani8-Aug-02 2:51

Ravi Bhavnani

8-Aug-02 2:51

void getAppDir
  (CString& strAppDir)    // buffer to receive application's directory
{
char*     pSlash;                     // location of last backslash filespec
char      szFilespec [_MAX_PATH];     // filespec
 
  // Get name of .exe file sans name
  ::GetModuleFileName (AfxGetInstanceHandle(), szFilespec, _MAX_PATH);
  pSlash = strrchr (szFilespec, '\\');
  ASSERT (pSlash != NULL);
  pSlash++;
  *pSlash = '\0';
  strAppDir = szFilespec;
}

/ravi

Let's put "civil" back into "civilization"
http://www.ravib.com
ravib@ravib.com

Re: how to get location like VB's "app path"

nss8-Aug-02 5:21

nss

8-Aug-02 5:21

Looks great! I thought I'd have to go via cfiledialog which wasnt acceptable.
Thanks so much! Smile | :)

call oracle pl/sql procedures with cursors as outputparameters

ownlife7-Aug-02 23:11

ownlife

7-Aug-02 23:11

hi
how is it possible to call an oracle procedure from my vc++ application. i have tried it with the oracle ole c++ library, but this method doesn´t work because this library isn´t maturad enough, like there are several exceptions, when i connect to the db or when i call MoveNext in a dynaset object. I have read about an solution with the ole db dataprovider from oracle, but the problem is, that this works with COM and COM+ and so it is to complicated for me, because i am not experienced in COM.

Is there any simple solution for my problem?

thanks

ownlife

Re: call oracle pl/sql procedures with cursors as outputparameters

Michael P Butler7-Aug-02 23:18

Michael P Butler

7-Aug-02 23:18

I use ADO all the time to call Oracle stored procedures from VC++ applications.

Simply create an ADO connection, create a command object and execute it. There are some issues with returning Recordsets but these can be sorted by a few changes to the stored procedures.

Michael Smile | :)

Time flies like an arrow. Fruit flies like a banana

A simple SQL question

nss7-Aug-02 23:02

nss

7-Aug-02 23:02

I have a lot of fields in my database. I want to include all but one in my search. I dont want to have to type the names of all the fields in my SQL search like this:

SELECT Aa,b,c,d....FROM Table

Is there something like

SELECT * From Table BUT NOT xyz

?

Thanks,
ns

Re: A simple SQL question

Jon Hulatt7-Aug-02 23:17

Jon Hulatt

7-Aug-02 23:17

nope, not possible.

But (unless the field is type text or ntext or some other blob), it's probably quicker to use * and just not use the field. If you specify a finite set of columns to return, you'll slow your query down some.

STL is a religeon. Enquiries to Reverend Christian Graus

Re: A simple SQL question

nss7-Aug-02 23:43

nss

7-Aug-02 23:43

Okay, thanks. I am putting my fields in a listbox, and didnt want my blob field to show up. SO ii suppose I'll test for it and exclude it while populating the box.

Smile | :)

Re: A simple SQL question

Todd Smith8-Aug-02 6:43

Todd Smith

8-Aug-02 6:43

You can go the lazy route and just use *. But if your blob data can be large I would consider it a worthy optimization to type out all of the fields. You could use a stored procedure to keep from having to type it multiple times.

Todd Smith

good point, but......

nss8-Aug-02 7:04

nss

8-Aug-02 7:04

Great optimization observation. I'm in a catch-22 situation though - I dont know how many fields there are, or what the names are. SO I do a select * and iterate through the fields to get that info. (I populate a listctrl with the names, so I was contemplating catching the blob field name and filtering it out). I f I'm missing something obvious, I'd like to know....
Thanks,
ns

Re: A simple SQL question

Anthony_Yio8-Aug-02 3:34

Anthony_Yio

8-Aug-02 3:34

Try to use view instead of table for search.

Re: A simple SQL question

nss8-Aug-02 5:11

nss

8-Aug-02 5:11

WEll,
This means I go in search of what a view is. None of the simple SQL stuff and basic db stuff I've seen (and its very little) speaks of views. If you have any links let me know.
Thanks,
ns

Re: A simple SQL question

Anthony_Yio8-Aug-02 16:07

Anthony_Yio

8-Aug-02 16:07

Something like below. Same way you write a SQL statement to create table. Reasons you write one is to help organise your SQL statement call and optimize in some sense as it will be compiled into an object in your DBMS.

create or replace view v_something as
select S.ID, S.CODE, U.NAME
from
salesman s, user u
where
U.id = S.User_ID
with read only

Device handle to CFontDialog?

Hel7-Aug-02 21:53

Hel

7-Aug-02 21:53

Is there a way to optain a pointer to the device context of a CFontDialog box before opening it? Confused | :confused:

My dog is anisotropic, but he doesn't scale easily like this mapping mode does... Practical C++ Jon Bates and Tim Tompkins

how can I paint messagebox with custom color

fyl_jf7-Aug-02 21:28

fyl_jf

7-Aug-02 21:28

In my dialog based application I modify the background of
the dialog ,now they looks very nice.
But in my application I also use MessageBox() to send some information to user,but their background is still grey.

How can I change the background of MessageBox()?
any help will be appr Cool | :cool:

eciate ,thanks.;)

Re: how can I paint messagebox with custom color

Tomasz Sowinski8-Aug-02 0:54

Tomasz Sowinski

8-Aug-02 0:54

fyl_jf wrote:
How can I change the background of MessageBox()?

AFAIK, there's no easy way for that. You may try to use MFC approach: set the WH_CBT hook before calling MessageBox, subclass the message box and modify the background by intercepting WM_ERASEBKGND.

Tomasz Sowinski -- http://www.shooltz.com

What is "scratch" and why can everything be made from it?

Re: how can I paint messagebox with custom color

fyl_jf8-Aug-02 20:11

fyl_jf

8-Aug-02 20:11

Thanks for your help! Smile | :)

but I'm a beginner,and I don't know how to set the WH_CBT
hook.Can you explain it more clearly or post code to me? Big Grin | :-D

Initial size of CFormView based app

Woody Green7-Aug-02 21:16

Woody Green

7-Aug-02 21:16

Hi,

I have a CFormView based application. The dialog is created using the dialog editor. When I compile and run the program the initial size of the window is always too small to show all controls, resulting in ugly scrollbars.

I am looking for a smart way that ensures that the initial size of the application window is just big enough to show all controls.

How do I do this?

Woody

Re: Initial size of CFormView based app

Michael P Butler7-Aug-02 22:02

Michael P Butler

7-Aug-02 22:02

Look at WM_GETMINMAXINFO. You can specify the min and max size of your frame, so your formview fits.

Michael Smile | :)

Time flies like an arrow. Fruit flies like a banana

Re: Initial size of CFormView based app

Woody Green8-Aug-02 1:32

Woody Green

8-Aug-02 1:32

Thanks. One more question. How do I determine the required size. For example, I draw four listboxes next to each other. How do I determine the total size of these listboxes and thus the total dialog size.

Woody

Re: Initial size of CFormView based app

nss8-Aug-02 5:26

nss

8-Aug-02 5:26

http://www.codeproject.com/dialog/resizeformtofit.asp

THeres an article on CP for centering MDIChild windows and you can easily modify it to fit completely into the frame (still might have scrollbars).

http://www.codeproject.com/docview/centermdiwnd.asp
Hope this helps
ns

Last Visit: 31-Dec-99 18:00 Last Update: 8-Oct-24 8:25

Refresh

ᐊ Prev 1...16456 16457 16458 164591646016461 16462 16463 16464 16465 Next ᐅ

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