Search results for query: *

replace hyr '93' with '1993' all the field is defined as 4 char. i am trying to write a short program to change these 2 char input to a 4 char. my program is select table ... replace hyr ... can anyone help the newbie on the block?

what is the syntax for changing a year field from two char to four char. i have the field defined as 4 char. but the data is 2 char. there is no 2000+ years

In my report design there is a field called Sex. In my table the field has either a '1' for Male or '2' for Female. my question is how do I write code behind the textSex field on the report to display 'Male' or 'Female' or 'Unknown'(if there is no entry in the table field).

what is the syntex to add the contents of 2 fields? I have a memory variable to store the total. example field_a + field_b = mvsum thisform.txtsum.value = mvsum

I am in VFP7 and created a form with ssn as my input field and my key field. Set the (name) field control source to mastet_table.name. Have another field (agency) that is from table second_table that has the key field of ssn. The control source in the agency field is second_table.agency. How do...

I am in VFP7 and created a form with ssn as my input field and my key field. Set the (name) field control source to mastet_table.name. Have another field (agency) that is from table second_table that has the key field of ssn. The control source in the agency field is second_table.agency. How do...

How do i set the relationships between two files? I know how to create a key field in each table. What I need to know is how do i call fields from the child to display in a list box. example: parent-tbl ssn,agn,unit (key fields),name,yrs_serv child_tbl_1 ssn,agn,unit(key...

I have a table that has several fields (name,ssn,wage etc...) that occurs 5 times(as it was written in COBOL). My question how do you code in VFP for the occurrs without having to create multiple tables with the same fields. any help would be greatly appericated.