Like the amount of time they clicked down? You could do that with a little javascript I guess. Is that actually what you want to do? Brad Australian The PHP MVP - Christian Graus on "Best books for VBscript" A big thick one, so you can whack yourself on the head with it.

Sql Server has the ability to schedule tasks inside and run them itself. If you are using SQL Server 2000, you will need to expand the Management node under your database, then expand SQL Server Agent and select Jobs. Right click and select New Job... In the General tab enter a name. Select the Steps tab and New... to create a new task. Suppose that you want to run a particular delete (delete from myTab where @created > dateadd(dd, getdate(), 2)). Give the step a name and leave the type as Transact-SQL Script (TSQL). Choose the database that you want to run the task against and enter the SQL in the Command textbox. Click OK. Next, go to the Schedules tab and create a new schedule. To change the times when it runs, select the Change button and set your schedule as appropriate. Deja View - the feeling that you've seen this post before.

Any client should be using atleast the latest MDAC[^] and ideally the latest Native Sql Client[^].

What is the error that occurs? "Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

If you want to know about ShellExecute see http://www.codeproject.com/system/newbiespawn.asp[^] WhiteSky

You can't "use" another exe as a static library. If the other exe exposes automation interfaces, you can make calls in it (or if it is a COM server/service). Otherwise, you can call it using a system call. The first case is not statically bound, and the system call is not bound at all. If you decide to become a software engineer, you are signing up to have a 1/2" piece of silicon tell you exactly how stupid you really are for 8 hours a day, 5 days a week Zac

Dear Friend, It is true i must do CoInitialize, i have forget it. Thank u:rose::)

A good example is DaveeCom's The CSpeech Class - give your application a voice with very little effort[^] Good luck!

You do know that this forum is for ASP.NET? If you have problems with PHP you might be better looking for a forum that deals with that technology. My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Well looking at your code I think you got the params for FormatMessage slightly wrong. Try changing it to void CEllepsisDlg::Log(CString x,...) { TCHAR fprmatedMessage[2048]; va_list marker; va_start( marker, x ); FormatMessage(FORMAT_MESSAGE_FROM_STRING, (LPCVOID)((LPCTSTR)x), NULL, NULL, fprmatedMessage, sizeof(fprmatedMessage), marker); va_end( marker ); } I havn't tested it, but I think that might work better. [EDIT]Be aware that in this new scheme that i've created, nothing happens to fprmatedMessage when FormatMessage has finished. Make sure you copy the string into a CString before using outside the Log function, otherwise your program will crash. e.g. CString myresult = fprmatedMessage; If you only want to use it within the function, then you can use fprmatedMessage just like any LPTSTR.[/EDIT] Hope this helps. Joel Holdsworth Wanna give me a job this summer? Check out my online CV and project history[^]

hi, My problem was solved! thank you :)

Have you tried DATEDIFF? Take a look in the BOL. You might need to write a complicated where to make it work, but it should be able to do the trick for you. Bill

SELECT xxx FROM xxx WHERE datetimefield BETWEEN #01/01/1970 12:24:36# AND #12/31/2038 18:50:25# I had to do the opposite once where I wanted rows for a particular day, regardless of the time. I used: SELECT xxx FROM xxx WHERE datetimefield BETWEEN #02/13/2004 00:00:00# AND #02/13/2004 23:59:59# A rich person is not the one who has the most, but the one that needs the least.