Question about Microsoft Visual FoxPro Professional Edition 7.0 for PC

1 Answer

Auto calculated field in Foxpro (2.6 prefered)

There are few fields in foxpro database say a,b,sum,product. I want to enter value in a and b and want sum and product field auto calculated - so that I don't have to put values there anbd quickly enter next value in next record.

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Vice President:

    An expert whose answer gotĀ voted for 100 times.

    Sniper:

    An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.

  • Expert
  • 64 Answers

Code example:
// all fields are numeric type
USE example APPEND BLANK REPLACE field_a WITH 25, field_b WITH 4, field_sum WITH field_a + field_b, field_prod WITH field_a * field_b APPEND BLANK REPLACE field_a WITH 60, field_b WITH 5, field_sum WITH field_a + field_b, field_prod WITH field_a * field_b
Result: field_a field_b field_sum field_prod 25 4 29 100 60 5 65 300
Don't use keywords as field names (ex. SUM).
Best regards

Posted on Mar 08, 2011

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

A tool for repairing DBF Visual Fox Pro databases


Try eRepair DBF works with a wide variety of database programs for recovering data from files that have become damaged or corrupt. eRepair DBF can recover the file structure which includes table fields that make up a DBF file, information contained in the memo fields, and a variety of records that are commonly included in DBF files.

For more: http://dbf.erepairtools.com/

Jun 27, 2015 | Microsoft Visual FoxPro Professional...

2 Answers

I want to create a function in access to calculate a total. Where can I find a step by step guide?


If you already have a field where you want the total to be if you right click on the field and go to properties and find out the name of the field and also the 2 or more other fields that you want to add or multiply together then you can make the total field equal to the formula ie

if you have 3 fields

Field one = value1
Field two = value2
Field total = total

in design mode you would right click on the total field and go to properties and in the properties there should be a field where you can enter a formula.

in there you would enter something along the lines of

=value1.value + value2.value

Then when you have it normal view ie you open it, it should always add the values together and put the sum of them into the total field.

If you want an example database post back and I will create one.

Apr 13, 2009 | Microsoft Office Access 2003 (077-02871)...

2 Answers

How to recover a database on known *.bak file?


Completely - in any way. If you find also tbk the file - then is possible. bak is
backup copy of the dbf file, tbk - a backup copy of fpt (there a memo of a field are).
However you were perhaps lucky, and actually fpt the file wasn't cleared.
And it is possible "to restore" of course simple renaming of bak file into dbf file. Of course then have to be reindexed the table, and if the structure changed, in general, to recreate the indexes from scratch. and perhaps "to treat"
the container Database dbc/dct (if you use it of course).
If so it doesn't turn out, then try to restore through DBF Viewer Tool. It well restores.
http://www.dbf.viewertool.com/
Come here on a forum and look at councils for this subject is there.
http://www.filerepairforum.com/forum/databases/databases-aa/dbase-iv-clipper-foxpro/1355-help-to-repair-dbf-file

Good luck!

Feb 10, 2015 | Microsoft Visual Fox Pro 9.0 - 34001231

1 Answer

Create javascript code whose function is to compute the sum of two inputs?


Hello,
The following code will dynamically calculate the some of the first two fields:



Enter first number:
Enter second number:
Their sum is:

Best Regards, Ben

Jun 29, 2011 | Computers & Internet

1 Answer

How to add a picture in a field in Visual foxpro. I could do it earlier in Foxpro for Windows with the APPEND GENERAL command but now it only saves the filename and not the actual picture. Please help.


The type of the field should be GENERAL.
Try this command: APPEND GENERAL <fld_name> FROM <url_file>
For example: APPEND GENERAL my_gral_fld FROM 'c:\my_file.jpg'
Good luck!

Jan 11, 2011 | Microsoft Visual FoxPro Professional...

1 Answer

Please give me the procedure how to import foxpro files in tally 7.2


To import data from a FoxPro database, use the Microsoft Visual FoxPro ODBC driver. To do so, follow these steps:
1) Click Start, and then click Control Panel.
2) In Control Panel, double-click Administrative Tools.
3) In the Administrative Tools window, double-click Data Sources (ODBC), and then add a new ODBC data source for your FoxPro database or tables by selecting the appropriate Visual FoxPro driver.
4) Start Access, and then open your Access database. 5) On the File menu, point to Get External Data, and then click Import. 6) In the Import dialog box, click ODBC Databases in the Files of type list. 7) In the Select Data Source dialog box, click the Visual FoxPro data source that you created in step 3, and then click OK. 8) In the Import Objects dialog box, click the tables that you want to import, and then click OK.

