Answer Questions

• Keren S how to shutdown the OS without error

  good day to all. i use my Net monitoring system developed in VFP at my net cafe for almost a year now, and so far it works fine. But there is a little problem that although it don't bothered the user and me but it much better if it does not shows-up. When i shutdown the workstation or restart it from the server, before it will totally close there is sometimes that a VFP error message will pops-up, which will prompt to send the error to MS. How could i prevent such error as if there is still missing in my shutdown code, clear events, clear dll's, etc and etc they've all there already. it seems that the PC can't wait any longer to shutdown. Thanks for any help regarding this matter Thank you very much Alex & MarciaAkins for yo ...Show All

• ahmed921983 Any suggestion?

  Any suggestion why the record not disappearing from the grid of Form when I press the delete (it indicates the deletion by black sign but not disappearing) Thanks # DEFINE MSGBOX_YES 6 # DEFINE C_MSGBOX1 36 # DEFINE C_DELETE_LOC "Are you sure you want to delete this record " IF MESSAGEBOX (C_DELETE_LOC,C_MSGBOX1) = MSGBOX_YES DELETE IF ! EOF () SKIP 1 ENDIF IF EOF () AND ! BOF () SKIP -1 ENDIF THISFORM . Refresh ENDIF Thank you very much all of you I thought it works perfect, but it's not. Because the deleted record appears with blak mark when form run's next ...Show All

• Grotius 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. This has been almost a touchy subject for me. I started using foxpro about 3 years ago and as soon as I really got into it I was hooked. When I heard that VFP was being "phased out", I was, to say the least, somewhat devistated. I keep ho ...Show All

• Jeff Williams extract data

  Hi, i have some dbf file which are I dont know their content. I try to import data to access but give me error. I search lot but cannot find a solution. Finally i try to open connection foxpro dbf file using java jdbc.odbc, connection is ok. But the problem is i dont know internals of this dbf file, which columns they have etc... Also i dont know about dbf files. Are dbf files normal databases, i mean they contains tables, tables contains columns etc. My question is which queries do i have to use to learn internals of this file. By this way i can import data to a text file , maybe. Thnx. You can get VFPOLEDB provider here if you don't have it: http://www.microsoft.com/downloads/details.aspx FamilyId=E ...Show All

• alien- excel and foxpro

  Dear friends, when exporting datas to excel from foxpro using the copy to command, there after trying to do some calculations and formating the excel file using automatation macros how could I integrate this in foxpro, I don't know where to start. thanks for explaining me the functionality satish No with copy to command it is NOT easy. You see that it's not when you try to copy a lot of records (namely over 16384 records pre VFP9) and/or your data has memo in it. Also copying with type xls,xl5 etc have different results that they create different excel versions compatible files. Type csv,fox2x were better on general. IMHO ideal copy is with using automation and ADO. I think I sent this s ...Show All

• Corby Transactions, buffering questions...

  Hi all! I do have a code were I open a table, store it on a cursor like: select name,surname,address from myTable into cursor myCursor readWrite and I display it on a grid. Then what I do is to let the user select a record, click on an " EDIT " button and edit the specific record (on another form), and after he clicks on a " SAVE " button to commit the changes to the table. So far everything is fine! My main problem/question is that I need this software to be a multiuser application and run over a LAN. So all the tables are shared (so the database is) and I try to use BEGIN TRANSACTION , END TRANSACTION and ROLLBACK commands. But suppose I have 2 users, user A and user B. If user A and user B are both viewin ...Show All

• Northern Rob MSCHART AND VISUAL FOXPRO 9

  I am trying to use MSCHART with VFP9 and have some success until I want to set or change Legions, Titles, Colors etc. or to enter data into the second Y axis. Using any of the property / constant names only produces the message "Name Unknown". Any suggestions. No I didn't and that is why I said "try". I don't have VFP (nor any other thing including .Net framework) to test something (on this box). If you want to see working code, visit universalthread.com and search for codes that I sent multiple times. Making = arrData style is not important though. You can simpy use row,col in a loop (check the sample on UT for many different types of settings). I don't understand "of course" part. ...Show All

• Tdar how to pause scan endscan

  I have a scan endscan, which opens a form. I would like to pause the scan from executing the next line after opening the form. How can I do code sample: select somecursor go top scan gather information from somecursor open a form (wait until the form closes) execute another line endscan You can make the form a modal form. There is a property on the form: WindowType = 1 If your form is a class loForm = createobject("YourForm") loForm.Show(1) ...Show All

