Answer Questions

• ved_30 Error loading file

  Hello, I can't open same forms and report, I getting error "Error loading file - record number n. "object" <or one of its members>. : Memo file c:\mypath...\my database.dct is missing or is infalid Is there a way to open these file I will deeply appreciate advices or ideas.. Thanks. Thanks, you save me Look at validate database recover command. Aleniko Aleniko, It isn't help me, I can build, run exe and see the forms and reports, but I can't modify them. I have a project with several database thanks for you help You can check: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp/html/err1881.asp ...Show All

• Pratyush copying tables from sqlserver to foxpro and vice versa

  Hi Experts, How can I copy an entire table from an SQL server database to foxpro (*.dbf) i.e i need to create a backup of sql server tables in foxpro (*.dbf) Any help Thanks in Advance [1] Establish a connection to SQL Server [2] Use SQLTABLES() to get a list of the tables [3] Use SQLEXEC() to select all data into a VFP cursor for each table [4] Use COPY DBF("sqlresult" ) TO [vfp_table_name] to create the VFP Table. ...Show All

• Faladrim Future of Visual Foxpro

  Hello friends, I have a general question. What will be the future of VFP The reason for asking this question is because, our company is planning a major commercial software development. So far we were very much satisfied with VFP. But now doubts are being raised whether we should base our investment on this platform or consider something new like VB.NET. Especially when we hear that the products will not be served beyond 2009!!! Any sincere opinion will be a big help. Thank you. Financial Investment companies here in the US often use the phrase "past performance is not an indicator of future returns". The same holds true with software. Just because old applications continue to run fine does not mean they will cont ...Show All

• nharendt how to check for your prg running?

  heres my prob. when you launch my application and minimize it and then try and launch it in a second screen you get alot of errors. how can i check if the program is already running so i know to cancel the prg right away if it is alrdy running Another possibility... use Windows Management Instrumentation Service... I use this function to kill existing processes I don't want running... PARAMETERS pc_ProcessToKill * Get connection to Windows Management Instrumentation service lo_WMI = GETOBJECT ("winmgmts://") * Set query into service to look for process to kill lc_Query = "select * from win32_process where name='" + pc_ProcessToKill + "'" ...Show All

• AndersL combo box inside a cell in grid

  hello, i wonder how to integrate the combo box in a cell of a grid. i saw this in one of the existing apps. i want the user to be able to select a record in that combo box and changes the record on the other cells in the grid. can anybody here to please guide me on how to do it. thank you jason what you can do is drag a combobox to a hidden part of the form. and everytime the user would click on a cell in the grid, you would change the coordinates of the combobox and make it visible. Then after the user clicks the combobox, you would transfer the text from the combobox to the grid and thereon make it invisible. Download Marcia Akins paper on this subject: " How to Put a Combo Box in a Grid " from http://www.tig ...Show All

• Binary Tiff files

  Hi gurus I am very new to VFP, so go easy on me. I would like to create a tiff file from a report, I dont want to view the tiff file or to open the tiff file once created, once the report runs, I just want to be able to give it a name and to save it on a folder as a tiff file. Can some help me with some code that I can see and learn or point me to the right direction or let me know where can I find some help on this matter. Thanks a bunch gurus OHHH.- VFP9 almost forget Thanks again gurus You may use ReportListener for tiff file.You will find a code exaple here: http://msdn2.microsoft.com/en-us/library/ms965281.aspx loListener = CREATEOBJECT ('ReportListener') loLis ...Show All

• jforward5 Imagelist control

  I want to add the imagelist control to the treeview control(ocx) but I keep getting a message that I have to initialize the imagelist control first. How is this done The treeview works fine. Both ocx controls are dropped on the form but I have been consistently getting the error. Appreciate the help.   alwayslearning wrote: Thank you very much for your answer. I placed this code into the init and I now receive: ole idispatch exception code 0 from treectrl: invalid object The bad part about this is that I have a functioning example of this tree control/ imagelist relationship in Fox 5.0 but when I try to recreate this in 9.0 for a different purpose, I continue to get this message ...Show All

• Jesper L. Nielsen Domain user as the anonymous account, problems...

  Hi all I have a domain account called sa-inetcms, I run my ASP.Net 2.0 web service under this account (configured in IIS 6.0). However, when it tries to perform an INSERT into a local table on the service, it says that the table (a foxpro dbf) is read-only, I've checked all permissions on the server, the sa-inetcms account has full permissions to everything it needs, yet it still fails. Any ideas what I'm doing wrong Thanks Kev rfreire wrote: Kev, please make sure your application is configured for use Windows Authentication and that you have Impersonation feature turned on. Doing that, your application will run using your windows account. Regards, Rodrigo When you say "your windows acco ...Show All

