Click here to Skip to main content

C / C++ / MFC

Re: How to use order by clause in insert into statement

«_Superman_»15-Sep-09 19:31

15-Sep-09 19:31

The SQL statement would be

SELECT * FROM <TABLENAME>
WHERE <CONDITION>
ORDER BY <FIELD>

Not sure if there is any change for access database.

«_Superman_»
I love work. It gives me something to do between weekends.

Re: How to use order by clause in insert into statement

CPallini15-Sep-09 21:08

15-Sep-09 21:08

jadhavjitendrar wrote:
How to use order by clause in insert into statement

AFAIK you cannot do than. However, you may add a counter field to the table and then use it to order data when querying.
Smile | :)

Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke

[My articles]

Compiler Design in C

DarkSorrow3815-Sep-09 19:05

15-Sep-09 19:05

I have compiler design in C practicals and i have encountered a problem. This goes as :
We have to take n number of productions(string) from user.
Each production is of different size.
I want the array size for each production to be dynamic with exact size as that of the entered string. There should not be any blank elements in array as it would spoil the output.
How this can be achieved. I am someone who not so good in C.

Re: Compiler Design in C

«_Superman_»15-Sep-09 19:28

15-Sep-09 19:28

You could create an array of pointers if you know the value of n at compile time.

char *strings[50];

Now as you save each string to this array allocate the size.

strings[count] = malloc(sizeof(string) + 1);
strcpy(strings[count], string);

If the value of n is not known at compile time, create a pointer to a pointer.

char **strings;

When you get the value of n, allocate the array.

*strings = malloc(sizeof(char*) * n);

Allocation for each string is the same as above.
Don't forget to increment the count variable after to store every string.

«_Superman_»
I love work. It gives me something to do between weekends.

EXECUTE_OFFLINE_DIAGS example

Abinash Mohanty15-Sep-09 18:48

Abinash Mohanty

15-Sep-09 18:48

Hi All,
Can anybody tell me how to use command EXECUTE_OFFLINE_DIAGS and subcommand SMART_SHORT_SELFTEST_OFFLINE.How to get its result.I know its used with IOCTL code SMART_SEND_DRIVE_COMMAND.But I am unable to get the result of SMART_SHORT_SELFTEST_OFFLINE.It would be better if anybody could help me with the help of a source code.
Regards
Abinash

Drawing lines, shapes on bitmaps

Game-point15-Sep-09 18:22

15-Sep-09 18:22

Hi
how to Drawing lines, shapes on bitmaps ??

Plz give any sample pgm

thanks

~~~~~~~~~~~~~Raju~~~~~~~~~~~~~

Re: Drawing lines, shapes on bitmaps

Naveen15-Sep-09 18:36

15-Sep-09 18:36

1 Create a memory DC( CreateCompatibleDC )
2 Select the bitmap to that dc ( memdc.SelectObject )
3 Draw your lines/shapes to that DC.
4 Unselect the bitmap from dc.

Now your original bitmap will be having the drawings...

nave

[OpenedFileFinder] [My Blog]

Re: Drawing lines, shapes on bitmaps

Game-point15-Sep-09 19:02

15-Sep-09 19:02

Hi naveen

Thanks for your replay .. i tried

HDC pDC=::GetDC(0);
		HDC TmpDC=CreateCompatibleDC(pDC);
		CImage _image;
		_image.Load(_T("//read.tif"));
		//HGDIOBJ hgdiobj = SelectObject(TmpDC,(HGDIOBJ)_image);
		CRect Recto(20, 20, 20, 20);
		int width=_image.GetWidth();
		int height=_image.GetHeight();

		HDC dcBmp=CreateCompatibleDC(TmpDC);		
		HGDIOBJ TmpObj2 = SelectObject(dcBmp,(HGDIOBJ)_image);		
		BitBlt(TmpDC,0,0,width,height,dcBmp,0,0,SRCCOPY);
		SelectObject(TmpDC,TmpObj2);
		
		DeleteDC(dcBmp);

but its not showing the rectangles in image ..??

