Answer Questions

• SillyMS MS SQL Server or VFP Database???

  Hi every one, hi MVFPs, I am working with SQL Server database, but I wonder that I've got some big problem with SQL table that has more than 500,000 records. If there are about 50 connections access to that table with select, update,,, task, the SQL will become very slowly and return error message as: ....query out of time,,, or dead lock.... If I work with VFP database, there are about more 100 connections with command "use" the table, and so often tasks to seek, select, update.... but It still work well even if not too fast. And I have a VFP table with more than 1,5 billion records working hard like that. So now I don't know if I will working with VFP database or getting SQL instead because of the more security of usin ...Show All

• Ubersnack Help with expression (one more time...)?

  Hello All...many thanks to all who helped with my previous post. I have hit one more 'snag' in preparing my data. Here's a sample of three fields in my table... MRC REQUIRED DETAILS 4720-00-001-0057 ADLF HOSE OR TUBING SPEC/STD DATA MIL MIL-H-5593,SIZE 4 SPECIFICATION ADJM INNER CONVEYING TUBE MATERIAL RUBBER, SYNTHETIC MEDA MEDIA FOR WHICH DESIGNED AIR CRWL INSIDE SURFACE CONDITION SMOOTH CQCS LAYER COMPOSITION AND LOCATION 1ST LAYER ANY ACCEPTABLE CQCS OUTER LAYER MOLDED RUBBER CRJM OUTER COVERING ENVIRONMENTAL ABRASION RESISTANT AND PROTECTION CRJM ...Show All

• KDragon75 Date formatting in a report

  I have an older accounting app (SBT Pro) that is using VFP 5. I don't have the source code available, but I can modify things in the report design. Currently control text box in bound to variable txt_date which displays in the report as mm/dd/yy (i.e. 07/24/06). I need it to show like mm/dd/yyyy (07/24/2006). I've tried several things, no success. How can I do this Thanks, Shreko To be honest with you, I don't really know if it is text field or date. I just see control on the form bound to value "ct_date" or something like that. I would not mind experiment with different suggestions, but I don't wanna burn too many cheques. This all comes from cheques layout being changed, I was able to move control box ...Show All

• bhoopathi VPF 6: Problem sending the item from the combo to report designer

  Hi all, I have a problem sending the data to the report designer after selecting the data from the pull-down combo. There is a field namely lbl_attname in the report designer. In Click procedure of the command button, if not(empty(thisform.Combo1.value)) lbl_attname = alltrim(thisform.Combo1.value) else lbl_attname = 'To whom it concerns”. endif I tried this code as above but it cannot work. Pls enlighten me. Thank you. Phrases like "it cannot work" is not helpfull. What do you exactly mean by that What happens Error message Maybe it's just the typo in your code having unmatching quotes and dot: 'To whom it concerns”. ...Show All

• Doug_Schulte how to create a setup wizards?

  Sorry for the incomplete questions before. Yes, i know how to build an executable but i really don't know how to create a setup wizards in Version 7.0 but in Version 5.0 you can only click the Tools--->Wizards--->Setup. Where's the Setup Wizard in Version 7.0 Starting with VFP 7.0, a version of InstallShield was shipped. You can use that to create an installation package for your application. There is a guide to doing this: "Walkthrough: Creating a Visual FoxPro Application Setup Program Using InstallShield Express " available from the VFP Website at: http://msdn2.microsoft.com/en-us/library/ms917481.aspx VFP7 and above comes with Installshield Express which you can use to build setup files ...Show All

