Crystal Reports 9 deployment - C / C++ / MFC Discussion Boards

How to Use Select [column] From Table where (column= Value) from vc++

himuskanhere11-Oct-06 23:12

11-Oct-06 23:12

Hello friends
I need your Help!!
I want to Fetch a value of clumn but i am unable to make query in VC++.
plz guide me..
I use pointer of CDaoDataBase class and member Funtion is Execute().
Hoping Best from u!!
Thankx Roll eyes | :rolleyes:

Born To Code

Re: How to Use Select [column] From Table where (column= Value) from vc++

prasad_som11-Oct-06 23:30

prasad_som

11-Oct-06 23:30

Remark from MSDN about Execute:

Execute works only for action queries or SQL pass-through queries that do not return results. It does not work for select queries, which return records.

Prasad
Notifier using ATL | Operator new[],delete[][^]

Re: How to Use Select [column] From Table where (column= Value) from vc++

Hamid_RT12-Oct-06 0:39

Hamid_RT

12-Oct-06 0:39

Is this[^] helpful?

WhiteSky

Re: How to Use Select [column] From Table where (column= Value) from vc++

David Crow12-Oct-06 3:18

David Crow

12-Oct-06 3:18

One way is to derive a class from CDaoRecordset. Then just change the GetSQL() method (it default to SELECT *) to select those columns and rows you want.

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

C++ Image printing

<color>Aljechin 11-Oct-06 22:54

<color>Aljechin

11-Oct-06 22:54

I want to print a small bitmap image using c++ (not MFC). I don't have a problem in printing normal text. But now I want to print an image.

Re: C++ Image printing

<color>Aljechin 11-Oct-06 23:13

<color>Aljechin

11-Oct-06 23:13

Sorry for incomplete information. I want to print using a standard LPT printer. for example, to print some text we can print simply by writing it into a file (naming the file as "LPT1" inside the program). But how do I print a image?

Re: C++ Image printing

Hamid_RT12-Oct-06 0:28

Hamid_RT

12-Oct-06 0:28

Do you need to print an image file?

WhiteSky

Crystal Reports 9 deployment

tuxyboy11-Oct-06 22:20

tuxyboy

11-Oct-06 22:20

Anybody with experiences in deploying CR9 with an application developed in VC 6.0 please help!
I'm pulling my hair out one by one! App should be installed on win98 machines!
I'm using CR9 Crystal Report Viewer Control implemented in my app, with printing, exporting functions as well.
I build my setup package with Inno. I used all the crystal docs could find in the topic of figuring dependencies.
I already have a bunch of files installed. I know the issue with unicows.dll, atl.dll, registering, not registering, etc. When I'm about to show the report in the app, it dies without errormessage.
I already have all the files installed that Dependency Walker shows, same mdac, but still doesn't work.
I developed the app under XP, but since than I installed the VC 6.0 to a win98 machine as well to check dependencies. Is anybody out there who has something similar working on win98? Might be possible to check file versions...

thanks

Re: Crystal Reports 9 deployment

Member 16066558-Oct-09 22:15

Member 1606655

8-Oct-09 22:15

Hi, I got through the same problem some time ago and there is the solution. Inno script with Crystal Report Installation.

Crystal Report 9 and 11 Installation - Inno Script

I like Inno since it's fast, easy and you have full control over the whole process. Crystal Report msi package is just pain.

Hope It helps. Thumbs Up | :thumbsup:

Subclassing Control

patricknorman11-Oct-06 22:10

patricknorman

11-Oct-06 22:10

Hi, I am trying to create a simple control which is a subclass of COMBOBOX. So using MSDE 2003, new C++ MFC project, create control based on COMBOBOX.
How do I expose the combobox's existing functions like AddItem in my subclassed control? Do I have to add same method to both ctrl and interface?

Many thanks for any helpful pointers...
Patrick

Re: Subclassing Control

Cedric Moonen11-Oct-06 22:14

Cedric Moonen

11-Oct-06 22:14

What do you mean exactly ? You want that the user of the control will be able to call AddItem (for example) as it was possible to do with the combobox ? If yes, then you don't need to do anything: the class 'inherits' also all functions from the base class.

Cédric Moonen
Software developer

Charting control [Updated - v1.1]

Re: Subclassing Control

patricknorman11-Oct-06 23:53

patricknorman

11-Oct-06 23:53

Yes, that's exactly what I mean. But currently they do not have any methods/properties/events. I can do things like add the OnClick event though, by adding a "stock" event.
If they should be there already then it means I am doing something wrong - I will see if there is anything obvious I am missing.
Thanks.

Datatype Misalignment

GDavy11-Oct-06 22:07

GDavy

11-Oct-06 22:07

I have a Datatype misalignment issue with one of my dll's.
The thing is that all the code inside the dll used to be in a normal .exe application, but since multiple apps will use the functionality inside it we decided to make it a .dll. When the code was completely in the .exe applications everything went very smooth, now however that I made a dll I got this Datatype misalignment issue.

