proper command help

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - VFP8 and installer Hi, I noticed that VS.NET 2003 has a template for building Setup projects under "Setup and Deployment". Has anyone used this to deploy VFP8 apps? Is there any documentation on how to do this? Our app has activex components and we use a post install procedure when we install it under VFP6. We don't want to use installshield. TIA Jan Tag: proper command help Tag: 192901
  - 2
    - VFP 8 - Northwind Demo Application If anyone has some time, your feedback of a demo product I'm developing would be greatly appreciated. I suppose you might call it a framework, but that may be going a bit far. The program includes a demo of the Northwind Database shipped with VFP 8.0. The demo is also compiled in VFP 8, and looks best when run on Windows XP The link can be found at http://members.cox.net/foxcon/SetupRanier.EX Feedback would be appreciated, either here or at turiya36@yahoo.com. There are a few known bugs, but their not too serious. Thanks! Long Live The Fox p.s. - no viruses, no spyware. WISE install included. Tag: proper command help Tag: 192899
  - 3
    - run VFP program as Windows 2000 service Hi all, I want to run my VFP 8 program as a Windows 2K service. This utility program constantly looks for some data and imports/exports to another application. I have made classes (one timer and other olepublic - timer class calls olepublic class methods periodically) and added code. But now I need to make it as a Windows service. How can I do this? Thanks in advance. Kamran Tag: proper command help Tag: 192889
  - 4
    - Using local view exclusively = reducing table corruption possibility??? Hi all, Just crossed my mind this afternoon: as we all understand, whenever we put a local view in the form's Data Environment, then vfp would open the underlying tables as well. I wonder if this has anything to do with table corruption possibility. I mean; what if the form only open the local view and not the underlying tables; suppose there is a power failure in the middle of transaction; would the table corruption possibility is lower than if the tables are open as well? (I hope I could convey my question well. Yet, if the question isn't clear enough, please let me know, I'll try to re-phrase.) TIA, Willianto Tag: proper command help Tag: 192868
  - 5
    - Newbie Control Subclassing Question Thanks in advance for the help. I'm still new to subclassing controls and I have what I believe is a very simple question. Where does the class code go so that I can use the new control on a form. For learning purposes I wrote a very simple variation of the label class that responds to the click event by reverting the colors. I'm putting the code here because it is short and I hope someone will tell me if I'm doing something silly. DEFINE CLASS ActiveLabel as Label PROCEDURE Click LOCAL TempRGB TempRGB = this.forecolor this.forecolor = this.backcolor this.backcolor = TempRGB this.refresh ENDPROC ENDDEFINE My question is where do I put this code so that I can use the ActiveLabel control on one of my forms using either AddObject in code or using the form designer. My immediate need is for using AddObject and doing it in code but I'd like having both answers. As always, Thanks in advance. Jeff Tag: proper command help Tag: 190867
  - 6
    - thisform.release() not working Any ideas? Close button in title bar works okay so not critical. Just anoying. Thanks in advance Tony --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.587 / Virus Database: 371 - Release Date: 12/02/2004 Tag: proper command help Tag: 190866
  - 7
    - row(), col(), top, and left Hello All and thank in advance for the help. I'm sure that some of you know that you can use both @ SAY and ? inside of a window for writing information. The functions Row() and Col() also continue to work in VFP so that you can tell where in the window you are. My question is: Is there a way to convert the values returned by Row() and Col() into values that will work for the Top and Left properties of a control. I've tried the assumption that a 25 by 80 character window is translated into a 640 x 480 pixel window but things aren't going where they belong when I use: oObject.Top = Row() * 20 oObject.Left = Col() * 8 I could probably figure this out by trial and error but if there is a formula or algorithm that someone knows I'd appreciate hearing about it. Thanks again, Jeff Tag: proper command help Tag: 190865
  - 8
    - DBF and DBT extensions I exported a table from MS Access into a DBF. It has 2 fields, one of which is a memo field. I'm going to have to import the DBF into a FoxPro database on Monday. When I exported, MS Access created two files, a DBF and a DBT file. What is the DBT for? Am I going to have issues when I try to import into FoxPro? I did a search and it appears the DBT is contains the memo field which could make some sense. The DBF is 5K and the DBT is 205K. Does the import process automatically look for the DBT file in the same folder? thanks! Tag: proper command help Tag: 190858
  - 9
    - Indirect Object Reference Suppose I need to dynamically create a series of objects and set their properties at run-time. What is the syntax I would use. For example lets suppose that under certain conditions that might occur while I'm scanning a database, I would like to create a label on a form and set its properties. For convenience (and uniqueness) I'm going to name the objects based on the record number in the database. Please help me filling what I'm missing: SCAN IF <condition occurs> obname = alltrim(str(recno())) thisform.addobject(obname, "Label") * here is the part that I don't know the syntax for * I need to set the top, left, width, and caption of this label that was just created. * the name of the object is contained in a variable * a "c like" approach would be something like thisform->obname.top = 5 but I doubt that is correct ENDIF ENDSCAN Thanks in advance Jeff Tag: proper command help Tag: 190848
  - 10
    - AOL, Yahoo, and Microsoft Instant Messaging Does anyone know of / have experience with libraries or ActiveX controls for instant messaging? It appears to me from a brief search that there are several available for Microsoft IM but I haven't been able to find any or AOL IM. One ActiveX control I found from LionKnight Software appears to support IM, File Transfer, or String Transfer. These would all be very useful to me. Does anyone have any experience with this product. They mention VFP support explicitly in their website which is always a good thing to see. Thanks. Jeff Tag: proper command help Tag: 190844
  - 11
    - Problem with listbox When you are in a textbox and you want to select something in a listbox you have to click two times. the first time to select the listbox and the second time to select something in the listbox. Does someone know how to do tis with one click. thanks Stefan Tag: proper command help Tag: 190835
  - 12
    - On Screen Keyboard Hi I want to use the On Screen Keyboard in my touch screen application. My application is developed in Microsoft Visual FoxPro 8.0. When the Application starts and the on screen keyboard is displayed to the user, I want the menu and the windows logo key to be not visible. How can I achieve this? Can anybody help me with this Thanks and Regards Tag: proper command help Tag: 190830
  - 13
    - Compile an .exe file! Hello I was just created some forms and reports, menus, stored procedures and triggers, but I found troubles to compile an .exe file as an error messge jumped out "Invalid Path or filename". It didn't tell where to correct this error. I have created .prg files like "main", "env"... So where can I debug such errors Thank you Brian Tag: proper command help Tag: 190829
  - 14
    - winsock.disconnected? Hmm.. when a winsock is listening, is there an event that would be fired when the remote host dropped connection? It seems that I need to poll winsock.state to detect a disconnection. There is a connectrequest() event (which is to be handled by the accept() method), but not one for hangup. -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 2:10pm up 1 day 19:16 load average: 1.00 1.00 0.97 Tag: proper command help Tag: 190828
  - 15
    - import into memo field I live in an MS Access world. I need to import data into a FoxPro DBF table. I got the following feedback from the creator of that table. Before I get into this, is there anything special I should know? Will an Access memo field export to a DBase III DBF file and import into the FoxPro DBF memo field without issue? ------------------------------------------------ The problem is going to be that Foxpro sees the Memo field in that DBF as a true "memo" field. That is, you can not import or enter data directly into that field. It has to be imported as a MEMO type in fox pro. ------------------------------------------------ thanks! Tag: proper command help Tag: 190820
  - 16
    - Fox with VB6 Error.. or not?? I am currently trying to insert a line into a foxpro table using VB6. When I run the insert statement, no error is generated but the line is never inserted. Also, If I open the table and then try to insert, there is still no error (I would expect one since the table is opened by me at that time). Does anyone know what might cause this? I am certain it's in my code because if I make a simple VB app that does nothing but insert this, it works fine. John Tag: proper command help Tag: 190815
  - 17
    - VFP and SQL I have a customer, whose network I support. Windows SBS2K server (Dual P4 xenon with 2 Gigabyte ram) with 5 W2KPro (P4 2.0 or better w/512 meg ram) workstations. They are using a Visual Foxpro application, database loaded on server, application loaded on workstations. The users have noticed that as more clients log on to application the performance slows. 500 megabyte database. When 1 or 2 users are accessing the program they both are satisfied with the performance. As additional users log on to application performance slows. Most complaints are in look ups or finding records (maybe the index takes to long) The program vendor is suggesting that my customer upgrade to the SQL ($7500.00)version of the program. Will upgrading to SQL make that much of a difference? Any other suggestions? Thanks for any feedback. explore@removethis@man@hotmail.com Tag: proper command help Tag: 190804
  - 18
    - Visual FoxPro-Multi-Projects Manager ver 1.054 (Freeware) Hello, All! http://www.superbasis.de/ProjectManager/index.htm With best regards, Mikhail Tchervonenko. Tag: proper command help Tag: 190799
  - 19
    - Example of create index with ADOX Hi, I need an example of How to create an index of a fox table with ADOX, using VFP8 OLEDB Provider. Thank you, Gonzalo Ferreyra Córdoba, Argentina Tag: proper command help Tag: 190798
  - 20
    - OLEcontrol in a form and winsock I am stuck again. The wincsock control was added, but it didn't connect to remote host. Clicking the connect button didn't initiate any tcp connection to my smtp server. local owinsock oform=createobject("myform") oform.show(1) define class myform as form add object owinsock as myole with ; protocol=0, ; remotehost="192.168.2.1", ; remoteport=25 add object text1 as textbox with top=0 add object command1 as commandbutton with ; top=220, left=100, caption="\<connect" procedure command1.click thisform.caption=thisform.owinsock.localip thisform.owinsock.connect * should dispaly 6 for connecting, 7 for connected thisform.text1.value=thisform.owinsock.state thisform.owinsock.close endproc enddefine define class myole as olecontrol oleclass="MSWinsock.Winsock.1" enddefine -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 5:38pm up 22:44 1 user 0.95 0.92 Tag: proper command help Tag: 190794
  - 21
    - Putting Formatted Text into Email I am using Word automation to open a document, edit the formatted text, and somehow email it to a recipient list I have in a DBF. I have created an Outlook.application item but can't figure out how to paste the formatted text into it (there is no 'paste' method in the Outlook object model). I also tried to figure out how to email directly from Word but can't find a 'recipient' property to set. Any help would be appreciated. --Mike Tag: proper command help Tag: 190790
  - 22
    - Passing parameter to an EXE Hi I want to pass a parameter to my VFP EXE such as running it like MyApp.EXE /s / How can I do this? I am using a .PRG as my "main". I tried using PARAMETER on the first line of my "main".PRG but I can't use the "/" switch. It gives me a "datatype mismatch". Please help ALC Tag: proper command help Tag: 190788
  - 23
    - Ken Levy's March 2004 Letter from the Editor From http://msdn.microsoft.com/vfoxpro/letters/ March 2004 Letter from the Editor There are many exciting announcements in this month's letter, so we'll dive right into the details. There is life on Europa... Visual FoxPro 9.0! Announcing here formally (insert mental drum roll here)... the next version of Visual FoxPro from Microsoft, code named Europa, will be named Visual FoxPro 9.0. Visual FoxPro 9.0 is scheduled to be released during the second half of this year. Announcing the official name of the next version of Visual FoxPro now will allow upcoming articles, conferences, events, etc. to freely use the name Visual FoxPro 9.0 instead of the Europa code name. Oh, beta! This coming June, Microsoft will release a public beta version of Visual FoxPro 9.0 on msdn.com for anyone world-wide to download and install for free! Life is like a box of Visual FoxPro 9.0 We have recently started the process with the packaging and branding group within Microsoft to create the product box for Visual FoxPro 9.0. It is very likely that the screen shot used on the back of the Visual FoxPro 9.0 box will be of the enhanced Report Writer. For the Visual FoxPro 8.0 back-of-the-box product highlight listing, I was unable to convince the team that we should include a bullet item for the return of the Puzzle: ACTIVATE WINDOW Puzzle FoxTalk Reloaded FoxTalk has been in existence for many years and is a great technical resource for FoxPro developers. I was a contributing author and editor of FoxTalk during the early days of GenScrnX and the new object-oriented features of Visual FoxPro 3.0. The publishers of FoxTalk, Ragan Communications (which acquired Pinnacle Publishing 15 months ago), have recently been making some big decisions concerning FoxTalk. After talking with the FoxTalk team at Ragan, we've come up with a plan to make the publication better than ever. FoxTalk welcomes to the team David Stevenson who is an experienced technical editor. Additionally, FoxTalk will now include a monthly column submitted by the VFP team at Microsoft called "Tips from the VFP Team", to give an insider's view of how to get the most from VFP. Along with the editorial changes, Ragan has decided to offer a new lower subscription rate! Ragan has confirmed with me that all of these changes will begin with the May 2004 issue of the publication now called FoxTalk 2.0. While Microsoft will be contributing monthly to the FoxTalk 2.0 publication, editor David Stevenson and the FoxTalk team will of course make all of the decisions regarding content, editing, etc. For example, if the VFP team suggests an article on the FoxPro "Puzzle", they may decline for other content readers would prefer to see. You should expect to see articles in FoxTalk 2.0 submitted by VFP team members as well as the top FoxPro authors world-wide. Stay tuned for more information about FoxTalk 2.0 and visit to subscribe at PinPub.com or renew your subscription today to show your support for FoxTalk while obtaining great upcoming Visual FoxPro content. The June issue of FoxTalk 2.0 will be dedicated exclusively to articles and information on Visual FoxPro 9.0 to complement the upcoming free public beta download on msdn.com. The May issue of FoxTalk 2.0 will include more details from the editor on the plans for exciting upcoming issues. Hocus pocus, more CoDe Focus David Stevenson, while previously working at EPS Software, worked with the VFP team on the special CoDe Focus issue for Visual FoxPro 8.0. The VFP team is currently working with Markus Egger at EPS Software on another great CoDe Focus issue for Visual FoxPro 9.0. That special issue is scheduled to be released and given to attendees at Advisor DevCon in Las Vegas, September 29, when we launch Visual FoxPro 9.0. The Visual FoxPro 8.0 issue of CoDe Focus, as well as a new issue on the topic of Office 2003, can be found free online at code-magazine.com/focus. FoxPro books in your FoxToolbox.com The online e-commerce store FoxToolbox.com, owned by DBX-Technologies, is a great resource for obtaining Visual FoxPro, Visual Studio .NET 2003, and MSDN Subscriptions as well as third party add-on products for Visual FoxPro. Our friends at FoxToolbox.com, including Jim Eddins, are busy working on plans to create, publish, and sell Visual FoxPro books on the upcoming release of Visual FoxPro 9.0. David Stevenson, the new technical editor for FoxTalk 2.0, is working part-time with the folks at DBX on their Visual FoxPro book publishing plans. The Eight FoxPro wonders of the world Yet more exciting news in the FoxPro community is the fact there will be eight conferences world-wide this year focusing on Visual FoxPro. DevEssentials - June in Kansas City, MO DevTeach - June in Montreal, Canada Praha DevCon - June in Prague, Czech Republic Advisor DevCon - September in Las Vegas, NV SouthwestFox - October in Phoenix, AZ Germany DevCon - November in Frankfurt, Germany PortalFox Conference - November in La Coruna, Spain OzFox - November in Sydney, Australia Take one Tablet PC with VFP and call me in the morning Later this month, we will be posting a new whitepaper on msdn.com called Creating Tablet PC Applications with Microsoft Visual FoxPro written by Mike Stewart of the VFP team. This new whitepaper will complement the article by Markus Egger of EPS Software in the July 2003 issue of FoxPro Advisor Magazine entitled Build Tablet PC Applications with Visual FoxPro. For more information on Microsoft's strategy with Tablet PCs, refer to the ZDNet article called Microsoft swallows tablet concept whole. In case you missed it, Visual FoxPro was recently mentioned in an article on InternetNews.com called Small Business Embraces the Tablet. AccountMate of the Month Last month in San Francisco, Softline AccountMate introduced a new interface to its software line at Evolution (its reseller conference). I spoke at a general session to almost 200 attendees, most of whom were FoxPro developers who have not yet upgraded to Visual FoxPro 8.0 but who plan to do so soon with the new release of AccountMate 6.5. It was stressed in AccountMate's keynote presentation that Visual FoxPro 8.0 played a significant role in AccountMate's new version 6.5 release. Most people (including the press) at the conference were amazed what AccountMate has done in the user interface using Visual FoxPro 8.0. The event made the news for Accounting Technology , which has 30,000 readers with 3 times that via pass along rate. AccountMate and AccPac are now both owned by the same parent company, see the article Best Strikes Again. A case of FoxPro identity We have several new case studies highlighting solutions based on Visual FoxPro 8.0 submitted to the case study team at Microsoft which are currently in the process of being posted on the Microsoft web site. These case studies will be targeting non-developers such as IT managers, decision makers, and executives. When the upcoming case studies on Visual FoxPro 8.0 are added to the Microsoft case studies web site, we will also make sure that the proper announcements go out about them in various Microsoft newsletters such as MSDN Flash, just like what occurs for Visual Studio and other case studies announced. Stay tuned for these new Visual FoxPro 8.0 case studies to be posted, and when they are, we will include links to them on the Visual FoxPro home page. Don't get blogged down without weblogs The new VS Data Team's WebBlog will have regular entries from VS Data group manager Alan Griver, myself, and others on the VS Data team, which includes the VFP team. The list of Microsoft employees and teams with their own weblogs is growing weekly at blogs.msdn.com. We encourage FoxPro developers to consider creating their own blog to discuss FoxPro related topics. A great example of a FoxPro related weblog is Craig Bernston's FoxBlog. For FoxPro developers adding .NET Framework programming to their toolbox of knowledge, read Rick Strahl's WebLog. For more generalized geek topics, check out master blog commander Robert Scoble's weblog at Scobleizer. For more Visual FoxPro resources in general, check out the listings on the Visual FoxPro Dev Center at Related Communities for Visual FoxPro. March to the beat of the FoxPro drum Here are some calls to action for all FoxPro developers to consider. It is important to not only say thanks to the vendors and sponsors within the community, but to also be active to show your support. Upgrade to Visual FoxPro 8.0 via product or MSDN at FoxtoolBox.com. Subscribe to BOTH FoxTalk 2.0 and FoxPro Advisor. Attend at least one Visual FoxPro conference this year to learn about Visual FoxPro 9.0, make contacts with other Visual FoxPro developers, and help continue to improve our great FoxPro community. As Gordon Gecko says in the movie Wall Street, "The most valuable commodity I know is information." Same Fox time, same Fox channel If you missed reading any of the letters from previous months, check them out at the side bar links on this web page under Archive. In next month's letter, we will have more Visual FoxPro whitepapers, new Visual FoxPro 8.0 sample downloads posted on msdn.com, and more juicy details on new features coming in Visual FoxPro 9.0. Ken Levy VS Data Product Manager Microsoft E-mail: klevy@microsoft.com -- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP cindy.winegarden@mvps.org www.cindywinegarden.com Tag: proper command help Tag: 190787
  - 24
    - Foxpro 2.6w under XP database access issues I have been testing out using a legacy 2.6w app on XP boxes and have been encountering "Not A Table/DBF" error messages which are temporary and incorrect. It will happen when I am using a shared table in 2 different instances of foxpro at the same time. Does anyone have any knowledge of a work around or fix to this? Thanks, Jonathan Kadish Tag: proper command help Tag: 190784
  - 25
    - Pass parm to form, form is "main" in project - doesn't work! I have a simple form that receives two parameters in form.init. I run form with parameters from within VFP, it works. I put form in project, set form as "main", compile into exe. I run the exe, with the same parameters. I get "no parameter statement is found". I'm thinking that you can't do this, anyone else confirm or comment? Tag: proper command help Tag: 190780
