Answer Questions

• Smylie Unknown Classes Loaded in Memory

  I just realized a problem that we have been having and now I finally found out why. Now I need a solution to address it. The gist of the problem is that we have a Public class based on another user defined class. When we compile the project, the class definition gets left in memory. As a result we cannot delete the files (clean the build folder) without closing out of the foxpro session. If I just compile the prg there is no problem, the problem is only when building from the project itself. I need a means to determine what classes are left loaded in memory (cached I guess) so that we can make our builder release them. RELEASE CLASS ALL does not work. You have to know the class name and the RELEASE CLASS <classname> Our only ...Show All

• ahmedilyas How to calculate the data connection time?

  I tried to add 2 fields, time_on, datetime, time_off, datetime to calculate user's log on time in the Users.dbf. How do I calculate the total time between the 2 value Any better way to capture users' activity Thank you for both of your replies. Can I wish to do is hide the timer codes, somewhere so that user won't notice. I figured out this formula, could you verify for me a=time_on b=time_off x=(b - a)/3600 x Thank you, you are right. it works in VFP9. Well since you didn't give the version number I gave a code that works in VFP9. Just replace text...endtext with a set textmerge block and you'd get what you wan ...Show All

• OmegaMan VFP9 Soap Server 2003

  Hi, I've written a VFP Soap Service and successfully tested it on LOCALHOST. When I deploy to server 2003 I keep getting the following error: "Error: 1429 - OLE IDispatch exception code 0 from WSDLOperation: WSDLOperation:Instantiating the dispatch object for method UpdateOracle failed HRESULT=0x80004005: Unspecified error - Server:An unanticipated error occurred during the processing of this request. HRESULT=0x80004005: Unspecified error .."associated the WSDL with SOAPIS30 I have deployed the VFP Runtimes on Server 2003, Installed SOAP 3.0, .DLL and allowed all unknow iSAPI extensions ... but no luck. However, if I install VFP9 Development then everything works!!. I have then proceeded to track the cha ...Show All

• Joymon Grid Reusable Form or Active-X question. Any Help?

  Hi, A problem I am always facing when I am creating a new software is the following: I usually need in every software a grid to display my records in some sort of way from a table of cursor. Ok the grid will change a bit from form to form and from software to software (different row colors, sometimes I ll need to sort by columns somentimes not, different fonts, buttons in grid or not or others things etc etc). Is there anywhere around the Internet such a ready made form-grid or Active X control that will do my job instead of each time spend a day of recreating it from almost scratch If it is also free (or cheap!) it would be really really very very nice :) Any help Thanks, Athan PS. Also any other forms - or links that ...Show All

• Luc Pettett Using INI files to store settings in Visual foxpro applications

  Does any one know a good example, tutorial, or walk through on how to save settings in your application to an ini file The best I found is "INI Class" at the UT: http://www.universalthread.com/wconnect/wc.dll 2,54,33,9309 You also have "Read / Write INI files": http://www.universalthread.com/wconnect/wc.dll 2,54,33,9766 ...Show All

• ycseattle can VFP9 take data type jpg, gif, or PDF ?

  You shouldn't expect others to write your code. ANyway here is a sample that you might expand yourself: Public oForm oForm = Createobject('form1') oForm.Show() Define Class form1 As Form Top = 0 Left = 0 Height = 470 Width = 740 DoCreate = .T. Caption = "HTML sample" Name = "Form1" HTMLFile='' && Custom prpoperty to hold temp .htm name * This is IE control - you'd use webbrowser4 from gallery instead * just because it already has some checks, extra pem. ie: wouldn't need readystate part * for the sake of keeping code short here I directly use olecontrol itself Add Object htmlviewer As OleControl With ; Top = 12, ; Left = 12, ; Height = 396, ; Width = 708, ; Visible = .T., ; Nam ...Show All

• csLearner Help converting string to numerical value

  hi, I'm trying to convert a string to a num with VAL(variable) however it returns a whole number with a decimal place. i.e. 69232.0 , how can I get VAL to just return a whole number aa = '69232.0' bb = CEILING ( VAL ( aa )) bb = int(val(aa)) Thank you! ...Show All

