Search results for query: *

Hi everyone, A very good friend of mine approached for help with his recent Foxpro application problem. His application was completed with Foxpro 6 around 2004/2005 and has been running on various windows platforms since then with no problems. The previous system the app ran smoothly with was...

Hi there, In an application a report no longer runs, probably caused by a system crash. I trace the problem down to a view used by this report. In that view, a filter variable “?vp_periode” is used which causes the following error message: “operator/operand mismatch°, but if that variable is...

Hi all, Could someone help me with the following programming problem? In a form I have 2 identical list boxes (LB1 + LB2). LB1 displays some fields of a record from the content of a view while LB2 is empty. With a dlbClick on any line in LB1 copys this line to previous empty LB2. A dlbClick...

Hi all, I start a script from a command button which contains a statement within a loop such as: "SUM lv_revisor.stunden TO lnGesStd". The result is correct but each time it is executed the code text "lv_revisor.stunden" is placed all over on the form. How can something like that happen? Klaus

Hi all, Could someone give me a tip on how to transfer a table (customer) from one database to another database with the entire contents? Would it be necessary to first convert the table (customer) into a free table? Regards Klaus

Hi, I access an Excel table like this: goExcel = CREATEOBJECT("excel.application") loBook = goExcel.Workbooks.Open(lcSourceFile) goExcel.Visible = .T. lnRows = loBook.ActiveSheet.UsedRange.Rows.Count lnCol = loBook.ActiveSheet.UsedRange.Columns.Count But I do not know how to transfer the...

I created a view from 2 tables and used this view to build report. Within my app the original view data are manipulated and the results are placed into a target view with the very same structure as the original view. Is it possible to use my report to display the data from my target view? Of...

Hi all, My W7-32bit System is down and i had to install VFP9 on a W7-64bit System. After moving my apps to the new system and setup the search path but when I load a project a bunch of files cannot be found. Such as wzedit.msk, wzclose.msk, _cancel.bmp, _save.bmp and more. Could it be that some...

Need some help again! I created a new table in a wrong folder and use it already in a form. Now I wanted to move that table into the correct Data folder. So i removed that table and copied it into the Data folder then tried to add the table there. Now a message appears: Cannot add this table...

Renaming files changes uppercase to lowercase, such as lcCSVname = "0207986742_EUR_20161026_100259.csv“ lcNewCSVname = "E1-0207986742-25AUG2016-26OCT2016.CSV“ RENAME &lcCSVname TO &lcNewCSVname Result e1-0207986742-25okt2016-26okt2016.csv Is there a way to force it to uppercase? Klaus

Will there be problems running VFP 9 apps on a Windows 10 64-bit system, because doing so an error message appears telling that "DLL/OCX is not registered: RegSvr32". What i found around here is that there is no VFP 64 bit version available. Does that mean VFP 9 apps will only run on 32-bit...

I hvae installed a new printer on my W7 system and set it as my new default printer. In my VFP main application program there is a statement SET PRINTER TO DEFAULT, but now most reports are not printed any more. What could be the reason for that? Klaus

While scanning some name and address lines I got some strange results from the ATLINE function. To find out what is going on, I run some test like this: X1 = "Gxxxxxxx Sxxxxxxxxxxxx Uxxxxx Oxxxxxxxxstr. 56 A D-86156 Augsburg" ?ATLINE('D-', X1) >>> result = 2 but should be 1 X2 = " D-86156...

Some of my reports will be printed two times and I cannot find why. Usually my print statements look like this: lcReportSelect = ThisForm.fm_ReportSelector(vp_bktyp) REPORT FORM reports\&lcReportSelect TO PRINTER NOCONSOLE Because these commands are correct, so the problem must be somewhere...

Hi, I have a MS Word document with some MergeFields on it and want to fill these fields using vfp. Untill now i was only able to open the MS Word document but could not figure out how to access the MergeFields. Can any one help me out here with some codes on how to to access those fields...

I’ve 2 identical listboxes in a form. One of them gets filled by a search routine. Now, by clicking on one of the found item in the listbox, only this row should be copied the other identical listbox. What would be a good solution to do that? Thanks! Klaus

A form cannot be modified any more but works correctly when starting it from Run. When I try to Modify it, a blank window pops up and an object window also appears in it such as Form1.Init. Because it is not shown as a scx-file no modifications are possible at the form itself. What could...

I'm using the picture buttons (picbtns) in one of my form but do not need all function. Therefore i want to disable all those buttons not being used from the buttonset. When the cmdAdd is set to Enabled = .F. the add button appears shadowed in the edit mode but running the form the add button...

Hi, I've a report and when run it from my command window like this: REPORT FORM reports\praxisbericht.frx PREVIEW, the report appears in a preview window. However, when place this command in a menue procedure nothing happens, no preview no error. Any idea what might be wrong here? Klaus

When executing a SQL "insert into" command with 14 fieldnames and 14 value expressions, it returns an error message "Too many arguments". The syntax shown from help for the insert command does not indicate that there are any limits for the arguments. INSERT INTO dbf_name [(FieldName1 [...