plz reply

~~~~~~~~~~~~~Raju~~~~~~~~~~~~~

Re: Drawing lines, shapes on bitmaps

«_Superman_»15-Sep-09 19:34

15-Sep-09 19:34

You could try changing the line
SelectObject(dcBmp,(HGDIOBJ)_image);
with
SelectObject(dcBmp,(HGDIOBJ)(HBITMAP)_image);

«_Superman_»
I love work. It gives me something to do between weekends.

Re: Drawing lines, shapes on bitmaps

Game-point15-Sep-09 19:54

15-Sep-09 19:54

its not working "superman"

its not showing any effect on images till the same image ...

~~~~~~~~~~~~~Raju~~~~~~~~~~~~~

Re: Drawing lines, shapes on bitmaps

«_Superman_»15-Sep-09 19:59

15-Sep-09 19:59

Check are return values for errors.
There was probably some error encountered at Load or one of earlier functions called.

«_Superman_»
I love work. It gives me something to do between weekends.

Re: Drawing lines, shapes on bitmaps

Game-point15-Sep-09 20:05

15-Sep-09 20:05

No its not showing any error msg ...

i dont know why ..??

please

~~~~~~~~~~~~~Raju~~~~~~~~~~~~~

Re: Drawing lines, shapes on bitmaps

Naveen15-Sep-09 20:16

15-Sep-09 20:16

you said you want to draw some lines and shapes. But the above code is not doing any of that.

rajugis wrote:
HDC dcBmp=CreateCompatibleDC(TmpDC); HGDIOBJ TmpObj2 = SelectObject(dcBmp,(HGDIOBJ)_image); BitBlt(TmpDC,0,0,width,height,dcBmp,0,0,SRCCOPY);

What the above code does is copy the image in dcBmp to TmpDC. The dcBmp has your image, but the target dc TmpDC doesnt have any bitmap selected into it. So basically that BitBlt function does nothing. To have a valid image in the TempDC, you have to select one bitmap to that dc. Check the below code(especially the one in the bold ). The hBmp conatins the final image.

HDC dcBmp=CreateCompatibleDC(pDC);
HBITMAP hBmp = CreateCompatibleBitmap(pDC, 20,20);
HGDIOBJ OldBmp = SelectObject(TmpDC,(HGDIOBJ)hBmp);
HGDIOBJ TmpObj2 = SelectObject(dcBmp,(HGDIOBJ)_image);
BitBlt(TmpDC,0,0,width,height,dcBmp,0,0,SRCCOPY);
SelectObject(dcBmp,TmpObj2);
SelectObject(TmpDC,OldBmp);

nave

[OpenedFileFinder] [My Blog]

Re: Drawing lines, shapes on bitmaps

Game-point15-Sep-09 20:36

15-Sep-09 20:36

hi Naveen

Still its not drawing rectangles in image ...plz mention where i can correct it ..??

HDC pDC=::GetDC(0);
		HDC TmpDC=CreateCompatibleDC(pDC);
		CImage _image;
		_image.Load(_T("read.tif"));
		//HGDIOBJ hgdiobj = SelectObject(TmpDC,(HGDIOBJ)_image);
		
		int width=_image.GetWidth();
		int height=_image.GetHeight();
		
		HDC dcBmp=CreateCompatibleDC(pDC);
		HBITMAP hBmp = CreateCompatibleBitmap(pDC, 20,20);
		HGDIOBJ OldBmp = SelectObject(TmpDC,(HGDIOBJ)hBmp);
		
		BitBlt(TmpDC,0,0,width,height,dcBmp,0,0,SRCCOPY);
		
		
		SelectObject(TmpDC,OldBmp);

please replay me !!!!!!!1

~~~~~~~~~~~~~Raju~~~~~~~~~~~~~

Re: Drawing lines, shapes on bitmaps

Naveen15-Sep-09 20:39

15-Sep-09 20:39

rajugis wrote:
Still its not drawing rectangles in image ...plz mention where i can correct it ..??

Where is the code to draw a rectangle?

