Search results for query: *

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

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

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

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

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

...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 * FROM testsort GROUP BY phone ORDER BY name I have 1079 records to start, after the SQL runs I have 854 (Where the rest go?) My hope was to...

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

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

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

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

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

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!

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

...IF (lnCount) = 1 lcSort = 'ALLTRIM('+lcItem+')' ELSE lcSort = lcSort + ' + ' + 'ALLTRIM('+lcItem+')' ENDIF ENDFOR ENDIF select * from (infile) where city = 'Palm Bay' or city = 'Malabar' or city = 'Valk' ; ORDER BY (lcsort) Thanks in advance

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?

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

Good Advice! Thanks again. RPP

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

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

...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, ; ROUND(SUM(charges)-SUM(payment),2) AS Balance ; FROM xar ; GROUP BY KEY ...