Search results for query: *

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

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

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

I don't think I've asked this before... I use the Redemption dll to send emails and make calendar entries in Outlook. This is all working fine, except for one user who has upgraded to Outlook 2007. With that, I find that the emails just get stuck in the drafts folder. Has anyone else had this...

I am planning a move my data from VFP to MySQL. I have a VFP table of flags (which can be applied to contacts' records to show what they are interested in and so on) in which I have a field called AfterApply. This field's default value is a parameter statement. In several records I have...

My application, built in VFP 9 SP2, recently threw a Function argument value, type, or count is invalid error on the lineinval1 = INKEY(0.06,[HM]) which is in the Click method of a command button. Can anyone suggest how that might have occurred? The variable inval1 wasn't declared in the...

I'm sure I've read that there is a setting that will stop the open table dialog box (the one that lists all the tables in the database) from appearing. This is in a compiled application. Can someone remember what it is? Thanks, Stewart

I always thought that if you had say an image control on a form, that the file you set as the Picture property was automatically picked up when building the project into an exe, but it's not happening. Can anyone confirm or deny that? Thanks, Stewart

I've got 2 queries. The first isSELECT Months.Date, ; (SELECT SUM((Months.Date - AllStaff.Started)/36500) ; FROM AllStaff ; WHERE Months.Date>=AllStaff.Started AND Months.Date<AllStaff.Ended) ; AS Centuries ; FROM Months ; INTO CURSOR Totals Where Months.Date...

Is it possible to set the default location for documents to a folder on a network ie not on C: If so, I'd really like to know how. Thanks, Stewart

I'm looking into upsizing our existing VFP application to run with a SQL Server back end. The Standard version looks right for us. Can anyone edvise me what the Developer version is exactly? If we're definitely going to go for SQL Server anyway, is there any point in buying the Developer...

I have a table with fields ShowDate & EditDate. Here's a selection of records:ShowDateTime EditDateTime a 06/03/2008 00:00:00,/ / : : b 03/03/2008 00:00:00,/ / : : c 06/03/2008 00:00:00,06/03/2008 15:30:55 d 03/03/2008 00:00:00,06/03/2008 11:20:22 e 03/03/2008...

VFP9 SP2 I have a table of donations. There are 2 date fields (one for GBP donations and one for foreign currency donations), at least one of which must have a date in it. At the moment I have the ruleIIF(EMPTY(ForeignDate), NOT EMPTY(Date), .T.) When trying to append a record, this is OK...

I've implemented sonething where my application waits for the user to copy a url from somewhere. I set a variable to the _CLIPTEXT value and then run a DO loop until the _CLIPTEXT value changes. Here's the code so far:OriginalCliptext = _CLIPTEXT MbResponse = MESSAGEBOX("Waiting for you to copy...

I found thread1254-1301901 which was extremely useful, thank you MikeLewis & FatSlug (what a name!). So I've got GETDIR([o:\patricia\pix],[ctext],[Pick a picture file],16648,.t.) I got 16648 from NewDialogStyle(64)+BrowseIncludeFiles(16384)+NoNewFolderButton(200) which does get a nice list of...

Hi, Working in VFP9 SP2. I'm wanting to show html pages in a pageframe on a form, but they don't work very well. I have one control that shows our Intranet home page. In the form Init event I have:THIS.pgfMain.Page2._WEBBROWSER41.Navigate2([http://10.0.0.1/intranet/top.htm]) However, when I...

In VFP9 I have a form from which I am calling a report. Service pack doesn't seem to be an issue because I get the problem with SP1 & 2. I have REPORTBEHAVIOR set to 90. With one report, I am getting the following values reported on the calling form: These lines are output just before the...

We are talking about building a new website and one thing we have discussed is allowing our supporters to view/change the data we have on them. I've heard that it is very difficult to integrate a new website to an existing databse (the comment was I think not specifically related to VFP...

Other than choosing courier new as font, is there a way of getting the columns on a listbox line up correctly when the length of items is different? For example: Date Amount Claimed 03/12/2007 7.46 N 22/11/2007 350.00 Y Thanks, Stewart

Using VFP9 SP2 I have the following SQL:SELECT TOP 15 Claimed, SUM(Amount)*TaxRates.taxrate/TaxRates.GrossUp AS Total, {} AS FirstDate, {} AS LastDate ; FROM Donation ; JOIN TaxRates ON BETWEEN(DonDate, YearStart, YearEnd) ; WHERE NOT EMPTY(claimed) ; INTO CURSOR curTemp GROUP BY 1,3,4...