Only Title

Answer Questions

• T-oha Call application from program and trace Menus and Programs within

  Hello, Can anybody help me please Am trying to call an application from another, but having a problem tracing the called program's Menus and Programs. At the beginning it started by having the Encrypted checkbox automatically selected after building project and an application (the application I will be calling) while I de-check it myself. I tried creating the project from the beginning and somehow this stopped, and I could trace again, ...Show All

• Darryn Lavery -- MSFT [noob questions] Arrays..

  Aaaaaaaaaaaaaaaarrrrgggghhhhhgadsfhasdjhf 1. Is foxpro incapable of returning an array from a function by using the return statement  2. Does foxpro have a function that merges 2 arrays 3. How do you pass an array as an argument to a function in a class when the array is a class variable For example: define class test as Custom     dimension Arr(1)        procedure asdf(tmpArray, tmp ...Show All

• Anika class called

  dear all, i have a class to detect table open exclusive or not in my project. when i put my code at load event it prompt me unknown my class. but when i put it at init event it run normally. thanks in advance. here is the code SELECT B IF !thisform.utility1.netuse(mdatapath+"FILE14",.F.) RETURN ENDIF SET ORDER TO 1 Thanks in advance. Can you post the code from your Load method yes thanks ...Show All

• AncientTones Populating a grid - strategy.

  Hi all - another newbie question: I'm trying to have a grid populated by a sql statement. I am wondering if the proper strategy is to create the grid in the form designer by dropping the original table from the DE into the form, and then tweek the fields, record source etc, or do the whole thing in code Thanks, Aleniko There is no proper strategy for it. It's a personal preference. ie: You might create a g ...Show All

• Joe.B coming back to foxpro

  used foxpro 2.5 and now have visual fp.  am having trouble lwith iff and if then syntax.  i want to have user enter a zip code and then the city and state are filled in.  thanks for any help I am not sure what the problem with IIF() and IF...ENDIF could be as they have not changed since VP2.5 - you need to give us some details here. But It sounds as though you are looking for a zip-code lookup ...Show All

• Mark q jones How to make a form truely private?

  A newbie question: I have a form which I have set it to private datasession. The form has an object which is based on a class: cboacct. This class is a container class which has a cbo and a text box. The cbo takes an acct# and seeks the customer file. Originally the ControSource for the cbo was simply 'acct' and being blobal, it worked fine. I'm trying to use a protected property instead. I have created a protected class property named 'acct'. ...Show All

• ndhuy Select Statement

  Basically i want to create a view that calculate the stock end balance using moving average. On entry invoice the prg would create txn on a table item_txns that store all txns that affects the balance. The problem is the sale txns only store the qty but does not store the cost of good sold. This would be calculated on the fly when users query and want to see the cost of good sold . I want to do this using SELECT statement, The fields ar ...Show All

• Chanduu Getting the numeric field precision

  I'm using code to extract a table's fields properties and I'm trying to figure how I can grab the precision of a numeric field. The FSIZE() function returns the full field size, how could I pulled what's reserved for after the decimal point: iLg = FSIZE("SomeNumField") if the field is a NUMERIC(10,4) for example, I get 10. How do I get the "4" Thanks in advance, Eric ...Show All

• Najm DELETE FOR-PACK ON BUFFERED TABLES

  I have a buffered(5-optimistic )tables in vfp 9.0.when i use delete the records arent deleted i use tableupdate but they dont get deleted.i use pack but i get a msg saying table should be in no buffered mode i then change buff to 0 (not programmatically with cursorset.. but from dataenviroment) but is still get the msg! how can i delete a record table must be in buffered mode the reason is that with a temp tab ...Show All

• wheelersctt How to upgrade a menu from FoxPro for DOS

  I'm a very old, retired, CCOBOL and ASSEMBLY programmer with some experience with dBase and FoxPro from the command window. A charity has asked me to get an old FoxPro for DOS program working on a donated used computer which contains VFP6.0. I have gone over the data files and they seem to be OK. The indexes have been converted to CDX type and that works. The old DOS program worked by relying on append and browse commands which all work. The nee ...Show All

• J Kenyon Open table exclusively?

  Forgive my ignorance - I've recently reinstalled XP and subsequently Foxpro 7.0. Now when i double click on a foxpro dbf file it opens the table and another datasession labeled 'B' (i'm supposing it's a datasession). Previously, when i opened a table i was in exclusive mode and didn't have this duplicate table open also. I normally work in exclusive mode because my data is not in a shared environment (i'm a vb developer). Any suggestions thanks ...Show All

• MarlaF memo file corrupt

  I am getting error 41: "memo file 'name' missing or invalid on one of my tables. Before I did something stupid I want to hear if there are any established ways to salvage the situation. I am getting this error when I am trying to use the file programmatically and also when I browse the table in browser. HOWEVER, in the browser I can read all the memo fields. I can open them up and also they appear in speedtips (It may be a dBase term): I ...Show All

• edhampt how do i get a result in 4 tables in SELECT- SQL command?

  good day to the experts... My transaction has 4 tables, 1 for recording the amount of loan, 1 for check payment, & 1 for cash payment, and the vendor table. Below is the tables and its corresponding fields *// vendor table 1 (FIELDS=acct_no, acct_name,address, totalamount) * // loan table table 2 (FIELDS=or_number,acct_no, loanamount, or_date) *//cash payment table ltable 3 (FIELDS=child_numb, or_number,acct_no, amountpaid, ...Show All

• paorear Path for temporary files

  How can I change in run-time the path on which Visual FoxPro stores its temporary files from the current specified in the TMPFILES in the CONFIG.FPW to the the temp folder in the local windows directory of any workstation (i.e. C:\windows\temp\,  D:\winnt\tmp\, etc...)   Please, notice there is just a CONFIG.FPW file in the server. More details see functions: SYS(2023), SYS(2019) and GETENV("windir")   ...Show All

• laurin1 how to send control codes via "???" to receipt printer

  Hi All, I am writing a POS system and using a receipt printer (Epson TM-U220D). Unfortunately the printer drivers from Epson didn't work & hence I resorted to using the Windows Generic/Text printer. I am using a series of to output to the printer, which works fine. My problem is that I need to do some form of simple formatting on the receipt, e.g. make company name bold, etc. My question is, how do I send the control codes to achieve t ...Show All