Answer Questions

• simon.bruynsteen sharing connections between applications

  Pehaps I better wrote: sharing databases between applications . This is the thing. I have a VFP application which is 99% complete. Occasionally I add some embelishments or premium features. I am also in the process of developing a C# app of Winsock style. It is a console app in Visual Studio 2005. It is supposed to use some of the same ODBC VFP9 databases. I've read that VFP databases are much superiod to SQLServer databases in terms of speed. I spent a day trying to figure out why I could not open a connection while my VFP app was open all the time and those databases were linked to it. Finally, even superstupid get their break and I realized that there was nothing wrong with my connection string. I shut the VFP app down. This brings m ...Show All

• spelger Line Drawing in Report

  I want to draw a triangle in report. Three points of the triangle will vary based on the values I specify. The triangle should be printed in a normal foxpro report. If it is not possible to do this in VFP, kindly let me know where it can be done. Thanks. >I have done line drawing in forms but not in reports. Where can I get a simple sample. Walter Nicholls published 3 part article sing GDI+ in VFP 9.0 with the FFC Library in FoxTalk 2.0 Magazine starting with August 2004 issue. Also: http://www.sweetpotatosoftware.com/SPSBlog/PermaLink,guid,1e3a72fe-ffba-43fe-97bf-d0856a435750.aspx http://www.code-magazine.com/article.aspx quickid=0404032&page=4 What version of FoxPro do yo ...Show All

