Answer Questions

• Nick Y Docked form and a Modal (Dialog)

  Hi All, I was wondering if this is an expected behavior:- I have a docked form in the main VFP screen, the docked form has a “Options” button that calls an “Options Form”, the “Options Form” is Modal and the AlwaysOnTop property is set to .T., however, the “Options Form” is displayed behind the Docked form, and the Docked form can be resized even when the Modal “Options Form” is displayed. Any insight would be appreciated. Hello Tamar, Thank you for the reply, I could see how that would make sense, however, a Modal Form show be on Top no matter what (I think), additionally; for example: in VS.NET the Solution Explorer, Dynamic Help etc. are docked, and when I select Help - About Microsof ...Show All

• Alba Execution of function or command is not allowed in context of SQL command.

  Hi; I got this error when I try to issue a quit command from my error trapping routine. Clicking help (Just like many other cases) is no help at all. I couldn't find this error anywhere in the VFP help or in google... Any ideas why this happens, and how I can avoid it Thanks. >> Being a newbie to VFP, I am not sure if I'm makeing sense. Am I No I understand exactly what you are trying to do. The error you reported suggests that a SQL Statement is still executing when you try to quit and one possible reason is that you are generating a cartesian product out of that query - If you have 100 Records in "tmpcpo" and 10000 in "polgr" the result set created ...Show All

• David Joyce datatype casting

  Hi, I want to know how to convert or cast a string to an int. Thanks INT(VAL(string)) In VFP, you can also use CAST(cString AS I). Tamar ...Show All

• Linda Cornerstone Access to Oracle 10g through Oracle ODBC driver. Problem with 64-bit Windows, with Vista

  In WinXP 32-bit, Win2000 32-bit, Win2003 32-bit all OK. In WinXP SP2 64-bit, Win2003R2 SP1 64-bit I can't access to Oracle 10g by hconn = sqlstringconnect('DRIVER={Oracle in OraHome10}; UID=xxx; PWD=xxx; SERVER=ORA10; DBQ=ORA10') return -1 How to connect to Oracle from 64-bit Windows platform Question 2. In Windows Vista (Business, 32-bit) I can connect to Oracle 10g only with administrative privileges. If already exist one connect (with admin privileges) then I can connect to Oracle many times even without admin.priv. Is this errors to Visual Foxpro team This doesn't sound like anything to do with VFP. All VFP does is invoke the ODBC driver and read its response. Why not post this o ...Show All

• Tom_Liu Visual foxpro 9 watch hang

  I was testing a program with debug and watch window . I enter a function in the watch windw than a window like passward with no title apears and evry think is bloked. I have to end forcely by task manager. Since than evry time I start watch window I get the same window and bloking situation.I uninstald Visual fox pro and I reinstald it. The same think. I uninsald Visual FoxPro and I deleted all the directory from program file . I reinstald Visual FoxPro 9 and the same think happends. I posted a screen copy of the event to www.bluejeans.lx.ro if you want to see it. What can I do    In the watch window I tested this UPPER ( ALLTRIM ( INPUTBOX (DVDLOGIN_LOC,DVDLOGINCAP_LOC))) it permanently genereit an ...Show All

• Nitin Sharma22 foxpro for windows

  sir, i hope i am not troubling you all. i have installed foxpro for windows 2.6 on win 2000. but i am not able to run foxprow.exe. i get error "divide by zero or overflow error" how to fix it. Hi Lakxmi, Have you tried applying the patches... Regards, Markish thank you very much If all files are properly installed you may try to create a short cut on desktop on foxprow.exe, then press property>compatibility>advanced and try win98. Yoy should have also in config.sys file or config.nt file: dos=high, umb device=%SystemRoot%\system32\himem.sys files=100 u have to apply the patch to foxpro 2.6 (windows) it to work in windows 2000 / XP http://support.microsoft.com/kb/240982 http:/ ...Show All

• kasumi241026 How do I creat a print button?

  How do I create a print button in Form of VFP9 that will print only the current record Will appreciate and thanks in advance... This is a very generalized question. Here's a generalized answer: First, drop a command button on the form. Set the caption of the button to 'print' or put a little printer icon on it. In the click method you would put whatever commands you need in order to print the current record. The method of printing the current record will vary, but I think you would use a report form (Which you have to generate first). So your command in the click method you would have something like this: report form someform next 1 to print preview Again, there are dif ...Show All

• Kapalic Help on Report Writer Wizard

  Hi guys, Hellllpppppp. I am very new with VFP and already getting frustrated. I would appreciate a little help from you gurus. Using the Report Writer Wizard always gives me this error message: "The DBC containing the selected table was previously opened non-exclusively and the field(s) you chose for sorting are not in existing index tag. Please select field(s) which already have an existing index tag or exit the wizard and reopen the DBC exclusively." I have done ALL of them and I still get the same error message. Thanks I'm not a guru but would consider one of the following object clean up commands (If DNI's venerable link fails): Clear All Close tables All Clos ...Show All

