Answer Questions

• Yhert Using Text To Speech With Visual Foxpro 8 & 9

  I am writing an application in VFP9 that I want to read a field from a Foxpro table and read this information the user.  I have had success using the speech5.1 SDK, but only with VB or C#.  This application must be written using foxpro.  The problem I am having is that I cannot insert the activeX control (OLE object)  into my foxpro form.  The Insert Object window will not allow me to add sapi.dll to my form.  Any ...Show All

• brents1 Grids Property - Partial Row Displays

  I think there is a grid property that controls whether a partial row is displayed at the bottom of the grid, but I can't remember it and can't find it in the help topic. Can anyone help Thanks. I think you are referring to "IntegralHeight" but that does not apply to Grids only TextBox, EditBox and ListBox controls... There is no similar property for grids that I know of (Headers and Rows have inde ...Show All

• uhsxa .exe does not stay open on desktop

  We created a program that has a mix of forms and hard coding that has a .prg file as our main file.  Now when we compile and run it within Foxpro it runs fine, with the interface console/form staying open after compile and run.  But when we converted it into a .exe file, it just runs the first login and just exits onto desktop.  Our program console does not stay open.  Please advise. ...Show All

• Dunk_SCO Enhancement Request: Ability to pass cursors as parameters

  The ability to pass a cursor to a method of an object belonging to another data session would be a great addition for a future versions of VFP. Today, we have to resort to arrays, which is kind of a kludge, or CursorToXML/XMLToCursor, which is way too slow for large data sets. If cursor could be passed between data sessions, n-tier apps would benefit greatly. Any thoughts Eyvind. Do you know how this compares ...Show All

• Datawizard Detect hard diskk serial number.

  Dear Expert, Can I know how to detect the hard disk serial number or code using foxpro Thanks a lots. Check application.servername. Dear Sir, I found this little code very useful, but it only works on 1st Harddisk (Primary Master). Anyway, thanks a lot. I have also changed your code a little bit to meet the need in my program. Here is the code: FU ...Show All

• CodeAnger Need solution for complex query

  Hello, I am having trouble in getting the expected results. I have two tables as below. I need Idno,transdt,cd,cycdt,amt from joining two tables. The criteria is that if the transdt greater than same month of cycdt then we need get the next month cycdt and corresponding amount for that, if it is less than or equal to same months cycdt then get the same months cycdt and amt. Cd is dummy field which can be anything. I am using foxpro 6.0 id ...Show All

• Brad Lindberg How to perform group by and order by AFTER union?

  Hi, I have a SQL statement like this: SELECT * FROM (    SELECT * FROM A     UNION     SELECT * FROM B) GROUP BY 1, 2 ORDER BY 1, 2 Is there any way to translate it to FoxPro 2.5 compatible Thanks. Thank you Tomik. However, your statement will perform like this: SELECT * from A ; UNION ; (SELECT * from B group ...Show All

• Fiona Coen MAPI and Set Default..

  When using mapi I am loosing my “set default” to goes back to the c: I wind up putting code like as follows just to correct it. Mdefa=set(‘default’) Mpath=set(‘path’) <Mapi code here> Set default to &Mdefa Set path to &mpath I’m not sure why I have to reset the path, the set(‘path’) still returns the correct path but foxpro can’t find the files! I have the same problem when users select certain PDF Pri ...Show All

• Carsten Loeffler seek char+date

  dear all, i seek stockist code+invoice date but failed to seek. why what i had done... use invoice shared index on code+dtoc(inv_date) to invoice.idx set index to invoice.idx seek code+dtoc(thisform.txtInvdate.value) but failed to seek. thanks. What do you mean by "failed to seek" Did it error or simply couldn't find a match If you mean no match then probably you're switching "set date" ...Show All

• Baris ERGUN a child form needs 2 clicks to close

  I have a form calling a secondary form. In order to close the latter I have to click twice the button that has the following statements in the CLICK method: ACTIVATE SCREEN "CLICK fired " THISFORM . Deactivate () THISFORM . Destroy () THISFORM . Hide () THISFORM . Release () 4 statements are there out of desperation. I tried them separately and in many combinations. I see on the SCREEN that the event fir ...Show All

• urbancenturion Help in VFP 6 Application...

  Hi, I've developed a application in VFP 6.0 in Windows 2000 Server Env. The problem is that if I start the application. the splash screen shows up... but with the Command window and the standard toolbars in background..... I tried with application.visible=.f. But it imposed several limitations in my applications.... So is there any way to get around this situation..... One more thing I wanted to ask is what is the be ...Show All

• Mark McLain show certain record in gridbox

  dear all, i dont want my form show ZZZZ product code that i make hardcode to my table. sele b SET ORDER TO 2 GO TOP thisform.grdSales.RecordSource = "b" thisform.grdSales.RecordSourceType = 1 thisform.grdSales.column1.Bound = .F. thisform.grdSales.column2.Bound = .F. thisform.grdSales.column3.Bound = .F. Thisform.grdSales.column1.text1.ControlSource = "P_name" Thisform.grdSales.column2.text1.controlsource ="P_c ...Show All

• bosstan1 pulling data from one field and making a new column out of it

  Hi all!!! I have two fields, work_id and sp_id. All sp_id's are related to the work_id's ie. work_id sp_id 1 000 3 000 3 111 5 111 9 000 9 111 i need the data to be listed by the work_id, then in another colum have it state whether it is one sp_id, the other sp_id or both sp_id work_id sp_id 1 000 3 both 5 111 9 both any insight life is short ...Show All

• Harsh deployment, building exe problem

  OK, this is the third round. I still cannot run an exec file. I cannot build it properly. When I issue (in the Command Window) BUILD EXE the intellisense prompt appears with my app name. So, I accept the rest of the clause as default. Until today I could generate .exe with no problem but had problem getting it started. Today finally for reason I cannot explain an error appeared during BUILD: Unable to find Unknown ARR . Jus ...Show All

• SandyS48337 creating tables programmatically-some questions

  I have decided to create some tables programmatically since they most likely will be used temporarily. I do have a number of questions pertainint to CREATE TABLE paramaters. I could not find any explanations so far to figure out what they meant. First I assumed that CODEPAGE should be 1252 (Windows ANSI). Is it the right choice I want to create tables FROM ARRAY arrName I understand that arrName is a 2-dimensional array with the same numb ...Show All