If I do a step by step debug the crash occurs on a line:

m_zsRow = new char[nLen+1];<br />

with m_zsRow being a normal char* declared in the class header.

Does anybody know how this could happen? And how I can fix this?

Thanks for any help you might provide,
Greetings,
Davy

Re: Datatype Misalignment

prasad_som11-Oct-06 23:36

prasad_som

11-Oct-06 23:36

GDavy wrote:
If I do a step by step debug the crash occurs on a line:
m_zsRow = new char[nLen+1];

Can you show complete function code, having this line?

Prasad
Notifier using ATL | Operator new[],delete[][^]

Re: Datatype Misalignment

GDavy12-Oct-06 0:27

GDavy

12-Oct-06 0:27

Hello,
Well apparantly all that was needed to find the answer myself was to post the question here Smile | :)

.
The error apparantly was not located in that function, it was a few steps up in the call-stack. There was memory being allocated like:

char* aString = new char(A_Certain_Length);

so with parenthesis in stead of square brackets. How nobody found that out earlier is a wonder to me... Anyways, fixing this fixed the problem. I don't know why this caused the Datatype misalignment error though.

Thanks anyway,
Davy

Re: Datatype Misalignment

Mark Salsbery12-Oct-06 5:33

Mark Salsbery

12-Oct-06 5:33

OUCH!

char* aString = new char(A_Certain_Length);

What is aString after executing that?? Smile | :)

Is there any LOGIN Event or Message

Ranjan Shrestha11-Oct-06 22:03

Ranjan Shrestha

11-Oct-06 22:03

I am developing a NTService program. And I want to know when any user logs into the system. Is there any kind of message sent to the application program when a user logs in.

Re: Is there any LOGIN Event or Message

David Crow12-Oct-06 2:56

David Crow

12-Oct-06 2:56

Check out ISensLogon::Logon().

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

"MS Paint-style" text input on CWnd

_NielsB11-Oct-06 22:02

_NielsB

11-Oct-06 22:02

I have to put some graphical functions to an dialog-based application using MFC/GDI/GDI+.
One of them is to give the user the abbility to write text-comments on a image.

Like you can do in MSPaint (and Photshop, GIMP ... ).
I found thats relatively easy to parse the mouse - and keyboard input and simply write it to screen (using Graphics DrawString - Method), but it seems to be not trivial to enable editing of the written text (blinking cursor when double-clicking on the text ie).
Or setting up a correct-sized (and blinking Wink | ;)

) cursor to signalize, that the app is ready to parse keyboard input.

So, does someone got a idea how to implement MSPaint-like text input on CWnd?
Searched for 2 days for demo-projects or smth like that, no success at all.

Thanks in advance and sorry for my ******* english.

Re: "MS Paint-style" text input on CWnd

Hamid_RT12-Oct-06 1:13

Hamid_RT

12-Oct-06 1:13

Hope I understood your question
You draw a image on screen and now you want to write on the image and also you need to modify image.
Maybe this way isnt good but its possible.
You draw your image when you want to write a text on image use of a editbox for gets text and transfer your text when it finish to a external image if you need to modify this text again use of editbox for it.
But maybe you ask I need to write this text on image and also location of text is important,not problem when you click mouse on screen create editbox on it location and set external image on this location when you want to close app or close image write these texts to Main Image.
(You need to arrays for save these text or texts and also location of these texts)

WhiteSky

Re: "MS Paint-style" text input on CWnd

Galatei12-Oct-06 1:37

Galatei

12-Oct-06 1:37

Hi,

In order to get movable and resizable edit control for placing texts on an image, just search CodeProject website for articles explaining "double subclassing".

Regards

particular double to CString to edit control

Desmo1611-Oct-06 22:02

Desmo16

11-Oct-06 22:02

Hi all,

I read a double (2.567656e-010) from file,
then I convert it into CString and finally i
put it in an edit control, but the value is too small
so in the edit control i find 0.000000.

Here you have the code i use, toremove is
the variable linked to the edit control:

double var=0;
std::fstream f_load;

f_load.open("C:\\best_pop.txt",std::ios::in);
f_load>>var;
CString tmp;
tmp.Format("%lf",var);
toremove.SetWindowText(tmp);

What should i do to see 2.567656e-010 in the edit control ?

Re: particular double to CString to edit control

Ranjan Shrestha11-Oct-06 22:11

Ranjan Shrestha

11-Oct-06 22:11

Use
tmp.Format("%g", var);

It should work.

Re: particular double to CString to edit control

Desmo1612-Oct-06 1:35

Desmo16

12-Oct-06 1:35

it works ! Thanx !

Re: particular double to CString to edit control

Hamid_RT13-Oct-06 7:42

Hamid_RT

13-Oct-06 7:42

And also you can use of wsprintf

WhiteSky

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