• Adam Miles Calling .NET from Foxpro

  Hi, I have a .NET dll that I need to call repeatedly from within a Foxpro app. In effect, I'd like to instantiate a class in a .NET assembly and call its methods just like any other Foxpro object. I've never done this in Foxpro before. Is there someplace where MS has some relevent documentation that can shorten my learning curve Thanks Thanks, I think this will be a good start. Here's a good article on COM Interop by Rick Strahl [MVP]. It might clarify things for you: http://www.west-wind.com/presentations/VFPDOTNETiNTEROP/VFPDOTNETINTEROP.HTM   ...Show All

• Antonov Alexey Problem with Browser activex control

  I have a vfp form with a browser activex control (which I've named ole1). I use the browser to display an html page which uses javascript to create a text editor object like this: var oFCKeditor = new FCKeditor( 'FCKeditor1' ) And then (again in javascript) I can set up the text to be edited like this: oFCKeditor.Value = "Some html <b>text</b> here" Is there a way of accessing the oFCKeditor object from foxpro after the page has been displayed I've tried something like Thisform.ole1.document.oFCKeditor.value but that doesn't work. Malcolm Thx, SharathMum. That is a good example of using .document to write to the browser. However my problem comes later, ha ...Show All

• Martin Unterholzner MySQL and VFP

  Hi experts. I have a MySQL database. I operate with them using syntax like SQL(sqlhandle, "select * from...") I copy them into cursor and than operate with a cursor. Is there a simplier way how to work with them Thanks in an advice. Then don't accept and don't download. You don't need to express it explicitly. Good luck. MSSQL server 2005 express version (SSE) is available for free from Microsoft. Check msdn.microsoft.com/express. You can even download other express versions from there for free (C#.Net, Visual web developer etc). You can also find some free hosting providers with SQL server and .Net support. >> ...Show All

• Lars E.Nes date question

  Hi, Someone knows if there is a function or something like that in fox 7 to calculate the difference between two dates. Thanks, Hi. VFP return the difference in days: x={^2007-02-27} y={^2007-02-20} x-y && 7 Does this respond your question or do you need to obtain another result Like CDFAUX said, you can subtract two dates and get difference in days. Or use to Datetime() and get difference in seconds. d1=DATE(2007,2,3) d2=DATE() diff=d2-d1   dt1=DATETIME(2007,2,27,1,12,33) dt2=DATETIME() diff=dt2-dt1 ...Show All

• Alois A (simple I suppose!) grid question ....

  Hi all! I used to work with VFP a long time ago and I have almost forgot most of it so I ll need your help here! :) I have a table (called myTable) with 4 fields (3 of C(20) and 1 Memo- ID,Title,Location,Descr.). When I am displaying that on a grid, I do that through a new cursor called myTable_cursor. But in the cursor I added a new field because what I wanna do is to display the first 20 characters of the memo and if the user wants then to double click on the memo cell and a new window to open and view all the memo field or edit the memo. So my problems are: 1. Whatever I put in the click event in the textbox cell in the grid (in the correct memo column) it does not respond! Any solutions here 2. I use a cursor to display ...Show All

• Coach24 Right Screen in VFP 9.0

  How Can I make a Program Designed by VFP 9.0 Language Start from Right to Left Without Pressing (ALT + Right Shift) Keys Thanks 0x0401 Arabic (Saudi Arabia) 0x0801 Arabic (Iraq) 0x0c01 Arabic (Egypt) 0x1001 Arabic (Libya) 0x1401 Arabic (Algeria) 0x1801 Arabic (Morocco) 0x1c01 Arabic (Tunisia) 0x2001 Arabic (Oman) 0x2401 Arabic (Yemen) 0x2801 Arabic (Syria) 0x2c01 Arabic (Jordan) 0x3001 Arabic (Lebanon) 0x3401 Arabic (Kuwait) 0x3801 Arabic (U.A.E.) 0x3c01 Arabic (Bahrain) 0x4001 Arabic (Qatar) DECLARE LONG LoadKeyboardLayout IN User32 STRING pwszKLID, INTEGER Fla ...Show All

• hr0nix Problem trying to create an Encryption Library

  I have followed the example for creating a C# Encryption Libary, but receive numerous errors with regard to no overload method ' ' requires 2 arguments, I have verified that my code is exactly as the example provided by microsoft and found no difference. Has anyone ever tried this code and had problems. Is there any other code to create an encryptoin library in C#. I would appreciate any and all assistance. I am responsible for figuring out how to encrypt the connection string for our web config files in Asp.net page. (we dont' have the .net 2.o framework, we are using Visual Studio 2003 with 1.x framework Thanks Heather However it could be a final fix to define Encrypt and Decrypt methods with 2 parameters as fo ...Show All