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!

  • Congratulations bkrike 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: *

  • Users: rollypac
  • Content: Threads
  • Order by date
  1. rollypac

    Not an object file message

    I am running a program (basic2.prg) which opens and closes alot of tables. It will run if I only use 17 tables when I add the 18th one I get this messsage - basic2.fxp is not an object file. Any ideas why I am getting this message and how get it to run using more than 17 tables?
  2. rollypac

    find a character in string

    I need to determine if a character field contains the character @. if found copy to a field. Any ideas on an easy why to search a string?
  3. rollypac

    add item to a list and check that it's not on list

    I have a file with an id# and table id#. I used seek to check if the id# is there. How do I get it to look at all instances of that id# and check if the table id# is there or not, and add if not?
  4. rollypac

    mark records already read so duplicates are not created

    My main table has multiple family members with the same envelope #.I have a 2nd table with envelope # as the key. Can I mark the records in the 2nd table after it reads them so it doesn't read them again when it gets to the next person with the same envelope#?
  5. rollypac

    How do I index on two fields?

    I have a family # and an individual #. I need to index on both fields. The family is a character field with numbers so I am indexing on the value; the individual field is numeric. my code looks like this for the family: index on val(alltrim(familynum)) to 23idx How do I add the individual?
  6. rollypac

    create variable with a len of 20 using a char field of varying length

    Working in MVFoxpro 6. The original character field is 9-12 characters.I need to create a variable with this field whose length needs to be 20 char no matter how long the original field is, with the blanks at the end. Ex"ada 2003 " Thanks in advance for any help.
  7. rollypac

    put day, month, year fields into date format in foxpro

    My data started out in excel and then saved as a DB4 file. I have date, month and year fields that I need to put into yyyymmdd format. The month and date fields do not have leading zeros, the year is 4 digits. Any sugestions on how to create the format I need would be greatly appreciated.
  8. rollypac

    Import zipcode from excel to dbf format without loosing leading zero's

    I have zipcodes that are in zipcode format in my speadsheet (06549, 05489). When I import or save them as dbf format I loose the leading zero's. Any ideas how to retain the leading zero's or add them after the fact? When they are in the dbf format they are characters.
  9. rollypac

    Pulling list of numbers some with an ext and some without

    In a subreport, I am pulling in a list of workphone, workphone ext. cell, pager and fax numbers, in that order. if {MEMBER.WORK_PHONE} <> &quot;( ) -&quot; then numbers := numbers + &quot;Work Phone &quot; + [member.work_phone}; If I pull in the work phone ext if {MEMBER.EXT}<>...
  10. rollypac

    Idapi error when opening reports on a different machine

    I have loaded CR 9 on a new machine. Why can't I preview reports created on another machine. It allows me to open the report in design view. When I try to preview I get &quot;Not supported. Details: IDAPI error: Message resource not found.&quot; Any ideas on how to fix the problem would be...
  11. rollypac

    Displaying records horizontally without spaces in between

    I am pulling children's names into my report using a sub report. I can get the names to print horizintally but they need to be separated by a comma with only one space between and parans around all names. This is what I am getting: Lisa Richard Troy Jason I need it to look like...
  12. rollypac

    Using the string function left(str,length)

    When I use the string function left(str,length)it doesn't pull anything in. If I use the right(str,length) it pulls in what I want. I have declared a string variable to use for the string. Both the functions are pulling from the same field. Any ideas why I'm not getting anything when I use...

Part and Inventory Search

Back
Top