Answer Questions

• David Hanzelka Tolbars and forms with PrivateDataSession

  Hi; I have a main toolbar for the application. one of the buttons on the toolbar does this: do frmStatements with customer.CustomerId When I have a form that is open and it has a private data session, clicking the toolbar button causes an error because the toolbar is not aware of the form's data. Can someone point me to the right direction - how the toolbar can see what is the value of certain data in the active form Thx. Tamar; That's what I was planning to do, or to use a public var, but I thought maybe there is a better way. Remember that I may have quite a few forms, and implementing it in every form is not as efficient as having a way to access the data. Any other ideas Is ...Show All

• Timmy0614 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   You can only do that through the Windows Control Panel. The settings are stored in the Registry and I suppose you could change them BUT if I had an application that changed my windows desktop - it would not be on my machine very long! Messing with user settings is a big "NO-NO!" in any computer program or application. On my personal machine I have my desktop set the way ...Show All

• MBrophy 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

• Bruxir Choppiness of Graphic animations (progressbars, etc.)?

  Its *good for users* to have a ProgressBar Indicator during backups of tables (while they wait for "who-knows-how-long", etc.). 'Twould be so nice for our users to be able to have: 1) the *Windows Flying Paper Progressbar* (during Window's copy/paste of files) ...or... 2) a 'Themed-progressbar' step-timed to the number of BYTES transferring during backup. (not just a wait window/Marquee (like Windows startup-progressbar), which leaves the user *hanging* about when its going to finish) Please try to help me (I'll continue researching this and let you-all know if I've found a ProgressBar routine that step-times according to actual bytes being copied) Just some extra info: You can copy one file, or some files, ...Show All

