ahh i think i got it! When i add a new row to the list control i have also added some code that checks the number of rows currently in the list. If its = to a 1000 then i delete the 1000th row! Code looks something similar to this: if (UpdateList.Items.Count > 10) UpdateList.Items.RemoveAt(10);

You didn't actually type www.duncas.com or some other typing error did you? Check your history. My current favourite word is: Bauble! -SK Genius

Don't blame us if you pick up a nasty virus or two! :laugh: Please don't bother me... I'm hacking right now. Don't look at me like that - doesn't anybody remember what "hacking" really means? :sigh:

Exactly! I've had to go back from time to time to futz around with some old c++ code and old and icky is an absolutely perfect way to describe it. When I look at all the lines of necessary code that essentially do nothing relevant or visible to the end user of the software I shudder in revulsion. Cum catapultae proscriptae erunt tum soli proscripti catapultas habebunt

You could use the equation of a line y=mx+c, we don't know the value of c (and we can't calculate it because the line might not be straight) but we can force it to be zero by shifting all the x,y coordinates by the same amount such that the first point is 0,0 now c=0 and we can calculate m for each point, m=y/x (except for the first point since this will result in divide by zero!) If the line is straight then the value for m will be the same for each point. Should be relatively easy and quick to code... :) Apathy Rules - I suppose...

That doesn't always work. In fact, neither does my original response. "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

You're welcome.I hope it solved your prolem.:-D WhiteSky

ahh-haaaa... i see (said the blind man). Well, guys it would seem i need to do some more reading of the subject material. Thankyou both for taking the time to reply. :)

dont worry about this one guys.. i have replaced ClientToScreen with the function GetCursorPos and all is rosey!!

flippydeflippydebop wrote: which i believe to be seconds since the year 1996. Since 1996 is not considered a special year by the computer, you'll need to add the appropriate number of seconds to that value so that it reflects date/time since, for example, 1-Jan-1970. That's roughly 820,454,400. Now you can use the date/time functions that handle values from 1-Jan-1970. "Approved Workmen Are Not Ashamed" - 2 Timothy 2:15 "Judge not by the eye but by the heart." - Native American Proverb

wow guys.. thanks everyone

ahh-haa... i have found the reason http://groups.google.co.uk/group/microsoft.public.vc.mfc/browse_thread/thread/2ae2e6583698ac21/481e981ec4591749[^] "This is a weird idiosyncracy of the tree control. It's mentioned in the Platform SDK docs under the topic "Tree View Control Window Styles": "If you want to use this style, you must set the TVS_CHECKBOXES style with SetWindowLong after you create the treeview control, and before you populate the tree. Otherwise, the checkboxes might appear unchecked, depending on timing issues. "

Sony are trying to make it appear to be a general-purpose computer so they don't get billed for higher customs duties for importing entertainment devices, in some countries. Stability. What an interesting concept. -- Chris Maunder

flippydeflippydebop wrote: I have just used lockWindowUpdate/UnlockWindowUpdate which works a treat.. A locked window cannot be moved. :~ Nibu thomas A Developer Programming tips[^]  My site[^]

here is a stored-proc which writes to a file IF OBJECT_ID('dbo.sp_TestWriteToFile') IS NOT NULL DROP PROC dbo.sp_TestWriteToFile GO CREATE PROCEDURE [dbo].[sp_TestWriteToFile] AS exec master..xp_cmdshell 'echo hello > c:\file.txt' exec master..xp_cmdshell 'echo blah de blah > c:\file.txt', no_output GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO exec sp_TestWriteToFile and here is one which appends data to a file: IF OBJECT_ID('dbo.sp_TestWriteToFile') IS NOT NULL DROP PROC dbo.sp_TestWriteToFile GO CREATE PROCEDURE [dbo].[sp_TestWriteToFile] AS exec master..xp_cmdshell 'echo appended data >> c:\file.txt' GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO exec sp_TestWriteToFile -- modified at 11:40 Tuesday 31st October, 2006

excellent. thanks for your prompt reply. yeah that will be interesting just to see what processes on my pc have an internet connection

You can also use a DTS package (which uses SQL Server Agent) Blog Have I http:\\www.frankkerrigan.com

Okay guys this one definatly tripped me up but ive managed to find a way to sort it. Firstly this table syncronisation is only a tempory job which i want for a couple of weeks so i didnt want to go through the whole replication bag. That is just to heavy-duty for what i need, and something that want be around in a month or so. So, after reading a post over at MSDN forums i found that the reason why the call to the stored-proc works inside Query Analyzer. Query Analyzer only requires the oledb to support ITransactionLocal. - But triggers require ITransactionJoin. I looked into distributed transactions but but couldnt come up with any work-arounds. It looks like there is a problem with our security settings and distributed transactions across the two servers. In the end i stumbled upon this hack and added a "COMMIT TRANSACTION" as the first line of the trigger and this worked. - I guess this is commiting the distributed transaction first. Then i added the call to my stored-proc which now works. the trigger now looks like this: IF EXISTS (SELECT name FROM sysobjects WHERE name = 'trig_testCopyDataAcrossDb' AND type = 'TR') DROP TRIGGER trig_testCopyDataAcrossDb GO CREATE trigger trig_testCopyDataAcrossDb on testbed FOR update, insert AS BEGIN COMMIT TRANSACTION EXEC servant.testbed..sp_AddRecord END

i have just found this good guide on using linked servers http://www.informit.com/articles/article.asp?p=21644&rl=1[^] thanks again