• Jon Watte Foxpro7 crashing with "fatal error exception code=c0000005 ..."

  Hi I have a tricky issue in my VFP7 application. At least tricky for me.  The application is crashing with fatal error C0000005. Sometimes I see a message like this one in the eventlog: "Faulting application <appname>.exe, version 1.4.82.0, faulting module ntdll.dll, version 5.1.2600.2180, fault address 0x00010f29.". Sometimes the application just hangs. I also see the Windows error "The instruction at "0x...." referenced memory at "0x.....". The memory could not be "read"", and then the application is closed, of cource. The error does only appear in situations where I print, but it does not occur in an exact pattern, or when I pass a particular code line. I use a third party dll called foxpp.dll ( ...Show All

• TheresaKad Upgrade MfoxPlus program to Visual FoxPro

  I had an early verson of FoxPro and I remember that it would convert mfoxplus programs to foxpro. Now years later an old customer is tired of running the program on Windows 98 and has upgraded to XP and would like to upgrade to a program that will run networked on XP without lots of problems. Will the new Visual FoxPro convert old foxplus code If not was there a version of Visual FoxPro that had this ability. Any help will be appreciated................ Aleniko, "If you are running in a multi user environment all your machines have to be XP, or 98 - you can't mix and match cause you would run into some locking problems." Our customers (and we ourselves) ...Show All

• QWERTYtech should I uninstall vfp6 before I install vfp9?

  hiya, I have vfp6 (as part of visual studio install) Should I uninstall it before I install vfp9 cheers, yogi thanks folks, it's now successfully installed.. yogi yogiberr wrote: I have vfp6 (as part of visual studio install) Should I uninstall it before I install vfp9 Only if you want to for some reason. They co-exist very happily on the same machine. I have both versions on my machine. No need to. You can have all versions installed in the same PC as long as you install them in different folders. Be aware that the Windows association will go to the last installed version. (i.e. if you click on Explorer in a V ...Show All

• WillieSea TYPE

  I like to know what character will return function TYPE() from x, where x is: x=STR ( YEAR ( DATE ())) I think I have somthing wrong with my vfp 9 installation. Don's right: TYPE ("STR(YEAR(DATE()))") && = "C" x = TYPE ("STR(YEAR(DATE()))") TYPE ("x") && = "C" It will always be "C" for character with this code. What do you expect from this You are right but I receive "N" on 2 computers (one with vfp 6 and other with vfp 9) and I don't know why. ...Show All

• wpm How to check a customized class property?

  I tried to find the value of a class property that was created by the previous programmer. But I did not succeed. How can I do that   Oooops, I found the value in the Property screen . Thank you for looking! (..) Amazing how often one finds the answer 3 seconds after hitting the 'Post' button I'll flag this thread as closed then ...Show All

• mague Debugging COM Server...

  Hi, I have a problem triggering a breakpoint in my VFP9 generated COM Server. I have built a COM server class having several different public methods. And I have built a client app in C++ which over automation instantiate an object of my server class and calls one of the methods. I'm using the debugger in Visual Studio 2005 to debug my C++ client application to the point where my automation method is called over COM. What I like now, is the ability to debug the VFP com server method as well. I would like a breakpoint to trigger in the method, so that I can watch variables etc. and in general debug my VFP code. How can I start Visual Studio and/or VFP so that I can trigger breakpoints in my VFP code In general I had envisi ...Show All

• sbni Sending Email through Visual Foxpro

  Dear Sir, I want to send email through visual foxpro. please write me code to help me. Thanks & regards, - Ravi Awasthi You have many options.  Look at http://fox.wikis.com/wc.dll Wiki~AutomatedEmail http://fox.wikis.com/wc.dll Wiki~CdoEmail http://fox.wikis.com/wc.dll Wiki~SendMapiEmail for choices and sample code. Samples courtesy of Craig S. Boyd [MVP]: MAPI MS Outlook CDOSYS CDO NTS Windows Shell WinExec W3JMAIL BLAT ESSMTP   You can get the code and links to Craig Boyd's functions in this post  Connect to Outlook Express and Microsoft Outlook You can use  West Wind Intern ...Show All

• Andre&amp;#39;s Excel to cursor?

  Hi guys, I am working with some data that is about 400 lines long, and I need to update it into MS SQL 2000 via Visual FoxPro. I need to know, is there a way I can take excel data and import it into a FoxPro cursor Thanks You ned to import Excel data into a VFP cursor (Dave showed you one way of doing that). Once you have the data in a temporary cursor (or save it in a permanent DBF if you want). you traverse te cursor with SCAN..ENDSCAN and for each record you look to see if it is in SQL Server. Once found just update the SQL Server record witn the info you want. To connect to SQL Server from VFP you have several ways: ODBC OleDB+ADO Cursor Adapter (ODBC or OleDB) Remote Views (ODBC) Read the chapter on Cl ...Show All

• syhzaidi Select question

  Hi, I want to know how to put the result of a select statement into a single variable. For example, how will be the sql statement that puts the salary of an employee into a variable given employee_id. Thanks, Results of a SELECT goes into a cursor unless specified otherwise with the INTO clause. The cursor's name is Query by default, so to answer your question you can just... employee_id = query.salary You'd select into array as Don pointed out. However you might also use xBase commands directly and do not use a select. ie: local empSalary if !used('SalLookup') use Employee in 0 again alias 'SalLookup' endif empSalary = iif( seek( m.employee_id, 'SalLookup', 'employee_id' ), SalLo ...Show All

• Slauncha Man 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 loListener = CREATEOBJECT ('ReportListener') loListener. LISTENERTYPE = 3 REPORT FORMAT myReport RANGE 1,1 OBJECT loListener loListener. OUTPUTPAGE (1,'c:\quaro.tif',101) & ...Show All