Thanks, that helps - we don't have any inserts that will be affected that I can think of so it's not a huge deal. I think what I was thinking was he just wanted to get the last record regardless of...

Can you find an example? on MSDN here http://msdn.microsoft.com/en-us/library/aa933217(SQL.80).aspx

it looks like it is similar to @@IDENTITY AND SCOPE_IDENTITY but just returning the last id...

Intersting, thank you - and what was your take on using

SELECT IDENT_CURRENT(’tablename’)

If you want to get technical, you're advice is bad as well, as scope_identity will:

"SCOPE_IDENTITY(), like @@IDENTITY, will return the last identity value created in the current session, but it...

To get the last record in a SQL database you simply type


SELECT TOP 1 * FROM tableName ORDER BY columnWithYourID DESC

or if you just need the id then


SELECT TOP 1 (columnWithYourID )...

You don't say if you have any programming experience at all. So the answer could be different. I think the O'Reilly books have a lot of good information in them but there is a lot of stuff on the web...

Did you realize this was a 9 month old post?

so much is either wrong with this code, or I am too new to understand. For instance, the array declaration is unlike anything I've ever used. It tries to take Last_Number and make it a const int with...

I'm willing to help you with this under a couple of conditions (I reserve the right to add more later)

#1 - Please tell me where you got the code and why you want to know. Don't lie, if it sounds...

Did you have further questions? It seems as though sknake answered the question quite completely but you didn't mark the thread as solved. If you just mean add variables he put it right out there,...

I guess my replies are either completely wrong or not worth looking at - seems to me on that link I posted was this


//Create a connection to the SQL Server; modify the connection string for your...

There and you can check here
http://support.microsoft.com/kb/320916

Thanks LizR - this will work perfectly for what I need to do.

I thought it was more than a mail merge, fields I need to merge are in our database based on a contract table, a customer table, and a claims table. I didn't think all that was possible with mail...

Hey all,

I have been tasked with figuring out a way to automate a form letter process that currently is done mostly by hand with a lot of copy/paste. We have letters that need to get sent out...

Well bummer, I was hoping I could edit my previous post and take out my suggestions.

NOBODY will do your work for you. First of all the forum rules prohibit it, secondly it doesn't help you learn...

Is this complete?

if not - on #2 see Class Derivation about halfway down on

http://functionx.com/csharp/Lesson14.htm

partial start of code

using System;

I don't see it just reading it quickly, however I do have a suggestion. Set a breakpoint near the top and step through slowing looking at the value of each variable as it moves through. See if you...

Personally I like the required field validators for this sort of stuff, but if you wanted an if statement you can also combine them into one


If(textbox1 == "" || textbox2 == "" || textbox3 ==...

Bob - your response could have been, can you tell me how to open exe/DLL ?
Just because someone assumes you know doesn't mean they are trying to be a jerk.

I'm glad you found it, if you have...

Danny,

You know I'm new and you're way beyond me, however; I don't see how you could change it other than to use 'less than' along with 'and' for your first statement or to use case statements . ....

how many ways do we have to tell you that we can't help you in this area? Search final project ideas in daniweb and see the hundreds of exactly the same posts or search google

IS final project...

I guess I'm not sure what the main goal is . . . you want on startup a combobox to show parent folders of a selected file? I guess the reason for this just baffles me, but I'm easily baffled. :)
...

k4kasun,

I'm currently a junior working on a dual degree in systems administration and information systems with a concentration on web programming. I have a full time job an hour away from home,...

if that fixed your problem then mark the thread as solved for him

hmm, well then ddanbe I am fast on my way to becoming an expert in everything!

Tobbek

Maybe you're used to working with global variables?

That makes sense, I thought you meant batch the updates in the trigger at first. :)

I'll start looking into that more, thanks again

LizR

We can probably batch it as we only cut checks twice per week as it is and the other info could be shared at that time I suppose.

Any ideas why people would say to shy away from...

yea, your link is no good

Does this help you?

http://www.syncfusion.com/faq/windowsforms/faq_c4c.aspx

Hi all,

I'm researching how to move data from a C#.Net web program into our accounting MAS90 database and back. I can do this manually, what I want to attempt to figure out is how to make the...

ahhh, I have to sign in. Smart thinking ddanb

Mine at work is just black, I'll try when I get home too

your 'from' is a valid email address as well not just a name?

I was going to add that the two outputs are the same . ..

lol - wrong page . . I'll get the correct one

http://lisa.uni-mb.si/osebje/bonacic/predmeti/orodja_za_razvoj_aplikacij_in_vs3/CSharp/Serialization_CSharp.htm

That's what I meant to post a link...

Does this site help you enough

http://www.perlmonks.org/?node_id=477517

That wasn't easy for me to see and if you hadn't pointed it out I don't know if I would have caught it.

how in the world did you see that randomly?

We need a way to "force solved" any thread that is either open for too long or solved but the poster won't mark it . . .