You can use an SQL TRIGGER to create these records automatically whenever a modification is performed. (see CREATE TRIGGER in the SQL documentation). Also, you can use the COLUMNS_UPDATED() function to determine which columns have been changed (in order to produce the text for the column name). Hope this helps. Regards, Alex

Ohh... thank you, thank you! :-D I searched the page for 'lonely' and 'loneliness' to no avail (and 'alone' but the matches weren't really relevant). And I must have missed it in my quick skimming for anything that seemed appropriate. :doh: You're wonderful! :rose:

I was searching for word for a certain phobia and stumbled across this little beauty. Sesquipedalophobia- Fear of long words. http://www.phobialist.com/[^] How very cruel. :laugh: btw. If anyone knows a word for the fear of being lonely... so far i haven't found one. :rose: Cheers, Alex

eeekkk... :eek: sorry lads. I guess I just don't CP enough. Shame on me!! :sigh:

Aoccdrnig to rscheearch at an Elingsh uinervtisy, it deosn't mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht the frist and lsat ltteer is at the rghit pclae. The rset can be a toatl mses and you can sitll raed it wouthit a porbelm. Tihs is bcuseae we do not raed ervey lteter by it slef but the wrod as a wlohe.

I could be wrong but... If you are an Admin can you not go and set yourself as the owner of the said files and then add permissions for yourself? I believe this should work unless the files have been saved encrypted thru EFS. Regards, Alex

I just had the sudden urge to fly around in a chopper blasting Russian tanks (as you do)... So i went searching for my Operation Flashpoint CD. As I hadn't played it in a while I figured it'd probably be in a big box of stuff i had stashed up high on top of a cupboard. Forgetting that my Microsoft Sidewinder force feedback 2 joystick was sitting on top of the box I started to pull it down... The joystick landed in my newly emptied waste paper basket and the stick snapped from the base. :( (I can't help but think that if i hadn't emptied the bin the masses of crumpled paper may have cushioned the fall) I guess that's gravity's way of telling me to get back to work... *sigh* And yes, the joystick is still sitting in the bin, i'm not sure if much can be done to resurrect it.

I've recently developed an interest in (digital) photography and have been toying with the idea of developing my own solution for archiving my photos. Due to my lack of spare time at the moment it will probably take a while to get off the ground (and might not stay in the air long when it finally does :()... but if anyone's interested in offering feature suggestions or advice I'd be delighted :) Thanks, Alex

Colin Davies wrote: Thanks, so he is a well known charlatan AFAIMC Isn't that the only type?! X| Colin Davies wrote: I agree your App was presented badly by you, but you were not promoting it. Exactly. And while i do agree with the general message of his article i think he should have chosen an example which was in fact malicious, or at least done some respectable research into the behaviour of my app. I'm listening to a streaming version of his last broadcast and it seems that this guy is similar to the one on your local station. IMHO its almost impossible to solve computer related problems in 2 minutes of talkback! He's offering advice like 'upgrade your OS' and even telling one guy that he needs a rebuild. ICK... it's 9pm, still 30 degrees and i'm sweating like an elephant, think i'll head for the pool :-D

He writes a weekly column called 'Hands On' for the Australian Financial Review (appears in the IT section on Tuesdays). He also appears fortnightly on ABC Melbourne talk back radio helping people fix their computer woes. I'm going to listen to one of his broadcasts in the hope it is amusing :) Here is a page briefly about him courtesy of the law firm he works for. http://www.asw.net.au/people/peter_moon.shtml[^] Enjoy yourself :p ~Alex

LOL! :laugh:

.S.Rod. wrote: Coding a software program is only 50% of the whole job. Another 50% is required to "advertise", or qualify your program. Sadly, the effects of this daily job are only rewarded in the long term. That's at least what I have learned from the past as a shareware/freeware author. This is the first piece of software i have written that has been released to a public audience, and that has sort of happened accidently. I guess in hindsight it is easy to see that telling a few friends to try it out can lead to a large number of users. Six Degrees right? :) .S.Rod. wrote: My suggestion is you automatically open a readme.txt document when PsychoFolder is installed, and provide full details of what is installed, how to use it (even if that looks obvious), and how to uninstall it (shortcut to add/remove programs, plus the manual procedure : all the registry keys to be removed, and the fully qualified filename). Thanks for the suggestion. I think the readme file is a great idea. I think I'm going to push promoting the software up my list of priorities, seeing as it has already been doing and OK job of promoting itself! Cheers, Alex

.S.Rod. wrote: But I am telling that you way you promote it (no feature list at all for instance) is very UNLIKELY to make people feel like downloading it, first, and then installing it. I'll certainly agree with that. I have not made any attempt to promote this software because i simply haven't found the time to bother. I stuck it on the web and told my friends about it, informing them what it did either verbally or a quick blurb in an email. They have downloaded it, liked it and then told their friends what it does... As i said, i have been intending to make a web page and then promote it a little. But I just haven't had time. .S.Rod. wrote: A good thing to would be to make sure your program installs without admin rights, so at least if I install it with reduced rights (no registry access unless explicitely permitted, etc.) we can trust much more already about the fact your program is not a virus or whatever one might think of. The install copies one file (a dll) and then registers this dll in the windows registry as a context menu shell extension for folders. I realise registry access could be seen as a potential bad sign - but it has to be done to register a shell extension.

I’m aiming to guage the opinion of software developers to a problem I am facing. I am still a student studying Computer Engineering and Science at university. I have a passion for software development and during my spare time I develop software on a contract basis. I am a director of an Australian company named PsychoSoft Pty. Ltd. We have developed a number of apps for local government as well as some private work. Earlier this year I developed a context menu shell extension for myself (to improve my own productivity). I made a little installer for it, posted it on my webspace and provided the link to a number of friends I thought would find it useful. Quite a number of them did, and they told their friends about it, and so on and so forth. It is probably important to note that I am still a student and presently we have enough work to keep me very busy, and as such we have not yet developed a company website. If you go to www.psychosoft.com.au[^] you will see the extent of our development. It consists solely of a boring under construction page with a link to the shell extension I wrote (so my friends could find it easily). This evening I stumbled across the following article which appears to have appeared in the Australian Financial Review on the 17th September of this year. While I respect the authors points and agree that many users will simply install or run anything and that this is a security concern, I do not appreciate some of his comments nor his tone. And although he concludes that he *thinks* my software is not malicious and even calls it a ‘very good little utility’, he has also referred to it as ‘a potential time bomb’. I feel some of the comments he has made are defamatory. And I also feel that he should have made an attempt to contact me before writing the article. As essentially a starting company, this negative publicity can not be good. The article can be found here: http://afr.com/it/2002/09/17/FFX97NU956D.html[^] I also stumbled across a pdf of the same article somewhere else. I would really appreciate the opinions of this community. Do you think the article is defamatory? Do you think I should do anything about it, even if it is providing my friendly feedback to the author? Do you think I should

Hi, Is it possible to use table variables as parameters to a stored procedure? What i would like to do is: CREATE PROCEDURE [dbo].[spSetBillingPlan_Custom] @ContractNumber integer, @ArgTable TABLE(phasenum integer, perc decimal(5,4)) AS --yadda yadda yadda But it doesnt seem to like the table arguement. If it is not possible, can anyone offer an alternative solution to passing a variable amount of data to a stored proceedure? Thanks and Regards, Alex

Howdy, I have a stored procedure in MS SQL Server 2000 which performs some inserts and then a select statement. If the inserts fail (for example violating primary key contraints) i still would like to retrieve the results of the select statement. To illustrate this: insert into table values (1) insert into table values (1) /*violates primary key*/ insert into table values (2) Select stuff from table executing this in the query manager i get an error message about the failed insert and a grid for the select statement. Using OLE DB, The Execute() method fails with DB_E_INTEGRITYVIOLATION and no result set is returned! Is there anyway to either suppress the error information generated by SQL Server so that the client is never informed of the failed insert, OR is there anyway to get OLE DB to give me the result set? I have simplified the problem a lot so it might seem like I'm trying to do something senseless. Essentially I attempt a bunch of actions and the select at the end returns a bunch of error information. :) Any assistance would be greatly appreciated! ~Alex Deem

Thank you, thank you, thank you! :-D

Hi, I'm kinda new to ATL and as such I'm after a little guidance :) Say i want to be able to get Cheeseburger objects from Maccas. ie. A client would have to create a Maccas and then ask it for a Cheeseburger. I can create the Maccas class using the ATL create object wizard, but i am unsure how i should create the stub code for the Cheeseburger object. Do i use the object wizard again? Would this not unnecessarily create a CoClass for the object and make it seperately instantiable (you don't have to get Cheeseburgers from Maccas anymore). How else do i do it? In case it is important its desireable to support c++ and VB automation clients (scripted from office macros). Thanks a bunch! Alex

Howdy, I'm afraid im not going to be much help, but i believe i may be experiencing the same problem. I have posted a question which may interest you to read: click If you make any progress I would appreciate it if you'd let me know the secrets ;) Cheers, Alex

Howdy, I'm currently undertaking to convert a c++ application which uses DAO to access an mdb file to using OLE DB to connect to MS SQL Server 2000. The UI for part of the application is split in two, allowing the user to browse records in the top portion [in a table] whilst allowing a specific record to be edited in the bottom portion. To implement this in DAO using a single recordset was simple. The bottom view requests the data of a specific record as well as a bookmark to the record. When the record is to be saved we jump to the record identified by the bookmark, set the data appropriately and call Update(). In between getting the initial data and the save process other records may have been retrieved from the database if the user browsed around in the table view. I am currently trying to move this functionality to OLE DB. According to the MS SQL Server documentation i have a choice of only 2 cursor types if i want read/write access. The cursor type that fits perfectly my needs is the keyset, as it allows bookmarking. The other type (dynamic) doesnt allow bookmarking. I am setting the properties of the command object in order to obtain this keyset cursor. This all seems to work fine when i view a table which has a Primary Key. However, if i try view a table which does not have a primary key, i receive an error when i attempt to Execute() the command. This seems logical because there are no fields from which the keyset can be created, so it fails. :(( How do i get around this? Am i missing something? I am annoyed because it was so simple and smooth with DAO, it somehow allowed me to obtain bookmarks even if there is no key information in the result set. So how can i achieve the same thing using OLE DB and SQL Server? Any suggestions at all would be great! I am about at my wits end! :confused: Thanks!