Search results for query: *

thank you, thank you, thank you

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

Thanks, I had tried the iif but did not have the syntax right. I am so thankfull for Tek_Tips because the VFP books just do not explain this stuff completely and give good examples,

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

Thanks to all I through trial and error found thisto work give me your opinion. store thisform.txtfieldA.value + thisform.txtfieldB.value TO mvsum thisform.txtsum.value = mvsum this is in the find button Thanks to all

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 split the occurs from the main table. they are defined (with a key field in both) name1 ssn1 wage1 name2 ssn2 wage2 etc... My question is how do call the ssn1 etc... to a listbox on the form

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.