- Next
  - 1
    - How to remove code page warning on tables from fox 2.6? I use vfp8 and winxp. On a regular basis I have to append records from a fox 2.6 table to a table in a vfp8 database. The code below works, but it gives me two windows the user have to deal with. A 'table update warning' window and a 'select code page' window. As far as I gather from previous postings the first window no one knows how to get rid of, but what about the second? Sincerely, Jan Nordgreen The code: * oapp.cdatfolpat is the folder for the database and cfilepath is the fox 2.6 table caux = oapp.cdatfolpat + 'newathlt.dbf' COPY FILE (cfilepath) TO (caux) IF INDBC('newathlt', 'TABLE') then REMOVE TABLE 'newathlt' endif ADD TABLE 'newathlt' * append the new records to the sdstud.dbf table USE newathlt IN 0 EXCLUSIVE SELECT sdstud INSERT INTO sdstud (st_house, st_sex, st_studid, st_class, st_name) ; SELECT st_house, st_sex, st_studid, st_class, st_name FROM newathlt Tag: proper command help Tag: 190777
  - 2
    - ReportDepot for .NET Announcement: New version of ReportDepot for .NET released by Semurg Enterprise Now ReportDepot for .NET provides complete code integration with the Visual FoxPro environment ReportDepot for .NET can make your reporting solutions more flexible, since it allows you to output FRX reports to PDF, RTF, XML SpreadSheet, and HTML files Take a look at how easy it is to incorporate ReportDepot for .NET in your VFP application ReportDepot for .NET v. 04.02.00 is currently available fo download at http://www.semurg.c Tag: proper command help Tag: 190775
  - 3
    - Need HELP...! I have problem with formset. Hi, my problem is that i have a program and i want that the first windows to be in a formset. In this formset i've got my main windows. But i don't know why my windows appears only if i set it to 'As top level form'. But the fact is that i don't want this windows in 'As top level form' cause i'm not abble to open another windows over. frmLoading : As top level form frmSetMain --> frmMain : In top level form --> frmAccess : As top level form --> frmSetOther --> frmOther : In top level form --> frmForm2 : As top level form --> frmForm3 : As top level form From my program (program.prg) i call frmSetMain and frmSetMain open frmMain. If i set frmMain to "As top level form" it's work but when i load my frmAccess windows (to type an access code to acces my form) the windows appears in back of the frmMain windows. And if i set frmMain to "In Top Level form" the windows is loading but everything is close and i return to foxpro windows. I'm going to be crazy.... I hope that you will understand my problem..(sorry for my bad english). thanks maxime Tag: proper command help Tag: 190774
  - 4
    - Foxprow I have several old programs running on Foxprow alongside some new ones developed in VFP6. I use the patch so that Foxprow runs on faster machines. My query is this. My machine is getting old and runs at 450 mz using Windows 98. If I upgrade to a new machine using Windows XP and running at a much faster speed, is there a speed limit at which the Foxprow patch stops being effective ? Will Windows XP run old foxprow programs ? Thanks. -- Tim Hobson Tag: proper command help Tag: 190771
  - 5
    - Union problem in view I use vfp8 and winxp. This parametric view I have used as a recordsource for a list. CREATE VIEW v_Sdstud AS ; SELECT ; sdstud.st_name AS Athletes, ; sdstud.st_studid ; FROM ; Sdstud ; WHERE ; sdstud.st_house = ?choicehouse ; AND sdstud.st_sex = ?choicesex ; AND sdstud.st_athlete = .T. ; AND (Sdstud.st_class = ?choiceclass OR upper(?choiceclass) = 'OPEN') ; order by ; sdstud.st_name It works fine. When I run the form, the list is filled the way it should with name of students. Now, on the top of the list of students I would like to add the record '(No athlete)'. I have tried this: CREATE VIEW v_Sdstud AS ; SELECT ; sdstud.st_name as Athletes, ; sdstud.st_studid ; FROM ; Sdstud ; WHERE ; sdstud.st_house = ?choicehouse ; AND sdstud.st_sex = ?choicesex ; AND sdstud.st_athlete = .T. ; AND (Sdstud.st_class = ?choiceclass OR upper(?choiceclass) = 'OPEN') ; union ; SELECT ; '(No athlete)' as Athletes, ; 0 as st_studid ; from sdstud ; order by ; 1 When I browse the query from the data environment and feed it the parameters it works fine. However, when the form is running it gives me an empty list. What am I doing wrong? Is there a better way of doing this? Sincerely, Jan Nordgreen Tag: proper command help Tag: 190765
  - 6
    - use run in xp? can the FVP6 command RUN (used in a PRG) be used in Windows XP? Tag: proper command help Tag: 190763
  - 7
    - file is in use and used('tablename') I use vfp8 and winxp. When I run this code something strange happens. IF USED('sdstud') then USE IN 'sdstud' endif USE sdstud IN 0 exclusive && line 47 In line 47 I get 'file is in use' error message. How come, when I closed it in the instructions above line 47? When I run the code a step at a time, used('sdstud') is false so it goes straight to line 47 and reports 'file is in use'. Can anyone help me? Sincerely, Jan Nordgreen Tag: proper command help Tag: 190754
  - 8
    - Open DB Exclusively I need to open the Database exclusively but I don't want to get an error if someone else has the DB opened and has it shared. Is there a way to find out if the Database is currently opened by anyone else? VFP8 sp1 Tag: proper command help Tag: 190743
  - 9
    - Triggers Hi Q1. I have a small problem, actually I am looking for something we use in SQL server Inserted.CustName or Deleted.CustNam Q2. I have a table A. I have some triggers in this to update table I am flocking table A before updation. Do I need to flock table B in the trigger ? If I flock table B in the trigger, will the locking and unlocking will happen fo every record ? because my updation is 'update where <condition>' for more that on record. Will it execute the trigger and lock table B for all the record separatly ? That is if the update condition is for 10 records, it will update record in A and execute the trigger then update the 2nd record and execute th trigger etc Mike Tag: proper command help Tag: 190740
  - 10
    - Function argument value ... is invalid when buiding EXE In VFP 8.0 (sp 1 installed), when i build the EXE of a project containing an OLE public class, i get the following error message "Function argument value, type, or count is invalid" This error is displayed when the status bar has shown : "Creating type library & registering Com component". Any help will be appreciated, Kind regards, Guy Tag: proper command help Tag: 190735
  - 11
    - Future support for Visual Foxpro Hi Our company has a product written in Visual Foxpro. We have a potential customer who is worried about purchasing our product because they say "we have concerns that FoxPro will not be supported by Microsoft in a few years" Can anyone suggest any papers and/or statements which I could show them to reassure them Thanks in advance for any help Pauline Pearc Tag: proper command help Tag: 190732
  - 12
    - to GURUs Not exactly a VFP question Is there a firing event that can be used when someone opens a folder? I would like to make an app that would start when the user enters into a folder, in order, let us say, to remind you something. Demetrios, Greece Tag: proper command help Tag: 190729
  - 13
    - how to specify the directory where I want to get the file Hi, I have used GetFile('txt') to get file using browsing table. However, I don't know how to specify the directory where I want to get the file. Please Help. Thanks a lot, Ray Tag: proper command help Tag: 190727
  - 14
    - SQLProcedures equivalent for FoxPro I'm writing a C++ tool that will list among other things, the stored procedures in FoxPro dbc file. Is there an ODBC API for that? Has anyone done that? SQLProcedures is not supported in FoxPro. --Kobby Tag: proper command help Tag: 190723
  - 15
    - Newbie question I am fairly new to programming/foxpro. I am rewriting an existing dos application using vfp 8. The application has the ability to setup new company files. Upon creating these company files, it creates a folder in the application directory (for example if I setup company 54, a folder called "Data54" will be created with all the dbf files in that folder). My question is, how can I make this happen? I want to create a folder for a company to work out of. Any help at all would be much, much appreciated!! Tag: proper command help Tag: 190719
  - 16
    - Microsoft MAPI Message control... Hi, did someone knows how i can add attachment files (JPG, AVI etc...) to a message with Microsoft MAPI Message Control ? I try this but it dosn't work: IF !this.parent.signon() && Use the custom method RETURN ENDIF IF this.parent.LogSession && Check if the user was able to login this.parent.OleMMess.sessionid=this.parent.OleMSess.sessionid * Start a new mail message and build the text this.parent.OleMMess.compose lcMessageText="My message ....bla bla bla" SET STEP ON this.parent.OleMMess.msgnotetext=lcMessageText this.parent.OleMMess.msgsubject="subject.....bla bla bla" this.parent.OleMMess.attachmentIndex=1 this.parent.OleMMess.attachmentName ="dsc0001.jpg" this.parent.OleMMess.attachmentPathName="c:\temp\dsc0001.jpg" this.parent.OleMMess.send(1) IF this.parent.logsession this.parent.OleMSess.signoff ENDIF && Session Handle test ENDIF Thanks for your help ! Tag: proper command help Tag: 190715
  - 17
    - Running Fox Exe's from a local network, VFP5.0 vs VFP6 - 8 I have several small office applications written in Foxpro. Years ago I bought some of them up from Foxpro 2.6 & FPW 3.x into the what was then the newest 'Foxpro', 5.x, and then wrote a few more apps. When later on 6.0 had been out for a while I tried to move up to that version. To that point all I had to do when distributing an application was to put the exe, two Dlls, DBFs and a few other files in a directory on the local network protected by the appropriate NT security. Then put an shortcut on the users desktop pointing that exe. With lots of changes in our office responsibilties this is easy to connect new workstations to these apps. With 6.0 that all changed to have to setup the apps on each computer even though the exe and dbfs could be shared on the network. This is what I had to do with VB apps (which is one among other reasons I didn't use VB alot). I tried to putting all the files the 6.0 setup wizard was putting on each computer on the network in the exe's directory but it didn't work. I guess this is because of the files not being registered properly in the setup. I was hoping that Foxpro would just look for these files in that directory first without checking the registry The upshot of all this is that all the apps are still on 5.x . I suppose that I could set up one VFP 6.0 app on each workstation and then as long as the rest of the apps used the same componets they would not require an individual setup. Before I go that route I'm wondering if there is a way to run 6.0 ( or actually I have 7.0 now) the way that I ran the 5.x apps on the network ?? Tag: proper command help Tag: 190712
  - 18
    - ADIR() Question I have a directory with the file extensions of .LOG and .LOG_LIX. When I do a numberof = adir(testing,'*.log'). I get all the files, but what I want is just the files with the LOG extension and not the ones with LOG_LIX. Is there something that I am missing with the ADIR() command? Any help is grateful, Dale Tag: proper command help Tag: 190709
  - 19
    - Multiple detail band Which of the third party report generator offering multiple detail band that works well with VFP8? sp Tag: proper command help Tag: 190701
  - 20
    - Intellisense manager Can somebody help me How can I switch off automaticly the Intellisense Manager My config.fpw file contains the following line _VFP.EditorOptions = " But -sorry- this does not work. Every time when I start to use VFP8 I have to switch off Intellisense manager by hand Many thanks Sandor Tag: proper command help Tag: 190691
  - 21
    - Uploading Large files using XMLHTTP Hi All, I am using XMLHTTP object in VFP to upload files using VFP and having the problem of string too long to fit when uploading files more than 16MB. The error occurs when I try to concatenate the FILETOSTR data with the header info. Temporarily I worked around it by using a memo field. But then it gives the same error in the XMLHTTPObject.Send method. Any body knows any workarounds? * This is a pseudo code only x = FILETOSTR(FileToUpload) BuildPostData(x) && Builds the Header information etc XMLHTTPObject.Send(x) If the above cannot be fixed any other fox pro code that may work? I recall Rick had a wwHTTP class, will it support files more than 16 MB? Tag: proper command help Tag: 190689
  - 22
    - sharing of data HI i m using dos base foxpro i wnt to know wherether i can share data among few computers if can ah how to do it Tag: proper command help Tag: 190682
  - 23
    - VFP email client Hi, I asked recently about accessing port 110 using VFP to be able to parse email in a POP3 account before it was downloaded to a client. I got some great help on the Winsock control which did the job well. Couple of questions: Any ideas how to cleanly disconnect? The POP3 server keeps the connection open for a period of time if I use the Winsock Close() method, and VFP hangs for a similar period of time if I issue a POP3 "QUIT" command. This is just annoying, not important. Now I can access POP3, and can send email in various ways (using BLAT for this, but CDO and wwipstuff are other SMTP based options), I wanted to see if I could write a basic email client using VFP. All works well so far unless I want to reply to an HTML email. In OE or Outlook, you click "Reply" and you can type your reply into what looks like an edit box, but with the original HTML nicely rendered below. Can this be done in VFP? I can display the original HTML using the Web Browser control, but I'm a bit stuck on creating an interactively editable browser object. I'm only doing this as an experiment. It's non-production, but would welcome any help. Neil Tag: proper command help Tag: 190672
  - 24
    - What is the SYS(1104)? What is the SYS(1104)? I found no docs about it! (VFP 6.0sp5) I test also the SYS(1101), SYS(1102), SYS(1103). They also return numeric values, but no docs about these... Have a nice day (or night), Nick Pofiris, ErmisPliroforiki Athens-Greece www.ermis-pliroforiki.com.gr Tag: proper command help Tag: 190663
  - 25
    - Subreport w/ External Foxpro DBF I'm having a problem with a report. I have a problem getting my subreport linked to my main report. I have a primary file used for the main report, and a second (stand alone) file for the subreport. The subreport is not showing any information from the second file. I'm at a loss, and could use some advise. I have included some details below. I have a file that includes multiple fields that are used in the main report: customer name, customer number, job number, company number, and equipment id. I have a second file which is a list of equipment used on a given job: (subreport) job number, company number, equipment id, serial number, model # These files are not joined in the report, I wish to use subreport links to join the two together. The second file will list the detail info for a given piece of equipment and for a given job. I setup the links as follows: ?Pm-Customer_history.ncompany = cs_equip.nCompany ?Pm-Customer_history.nsite_equipid = cs_equip.nsite_equipID ?Pm-Customer_history.njobnumber = cs_equip.njobnumer The selection formula (record) on the subreport was left as it was created by the SubReport Links window. -------------------------------- Thx in advance, Dan Tallent Tag: proper command help Tag: 190658

I would like to change an entire field to proper case ( ALASKAJOE TO Alaskajoe)
I read the foxpro help portion about proper() command but didn't understand the STORE portion

Should this be excel I would create an new field. use =proper(field), copy, past values

There has to be an easier way

Thanks for you hel

Jo

ps-- I don't want to do just one record. I wand the entire field changed to proper case

Top

RE: proper command help by anonymous

anonymous
Sat Apr 17 05:21:01 CDT 2004

You were probably confounded by the VFP example. Just use PROPER() as follows

REPLACE ALL Myfield with PROPER(Myfield) in Mytabl

where 'Myfield' is the name of the field you want to convert to proper case and 'Mytable' is the table which contains that field.

Top

RE: proper command help by anonymous

anonymous
Sat Apr 17 20:41:02 CDT 2004

THANK YOU

Top