Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Howard2002

    fix my sql PLEASE!!!

    thank you, thank you, thank you
  2. Howard2002

    fix my sql PLEASE!!!

    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?
  3. Howard2002

    simple question on changing year to 4 char.

    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
  4. Howard2002

    Fields on the Report

    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,
  5. Howard2002

    Fields on the Report

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

    adding contents of 2 fields

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

    adding contents of 2 fields

    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
  8. Howard2002

    Form not displaying data

    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...
  9. Howard2002

    Form not displaying data

    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...
  10. Howard2002

    setting relationships

    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...
  11. Howard2002

    handling tables with 'occurs'

    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
  12. Howard2002

    handling tables with 'occurs'

    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.

Part and Inventory Search

Back
Top