Recent content by StewartUK

Thanks for the offer Cetin. As it happens the back end of the new system in SQL Server Express. There are no blob or general type fields. I know I could have simply worked out the mapping from my data structure to theirs and transferred the data straight in with ODBC (which I partly did when...

Cetin is correct - we are changing our CRM database from the one I designed and purchasing another system. Therefore I need to output the data from the current system in to csv files so that it can be imported in to the new system. Stewart

Thanks Geoff & Mike. I found that the textmerge idea is simplest. Stewart

We are in the middle of migrating our database and I need to get my notes fields, which are memos, into a csv file. How can I do that? Thanks, Stewart

Sorry Filip, didn't mean to set off a load of comments. I was saying "or the French version" because I noticed that you had an IF...ELSE...ENDIF with different languages in each part. So you starred out the line m.xxbody = alltrim(tmpcroff.mailtekst) to test what was going on? Does that...

Hi Lee, Sorry about that, I see Mike partly clarified what I meant, although I was thinking of still building up a string for macro execution, so instead of" AND Surname = " + m.TargetSurnameyou would have" AND Surname = [" + THISFORM.txtSurname.Value + "]" && note the extra quotes...when...

Lee, Assuming you are using textbox or something similar for the user to enter search criteria you don't need to use variables - you could instead put the textbox value directly in as you build up the WHERE clause. Another thing you could consider is to loop through each object on the form...

Filip, Maybe I'm missing something but you have the line* m.xxbody = alltrim(tmpcroff.mailtekst) commented (starred) out followed by the linem.xxbody ="Geachte,"+CHR(13)+CHR(10)+CHR(13)+CHR(10)+ "Naar.....(or the French version). Otherwise I can't see a problem with the...

Oh yeah!! Doh! Thanks, Stewart

It's so long since I've used SET ALTERNATE TO that I've forgotten how to stop output to the screen when using ? to output text to the alte file. I've got Echo, Notify and Talk off. What's missing? Thanks, Stewart

Hi Howard, Well FDATE([filename]) will give you the modification date (or datetime), FOPEN([filename],12) can return whether or not the file is availble to write to (and so whether the routine has finished). However I have to ask why are you using the RUN command to an external program to do...

I'm looking into migrating my database from VFP to MySQL. Most of the data type mappings seem straightforward, but I'm not sure how to deal with the VFP logical data type - that is TRUE and FALSE. It seems that I can either use tinyint(1) or bit(1) for creating the field. What would you...

Steve - glad you found it useful. Also see the help topic How to: Assign Access Keys and Keyboard Shortcuts. It doesn't seem say it there, but if you use the \< with a label object caption, VFP will put the cursor in/on the next object in the Tab Order list. Stewart

Steve, Can I just check that you know about using this key combination\<in the caption of buttons? This creates a shortcut that responds to an Alt key combination. Stewart

Glad you found it useful Bart. Yes I do use a table for messages to users. I also use it to hold other data that the application needs such as dates when an event last happened, lists of users who should be informed when certain things happen and so on. The structure is in the form of, what I...