• Moahmad Can't access DBF with memo through ODBC (was Memo field conversion)

  I am using a Microsoft ODBC Driver to connect to 4 DBF files . One of them has Memo Fields in it and I am not able to see this particular table when I try to import it in Access. All the others I am able to see and they do not have memo fields. Any idea guys How I can fix this Deepak Patil wrote: I am using a Microsoft ODBC Driver to connect to 4 DBF files . One of them has Memo Fields in it and I am not able to see this particular table when I try to import it in Access. All the others I am able to see and they do not have memo fields. Which Microsoft ODBC driver are you using Is it the Visual FoxPro driver, or a different one The thing is I am no Fo ...Show All

• Ed Steele Wait Window "" timeout 0.01 and Sleep(10) in VFP-9

  At times my VFP processing requires *rest(s)* it seems. (report processing/printing, various functions, .BeforeRowColChange events, etc.) I've *discovered*: Wait Window "" timeout 0.01 && ... helps at times while the preferred: Windows API Sleep() routines && ...I've had NO success with API Sleep() declarations Any general or specific feedback concerning *rest(s)* in VFP-9 is appreciated. I overlooked your code, sorry. You don't need any code. It looks like after setting it to red your code is running fast and reaching "yellow". You're not seeing the change from speed despite it really changes (a human eye can notice 16 frames a second as far as I remember). Let's try to reproduce: Public ...Show All

• Kirti Mistry Future of Visual Foxpro

  Hello friends, I have a general question. What will be the future of VFP The reason for asking this question is because, our company is planning a major commercial software development. So far we were very much satisfied with VFP. But now doubts are being raised whether we should base our investment on this platform or consider something new like VB.NET. Especially when we hear that the products will not be served beyond 2009!!! Any sincere opinion will be a big help. Thank you. Microsoft has never said that VFP.Next (Sedna) will be version 10. I talked to Alan Griver (yag) last month in Germany and he said the decision on what to call it or how to package it hasn't been made yet. My bet is that it will be more of a servic ...Show All

• imdqa VBA to VFP code conversion

  Can anyone help with converting the following from VBA code generated in Excel to VFP code: Sheets("Notes").Copy Before:=Workbooks("AB0KF3FK.XLS").Sheets(1) Thank you You like to copy sheet "Notes" before Sheets is same workbook Am I understood correct Do you like to keep excel format or convert to tables And here are the steps that you can use to translate the VBA into VFP: 1. Add parentheses around the parameter list 2. Examine the calling prototype for the method in the object browser and rearrange the parameters in the generated macro so that they appear in the same order that they are listed here. Because VBA uses named parameters, th ...Show All

• laker_42 SCAN statement help

  can anyone see anything wrong with this SCAN statement The compiler says theres a Nesting error b/c (im guessing) that it sees ENDSCAN but doesn't recognize the SCAN statement like it should. SCAN WHILE VarSono $ sotran.sono AND ln_counter < 50 ; FOR sotran.qtyord <> 0 ; AND sotran.qtyshp = 0 ; AND NOT RTRIM(sotran.item) == "INSURANCE" ; AND NOT LEFT(sotran.item, 5) = "SHIP_" ; AND NOT sotran.sostat = "X" yeah, looking at it more though, this is a program im just modifying, instead of deleting the code I am just commenting it out and the commented code above the scan statement was breaking it up. *SCAN REST WHILE Detail.tranno = Master.tranno AND ...Show All

• Andrew Buyan SYS(3056)

  SYS(3056) - Forces Visual FoxPro to read its registry settings again and update itself with the current registry settings. Hi. I have accidentally executed "SYS(3056)" command in the Command Window. Now, whenever I open the Debugger Window (Environment: Debug Frame), VFP starts to crawl real slowly and the CPU usage jumps to 100%. Is there anyway to "undo" SYS(3056) command Thanks. Danny Thanks. It doesn't work as I am using VFP 8.0 However, I've tried Tools/Options Set As Default button. Problem still persist. I have managed to sort out the problem. Realised its got to do with the debugger. ...Show All

• CFIG SQL 2005 Varchar(max) and Visual Foxpro 9

  SQL 2005 has new type character data - varchar(max). This type will substitute type TEXT in future. SQL 2005 BOL recommed replace type TEXT to type varchar(max). Our research determine that type varchar(max) faster then TEXT. But Visual Foxpro 9.0 does not support this type. By sqlexec('select field from table','mycursor') does not return to cursor MEMO-field. For TEXT field this select return true MEMO-field. Question to developers: is support varchar(max) in plan to develop VFP Please, do it in service-pack! ...Show All