Answer Questions

• FraGar how to define an array?

  I have this situation. There are two functions in a prg file. The first function is major, the second one is simply a container for a large DO CASE ENDCASE clause with about 18 macros for different choices. Those macros do the following (individually): SELECT FROM <table name> WHERE ... INTO ARRAY arr1 The main function gets a cAlias as an output parameter and this parameter is used to address the second function. The return value for t ...Show All

• Mark Raimondi a bug or i miss something?

    This is how it goes,  i make a prg with this coding below;    lcdir=GETDIR()   SUSP   IF !DIRECTORY(lcdir)       //some code here   ENDIF  then I run the prog, it works fine, the window that shows the directory tree pop-ups, then I click the button SELECT, the window's gone,but instead of the debugger will comes-up next or I will select the debugger from the menu, the wi ...Show All

• Ali Zahid Moving from VFP 5.0 to client/server

  I currently have an application that was written in VFP 5.0 and running on Windows XP machines with the database stored on a Windows 2000 server. It was first installed in 2000 and has had modules added, the most recent being 6 months ago.  However, I have been having some problems with the program seeing that the database sizes has grown considerably with at least 2 tables having over 20000 records.  The hardware technician has ...Show All

• Lenzoi Web Service Deployment

  Hi, I've written several Web Services using VF9, all have been tested and working fine on my local IIS (Operating System XP Professional). However, when I deploy any of these to IIS on Server 2003 I get the following error message: "Error: 1429 - OLE IDispatch exception code 0 from Client: Client: An unanticipated error occurred during processing of this request. HRESULT=0x800A13BE - Client: Sending the Soap message failed or no recogni ...Show All

• Trenomarcus Preview Toolbar not enabled in EXE

  The Preview Toolbar in VFP9 is not enabled when a report is generated to Preview from a compiled EXE.  _reportbehavior is set to 90.  The 90 preveiw toolbar is displayed The application runs from a main form (modeless, as Top Level Form).  Displays all reports to a preview form that is is either modal/modeless and In top level form.  I have tried as Top Level Form and In Top Level Form.  I have created the report two dif ...Show All

• vkarimbil newbie here...

  hi to all... i have a form named customers and i have txtboxes to input all information i needed. i have a grid that shows all the records in the table customer. works fine on loading. now, i have 2 buttons previous and next respectively. my codes are as follows: Previous Button: USE customer if not BOF() skip -1 thisform.refresh() if BOF() go top endif endif Next Button: USE customer if not EOF() skip thisform.refr ...Show All

• JoseMiguel Memo File Corruption on VFP9 ONLY

  I am just beginning work for a new client.  This client wanted a VFP5 app upgraded to VFP9..they're using Novell (lastest version).  After the conversion (very little changes needed to be made), they started getting file and memo corruption errors as well as indexing errors.  I took a copy of the data and tried a recopy using SCATTER MEMO MEMVAR to a new fresh data file (using GATHER MEMO MEMVAR) in VFP90.  I got the same er ...Show All

• Inna Tzipris Emailing attachements

  I searched the forums here looking for a way to create emails from Visual Foxpro, and found what I was looking for in another thread using this code provided here: #DEFINE olFolderInbox 6 #DEFINE olFolderOutbox 4 #DEFINE olMailItem 0 #DEFINE olRecipient 4 #DEFINE olRecipients 17 #DEFINE IMPORTANCENORMAL 1 loApp= CreateObject ("Outlook.Application") loNamespace = loApp.GetNamespace("MAPI") loFolder = loNamespace.GetDefaultFolder(o ...Show All

• Golf4Fun Quick subquery ... query.

  Hi there, I have a small query with regards to FoxPro's subquery handling. In T & Oracle SQL the following query returns the data I require: SELECT * FROM tableName WHERE (SELECT count(fieldName) FROM tableName WHERE fieldName = 'testData') = 0 Whereas in FoxPro I'm getting the error "Queries of this type are not supported". Ignoring the fact the query is pointless in its current form (I'll be replacing the select w ...Show All

• Robin H. Sanner report labels

  hi all,im making new reports during run time according to users actions.for example he selectes some fields from comboboxes then he puts in a text box a value that is for the "where like.."and i save the results in a temporary table.from that table i create report and the i report form to print the new report..the problem is that the new report has as labels the names of the fields..for example if the field name is costomer_id it shows costomer_ ...Show All

• Divermarv Date range in a *.prg

  I'm writing a little program and instead of having to fill in the date range throughout how do I write a variable for the 2 date fields. Example of an excerpt is below but the program has 17 more date lines all with the same range to run on a bi-monthly basis. SELECT Fforder.order_no; FROM ffdbc!fforder; WHERE Fforder.order_date BETWEEN {01/12/2005} AND {31/12/2005}} SELECT Fforder.order_no; FROM ffdbc!fforder; WHERE Fforder.order_date BETWE ...Show All

• itzkid How to open the table exclusive for ZAPping?

  Hi Sir, To be able to PACK/ZAP a table it must be open exclusive, such as USE myTable EXCLUSIVE .... My question is, Why there isn't a place in data enviroment (TAB DATA) to stated that myTable should always open EXCLUSIVE so I can pack/zap anytime Please tell me where is the proper place (the way) to open a table exclusively SELECT myTable USE USE myTable EXCLUSIVE thanks Joe On the data environment there is a property for EXC ...Show All

• AlexBB Need help understanding Client to host window settings

  Greetings Fox-folk! I have a simple form with a functioning webbrowser control on it. I am trying to force the URL to resize itself automatically to the size of the control on the form. A little research seems to indicate I need to do something with the ClienToHostWindow. What I see is this: *** ActiveX Control Event *** LPARAMETERS cx, cy ... which seems to suggest x and y dimensions. Could someone please post an example code snippe ...Show All

• cschaeff [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

• Anindita 2.5 Compatible font for VFP9

  Hi all; I have asked others before, but no helpful answer: What fornt should I use in my VFP application so older command would produce the exact results as in the old 2.5 DOS app I have tried many different options and none are spaced right. I have been told to use monospaced fonts but nothing works... Any ideas Thanks. Aleniko, Monospaced works (like Courier New). However they're true ty ...Show All