• Ed Abshire Speeding up SQL Statements

  As per Tamar Granor's interest, I'm curious if I can speed this up a bit; it takes almost 3 seconds of user-time on an IBM X41 tablet (SANS networking). Behold: Select Allt(patient.first_name)+' '+ patient.last_name As PatientName,Record From patient; UNION (Select Allt(patient.last_name)+', '+ patient.first_name As PatientName,Record From patient); UNION (Select Distinct Alltrim(Proper(patient.Record))+' '+Alltrim(patient.last_name)+', '+Left(patient.first_name,1) As PatientName,Record From patient Where patient.Record <> (' ')); UNION (Select Distinct Alltrim(Proper(visit.insur_no))+' '+Alltrim(visit.last_name)+', '+Left(visit.first_name,1) As PatientName,Record From visit Where visit.insur_no <> (' ') ...Show All

• robbie__ 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 Aw, that's just too easy!! I expected there was much more to it. Thanks, Garrett... 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 y ...Show All

• godzilla9 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 sorry i forgot to mention my client pc's vfp appli ...Show All

• Messs17 vfpencryption.fll

  hi all, i came across a library file to encrypt and decrypt from tis website.http://www.sweetpotatosoftware.com/SPSBlog/PermaLink,guid,23a74c5d-5173-420e-af23-22494d95a54c.aspx after i download the fll files i try encrypt but vfp prompt me invalid library file. set library to c:\windows\desktop\vfpencryption.fll. where is my error Thanks in advance. pls somebody help me. Alex is right. You are missing the proper runtime libraries for this. Go to the following page... http://www.sweetpotatosoftware.com/SPSBlog/PermaLink,guid,91241006-595a-487d-ac06-d0fc1fc71632.aspx ...and look for the section entitled " Important note about the required C++ runtime libraries " where you will find som ...Show All

• cmwith How to remove redundant phrase in field?

  Hi all........ I have a table field that contains things such as..... V DISCONTINUED W/O REPLACEMENT; V DISCONTINUED W/O REPLACEMENT -I&S MASTER; 7 SUB 2610-139-3704; I&S MASTER; 7 SUB FOR 2610-139-3704 What I need to do is remove the duplicate phrases, leaving only one instance of each phrase in the field. The amount of phrases in the field varies...could be 2 as shown above or there could be 6. I suspect that the 'common denominator' is the semi-colon, but everything I've tried has failed. Any help is greatly appreciated! I have proven my code with your example and I have obtained: Hello CDFAUX Thought this worked for me, but here's what I got: Th ...Show All

• freddieb VFP9 SP1 DLL Error

  Hi All Shot in the dark, but just wanted to see if anyone else is getting a similar problem. My VFP9 SP1 application has been working fine but over the last month, one of my forms has been returning an error with vfp9r.dll. It's the standard error with the "send report to Microsoft". The forms in question do not do anything different to any other form and I've cut down the code and tried to isolate the problem. However, the error does not happen all the time and some users experience it more than others. The form has not changed recently either. I've tried reinstalling the VFP runtime, giving users admin privledges, etc. Nothing works. The only thing I've got is an entry in the event viewer: The descriptio ...Show All

• Pocketmnky How to overwrite a disk file that is read-only?

  While trying to run oFS = Createobject('Scripting.FileSystemObject') ...... oFS.CopyFile (file1,file2,.T.) I get an error on statement # 2 if file2 is read-only. It is a errant situation. This file is not supposed to be this way. I have to transfer about 2,000 files each time and a couple of them turn out to be this way for no apparent reason. The program breaks down. How can I change this property on the fly programmatically Thanks. Thank you, Cetin. It is already working. Was there a problem with the forum website yesterday I could not sign in for a while. Function ModifyFileattribs lparameters tcFileName, tlReadOnly, tlHidden, tlSystem #define FILE_ATTRIBUTE_READONLY 0x00000001 #define FILE_ATTRIBUTE_ ...Show All

• vbjunkie Expecting Advise on A Graphics Problem

  Hi Everybody, I've project, that I have to use a custom worldmap and show some other drawing according their coordinates.Now I managed to draw the worldmap with FORM.LINE method. To zoom in/out I have to scale the worldmap. When I scaled 10x or much more times I can see the part that is on the form. And the other parts of the worldmap which is extended out of the form is lost. Because the LINEs that are created with LINE method aren't objects, form doesn't show any scroll bars to scroll left/right/up/down. So I need some thing like a canvas so that I can draw anything on it. And even it is off view I can managed to scroll to the extended drawing parts. Any ideas KAYA,Tolga Hi Cetin I tried really lots of things.& ...Show All

• jortiz Error massege: API library is not found when run program?

  Hi all! I use VFP9! My program was compiled to EXE file, but when run from EXE is error massege: "API library is not found when run program". But if start VFP9 before run program is normal not error! Thanks! Thanks Alex, - I don't use library API in my program. - OS WinXP SP1. - VFP not know line error! Do you know which library you are using and is not found You may have to debug the EXE (can't use debugger step-by-step) by writing to a log or using Wait Window or MessageBox in strategic places, or debugout. Once you find the offending API call you may have a handle on the problem. Is this happening in the same PC Which OS Are t ...Show All

• Fradam join confusion

  Hi All, I know i can manipulate data in a very long and strechted out process, but does any1 know of a the best join method to use for joining 10 tables Here is my situation. I have a table 'spec' it has 102 possible specialties. I then have 10 more tables that are named after the last 10 years (ie. 2005, 2004, 2003, ... , 1996). On each of the 10 year tables, there exists all the specialties of that year. I would like to join all 11 tables into one table. What join works the best. I broke it down here. 'spec' specialty spec1 spec2 spec3 . . . spec102 '2005' specialty     cnt spec1           10 spec3           15 spec96     ...Show All

• Vic02 My.ProgressBar for Backups?

  Its *good for users* to have a ProgressBar Indicator during backups of tables (while they wait for "who-knows-how-long", etc.). 'Twould be so nice for our users to be able to have: 1) the *Windows Flying Paper Progressbar* (during Window's copy/paste of files) ...or... 2) a 'Themed-progressbar' step-timed to the number of BYTES transferring during backup. (not just a wait window/Marquee (like Windows startup-progressbar), which leaves the user *hanging* about when its going to finish) Please try to help me (I'll continue researching this and let you-all know if I've found a ProgressBar routine that step-times according to actual bytes being copied) ...Well, found the flying-paper progressbar FILECOPY.AVI in ...Show All