• Nick Port 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 no...not the VFP SCREEN but at windows desktop screen itself. thanks   (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 ... >> ...Show All

• Ewild 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 Thanks Marcia for the guidance. I am still having problems getting it to work. I included sample code below. Briefly, what I am trying to do is copy one tab from one excel file to another (the Notes tab from copy_this_tab.xls to the first tab in into_this_file.xls). The first line in my trial section (which I believe is converted properly per your guidance) is what I thought it should be --> loWBFrom.sheets("Notes").copy(loXLTo.Workbooks("into_this_file.xls").sheets(1)) --> but ...Show All

• Skyone About the median of a grouped frequency distribution

  hi, I have a urgert problem about the median to be solved. I have the table like this age_group frequency cumulative frequency 1 18 18 2 24 42 3 39 81 4 23 104 5 12 116 6 8 124 What program code should I write to get the median Thanks. First you have to put your data in order. Either select with ORDER BY, or INDEX your table. You cannot reliably find a median on unordered data. Ascending or descending order does not matter. Given n as the number of data points: - If n is odd, take the middle value as your median: (n+1)/2 value - I ...Show All

• Aaron Sulwer Connect to Outlook Express and Microsoft Outlook

  Dear Expert, Can I know how to connect to the Outlook Express and Microsoft Outlook using FoxPro Like the data in a memo feild how I connect or send out using the Outlook Express and Microsoft Outlook Or Can I generete email using FoxPro Thank you.     Aleniko wrote: Can one use CDO if the SMTP server is an ISP You mean that the SMTP server is not installed locally Absolutely, all you need to know is how to access the SMTP Server. As I said earlier, the easiest way to do this is to configure Outlook Express correctly to create the necessary registry entries. Otherwise, you have to manually confiure CDO so that it can find the SM ...Show All

• Charles Tam browse fields in a window with noclear

  Define a window AA. Open a file. Browse fields a,b,c,d noclear rest in wind AA. When Esc key is pressed, the window is cleared. The "noclear "command does not work (Visual Foxpro 6) DEFI WIND LISTC FROM 06,32 TO 23,86 TITL "F3:Currency Help. USE Up/Down Arrows. ESC>=Search/Close" FILL FILE BAKICON; ICON FILE GRUPICONCIRCLEF FLOAT SELE 36 USE EXFILE ORDE CURCD NOUP GO TOP SET NEAR ON ACTI WIND LISTC *---------- DO WHILE .T. BROW FIEL CURCD:H="CUR":R, CURNAME/R:H="CURRENCY NAMES", CURRATE:H="EXC.RATE":R,CURDATE:H="UPDATED UPTO":R REST NOME NOED NOCLEAR IN WIND LISTC *----------------- CEQ = REPL(" ",5) @ 14,03 SAY SPACE(20) ...Show All

• Jason D. Camp form help

  hi! i am new in vfp now i am creating new proj and icreate form with theree grid i would like to auto increment id field (tab not to stop on this field) also when i click add buton it will refresh only parent form field ( not grid field) thanks lavesh how about refresh parent field and grid field when i add new recored thanks for your reply If I understand you correctly you want the ID Field to automatically calculate the next available number, and you do not want anyone to override this number If you are using version 9.0 of VFP you can use the database container with an auto increment field type. This will automatically calculate the next number wh ...Show All

• kkos Grid class

  I have made my own grid base class with 9 columns. When I create a grid based on this class, and I try to reduce the number of columns, I get an error message saying "Member COLUMN# is a class member" (# being the umber just above the one to which I want to change; if I want to go from 9 to 7, # = 8). What am I missing, believing this would work Hans L PS. I wanted to make every column heading centered vertically/horizontally and bold. With column # = -1, this cannot be done, as far as I understand (no columns in Propoerties). 1) You can decrease columncount to 8,7 ... in code. 2) You can use SetAll() to assign properties to all member controls of a container type class (like a grid). ...Show All

• Roxy1980 Why I can not read all kind of registry?

  I use the method GetRegKey, but with this, I can read only the registry that type is REG_SZ , but I need to read also the registry that type is REG_DWORD. With What I can obtain the value of registry whom type is REG_DWORD I have Windows XP, and use VFP9 Thank you. You need to supply lpdwType parameter to RegQueryValueEx. Here is a sample: #Define HKEY_CLASSES_ROOT -2147483648 #Define HKEY_CURRENT_USER -2147483647 #Define HKEY_LOCAL_MACHINE -2147483646 #Define HKEY_USERS -2147483645 #Define REG_SZ 1 && String #Define REG_BINARY 3 && Binary data #Define REG_DWORD 4 && 32bits int #Define ERROR_SUCCESS 0 && OK Declare Int ...Show All

• Kirk.Clawson VFP9 - Related record not seeking in a field valid in a browse command.

  Hi everyone. I have noticed a rather serious incompatibility between VFP9 and older Foxpro versions. In the following code, when the field valid is fired, the related table record is not seeked and not found. In older Foxpro, the related table record is already seeked in the valid clause. This happens only for the first entry in the 'TmpProd' table but subsequent entries are seeked and fine. Is there a solution for this aside from seeking within the field validation code SELECT 2 USE prod order ProdId &&Index is on ProdId SELECT 1 USE TmpProd EXCLUSIVE SET RELATION TO ProdId INTO prod zap APPEND BLANK BROWSE FIELDS ProdId:v=showinf(),design=Prod.design RETURN FUNCTION showinf ...Show All

• Punpromk Sys(2600) and Apps

  Sys(2600) is the way to send or retrieve a String from a memory Address. Passing the memory address to another application as a parameter, can we retrieve the string in memory sended by the first application I try it, but it doesn't work, I think the GlobalAlloc() doesn't work any more as Global but as Local - according to MS info) Does anyone know how to do it DaCosta11 yes, if you put: _Cliptext =lcString also works. With this method you avoid the use of extra DLLs calls such GlobalAlloc() and GlobalFree(). and, of course, you don't need the Chr(0) in the end of the lcString. the main propose is to use the memory address as a place holder for data in which others apps use it. It is working if you put: _Cliptext = Sys ( ...Show All

• rasmasyean problem with buffering table same open

  hello friends: I'm trying to migrate my aplication made in vfp 7.0 to vfp 9.0 . for example: in the invoices forms, i have the table buffering=4 , but in the same table I have other alias, but there are not have table buffering. so at the time, when I clik a replace, it does not update the information to me, until I move the leader or until I clik in tableupdate whit buffering I had these problems , but I found the solution whit the service pack 1' vfp9 instalation hola amigos estoy tratando de migrar mi aplicacion hecha en vfp 7.0 a vfp9.0 la cual por ejemplo en la forma de facturas tengo la tabla encabezado con table buffering = 4 pero esa misma tabla la tengo con otros alias pero sin table buffering la cual al momento de ...Show All

• Javahar Need assistance with re-write 2.6 to VFP 9 for a newbie

  Rewriting a 2.6 app that contains 2 tables, and screen sets into VFP9 and I am not sure what would be the best practice to handle the previous screen set information. I have normalized the 2 tables into 3 tables using Int(autoinc) for the customer id in 1 table, the booking id in the second table and the pet id for the last table. This app is a booking system for a dog kennel. Would you advise using form sets as the previous app had only 3 screens in the screen set. The first screen displayed all the customer information on the top portion of the screen, then the middle of the screen displayed the pet information for maximum of 5 pets. eg Customer information pet 1 information Pet 2 information Pet 3 information Pet 1 co ...Show All

• Claire O HUGE problem with the Container Control (?)

  In VFP9: I have a Form, that has a Container, that holds a Listbox The Listbox has some items in it. Now, if you try to click on an Item, hold the mouse clicked and drag it up and down, the selected item does not change, it just blocks there. When you release the mouse and click on another item, you now have TWO selected items in the Listbox. That is not normal. A Listbox outside a container works just fine. Has anyone been able to solve this Thanks. >> Has anyone been able to solve this Thanks. This is not native behavior. I just tested this with VFP Base Classes and I do not see the behavior you describe. The listbox functions identically whether it is in a container, on a Page in a Pageframe ...Show All