Questions
drop down search in visual foxpro 9
Comments: 6
Hi I need a drop down search complete code, i have table with employee name, i want to add a combo on my form. When i enter 1st character of employee the drop down box automatically open a...
Showing the word wrap in a cell of a grid of Visual Foxpro
Comments: 2
I replaced the textbox with an editbox, but the word wrap only shows when that cell is highlighted. How can I get all cells in the grid to show the word wrap all the time?
Delete all records in a table that match records in 2nd table
Comments: 6
I am using VFP 6. I have 2 .dbf's, contract.dbf & deposit.dbf. Both tables have a field called tranid & have indexes setup on that field. I need to delete all records in deposit.dbf that h...
VFP Table to XML
Comments: 8
Hi: I am updating a VFP-7 app. where keyed data needs to be exported to an XML document. I am completely new to XML and totally ignorant. My client has provided a sample XML and "SC...
selecting records based on value populated in a field
Comments: 2
I am trying to copy records into a table that include a particular value as part of a field. As an example, if there were two records with the following values in a particular field: xyz-123-tom...
Populating Grids from controls
Comments: 4
I would like to populate a grid by entering a value in a text box and then use it to populate a grid with all records related to the entered value.
What is the Difference between FoxPro and Visual FoxPro?
Comments: 2
Does anyone know what the difference is between FoxPro and Visual FoxPro?
Extracting a csv file
Comments: 14
I know nothing about FoxPro, but I have data I need to export from a FoxPro database to a CSV file. I've installed Visual FoxPro x.xx on my server and can see the tables, and I know what fields I w...
Delete records based on SQL query
Comments: 6
Hi Experts, Have 2 files, icdist and ictran. icdist has 2 records for every tranno. ictran has 1 record for every ttranno. I want to delete all the fields from icdist where icdist.tranno=ictra...
SQL subquery
Comments: 6
Hi Experts, Have 2 files, icdist and ictran. icdist has 2 records for every tranno. ictran has 1 record for every ttranno. I want to select all the fields from icdist where icdist.tranno=ictra...
Exist Query
Comments: 4
I can grab the orders with the oline='FREGHT' but now I want to get only the ones that have oline='FREIGHT' > 1
IMPORT EXCEL FILE in Foxpro
Comments: 4
Hi Expert I am having problem importing Microsoft Excel 97-2003 worksheet. I am running VFP9 SP2. It stops working when try to import using import wizard. If I open it first and save it as...
incrementing in vfp
Comments: 2
Hi: I have a free table and I need to replace a field value (called auto; its an integer)with an incremental number starting at 1. Ithought I had a nice loop but the field does not update; neither fi...
a slash in a text field
Comments: 5
How do I get a text field in report writer to display the following N/A What I'm getting is N// I know this has special uses in VFP, such as disabling items in combo/text boxes...
Printing a Report Footer only on the LAST page
Comments: 26
Is there a way to get a footer to print only at the bottom of the LAST page of a report? I am printing an invoice that I want to print on 8.5 x 11 two perf paper to have a tear off payment slip at th...
Take a select make the results into a report and save as a P…
Comments: 3
I heard you can make your cursore reults into a report (instead of copy to .xls and formatting it) then save it as a PDF .. Anybody know of this procesess?
Using gdiplus.
Comments: 12
I am trying to get full text justification into a vfp report. I pasted some code but can't seem to find the library "system.vcx". I may have more questions after this is resolved, but at this point I ...
Check Windows Service status with Foxpro.
Comments: 7
Hi, I'm writing a Foxpro application and I need to know how to Stop/Start/Check the Status of a Windows Service. I can do the stopping and starting by running DOS commands, but I'm not...
Lost the plot
Comments: 13
Hi Guy's This is probably an easy question! But here goes. I want to run a LostFocus event to populate the fields on a form with data held in two different tables for a value already ent...
Help with query to DBF table!
Comments: 5
Hello, We get a dbf table with field page_number. Field page_number should have continuing values like: 1,2,3,..., 100. However, constantly we get the dbf table with missing...
Copy To Excel Type Xl5 - others?
Comments: 10
Is there a newer type other than Xl5? It doesn't seem to be a format type that Quick Office likes when trying to open on a iPhone attachment. Quick Office techs say it is an older type it must...
VFP 6 Drop-down Search?
Comments: 4
Hi, I am completely new to VFP and have been asked to look at some code that was written years ago and try to add drop down search capability. In this case it will be when a user starts typing in the p...
Can labels/text fields be both left and right justified in VFP …
Comments: 13
I have to duplicate a form that has a column of instructions in it. I would like to have it look like a newspaper column; ie. justified at both ends. Any suggestions ?
Take a user input and use it for the SQLEXEC()
Comments: 6
If I select the run x.prg on my menu I want it to prompt for a Startdate and EndDate so I can pass it through in the sqlExec()
How can i connect to a Firebird database from Visual Foxpr…
Comments: 2
How can i connect to a Firebird database from Visual Foxpro 9? Please give me some code examples.