• AndyL Dynamic object creation

  Hi! Is it possible to create an image object at runtime in vfp 8. If yes then can any one tell me how to do it. Regards, >> Is it possible to create an image object at runtime in vfp 8 Of course. If you want it on a form just do this: ThisForm.AddObject( 'oImage', 'image' ) If it is an independent object, then use oImageRef = CREATEOBJECT( "image" ) Once you have created the object, just set its properties directly: WITH ThisForm.oImage .Top = 25 .Left = 50 .Picture = "C:\Graphics\myimage.jpg" [whatever else you need to set] .Visible = .T. ENDWITH The important one to note is VISIBLE - when you create a new object at run time it is always instantiated with Visible = .F. ...Show All

• Adam Covington Convert ADO recordset to a Foxpro DBF free table

  Hi,     I currently have a need to convert an ADO recordset to a DBF. I've seen some posts here on how to create and write to a DBF using C# in conjunction with the VFPOLEDB provider. I mocked some code up in VB6 similar to the example and I am able to open the dbf in VFP6 no problem. However, I'd like to find out what ADO to Foxpro field type conversions would work. The ADO recordset comes as a result of a query from SQL Server 2000, so there are bound to be some datatypes that will not convert natively. I've come up with this matrix so far based on some MSDN Library materials.     SQL DataType              ADO DataType   &nb ...Show All

• logtorahul Memo field conversion

  I am not a Foxpro developer so I'm throwing myself on the kindness of my foxpro brethern. I'm converting data from a foxpro system into Oracle and have run into a problem with a memo field. The data appears to be stored in a .fpt file and I haven't a clue as to how to get to the data and and convert it (including the foreign key) into a text file, excell or any other format that I can use. Any advice you can give me will be greatly appreciated. Alex Feldstein wrote: Isn't that what I said, in part, when I listed importing through OleDB or ODBC as options Oh, probably: I just thought that ODBC would fail with memo fields, for some reason. Darned if I can figure out why I thought this, ...Show All

• thanksforhelp Standard UI

  Hi! I have question for You. I`d like to change the look of my System but I don`t know how do it. The FoxPro (9) brings me standard Toolkit and I am blocked. I am inspired the UI of Vista and I would like to create something similar to it. I know that the people who use foxpro can do it. I need that information, it is very important for me. Help! And let me add Doug Hennig's post on the same topic: Creating Gradient Images the Fast and Easy Way http://doughennig.blogspot.com/2007/02/creating-gradient-images-fast-and-easy.html There are many small changes you can make to improve the look and feel of your apps. There is no single source for this, but many people a ...Show All

• skeezix Problem with on key label on conversion from Foxpro 2.5

  In an application that I converted from FoxPro 2.5 to VFP6 where I created the menus in VFP6 and then called the 108 prgs from this menu I have this problem I call this prg from within the menu the prg then calls on a procedure from the main prg which works fine until the time to choose the options I have two choices to press Escape to go out or to press F10 so I can continue and go to enter data, pressing Escape works fine but when I press F10 nothing happens. I was told to use “on key label” as a workaround. Ive tried splitting the lastkey part of the procedure into two procedures that could be called from a procedure that gets called from the “ prEp_hdr_f ”procedure and on this procedure all I have is to lines with on key label do that ...Show All

• Will George database question

  Hi again, I want to know if there is a command or a function that let me know if a fox table exists or not. Thanks, To add to dni's answer, FILE() checks for the existence of any file. You must supply the full name.ext and if it is not in the current path, you must supply the pathname too. Another complementary function for tables is to see if the table is in use in another area in your program: IF USED("myTableAlias") * it's open ENDIF Note that in this case it does not look for a file on disk (path\file.ext) but a table alias open in memory. FILE() IF FILE( 'foxuser.dbf' ) WAIT WINDOW 'Visual FoxPro resource file present' ...Show All

• Ray Dyce Record repositioning

  Thanks for the tips. I have already run extensive traces trying to track changes in the primary key and/or record number. The problem is I can go into the exact same record that the user reports the problem on, do the exact same sequence of keystrokes, and the problem doesn't occur. I've only seen it reposition one time while tracing, and unfortunately I didn't have the break point set before the record repositioned. I've modified the data entry form to trap these "jumps", and if I find the problem, I'll report it. There are any number of commands that move the record pointer so presumably you are using one of these in a When() or Valid(). For example: COUNT, SUM, AVERAGE, MAX, MIN, SEEK, LOOKUP etc etc etc. Are ...Show All