That's great, thanks Mike!

OK, thanks, that's a good idea. But the question still remains about the SQL to use in the stored procedure.

This is on SQL Server 2000, I don't think it's possible, but maybe there is some way of doing it, or another better idea? If I have two tables, and I want to insert a new record into both of them, and at the same time set a field in one table to be the identity inserted field in the other, can that be done? e.g. the SQL I'd want to work would be for example: insert into tablea inner join tableb on tablea.bid = tableb.id( a, b, c, bid ) values( 1, 2, 3, tableb.id)

Thanks for your reply. The problem with that is it will open a new form, what I want to do is replace the existing form with the new one. I don't know how to do it in an SDI app, in an MDI app you can open a new child form, the problem is the user can restore the forms and switch between them, I want it to appear as an SDI app.

I have an interface problem, trying to write a program in C#, which I'd really appreciate some help on. It's an SDI app, and I want basically to switch the main form to a different one. So to start with there's one form, but on editing one of the entries I want to switch to a different one, so I can lay out a different set of controls on the other form. I'm not sure how to do this in C#? I hope you can understand what I'm trying to do, and I'd appreciate any advice! Thanks, Mark

You can get most system information you want. Here's a way of calculating CPU speed. It's not 100% accurate but close enough: #pragma warning( disable: 4035 ) inline unsigned __int64 GetCycleCount() { _asm { _emit 0x0F _emit 0x31 } } #pragma warning( default: 4035 ) int GetCPUSpeed() { Sleep( 0 ); const unsigned __int64 ui64StartCycle = GetCycleCount(); Sleep( 1000 ); return static_cast( ( GetCycleCount() - ui64StartCycle ) / 1000000 ); }

I don't think so. If you had a shared location they could both access you could create a file there though which would indicate the program was running.

Thanks Shog!

It seems the ClassWizard has gone from Visual Studio.NET, this was very handy when working with dialogs for associating member variables with controls and adding handlers for messages e.g. WM_INITDIALOG, have I missed an alternative in Visual Studio.NET?

Or remote debug!

Missing semi-colon after d+= (i && x ) ?

This is a C++ BOOL you're talking about is it? a BOOL (int) is 4 bytes but a bool is only one.