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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gregjohn

  1. gregjohn

    Crystal

    My goal is to have foxpro scan down a table of tickers and pass the ticker to a crystal report. For now, I have just hardcoded IBM as my ticker. The crystal report connects to a sql server. I have never done this before, and am really not a programmer, but have come up with the following...
  2. gregjohn

    Import to Memo Field?

    I have an adobe form that I am exporting to a txt file and then saving as an excel worksheet. The adobe form allows the user to a comment section in which they can clarify some answers. As long as the answers are less than 255 characters, everything gets imported ok. However, that is not...
  3. gregjohn

    Remote View -- Line Too Long

    I am using vfp 8 and a single table. Do you know if the lengths you described for vfp 9 are the same for 8? While my fields are long, they are not 128 characters. The fields exist in a table right now.
  4. gregjohn

    Remote View -- Line Too Long

    I am in the process of converting vfp tables to sql server express. I have the connection made and have used remote views. For several tables this works fine. However, I have a few tables that, have very long field names. When I try to create the remote view I receive an error that "line...
  5. gregjohn

    Corrupt Project?

    I think the database is corrupt. I tried the open database from the command prompt and received the same "index does not match the table". Also, I tried to open a table and received the error "the database for file .. could not be opened. Would you like to try and locate or delete the link."...
  6. gregjohn

    Corrupt Project?

    I was in the process of rebuilding my project when I had a hardware failure. The project opened, but for the key database, upon trying to drill down says, "no drilldown information is available for database name. Database may be invalid. Upon clicking the validate button, I get the error...
  7. gregjohn

    Index Suggestion

    Thanks for your input. Stella740pl, I understand what you are suggesting but there is one more component. I have created the index files and I can calculate how many records match a certain sector code with the for command. No problem. But at this point I still have my complete table of...
  8. gregjohn

    Index Suggestion

    Sorry Mike, I'm not really sure I follow. I need to index by variable (say price/earnings) but for only those records whose sector code matches sector_code_a. Is your suggestion to create an index on sector_code for each one of the 12 sectors? By creating an index on sector_code, I would...
  9. gregjohn

    Index Suggestion

    Gentlemen: Thank you for your replies. Let me try to be more specific. I index for a specific sector -- lets say all technology stocks. I want to eliminate outliers (values that are gt 100 or lt -100). Based on the number of records, I skip down a certain number to find and store an upper...
  10. gregjohn

    Index Suggestion

    I am not a programmer, but have had to use vfp for a while. I'm hoping someone could help me with this indexing question. I have a table of 7,000 or so records. I start with a for loop (for x = 1 to 12) Within the for loop, I create the following index: index on expected_return tag er for...
  11. gregjohn

    Delete Tags

    I have several tables that are part of a database (which is part of a project) with approx 200 fields and 5,000 records. I also have about 200 index tags. Unfortunately, I need to change the tag expression. Trying to rewrite the index seems to take a long time and I keep getting that pesky...
  12. gregjohn

    Cancel program on escape

    I recently upgraded from v6.0 to 8.0. With v6, you could use the escape button to stop program execution. The default in v8 is to not allow that, although the user has the ability in tools/options/general to set a check box to allow "cancel programs on escape" (you can also use the...
  13. gregjohn

    Pdf Image in Word

    I have a pdf file that I would like to include in a word document. I inserted an abode acrobat document object and browsed to the file I wanted. The adobe acrobat icon was placed in my word document. If I double click, the pdf file opens fine. But, is there a way to have the pdf image...
  14. gregjohn

    Include pdf in crystal subreport

    I have a crystal report that includes several different subreports. I would like to try and incorporate a pdf file (that already exists) into this report. I went to insert object, selected adobe acrobat document, and selected the pdf file I wanted. Upon hitting ok, I was able to place the...
  15. gregjohn

    Print to file

    Mike: Yes, this is confusing. I am using VFP 6.0 to call crystal and have crystal print a pdf. I appreciate your code using export, but I have already tried that. Apparently crystal has an issue when you are trying to print a report to a pdf that has graphs (which my report is full of). The...

Part and Inventory Search

Back
Top