Search results for query: *

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...

The errors have to do with the database and you have to just narrow them down. If you ignore the errors you get a faily full but unhelpful list of errors from the wizard in a table. Things I have worked out so far are: (1) Rebuild all files. (2) Validate and recover the database as this gets...

I have just transfered 40 machines(XP and win 98) from Netware to 2000 server. If you cant connect to the domain I found it is usually that the DNS entry in the network TCP/IP properties is not set to the server holding the DNS with your 2000 style domain reference. The machine then cant find...

The builder was runing the FVP 7 builder ::mutters about inheriting projects::. Thanks for the help folks.

I am getting a bulkinsert error using this. Is this the same problem that was fixed in 7 and they have re-introduced it? Regards

Check out the whats new in VFP 8 section of help as you are likely to find a few of these, my particular pet hate is the select distinct variant. The more common one of these is because of memo fields which you can at least cast into strings (although you have to pick a length to get). The...