Set index in CListCtrl - C / C++ / MFC Discussion Boards

JohnnyG2-Oct-02 6:38

2-Oct-02 6:38

I seem to recall seeing a recent article that addressed creating a .XLS file even if there wasn't an ODBC driver for Excel installed. However, all I can find was the following:

http://www.codeproject.com/database/excel_odbc_write.asp

Try that other site, codeguru.com, too.

Re: Saving File Formats

SanShou2-Oct-02 7:10

SanShou

2-Oct-02 7:10

Thanks for the suggestion, but I checked out the "other site" and the articles on Excel. They all require excel ODBC drivers to read and write files.

I need to learn how to automated create ODBC or DAO drivers. I just need a method of letting others use additional software to edit the file outside of the actual GUI program.

I will keep looking...

Brian

If you start a fire for a man, he will be warm for a day. If you start that same man on fire, he will be warm for the rest of his life.

Re: Saving File Formats

Phil J Pearson2-Oct-02 7:21

Phil J Pearson

2-Oct-02 7:21

It depends on how complicated the state information is. Simple options would be:

1. Use ini files (WriteProfileXxxx and GetProfileXxxx)
2. Write csv files. They can be opened in Notepad, Excel, Access etc., etc. Get some code from CP to handle csv files or write your own, it's pretty easy.
3. Use XML. There are several examples on CP of loading and saving configuration to XML. It's not so easy to hand edit (and fairly easy to screw it up) but it can be done.

The opinions expressed in this communication do not necessarily represent those of the author (especially if you find them impolite, discourteous or inflammatory).

Re: Saving File Formats

Rickard Andersson²⁰2-Oct-02 8:28

Rickard Andersson²⁰

2-Oct-02 8:28

Phil J Pearson wrote:
. Use XML. There are several examples on CP of loading and saving configuration to XML. It's not so easy to hand edit (and fairly easy to screw it up) but it can be done.

you can use MC++ and DataSet
but then you need to use MC++ Frown | :(

Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!

Re: Saving File Formats

Scott H. Settlemier2-Oct-02 9:57

Scott H. Settlemier

2-Oct-02 9:57

Requirement 3 would seem to limit you to flat ASCII files
that could be viewed/edited in Notepad or Wordpad.

You can then create an ODBC data source that will let you
manipulate the file via ODBC and satisfy that requirement.

Strange though. The requirements seem to have arisen from
different goals: hand editability and independence from
outside application vs. standardization of the interface
allowing substitution in the data source.

Re: Saving File Formats

SanShou2-Oct-02 10:11

SanShou

2-Oct-02 10:11

Tell me about it. My boss laid down the requirments at just the right level to be dangerous without exactly knowing what he wants. Now I am just researching what I can actually give and then counter proposal time...

If you start a fire for a man, he will be warm for a day. If you start that same man on fire, he will be warm for the rest of his life.

Re: Saving File Formats

Patje2-Oct-02 21:27

Patje

2-Oct-02 21:27

Just write to a plain ASCII text file.
It can be edited with notepad, wordpad, UltraEdit, ... you name it.
Then tell your boss that you use something like Online Dirty Binary Conversion (=ODBC) logic (or invent a nice acronym yourself).

Smile | :)

Enjoy life, this is not a rehearsal !!!

Set index in CListCtrl

Telefonen2-Oct-02 5:54

Telefonen

2-Oct-02 5:54

I have a CListView where I want to set the top index explicitly.
How can I do that?

/Per

Re: Set index in CListCtrl

Chris Richardson2-Oct-02 9:55

Chris Richardson

2-Oct-02 9:55

Here's one way to do it. I'm not sure why MS didn't include a SetTopIndex with the SysListView, but it seems silly...

void CYourListView::SetTopIndex( int p_iDesiredTopIndex )
{
   CListCtrl & a_roList = GetListCtrl();
   CRect       a_oRect( 0, 0, 0, 0 );
   
   // Get the height of one item.
   a_roList.GetItemRect( 0, &a_oRect, LVIR_BOUNDS );
   
   // Scroll the control vertically, by the amount of height of one item multiplied by the desired top index.
   a_roList.Scroll( CSize( 0, p_iDesiredTopIndex * a_oRect.Height() ) );
}

Chris Richardson

Changing dialog properties programatically

adamUK2-Oct-02 5:53

adamUK

2-Oct-02 5:53

Hello again,

I have a bunch of dialogs that I use as modals but I want to now bunch them together as child windows in one big dialog. In the process of doing this (without even getting to the make my dialog a child window yet), I am trying to alter the properties of my dialog at run-time. My problem is that when I change the properties by ModifyStyle() and ModifyStyleEx() it behaves (when I click the mouse etc..) as though the properties have changed but it still has the border and title etc. What am I doing wrong?

heres a snippet of the code thats causing the prob. I have tried all sorts of permutations and combinations of ModifyStyle(). It works if I change all the properties in the resource editor..

m_pProjInfoDlg = new CProjInfoDlg(this,m_pDoc);<br />
m_pProjInfoDlg->Create(IDD_PROJINFO,this);<br />
m_pProjInfoDlg->ModifyStyle(WS_POPUP|WS_CAPTION|WS_BORDER|WS_DLGFRAME|WS_THICKFRAME|WS_BORDER,0,SWP_NOACTIVATE);<br />
m_pProjInfoDlg->ShowWindow(SW_SHOW);

help!! Steadily going bananas.

thanks! Smile | :)

Adam.

www.beachwizard.com/travelogue[^]

