Answer Questions
Rico Alexander SELECT .... INTO TABLE <existing table>
G_TempDBF = "C:\scratch\" + SUBSTR(SYS(2015), 3) + ".DBF" SELECT field1, field2 FROM myTable INTO TABLE (G_TempDBF) USE (G_TempDBF) ALIAS CUSTOMER INDEX ON field1 TAG field1 I have created a temporary table, stores the retrieved records into it and alias it CUSTOMER How can i reuse this temporary table for other SELECT statements SELECT field3, field4 FROM myTable INTO CURSOR CUSTOMER ---> results in an error saying Alias CUSTOMER has been used. Hi, I am not sure what are you trying to achieve. However, you can use ZAP to delete all reocrds, and then use APPEND FROM or INERT INTO ... SELECT ... FROM ... statement to replace records. Beside, you can t ...Show All
comsult how do i change the desktop background?
Good day to all experts.... how could i change the desktop background programatically i would like that if a user change my desktop background...at the time I open my VFP application it automatically search my desired background and changed it. Thank you (What is it you are trying to do ) well...I just wanted to know that not only RDBMS the VFP is good.. but in some simple task by other programming language...the VFP can do it too...besides it's a common that we always change the setting by going to the control panel or right clicking at the desktop.. why not incorporate this in our program . if we can ... You can only do that through the Windows Control Panel. The settings are stored in the Registry ...Show All
Luis Esteban Valencia Mu&#241;oz VFP7 COM+ object and ASP.Net 2.0 on IIS6 - Interop issue
Hi,I wonder has anyone managed to get his/her VFP7 COM+ object run on ASP.Net 2.0 on IIS6 1. I compiled the object using MTDLL and deployed into my SBS2003. 2. I think this shouldn't be a security problem as I didn't manage to get it run even I have set the IIS6 worker to Local System. 3. The COM+ object has actually initialised. Codes in INIT method has actually run (I put CREATE TABLE ..... in the INIT method, and check if the table is created later), but when come to calling a method from ASP.Net, I hit an error. 4. Tried many possibilities, but no luck. I have also followed the example from Craig, got the same issue. 5. The same VFP7 class (but complied as EXE and configured as DCOM) was running fine on IIS5 ASP2.0 on Windows 2000 Ser ...Show All
Wendell G Visual FOXPRO ODBC Drivers for windows Vista
Hi. Does any one knows where i can get the Visual FoxPro ODBC Drivers for Windows Vista Thanks. Helder Santos Dan, Are you sure of this 64bits OS and/or Apps I don't think that the current download/install of VFPODBC (VFPODBC.MSI) hasn't ever worked on Vista, and I notice it's still broke in RC2. Is VFPODBC going to be supported in Vista Just don't let any of your users run a 64-bit version of either WindowsXP or Vista. 32-bit ODBC and OLEDB drivers are not visible or usable by 64-bit applications. Prefer VFPOLEDB. VFP ODBC driver doesn't have all the capabilities of OLEDB driver. ...Show All
Tom25 slipstream VFP 9 with SP1 ?
Anyone know how to slipstreaming Visual FoxPro 9 with current SP1 Since VFP 9.0 isn't part of VS 2005 (or any other version of Visual Studio) and the VFP 9.0 SP1 isn't part of the VS SP1, I doubt if this works. Historically MS hasn't provided this capability for VFP, and with SP2 for VFP 9.0 coming, I doubt if they'll provide one right now. Rick Sure: copy the VFP CD to a writeable drive, use WinZip to extract the MSP file from the SP1 installation, then run this command (allowing for different file paths) to update the installation directory: msiexec /a c:\vfoxpro9.0\vs_setup.msi /p c:\temp\VFP9.0sp1-KB909149-X86-Enu.msp I just tested an install and it seemed to ...Show All
MCP_SS ADO Performance Problem with FoxPro 6.0 & AS/400 use
Hi all, I used ADO to connect AS/400 machine from foxpro 6.0 and i get data through processing SQL on it.The performance is very low when we try to connect to a AS/400 machine in a far place. Here is my code : * Procedure to get connection from AS/400 procedure GET_SERVER_CONN local Err, cOldErr, cn cOldErr = On("error") On Error Err = .T. cn = createobject('adodb.connection') rs = createobject('adodb.recordset') * MERKEZ10 - Name of server in network cn.open("Provider=IBMDA400;Data Source=MERKEZ10", "", "") if Err wait window "No connection with server!!!" nowait else return cn endif endproc Here is the procedure which gets customer list ...Show All
Derek Ekins file question
Hi, I want to to know if there is a function or command to create a directory in visual fox pro 7. For example, I want a new directory called: 'c:\users\test' . Thanks, if !directory('c:\users\test') md ( 'c:\users\test' ) endif PS: VFP can create multiple levels at once. In other words no need to chcek/create c:\users first. ...Show All
LuckyL Importing to Excel
Dear Friends, I would like to export my cursors to Excel file but when I do this they send only the datas of one cursor and the rest not. How to do this eg ; SELECT cursor1 SELECT cursor2 SELECT cursor3 copy to compare.xls type xls only the datas of the cursor3 will be exported not for the rest advance thanks for your suggestions satish "SELECT" select only one table at time.So, vfp consider the last select (SELECT 3).You need to export to excel after each select. thanks Friend, when we export after each select what happens is we again get the last selects details , I need them all in the same spreadsheet otherwise in the same excel sheet so my q ...Show All
Z.Y.S. SCATTER/GATHER
Hou can I "scatter" in a method (valid) and "gather" in other method(click).My vf.7 is forgetting all "m." variables between methods. Thanks, Daniel You are missing something VERY basic about memory variable scoping. Unless it's declared PUBLIC (a bad idea), a variable is scoped to the procedure (method) that declares it and possibly called procedures (if PRIVATE). When a method that creates a variable ends, the variable goes out of scope and is released. A far better mechanism for making values available across all form methods is to create a property of the form. (From the Form menu, choose New Property.) Thanks I will try, but I used thisform.refresh and ...Show All
UnWiNd VFP9 anchor bug
I set anchor in my class cs. I have a program in vfp code to create a form. I created a control object using cs and give a position in init method of the my form. Running result: The control object position is always on the left top of my form when I run my form. I am not sure I understand. What is the "bug" you are reporting The default behavior of controls is Anchor = 0 (which means the object is neither moved, nor re-sized, when the form is resized), what value are you setting, and how What are you expecting to happen If you have an object with an Anchor value other than 0 and you want to move it programmatically, you need to save the Anchor and reset it after moving: For example: nAnchor = This.Anchor This.A ...Show All
csi_hugh move question
Hi again, I want to know if there is a function or command to move a file in visual fox pro 7. For example, if i want to move 'c:\users\pru.dbf' to c:\myapplicaction\pru.dbf. Thanks, Look in Help for: RENAME COPY FILE DELETE FILE (also ERASE) As has already been posted, there is nothing native to VFP to get a move done in one fell swoop. But, there always is the use of the Windows API to do a move, if you must go in that direction. MoveFile http://www.news2news.com/vfp/ group=27&function=20 The MoveFile function moves an existing file or a directory, including its children. Actually there is, as I ment ...Show All
kampak1111 Excel & Foxpro 5.0
oSheet.Paste(oSheet.Range('A30')) Looks like I'll end up writing your whole code step by step. Please create a new thread next time so others would also deal with your questions. oExcel = Createobject("Excel.Application") With oExcel .Workbooks.Add .Visible = .T. With .ActiveWorkBook.ActiveSheet .Range('A1:F10').Cells.Value = 'filledbefore' .Range("1:6").EntireRow.Insert Endwith Endwith I don't know what you mean by transparent. Maybe you meant this: oExcel.ActiveWindow.DisplayZeros = .F. ...Show All
mail2amar How copy form from VFP5 to VFP9
Hi, I'm a retired DOS programmer and am learning VFP9. I messed with VFP5 a few weeks ago and created a form (doesn't connect to anything and has no code - simply a form). I now have VFP9 and would like to copy that form from 5 to 9. How Thanks Lamon wrote: I messed with VFP5 a few weeks ago and created a form (doesn't connect to anything and has no code - simply a form). I now have VFP9 and would like to copy that form from 5 to 9. How You shouldn't have to do anything: the SCX should open equally well in 5 and 9. It's possible that saving it in 9 could leave it uneditable in 5, but that shouldn't be an issue for you. Aw, that's just too easy!! I expected there was much m ...Show All
NoEgo Simple question about option group labels
Can't find where to change the background color of the label portion of the option buttons. They stay the original color of a dirty beige. Even though the color of the group box changes, the label will not. How Thanks Interesting but I had already tried a new form ... with the same result. Also, neither form has any code applied. They were both built from scratch as a way to learn how to use VFP's form controls. Right click edit did it!!! Thank you very much. I wish it did. There are two choices 0=Transparent and 1=Opaque. Neither have any effect. Should it have And if so, what may I have done wrong when the form was created Would backstyle = 0 help Lamon, ...Show All
Wail_gsm Accessing VFP 8 through C# and ODBC
Our company has an online product ordering program that accesses our VFP 8 accounting package through an ODBC connection on our server. Occasionally, our system error log table will trap the following error: "ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]This file is incompatible with the current version of Visual FoxPro. Run 30UPDATE.PRG to update the file to the current version. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr)." All the offending lines are doing are forming a SELECT statement: OdbcConnection ODBCConn = null ; O ...Show All