Jul 05, 2010 | Computers & Internet

4 Answers

HOW TO SOLVE VFP FILE CURRUPT WHEN POWER FAILURE


At times, you may view that your MS Visual FoxPro 9.0 database is behaving abnormally. Some of the abnormal symptoms could be an error message while opening any database table, invalid characters in place of pre-defined values, and and more. The main reason for abnormal behavior of the database is its corruption due some logical crash. Few common reasons for corruption of MS Visual FoxPro 9.0 database are abnormal termination, faulty network devices, simultaneous modifications, conflicting third-party software, and incompatible service packs.
To overcome such database corruption scenarios, the user can use an up-to-date backup and perform restoration. However, restoration fails in cases where the user either forgets to create a database or the database backup itself gets damaged. In such cases, the database users can use a third-party DBF File Repair application to repair his/her corrupted database.
To illustrate the above case, consider a real-time scenario wherein you execute a query to modify your MS Visual FoxPro 9.0 database. While the query was performing the modification, the system shutdown due to power failure. However, the next time you tried to mount the database, you encountered an error message that did not allow you to access the database records. Moreover, the same error message appears every time you try to access the database.
Cause:
The root cause for the error message is MS Visual FoxPro 9.0 database corruption due to improper system shutdown.
Resolution:
The database corruption error message can be surmounted by following the below steps:
Use a complete database backup and perform restoration. However, in case of database backup unavailability, you will need to search for a commercial DBF File Repair utility.
A third-party DBF Repair application uses effective repair techniques to repair logically damaged MS Visual FoxPro 9.0 database and restore it at a new and safe location. The original database during the repair process remains intact. The tool is easy-to-understand and allows even a non-technical person to perform repair.
DBF Recovery Software is a comprehensive solution to repair databases created in MS Visual FoxPro 9.0, MS Visual FoxPro 8.0, and MS Visual FoxPro 7.0. The tool also repairs databases built in dBase III, dBase IV, and dBase V. Supported by Windows 7, Vista, 2003, XP, and 2000, the DBF Repair tool creates a new repaired file that can be attached to existing database.
Tanvi Sharma is a self employed Internet entrepreneur and product reviewer. This DBF Repair utility is extremely useful when the dBase and Foxpro database gets corrupted due to internal program errors, hardware malfunctioning, accidental deletion of data and more. This DBF Repair software repairs all types of database components including table name, column name, column data type, indexes and primary keys.

May 31, 2010 | Microsoft Visual FoxPro Professional...

1 Answer

How to get 1 value from report to another form in ms access


You'll have to use a separate Group By query to get the summed data you are looking for, you cannot pull it off the report.

Feb 06, 2009 | Microsoft Computers & Internet

2 Answers

Convert my database from dpf to mdb


Use access to import external data. It can read dbf and create mdb

Jan 06, 2009 | Microsoft Visual FoxPro Professional...

1 Answer

Create access mdb file by vfp code


Try this

#define dbLogical 1
#define dbNumber 2
#define dbInteger 3
#define dbLongInteger 4
#define dbCurrency 5
#define dbSingle 6
#define dbDouble 7
#define dbDateTime 8
#define dbBinary 9
#define dbText 10
#define dbOLEObject 11
#define dbMemo 12
#define dbReplication 15
#define dbDecimal 16
if file("C:\accesstest.mdb")
delete file c:\accesstest.mdb
endif
public oAccess
oAccess = createobject("Access.application")
oAccess.visible= .t.
newMDB = oAccess.NewCurrentDatabase("C:\accesstest")
newtable = oAccess.CurrentDb.CreateTableDef('testtable')
with newtable
.fields.append(.CreateField("Field1", dbLogical))
.fields.append(.CreateField("Field2", dbNumber))
.fields.append(.CreateField("Field3", dbInteger))
endwith
oAccess.CurrentDb.TableDefs.append( newtable)
dbc2Convert = "\\tpdfiles\data\dfreeman\tip\data\rta\rta"
open database (dbc2convert)

dbgetprop(rta,"table",)

After it runs you will need to close the MDB and reopen it.

Oct 15, 2008 | Microsoft Computers & Internet

Not finding what you are looking for?
Microsoft Visual FoxPro Professional Edition 7.0 for PC Logo

Related Topics:

474 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2888 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18409 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...