rajugis wrote:
//HGDIOBJ hgdiobj = SelectObject(TmpDC,(HGDIOBJ)_image);

Why did you comment it? Also correct this line as SuperMan mentioned.
HGDIOBJ hgdiobj = SelectObject(TmpDC,(HGDIOBJ)(HBITMAP)_image);

nave

[OpenedFileFinder] [My Blog]

Re: Drawing lines, shapes on bitmaps

Game-point15-Sep-09 20:42

15-Sep-09 20:42

Sorry to say naveen ..really i dont know the rectangle code..

~~~~~~~~~~~~~Raju~~~~~~~~~~~~~

Re: Drawing lines, shapes on bitmaps

Naveen15-Sep-09 21:00

15-Sep-09 21:00

try the below code. If everthing goes fine, it will draw a rectangle on the top left portion of the image;

HDC pDC=::GetDC(0);
HDC TmpDC=CreateCompatibleDC(pDC);
CImage _image;
_image.Load(_T("//read.tif"));
int width=_image.GetWidth();
int height=_image.GetHeight();
HGDIOBJ TmpObj2 = SelectObject(TmpDC,(HGDIOBJ)(HBITMAP)_image);			
Rectangle(TmpDC, 0,0, width/2, height/2 );
SelectObject(TmpDC,TmpObj2);
ReleaseDC(pDC);

nave

[OpenedFileFinder] [My Blog]

Re: Drawing lines, shapes on bitmaps

Game-point15-Sep-09 21:33

15-Sep-09 21:33

ReleaseDC(pDC);

Showing Error message naveen like

error C2664: 'CWnd::ReleaseDC' : cannot convert parameter 1 from 'HDC' to 'CDC *'

~~~~~~~~~~~~~Raju~~~~~~~~~~~~~

Re: Drawing lines, shapes on bitmaps

Naveen15-Sep-09 21:35

15-Sep-09 21:35

modify

::ReleaseDC(0, pDC);

nave

[OpenedFileFinder] [My Blog]

Re: Drawing lines, shapes on bitmaps

Game-point15-Sep-09 21:51

15-Sep-09 21:51

its execute completly with out error but its not creating any rectangle in image... naveen ...

HGDIOBJ TmpObj2 = SelectObject(TmpDC,(HGDIOBJ)(HBITMAP)_image);			
Rectangle(TmpDC, 0,0, width/2, height/2 );
SelectObject(TmpDC,TmpObj2);
::ReleaseDC(NULL,pDC);

any need to create the new bitmap for this HGDIOBJ TmpObj2 ..??

~~~~~~~~~~~~~Raju~~~~~~~~~~~~~

Re: Drawing lines, shapes on bitmaps

Naveen15-Sep-09 21:52

15-Sep-09 21:52

How did u verify that no rectangle is coming..?

nave

[OpenedFileFinder] [My Blog]

Re: Drawing lines, shapes on bitmaps

Game-point15-Sep-09 21:58

15-Sep-09 21:58

just i save the image like read.tif ..its not show the rectangle so that??

~~~~~~~~~~~~~Raju~~~~~~~~~~~~~

Re: Drawing lines, shapes on bitmaps

Naveen15-Sep-09 22:07

15-Sep-09 22:07

hope you saved the image like the code below

_image.Save( _T("c:\\abcd2.bmp"), Gdiplus::ImageFormatBMP );

nave

[OpenedFileFinder] [My Blog]

Re: Drawing lines, shapes on bitmaps

Game-point15-Sep-09 22:19

15-Sep-09 22:19

thanks naveen ...i never forget this help

i would like say ..please add my name to your friends list please .

~~~~~~~~~~~~~Raju~~~~~~~~~~~~~

Re: Drawing lines, shapes on bitmaps

Naveen15-Sep-09 22:22

15-Sep-09 22:22

rajugis wrote:
thanks naveen

Your are welcome.

nave

[OpenedFileFinder] [My Blog]

General News Suggestion Question Bug Answer Joke Praise Rant Admin

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