Answer Questions

• Ted Lee - MSFT table buffering mode

  On a statement like this: IF NOT initTableEmpty TABLEUPDATE () ENDIF I get an error: This operation requires table to be opened in buffering mode . SQLBUFFERING is set to ON before the table is opened. It does not help. Actually the error happens once in a while for no reason. I cannot understand what triggers it. Most of the time the statement works. The USE command does seem to have no option for buffering either. Is any h ...Show All

• Ahojko 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

• basittanveer How to play a Windows Media Audio format (WMA) in VFP?

  Hi all, I am now trying to create a small program to play media audio files. I'm now using the MultiMedia ActiveX control (mci.ocx) to play these files but this ocx seems can not play WMA files while this type of file is getting more and more popular to music-lovers. Could anyone tell me how to play WMA files in VFP. Note:I want to play them directly in VFP with MCI control or with some API function that VFP can handle,  ...Show All

• MikeCampbell problem with physical sorting

  Hello , my name is victor , and i have a problem ! i am beginner in VFP9 , and i would like to put a question. I try to do a little program wich will help me to see better our employment. I tried to do a table , and to sort workers by theyer names from "A" to "Z", but it doesn`t work. The code is like this : USE tabel_de_baza.dbf SORT TO tabel_de_baza1.dbf ON nume_pren /A USE tabel_de_baza1.dbf List Use. ...Show All

• raducu Strategy for multiple index query

  Hi all; I am using a sql query and I am sending the results to a grid (I mean I set the recordsource to the resulting cursor). I need to have the grid 'sortable' by several columns. The user will click a header and the grid will be sorted by that column. I am wondering what is the proper way of doing this: Am I to run a query to a cursor, and then do a several 'index on' commands, or is there a better way thanks, Aleniko ...Show All

• jeinhorn 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

• lovealotnana report export to excel differs from print preview and print

  When using Visual Foxpro 8, I notice that my subtotals based on 2 report variables that calculate sums per group in the 4th data grouping are continuing to accumulate instead of resetting after each group when I export to excel but appear fine when I do a print or print preview.  I tried deleting and re-adding the grouping only to get the same result.  Strangely, I also notice some of my text labels have also shifted over to the r ...Show All

• Raj Thilak Obtaining a web page's title

  I'd like to get the titles of web pages, and would prefer not to do this by loading all the web pages into a webbrowser, because that seems a bit heavy handed. In VB6 I used some APIs to achieve this, but I'm not having any luck in getting it to work in .net. Here's the code I'm trying: Module Module2 Private Const INTERNET_FLAG_RELOAD = &H80000000 Private Declare Auto Function InternetOpenUrl Lib "wininet" Alia ...Show All

• ymhtp Create a Directory

  How can i create a directory when the app begins but validating if the directory exists avoiding an error code thanks a lot! Hi Nora, two more things to consider: 1) MKDIR only creates directories one level deep. If C:\Customer1\Data doesn't exist at all, you first have to create the Customer1 directory, then the Data directory. 2) When creating directories pay attention to the permissions of the current ...Show All

• hypershot COM server problem

  I have a VFP6 project that when compiled worked great as a DLL lookup on an included table. As I no longer have access to VFP6 and the table needed updating, I tried to test out VFP9 with this project. It builds to the DLL with no errors but when I tried to register it, I got the dreaded message" DllRegisterServer in ....failed. Return code was: 0x80004005". I used Dependency Walker to profile this dll and got the following results: ...Show All

• Aravindalochana FoxPro won't run. Fatal Error - C0000005

  Hi I've been working away in FoxPro for the past few days and then this morning, after using it for a couple of very productive hours, I suddenly got this error when I tried to start it up. Fatal error: Exception code=C0000005 @ 05/25/06 03:28:35 PM . It gets as far as showing the menu and the various things like the command window and then gives the MSoft error message. It shows as error 1000 in the Windows error log. I'm using VFP9, S ...Show All

• Surfsune Cursor help

  Hi    I am new to foxpro and have a question reguarding cursors. I am using VFP 9.0. I am working with a local VFP data base. As I understand it a cursor is a recordset created by a SQL statement that is stored in memory (or also on the hard drive if it is to big to fit into memory) on the client computer that the application is running on. I also understand if it uses the hard drive for temporary files that they will be deleted when t ...Show All

• DaSteph How do i disable an active screen saver?

  Good day to everybody, i have a small program installed in the workstation that is controlled at the server, Can we disable a running screen saver when my program becomes active Example: I send a message to the workstation,... so my program installed there will pops-up automatically....but the problem is, ...when the user did not use the PC in a period of time so naturally screen saver will take-over, and my program pops-up at t ...Show All

• netsql cannot update cursor

  I have a main form that calls a couple of other forms to make some selections. One of them opens a table and after a selection is made a mark is left in a special field that this record has been selected. Then this small form is closed and the same table is opened in the main form. The table is opened EXCLUSIVE in both forms. Before it is opened in the secondary form it is not opened in the main form. The point is that it all works well in ...Show All

• moria yizhaki Form Feed Character

  Hello Experts: I am using FPUTS to write text to a file. At the end of each page I need to insert Form Feed Character. How can I do this I normally work them from memory but any decent ASCII table would show it. Here's one I found through Google: http://www.lookuptables.com/ Try adding CHR(12) as your FF character. Thanks Alex. Is ther ...Show All