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 derfloh 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: rpp
  • Order by date
  1. rpp

    How do I detect if a VIEW is present in a database?

    I new there had to be a command similar to that of USED() or FILE() that I could query to see if my view was in the DBC. At this time the INDBC() will do nicely. I looked for something like it however I had no idea what it would be called. Thanks Experts
  2. rpp

    How do I detect if a VIEW is present in a database?

    Hi Experts, How do I determine (programatically) if a VIEW is present for within a DBC? I am trying to create one if it is not found, and if so then I plan to use it. Thanks in advance. Richard
  3. rpp

    EXE From VFP7.0 wont run as stand alone

    Thanks guys, Yep Recompiling in 7.0 was the trick, all is well now. Thanks for your help. Richard Peterson
  4. rpp

    EXE From VFP7.0 wont run as stand alone

    Hi Experts, I am having trouble getting my EXE file, that ran fine when Under VFP 6.0, to run in stand alone environment. The error message is "c:\program files\myapp.exe is not a Visualt FoxPro .EXE file." I have included in this exe's folder the VFP 7.0 runtime dll's as well as...
  5. rpp

    (SQL) Select Statement Woes on "Group" option

    Hi Ramani, I wish it where that easy. My data has duplicate records, names listed as first/last and last/first in the name field, my hope to group on phone but still have an alphabetical list of names, ie., I would not even care where this guy ended up sorting, either in the "F's" or...
  6. rpp

    (SQL) Select Statement Woes on "Group" option

    Hi Experts I am trying to create a SQL statement using the group option but find it behaves similar to that of the "Distinct" option. It is eliminating the matching or grouped records. The Deal: fields: phone, name I want to be able to sort on name but group by phone SELECT ALL *...
  7. rpp

    How do I include "copy" "cut" "paste" in menu...?

    Thank you Slighthaze, These menu functions are working fine now! Thanks for you help! Rich
  8. rpp

    How do I include "copy" "cut" "paste" in menu...?

    I to include the "EDIT" as a submenu then under that the "cut, copy, paste ...". Using the menu designer do you make your "RESULT" to be a "Bar#" or "Command"? Do you include a graphic? Thanks Rich
  9. rpp

    How do I include "copy" "cut" "paste" in menu...?

    Hi Experts, During VFP 6.0 I had used the _MED_CUT _MED_COPY _MED_PASTE VFP called function in my menu, however, since moving to VFP7.0, these features no longer work. Is there another way or do I need to call something else to make these feature work once again? Thanks in advance. Rich
  10. rpp

    How do I return new values of variables from a method?

    Hi experts, I cannot seem to have the new values returned from a method I have created in my app. For instance, I have a form that initializes these values like so... STORE address TO gcAddress STORE '' TO mstno, mdir, mstname, mapt Then I call and run my method...
  11. rpp

    Is it better to open all tables for an application...

    Thanks, I did not consider the potential of client-server issues, but that makes sense. Do VIEWS encounter the same issue of being open more than once, and if a view is closed for one form is closed for other forms also? Rich
  12. rpp

    Is it better to open all tables for an application...

    Hello again. Is it better to open all tables for an application at startup...or open the tables individualy as required by the forms? The pitfall with the later is opening different forms that use the same tables produce errors. What is the pitfall with the former method? Thanks in advance!
  13. rpp

    How do I run a SQL statement that includes variables

    Man your the greatest!!!! I have worked around that thing for years. Thank you so much!!!!!
  14. rpp

    How do I run a SQL statement that includes variables

    I am trying to select a record set that has a variable used where field names are normally listed., Why wont this work and what might be the best work around? lcSort = '' IF Thisform.lstsorted.listcount >= 1 FOR lnCount = 1 TO (Thisform.lstsorted.listcount) lcItem =...
  15. rpp

    What does this Exception Error mean!!

    The Service Pack is SP5 on my machine running win 2000 pro. The client box is running on xp pro. And does not have VFP installed. It of course is running the DLL's and EXE of vfp 6.0 is that correct and current?
  16. rpp

    What does this Exception Error mean!!

    I got an exception error during the running of a standalone exe from FoxPro 6.0. The error is C0000005 Fatal error: Exception code = c0000005 Called from = App.araing line 140 etc....... I understand this is not syntax error but an error up a level returned by the runtime dll or runtime...
  17. rpp

    What resource is available to understand about Monthly Billing?

    Good Advice! Thanks again. RPP
  18. rpp

    What resource is available to understand about Monthly Billing?

    I have one table that I capture the "Contract" information A single record for each customer. 1. Invoice Amount, 2. Discount 3. Net Due 4. Number of Payments, 5. Date to start the monthly billing. I have a key that links it to a customer table for the other information name etc...
  19. rpp

    What resource is available to understand about Monthly Billing?

    I am needing to become more familiar with "Monthly Billing" and creating a program that can be generate the process. The problem: Sale is made, cost 1000.00 with terms that reflect 1 to 12 month billing at signing of contract. Possibly collect a down payment. I need to accrue...
  20. rpp

    I do I determine the balance due using a Select Statment/

    So sorry, you are right I did not include this information, there are multiple records for a single customer, both credits and debits. Through some trial and error I have the following working: SELECT xar.*, ; SUM(CHARGES) AS sumcharges, ; SUM(PAYMENT) AS sumpayment, ...

Part and Inventory Search

Back
Top