• Vinchenzo12 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 We are in same situation...I'm trying to view inside VFPODBC.MSI with ORCA to learn how can i install it "manually" but is hard for me ! Can anyone help us We have a bunch of code that doesn't work under VFPOLEDB, but works just fine under VFPODBC so we can't just switch... plus it's a deployed application, so in order to change code we'd have to put a bunch of remote customers through an app upgrade. When I say it still isn't working, I mean the install process is broke ( the VFPODBC.MSI that works with XP doesn't work on Vista )... ...Show All

• sdj_dk physcial Hard drive serial using api in windows vista

  Hi all, I am using a thrid party tool to protect my application using the physical hard disk number and microsoft licence number.It is working fine with XP and other versions of windows but not with windows vista . Is there anyway to get the physical hard drive serial number and micirsoft licence number using windows api in windows vista You may need to check new "apis" and new flags in visa: http://msdn2.microsoft.com/en-us/library/aa383874.aspx ...Show All

• Learning VB Backup Options for newbie to VFP9

  Can someone please advise me on how to perform backups to either a CD or a memory stick from a menu choice Referring to a previous thread re the zip libraries, how would I call these libraries then actually perform the physical backup to the CD or memory stick The users want VFP9 to completely run this routine for them without any intervention except either inserting a CD or placing the memory stick in the USB. Previously, the 2.6 app used the run pkzip then copied the file to a disk drive. Thanks Sammy32 You can use an external ZIP library. Generally using an ActiveX or DLL that does the ZIP seamlessly is a better idea. I use DynaZip (See http://fox.wikis.com/wc.dll Wiki~DynaZi ...Show All

• JRQ MyEditor (Edit Control) Validation in VFP-9: STOPPING Menus, etc?

  I'm trying to *stay within myEdit control(s)* until *pProcessing* is finished. I seek *better ways*, per se, from any of you (besides making the form(s) modal). Here are some of my awkward (non-bulletproof) workarounds. In myEditor.VALID ... If pProcessing This.SetFocus * Return .F. Endif To STOP Menus... In _msysmenu: set skip for pProcessing (for every menu bar()... ) OR SET SYSMENU SAVE SET SYSMENU TO ...when pProcessing is finished SET SYSMENU TO DEFAULT (I'd prefer to make _MSYSMENU/SYSMENU just *freeze* ... in a modal (myForm.windowtype=1) manner and not have it *blink* off and on ) To prevent oApp.oToolbar... If pProcessing oApp.oToolbar.enabled=.F. Endif Hiding forms until pProcessing is completed, Etc. Etc. Thanks in adv ...Show All

• Alvin Kuiper appending data into an existing DBF with an autoincrement field

  I have a table called special.dbf. It has a autoincrement field. I would like to append records to this file. The autoincrement field always defaults to zero and produces an error message. Any suggestions on how to append or insert records would be helpful. I would like to append using a text file or excel file from MS Access table Or import directly from Access to FoxPro. Drop the autoinc field from the list. For example when getting directly from access: Instead of: select * from ... use: select field1,field2 .... from ... && list all fields except autoinc Another way is to alter table command (wouldn't work if there are any longfieldnames): SQLExec(m.nHandle, "select * from AccessTable","V ...Show All

• ajay1007 Additon in character type data

  Dear Experts Field1 of Table1 has character type data, but digits. In Field2, I want to replace data as under 801 -------- 801 803 -------- 802 807 -------- 803 809 -------- 804 902 -------- 901 905 -------- 902 906 -------- 903 908 -------- 904 Please help   Tariq Mehmood wrote: Dear Experts Field1 of Table1 has character type data, but digits. In Field2, I want to replace data as under 801 -------- 801 803 -------- 802 807 -------- 803 809 -------- 804 902 -------- 901 905 -------- 902 906 -------- 903 908 -------- 904 Please help sele Table1 go top i = 1 do while !eof()     if i = 4        i = 1 &n ...Show All

• XpyXt How to check if a control exists?

  Hi. How can I go about checking if a control, eg Label, exists on a form Thanks Hi, I don't know if any built-in function exists, still you can go about having your own udf iterating though the form.controls array. Something like Func Ifobjexists Para cobjname for ii=1 to thisform.controlcount if thisform.controls(ii).name==cobjname return .t. endif next ii Return .f. I've not checked.... But I feel It'd help you. Regards, Markish Thanks, guys. Your suggestions helped! Look in help for PEMSTATUS() http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/1a82169f-fe6a-4631-a9c3-d106d127046b.asp fram ...Show All

• KIPREAL Framework in VFP...

  Hi all,          I'm planning to develop a framework for my development environment. The framework should enable me to automate most of the development process . Please help me with suggesting the directions to go about and things to consider...      Please tell me if there exist any such products....that can be customized to my own needs... Thanks in advance. Regards, Markish You may want to look at this book http://www.hentzenwerke.com/catalog/buildfox.htm I think there is both good and bad advice in it, so read carefully. There are also some .Net books that can help: http://www.apress.com/book/bookDisplay.html bID=279 http://www.apress.com/boo ...Show All