Recent content by rollypac

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?

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?

Thanks Tamar. It worked like a charm.

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?

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#?

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?

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.

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.

The spreadsheet came to me with the zip code column formatted as special/zip code and when I reformat as text it removes the 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.

The chart is a custom chart called floating bar. It says you need two sets of data. The picture of the chart appears to start at the first set of data and stop at the second set. When I use dates the bar starts at the first date but doesn't stop at the second date, it continues to the right...

Thanks, that did the trick. I had to put the not (isnull) portion before the <>&quot;&quot; to get it to work.

I have what you have but I also need to add cell, pager and fax numbers to the variable to print in the group footer. If {MEMBER.WORK_PHONE} <> &quot;( ) -&quot; then numbers := numbers + &quot;Work Phone &quot; + [member.work_phone}; if {MEMBER.EXT}<> &quot;&quot; then numbers := numbers...

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

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