Recent content by MichaelHawksworth

Thanks guys, I used scan..endscan instead in the end. The code works fine in Informix and Update should allow sub-queries... 'should' is always to be taken with a pinch of salt tho! Regards Michael Hawksworth

Hi Folks The following code produces a "Function Name is missing )" error when run. I am setting ctd_sPostCode from the postcode field from the curUpdate cursor where the account codes match. UPDATE vw_contactdetails ; SET...

For those of you going steadily up the wall trying to automate mailmerges etc. (particularly with Office XP) here is a good place to start. Also includes lots of examples for VC++ etc...

Thanks, much better. To sumarise, you need to prefix all the columns with '\' not just the first one. (P.S. Thats why the post said Multi-Column ;) ) Regards Michael Hawksworth

I have tried that. If it has only one column it is fine if it has two or more it doesn't work. Regards Regards Michael Hawksworth

Nah that doesn't work, completely ignores it. Regards Regards Michael Hawksworth

While prefixing an item with "\" disables the item (cant select it with mouse) it does not change the item to the disabled colours. Makes it a little difficult for the users. At least as far as I can tell! Regards Regards Michael Hawksworth

This is an artical posted by Randy Pearson that pretty much details the above. While I haven't tried it I would guess that adding your own 'get' methods would work as well. http://www.west-wind.com/wwthreads/ShowMsg.wwt?MsgId=0Y40USMEN Regards Regards Michael Hawksworth

My nice token factory code has gone belly up following a move to .net (2003). I get a message saying covariants aren't allowed in .net. Q240862 says this is fixed in .NET! Does anyone know if this will work or if there is a patch? Ta Regards Michael Hawksworth

To expand on Mikes work a little for anyone interested. This is with GW 6.5. The line: objMessage = objMessages.Add("GW.MESSAGE.MAIL", "Draft") can be shortened to objMessage = objMessages.Add("GW.MESSAGE.MAIL") as the draft option is the default. However, if...

Jim If you are simply sending emails SMTP and MAPI are OK but if you want to use GroupWise's tasks, document links etc you need to do it direct. Regards Regards Michael Hawksworth

Excellent work Mike. Saved me lots of wasted effort! Cheers. Regards Michael Hawksworth

I have just come across this on a form myself. They fail to close if you have any public variables created in LOAD or INIT. It also seems to only effect variables pointing to objects not base types. If you release your variables first it should work. e.g. RELEASE oCRApp...

For those interested, its a bug in VFP8 as well! Michael. Regards Michael Hawksworth

If I compile and run a program without the debugger I have no problems. If I use the debugger the program hangs my machine (XP Pro) before it reaches the first breakpoint (even if this is on the first line in main). I can find the odd reference to others with this problem but not fix etc. Any...