"I spent a lot of my money on booze, birds and fast cars. The rest I just squandered"
George Best.

How do I convert a double to char

Jose Cruz2-Oct-02 5:20

Jose Cruz

2-Oct-02 5:20

I´m trying to convert a float to a char with the following code:

double Total;
char buffer[50];

Total = GetDouble(dbf, 2) + GetDouble(dbf, 3) + GetDouble(dbf, 4);
_gcvt(Total,10,buffer);

But the result is allways the same, even if the value of Total equals cero.

Can some body help me.

Re: How do I convert a double to char

Jon Hulatt2-Oct-02 5:23

Jon Hulatt

2-Oct-02 5:23

I think you probably want to be using sprintf(). See MSDN.

Signature space for rent. Apply by email to....

Re: How do I convert a double to char

jhwurmbach2-Oct-02 5:50

jhwurmbach

2-Oct-02 5:50

std::ostringstream could help you.
You can stream almost anything into it using operator<< and get the text using the ostringstreams str() function.

question about safearray

Gérald Mercet2-Oct-02 4:59

Gérald Mercet

2-Oct-02 4:59

I have tried to test an application i have found into microsoft support, it's Q186120: "Use MFC to automate excel and fill a range with an array"

I have a problem when i try to run it at the following line:

saRet.PutElement(index, &d);

or

saRet.PutElement(index, v.bstrVal);

(it depends on checkbox is false or true)

when i try to debug it tell me that there's a problem in the function AfxCallWndProc.

So, i would like if someone have tested this application and if he could tell me what could be wrong?

thanks in advance

gerald

DoWaitCursor(true) not staying up

2-Oct-02 4:40

hey, in my program when someone hits the update button, it used to update but the UI would not respond etc. so i use a thread and it works good, but i set the waitcursor before i start the thread but it never stays up, any ideas on how to keep the curors as the wait cursor?
i have have this when the button is pushed:
CWinApp *pApp = (CWinApp*) AfxGetApp();
pApp->DoWaitCursor(true);
AfxBeginThread(startThread, this);
then when the thread is done it posts a message and then i set the cursor back to normal, but the cursor never changes, hope someone can help.
Also how do i go about making a button on the toolbar disabled?

thnkas

luke.

Re: DoWaitCursor(true) not staying up

Paul M Watt2-Oct-02 5:00

Paul M Watt

2-Oct-02 5:00

You will need to create an OnSetCursor handler for your main window that wants to set the wait cursor. You will want to create a variable that holds the current state that the cursor should be in. Then in your OnSetCursor function you should call ::SetCursor();

The reason that you need to do it this way is that every time you move the cursor over your window, a mouse message is generated, then a WM_NCHITTEST message is generated from that, and the WM_SETCURSOR message is then called to allow the mouse cursor to be updated when you move the cursor over the different regions in your window.

DoWaitCursor is only meant for a single function call, or single message handler where the operation could take a long time. However it does not work across message handling boundaries for the reason that I explained above.

Build a man a fire, and he will be warm for a day
Light a man on fire, and he will be warm for the rest of his life!

A simple array question

ns2-Oct-02 4:29

2-Oct-02 4:29

And its confounding me...

I have an array Arr in which I stored the values of 1 row of a database, and the size of this is the number of fields n. Now I want to send this off to a function in a parameter list like

myFunc(Arr[0], Arr[1], Arr[2],....,Arr[n-1])

I cant do a for n =0, n++ type loop since I need them all at once> So what is the way to go here?

Appreciate your help,
ns

Re: A simple array question

RedZenBird2-Oct-02 4:31

RedZenBird

2-Oct-02 4:31

why can't you just pass in the entire array to myFunc? Seems like that what you want....

Just trying to keep the forces of entropy at bay

Re: A simple array question

ns2-Oct-02 4:47

2-Oct-02 4:47

The function demands that the parameters be fed in as I showed....I cant change that. Otherwise your idea is great!

Appreciate your help,
ns

Re: A simple array question

jmkhael2-Oct-02 4:51

jmkhael

2-Oct-02 4:51

does the function takes a limited or variable number of parameters?
i mean is it like printf ??

Papa

while (TRUE)
Papa.WillLove ( Bebe ) ;

Re: A simple array question

ns2-Oct-02 5:24

2-Oct-02 5:24

Nope, fixed number of variables

Appreciate your help,
ns

Re: A simple array question

Joe Herbert2-Oct-02 5:43

Joe Herbert

2-Oct-02 5:43

you could change it from this
myFunc(Arr[0], Arr[1], Arr[2],....,Arr[n-1])

to this

i=0 ;<br />
myFunc(Arr[i], Arr[++i], Arr[++i],....,Arr[++i])

I'm new here, pardon the n00bing

Re: A simple array question

ns2-Oct-02 5:50

2-Oct-02 5:50

Thnaks. Welcome to CP Smile | :)

Appreciate your help,
ns

Re: A simple array question

jmkhael2-Oct-02 6:07

jmkhael

2-Oct-02 6:07

This doesnt work i fear cos i++ isnt yet evaluated

Papa

while (TRUE)
Papa.WillLove ( Bebe ) ;

Help with fstream

Sunnygirl2-Oct-02 4:23

Sunnygirl

2-Oct-02 4:23

hello!

first: i want to read a .txt file with visual c++. i know there something with fstream, iostram and so on. but i don´t know the details.

second: i want to read different txt files. if i press a button a dialog should open where i can choose a txt-file. how can i program this dialog???

thanks
sunny Rose | [Rose]

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