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 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.
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.
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} <> "( ) -"
then numbers := numbers + "Work Phone " + [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 "Not supported. Details: IDAPI error: Message resource not found."
Any ideas on how to fix the problem would be...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.