Getfile Q.

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
    - Running SQL Views from VFP9 Does anyone have an example of how to run a predefined SQL view from VFP? I have looked all over the net for anything about views and cannot find anything but how to run a stored procedure from VFP. I have tried changing the syntax, but nothing seems to work. I am simply trying to run a currently pre-defined view from SQL that returns a table of vehicle data. Any help would be appreciated. Thanks in Advance. Tag: Getfile Q. Tag: 218619
  - 2
    - chart recommendations? The MS Chart control is getting to be a bit limiting for an application I have. I don't need anything terribly fancy, but I do need more control over some aspects, in particular axis labels. Also, I must have several charts on one form, so speed is a concern. Simplicity of use is also up there. Anyone used a chart control that they can recommend? -- You can reach me at: p one six seven k b r (remove spaces and convert words to digits) at comcast dot net Tag: Getfile Q. Tag: 218609
  - 3
    - Sending Key Strokes to another Windows Application Dear Friends, Is there a way to send Keystrokes to another windows application from Visual Foxpro 8 Application. Please guide how to go about it. Regards S Bans Tag: Getfile Q. Tag: 218570
  - 4
    - Debug on client machine (vfp 7) I need to debug an application on a client PC, where VFP is not present. I have tried using messageboxes on strategic places in the code, but it's quite tedious. Any good ideas on this? Tag: Getfile Q. Tag: 218567
  - 5
    - Keybord Hi 2 all How can i hook keyboard Interrupt ,. means when software is minimize the key stroke are captured in to a table or array -- Qaiser Me Tag: Getfile Q. Tag: 218564
  - 6
    - How to handle connectivity breaks without losing data Hi to all. Our application is used by 100 users simultaneously. We use views that can be updated to store the data in SQL Server. When the connectivity is broken (ODBC) it is shown a window with a connectivity error and Vfoxpro shows a window asking for the connectivity password. 1.Is there any way to avoid that the password window appears? 2.How can I establish the connectivity without closing the view? Regards, JosÃ© Tag: Getfile Q. Tag: 218546
  - 7
    - Prompting before closing project window? Is it possible to have VFP9 confirm that you want to close the project window? Reason: Using SourceSafe takes about 5 minutes to load my project window up, and when I mistakenly close the project window, it's quite annoying having to wait for it to come up again. Tag: Getfile Q. Tag: 218541
  - 8
    - long wait for "attempt to lock ..." This is a multi-part message in MIME format. ------=_NextPart_000_002E_01C5F140.B7C41890 Content-Type: text/plain; charset="windows-874" Content-Transfer-Encoding: quoted-printable Hi, Sometime my VFP exe happens in network environment "attempt to lock ..." = and users have to wait long. I usually code this way , eg :- sele 0 use dbf1 index dbf1 set order to tag tag1 seek cVar do while !eof() .and. ref=3DcVar if ... replace ... endif skip enddo use I never apply any USE .. EXCL nor RLOCK()/FLOCK(). How suppose I code to allow all dbfs in sharing mode by many users and = avoid this annoying locking message ? Regards Hoe ------=_NextPart_000_002E_01C5F140.B7C41890 Content-Type: text/html; charset="windows-874" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dwindows-874"> <META content=3D"MSHTML 6.00.2900.2668" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Sometime my VFP exe happens in = network=20 environment "attempt to lock ..." and users have to wait long. I usually = code=20 this way , eg  :-</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>sele 0</FONT></DIV> <DIV><FONT face=3DArial size=3D2>use dbf1 index dbf1</FONT></DIV> <DIV><FONT face=3DArial size=3D2>set order to tag tag1</FONT></DIV> <DIV><FONT face=3DArial size=3D2>seek cVar</FONT></DIV> <DIV><FONT face=3DArial size=3D2>do while !eof() .and. = ref=3DcVar</FONT></DIV> <DIV><FONT face=3DArial size=3D2>  if ...</FONT></DIV> <DIV><FONT face=3DArial size=3D2>     replace = ...</FONT></DIV> <DIV><FONT face=3DArial size=3D2>  endif</FONT></DIV> <DIV><FONT face=3DArial size=3D2>  skip</FONT></DIV> <DIV><FONT face=3DArial size=3D2>enddo</FONT></DIV> <DIV><FONT face=3DArial size=3D2>use</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I never apply any USE .. EXCL nor=20 RLOCK()/FLOCK().</FONT></DIV> <DIV><FONT face=3DArial size=3D2>How suppose I code = to allow all dbfs=20 in sharing mode by many users and avoid this annoying locking message=20 ?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Hoe</FONT></DIV></BODY></HTML> ------=_NextPart_000_002E_01C5F140.B7C41890-- Tag: Getfile Q. Tag: 218533
  - 9
    - Database Corrupt ( please help) my client PC had been infected with virus and when he/she using the visual foxpro application, the PC always hang , now the database seems corrupt and need to be indexed. Does any msdn web site talking about database index problem when PC hangs ? I need to show some supporting to my client/ thanks in advance Tag: Getfile Q. Tag: 218531
  - 10
    - Virtual Desktop for Windows (freeware) http://virtuawin.sourceforge.net/ -- .~. Might, Courage, Vision. Sincerity. http://www.linux-sxs.org / v \ /( _ )\ (Ubuntu) Linux 2.6.14 ^ ^ 19:20:02 up 25 days 21:06 load average: 1.09 1.13 1.15 Tag: Getfile Q. Tag: 218527
  - 11
    - Carriage return in Edit Box I want to put a string into edit box ( I am a boy. I live in China) becomes, I am a boy I live in China Does anyone know the carriage return ?? Thanks a lot Tag: Getfile Q. Tag: 218522
  - 12
    - "USE" commands in Visual Foxpro Hi All, This is Sam. I'm new to Visual Foxpro. I'm now having troubles about sharing .exe file and seeking for any professional help from all of you. I have developed a system and now expecting to share my compiled .exe file(inventory.exe) to other computers. My system are placed in computer "A" and logon to it, and using B computer to try access into same system in "A" computer. It generated an error message "Invalid operation of reading files". The system was closed after hit "cancel". I debugged and found an error message was from using the word "USE". I often use "select 1" (workarea) and "use sysid"(open table "sysid"). I already placed the command "SET EXCLUSIVE OFF" in Main Program and the first command of each form designer "init()". I had also tried "use sysid shared" it still doesn't work. So what's wrong with my program? Please help, Many thanks, Sam. Tag: Getfile Q. Tag: 218519
  - 13
    - How can I know if a table is in use by another user Hello: I have a project when I share tables with some users. But, I don´t know how can I be sure if a table is in use or not. I open tables EXCLUSIVE and when a user is using them, FoxPro says an error, but I want to avoid this error. Someone can help me? Regards in advance -- rod_esq ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Getfile Q. Tag: 218517
  - 14
    - iSeries Connection I need to talk to an iSeries and have setup an ODBC connection and connect in the following way: ConnHandle = SQLStringConnect('DSN=iSeriesODBC;UID=&myUserID;PWD=&myPassword') While this does work well 99% of the time, once in a while I see the iSeries Logon Screen and once this screen appears I can only kill the foxpro application. There is a Cancel button on the iSeries screen, but it never works. The iSeries ODBC is setup with a specific UserID and to never prompt for SQLConnect. Is there any way to trap for this situation and not have to tell users to kill the application. Anyone have any ideas on why this happens?? Thanks for your assistance Tag: Getfile Q. Tag: 218516
  - 15
    - Where can I still purchase VFP 8? I need to purchase a copy of VFP 8. Does any place still have it? Thanks Much Greg Tag: Getfile Q. Tag: 218505
  - 16
    - ComboBox in a Grid - Using selstart will not work - Help?? Hey All, I have a combobox that has the following code in the KEYPRESS method. This code will functionally highlight and give you quick searching (Typeahead) on your combobox items as you type. The only problem is when I put it in a grid, I can no longer use .SelStart because it and .SelLength are always set to 0. Any idea of why a grid would behave different than a form? Any workarounds for this? I am simply trying to do "typeahead" within a combobox and a grid. If someone has some other code which works in a combobox, I would be happy to use that too!! Any help would be appreciated. Thanks, Sean ******************************************************************************************** *Combobox Example Code: ******************************************************************************************** Rowsource: one,two,three,four,five,six,seven (example data) *//*KEYPRESS METHOD: LPARAMETERS nKeyCode, nShiftAltCtrl WITH THIS IF nKeyCode = 127 and .SELLENGTH = 0 AND .SELSTART = 0 NODEFAULT RETURN ENDIF ENDWITH if between(nKeyCode, 32, 122) for x = 1 to this.ListCount if upper(subs(this.list(x), 1, this.selstart+ 1)) = ; upper(subs(this.text, 1, this.selstart)+chr(nKeyCode)) nCurPos = this.selstart + 1 this.Value = this.list(x) this.DisplayValue = this.list(x) this.SelStart = nCurPos if len(allt(this.list(x))) - nCurPos > 0 this.SelLength = len(allt(this.list(x))) - nCurPos endif nodefault exit endif next x endif ******************************************************************************************** *Combobox END OF Example Code: ******************************************************************************************** What is so strange is that if I add this control into a grid, it will not select any more as I type unless I turn SPARSE to .T., but then I cannot see the data anymore. HELP??? Tag: Getfile Q. Tag: 218503
  - 17
    - Future of VFP (yet again) I have had a potential client raise the issue of VFP's future. He says he has heard that it won't be supported past 2009, etc. I have been working with Fox since Foxbase, and hope to continue working with it forever. I wonder if I could get some developers and Microsoft people to chime in with the best and most convincing reasons that this should not be a concern to this potential client. Joshua Rubin Tag: Getfile Q. Tag: 218502
  - 18
    - Question for someone who has Visual Studio 6 I have been using VisualFoxpro 6 with VisualStudio 6 for years. I need to install everything on a new computer. In my CDs I have 2 disks for VisualStudio 6 Library and 4 disks for Visual Studio 6.0 Plus Pack. Also, there is VisualStudio 6.0 SP3. I am quite sure there is supposed to be 2 more disks for Visual Studio 6 itself, but I can't seem to locate them . Can someone verify whether there are supposed to be 2 more disks and if so, what is the number of the CD SET which identifies them (I think I will need that number in order to try to purchase them from Microsoft). Thanks for any help you can offer. -E. Myron -- To reply, change "invalid" to "net" Tag: Getfile Q. Tag: 218493
  - 19
    - Image control I am using the image control to show drawings in a form. So far it works fine. If the picture is bigger than the form scrollbars appear and the drawings can be viewed by using the scroll bars, ... hmmm .. also fine. Anyhow, I would like to provide a hand icon to move the drawing around and not the scrollbars. Any idea how to do this? Thanks Wolfgang Tag: Getfile Q. Tag: 218488
  - 20
    - Thank you!! i might not ever get to meet any of you, but i wish to say Thank you!! without your help i might still be trudging in the mud. i want to let all those know who have helped this rookie out in the past....THANK YOU. you knowldge sharing is greatly appreceiated. i hope some day i can help others the way you all have responded to my calls. From my family to all of yours...Happy Thanksgiving. Tom Tag: Getfile Q. Tag: 218487
  - 21
    - Email Body Message Do i have any options when i create emails in VFP for outlook.. or do i just have to use Text with no options for Color fonts or the like. Tag: Getfile Q. Tag: 218480
  - 22
    - The .exe load but the form disappear after a second Hi, i'm using VFP7.0 and i made a program that works fine but when i build the exe file and execute it in the same pc, the form load and shows data in the grids also but disappear after a second and shows no error or warning. Please if somebody knows what is happening. Tag: Getfile Q. Tag: 218476
  - 23
    - Buffer Overrun in VC++ using VFP9 Every so often I get a a dialogue displaying a message stating: Buffer Overrun Detected! Program: c:\ASM GeMS\Sapphire.exe A buffer overrun has been detected which has corrupted the program's internal state. The program cannot safely continue execution and must now be terminated. The application, Sapphire.exe was originally written in VFP8 and was upgraded. It will run quite happily for several weeks and then, when it is started up sometimes throws the above error. Does anyone have any suggestions on how to go about debugging this? I notice that SP 1 contains changes that prevent this error with large Scan loops but there is no such construct in this application. The environment is Windows 2000 Server SP4 with latest hotfix. The machine has 512 MB of RAM and a 2.4 GHz processor. This never occurred when the app was in VFP8. Nothing has changed other than a recompile. Leaving the application in VFP 8 is not a viable option due to company support policies. TIA John Tag: Getfile Q. Tag: 218475
  - 24
    - MsMapi and html Hi, I'm using MsMapi to retrieve messages. but how can I know when a received messagebody is a html text ? regards thanks in advance christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- Tag: Getfile Q. Tag: 218474
  - 25
    - New table --> HELP FAST!!! When I run the following statement in FoxPro (versions 6.0 and 8.0), it creates a new table. The new table cannot be opened using Excel and a couple other DBF viewers. If you view the DBF file in a text viewer, the header looks corrupted. SELECT * from tableName.dbf INTO TABLE test.dbf Any help with this issue is appreciated. Thanks KT Tag: Getfile Q. Tag: 218453
- Next
  - 1
    - Progress Bar Help. this is my first attempt at this, i have it working somewhat but ive still screwed it up. i have taken the advice of a few folks and put that together. the bar now acts like a crazed dog..and my loop does not complete or grab the data i need. Please advise this rookie on his mistakes. Code Below PUBLIC othermometer othermometer = CreateObject('thermometer') othermometer.Visible = .T. i=0 SET CONSOLE OFF DO WHILE i<100 WAIT TIMEOUT 1 && Place application-specific code here othermometer.update(i) set century on set deleted on set exclusive on wsproc=ctod(thisform.text1.value)&&date she enteres nagent = val(thisFORM.text2.value) wsprev = gomonth(wsproc,-1) wsdate = dtoc(wsprev) wsdate2 = substr(wsdate,1,3)+"01"+substr(wsdate,6,5) wsprevdt = ctod(wsdate2) select 0 use f:\foxpro25\lopfi\dbases\fulopmas shared wsag = 0 wsdpt= 0 set order to key i=0 x=reccount() go top scan if (fulopmas.agency=nagent) if (wsag = 0) or (wsag<>fulopmas.agency) OR (WSAG=FULOPMAS.AGENCY AND WSDPT<>FULOPMAS.DPT) wsag = fulopmas.agency WSDPT=FULOPMAS.DPT select bwagefile append blank replace bwagefile.agency with fulopmas.agency replace bwagefile.dpt with fulopmas.dpt replace bwagefile.employee with 999999 replace bwagefile.name with "ZZZZZZZZZZZZ" replace bwagefile.fullname with "ZZZZZZZZZZZZ" replace bwagefile.filedate with wsproc ENDIF select fulopmas if ((fulopmas.iactcode<>"T" and fulopmas.iactcode<>"D") or (fulopmas.iactcode="T" and fulopmas.mdfbal<>0 and fulopmas.inactdt>wsprevdt) or (fulopmas.iactcode="T" and year(fulopmas.inactdt)=year(wsproc) and month(fulopmas.inactdt)=month(wsproc))) and ((fulopmas.termcd < 60 and (fulopmas.termcd<>30 and fulopmas.termcd<>31 and fulopmas.termcd<>50 and fulopmas.termcd<>20)) or ((fulopmas.TERMCD >= 60 and fulopmas.termcd<>98) AND fulopmas.RETWAGES <> 0) or (fulopmas.termcd=98 and fulopmas.mdfbal<>0) or (fulopmas.termcd=30 and month(fulopmas.dtref)=month(wsproc) and year(fulopmas.dtref)=year(wsproc) and fulopmas.currwg <> 0)) select bwagefile append blank replace bwagefile.agency with fulopmas.agency replace bwagefile.dpt with fulopmas.dpt replace bwagefile.employee with fulopmas.employee if (fulopmas.termcd >= 60) and (fulopmas.termcd<>98) replace bwagefile.wage with fulopmas.retwages replace bwagefile.newwage with fulopmas.retwages else replace bwagefile.wage with fulopmas.currwg replace bwagefile.newwage with fulopmas.currwg endif if fulopmas.dpt = 24 or fulopmas.dpt=34 or fulopmas.dpt=35 replace bwagefile.wage with 1.00 replace bwagefile.newwage with 1.00 endif if fulopmas.retwages >= 1093.00 replace bwagefile.service with 1 else replace bwagefile.service with 0 endif replace bwagefile.fileterm with fulopmas.termcd replace bwagefile.name with alltrim(fulopmas.lname)+", "+alltrim(fulopmas.fname) replace bwagefile.fullname with alltrim(fulopmas.lname)+alltrim(fulopmas.fname) replace bwagefile.filedate with wsproc select fulopmas endif endif SELECT FULOPMAS x=x+1 i=i+1 othermometer.update(recno()/reccount()*100) endscan select bwagefile set order to lagkey messagebox("Finsihed!!") thisform.release() ENDDO othermometer.Release DEFINE CLASS thermometer AS form Height = 73 nshapemaxwidth = 300 Width = 349 DoCreate = .T. AutoCenter = .T. Caption = "" Closable = .F. ControlBox = .F. MaxButton = .F. MinButton = .F. Movable = .F. Name = "Form1" ADD OBJECT shape2 AS shape WITH ; Height = 25, ; Left = 24, ; Top = 24, ; Width = 300, ; Name = "Shape2" ADD OBJECT shape1 AS shape WITH ; BackColor = RGB(0,0,255), ; Height = 25, ; Left = 24, ; Top = 24, ; Width = 0, ; Name = "Shape1" ADD OBJECT timer1 AS timer WITH ; Top = 0, ; Left = 0, ; Height = 23, ; Width = 23, ; Interval = 100, ; Name = "Timer1" PROCEDURE update LPARAMETERS nPercent Local lnPercent lnPercent = iif(npercent<0,0,iif(npercent>100,100,npercent)) This.shape1.Width=This.nshapemaxwidth*lnpercent/100 ENDPROC ENDDEFINE Tag: Getfile Q. Tag: 218447
  - 2
    - Pull Hard Disk Serial, Processor Serial etc. Nov 22, 2005 Hi What is the easiest way to pull the Hard Disk Serial Number, Processor Serial Number or any other unique code from a PC through Visual Foxpro. I am using VFP version 9. Thank you in advance. Regards Tanveer Tag: Getfile Q. Tag: 218446
  - 3
    - Include Files in Forms Hello and thanks in advance for the help. How do you specify include files in a form? I seem to have done this at some point in the past but I don't remember how. When I search for the header file that is giving me a problem I find that it is in the RESERVED1 and RESERVED8 fields of several of my forms. I don't remember what I did a long time ago to get it there. Thanks, Jeff Tag: Getfile Q. Tag: 218440
  - 4
    - Contract position opening in Downtown Seattle (Opening is with the City of Seattle, City Light, Budget Office) Ciber is currently looking for a Visual FoxPro Developer for a 6 month contract, located in Seattle, WA. Scope of assignment: Maintain Visual FoxPro 6.0 applications used to plan, schedule, and budget capital projects. Use a combination of FoxPro applications and standalone programs to support a $150 M capital program. Applications are provided online to over 70 active users and involve OLE automation links to MS Project. The immediate need is to provide a bridge during scheduled personnel reassignments. The transition work will involve stabilizing and documenting existing application code. The remainder of the contract will involve maintenance and enhancement of the applications during the upcoming budget season. Required Qualifications: a.. Three years experience with Visual FoxPro 6.0 in a Windows XP environment b.. Demonstrated experience to write complex FoxPro SQL statements and the FoxPro report writer c.. Good interpersonal skills and the ability to write well; ability to prepare procedures and related documentation Desired Qualifications: a.. Experience in business analysis (budgeting, accounting) in a Municipal environment b.. Ability to prepare ad hoc queries, analyze results in Excel, and prepare management reports c.. Experience with object-oriented development, and Source Safe. jobs-seattle@ciber.com Tag: Getfile Q. Tag: 218425
  - 5
    - date updates and interactivechange It sometimes happens that I have a control, a checkbox for instance, tied to a field via a control source, and I have to run a procedure when the value is changed. So I put a function call in checkbox.interactivechange to do whatever. Unfortunately, code that runs here, if it looks at the underlying table, does not yet see the change that the checkbox is supposed to have made. For instance, suppose the checkbox is tied to a logical field, and there are three .T. and the rest false. If I COUNT FOR logfield TO myvar, then myvar is 3. But if I uncheck one of the checkboxes and put COUNT logfield TO myvar in .interactivechange, I still get 3. It doesn't change to the correct 2 until after interactivechange is completed. I find this very annoying. Anyone have a good way to force the field update before .interactivechange is called? -- You can reach me at: p one six seven k b r (remove spaces and convert words to digits) at comcast dot net Tag: Getfile Q. Tag: 218424
  - 6
    - Web vs Classic Explorer View How can I prevent the "WEB" version of the explorer window from opening when I want the "CLASSIC" view? The idea is to prevent access to the other directories commonly seen in the WEB BAR on the left side of explorer window such as Network Neighborhood, My Computer, etc. Thanks in advance. Craig Farrel Tag: Getfile Q. Tag: 218421
  - 7
    - grid.column.container.image caused refresh problem I have a grid with a column that uses a container with an image. I used grid;dynamicfontbold to refresh the container. Now when I scrolled the grid horizontally into the container, the grid became a mess. Needed to go back and forth a few times on the horizontal scroll bar to clean things up. Is there a way to avoid that? -- .~. Might, Courage, Vision. Sincerity. http://www.linux-sxs.org / v \ /( _ )\ (Ubuntu) Linux 2.6.14 ^ ^ 22:19:01 up 23 days 5 min load average: 1.44 1.38 1.29 Tag: Getfile Q. Tag: 218416
  - 8
    - Terrafox Announcements for November TerraFox Publishing Announces the Call for Info to fill the first edition of The FoxGuide! Ok Ok - what's the FoxGuide? It's a resource book for everything about VFP and VFP developers - a list of independent consultants, consulting companies, 3rd party vendor tools, accounting software written in VFP, MRP systems written in VFP, plus display advertising!! (We can't say the YP word, thats copyright title) . First Edition Due out on 15 December 2005, both in Print and Electronic Format. Deadline for entries on 10 December 2005. Primary audience - New Clients of VFP Custom Development Services. Independant Consultants and shareware authors can post for free - for everyone else, rates are SuperMondoLow! http://www.terrafox.net ---- TerraFox Publishing Announces the TerraFox Video Magazine and Call for Content Authors! Published every two weeks - you retain copyright -and we pay for material! Most Content shot in Camtasia with VFP 9. 5 to 10 minute features, 30 sec to 2 minute tips, Video Advertising, and that Newest Feature - FoxSpotting! www.terrafox.net ---- TerraFox Publishing Announces the TerraFox VFP UG Video Report and Call for UG Video Content! to be published monthly - you retain copyright and we pay for material! It's a great way to get your user group noticed. Monthly Video Mag, deadlines are 5 days prior to first of the month, each month. www.terrafox.net ---- TerraFox Publishing Announces New VFP Print/Electronic Magazine, to be put out biweekly! Content Authors wanted - you retain your copyrights and we pay for material! www.terrafox.net ---- Are you a good VFP trainer? Want to create your own training segments on video for publication and resale? TerraFox Publishing is compiling video training segments on VFP for resale and publication. You retain all copyrights, and we pay for usage! Most Content shot in Camtasia, 5 minute to 2 hours. www.terrafox.net -- =================== William Sanders / EFG VFP / mySql / MS-SQL www.efgroup.net/vfpwebhosting www.terrafox.net www.viasqlserver.net Tag: Getfile Q. Tag: 218413
  - 9
    - How to obtain a list of available ODBC Data Sources, User,System or File DSN Hi, How can I find, using VFP 6.0, the available ODBC Data sources, User, System or File DSNs? Thanks Demetrios, Greece Tag: Getfile Q. Tag: 218411
  - 10
    - Security - C2 rating Hi, We have a customer requirement that "the dbms should be capable of being secured to 'C2' level". Am I correct in thinking that Visual Foxpro 8.0 is NOT C2 compliant? I believe SQL Server 2000 is C2 compliant, is SQL Server 2005? Thanks in advance, Pauline Tag: Getfile Q. Tag: 218410
  - 11
    - grid column changes Is there a way to detect grid column changes - width, column order? Is there a way to prevent the user from making such changes? lockcolums prevents moving but not resizing. allowautoresize doesn't help either. -- You can reach me at: p one six seven k b r (remove spaces and convert words to digits) at comcast dot net Tag: Getfile Q. Tag: 218394
  - 12
    - PageFrame and Controls collection I'm writing a method that set the size of a form at runtime and I've just noticed that the form's page frame doesn't appear in the forms controls collection. Minor bummer, but why isn't it there? -Lew Tag: Getfile Q. Tag: 218392
  - 13
    - Need to create a new DBF file using dbase driver. Hi, I'm trying to create a new DBF file using dbase driver but error is coming while i run the command that is "[Microsoft][ODBC dbase driver] Syntax error in field defination" I'm using syntax as follows: "Create Table E:\KPSFeesN\Korangi\FeeSlip.dbf (Challan_No N(10), Computer N(5), Org C(1), Branch C(1), Session N(4), IssueDate D, StartMonth N(2), NoOfMonth N(2), TuiPrevMth N(10), BusPrevMth N(10), BusEndMth N(10), Tuition N(10), TuiArrear N(10), Term N(10), TermNo N(2), Late N(10), LateNo N(2), Bus N(10), BusArrear N(10), Arrears N(10), DueDate D, Status C(1), TuiEndMth N(2), Term_Beg N(2), Term_CNT N(2), AnualFee N(10))' Please help.. Thanx Ammar Tag: Getfile Q. Tag: 218388
  - 14
    - Maximize child form I have a top level form that is maximized (windowstate = 2) _Screen is hidden. Why won't the child forms that I open in my top level form open maximized if I set their windowstate = 2? The child form is modeless. I am using VFP 9.0 Thanks. Tag: Getfile Q. Tag: 218378
  - 15
    - VFP9 limit to the number of joins per SELECT statement? VFP8 Help says "The limit to the number of joins that you can use per SELECT statement is nine. " Does VFP9 handle more than this? Regards, Bernie Beattie Tag: Getfile Q. Tag: 218374
  - 16
    - _screen.windowstate = max Hi, If I set this, I set all forms also maximized. no problem so far but the size is to heigh ? all forms are underneath the Windows(XP) taskbar. Is this called normal behaviour ? or should I make all forms not so high and shrink it with the height of the taskbar but then how heigh is this ? thx in advance christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- Tag: Getfile Q. Tag: 218365
  - 17
    - A4 size report - A3 all my a/c report are written in A4 size standard, Now , my new client got a A3 printer only and she want all report print as A3 size, all font should be 'enlarge ' . I don't want to re-redraw all the report. Any simple method can enlarge it ? Thanks a lot Tag: Getfile Q. Tag: 218361
  - 18
    - PDF Creator Anyone try the PDF Creator ?? I just d/l it and use it as printer driver, However , the pdf is blank after 'generation'. Do I need to install ghostscript printer driver also ? thanks Tag: Getfile Q. Tag: 218359
  - 19
    - Huge speed difference USE mytable EXCLUSIVE && about 5000 records REPLACE ALL myfield WITH .T. && instant UPDATE mytable SET myfield = .T. && 0.1 seconds USE mytable SHARED REPLACE ALL myfield WITH .T. && 0.5 seconds UPDATE mytable SET myfield = .T. && > 90 seconds ! Is that to be expected? The presence of an index on myfield makes no difference. -- You can reach me at: p one six seven k b r (remove spaces and convert words to digits) at comcast dot net Tag: Getfile Q. Tag: 218344
  - 20
    - VFP 6: Memo Wrapping Problem If I ever thought about the internals of memos, I supposed that memowidth controlled the output only or that there were soft returns in the memo. I have been rudely disabused of this notion. Is there any way to distinguish between the returns inserted because of memowidth and those entered by the operator? I am thinking not, but hope to be wrong. The trouble is that mline() stops when it reaches a return. I have memos entered with a shorter memowidth in effect than I now wish to print with. I can do thememo=chrtran(thememo,chr(13)," ") but this is a kludge. It would also mess up a memo that was formatted into a table or into paragraphs. I am considering setting memowidth to 8192 and hoping that nothing else inserts returns into my memos. Is this safe? What do you folks do? Sincerely, Gene Wirchenko Tag: Getfile Q. Tag: 218343
  - 21
    - data access question I want to make sure I understand how the private datasessions and data access in general works. If I open a table, am I correct in assuming that I do not see some one else's changes until they do a tableupdate? situation: I append 3 records. I need to udate a few fields on those records but have not done a tableupdate. I change the field on the three records and then do a tableupdate. Person2 appends 2 records without doing a tableupdate while I am in the process of update some other fields. Is it correct that I do not see the two records they append because they have not done a Tableupdate yet? Tag: Getfile Q. Tag: 218333
  - 22
    - SQL question This seems too simple to call a "puzzle", yet I haven't figured out how to do it. I want to set a field in one table to .T. or .F. depending on the existence of certain records in another table. I can do this in one pass using SET RELATION, or in two passes using SQL. Can someone come up with an SQL statement that will do it in one pass? UPDATE mytable SET myfield = <?> WHERE ... ??? -- You can reach me at: p one six seven k b r (remove spaces and convert words to digits) at comcast dot net Tag: Getfile Q. Tag: 218324
  - 23
    - Variable existence Could you describe me the easy way to finding out the public variable existence ? Thanks in advance. Tag: Getfile Q. Tag: 218322
  - 24
    - UNION same table doesn't work? FPW2.6, just ran into an unexpected error. CREATE CURSOR temp (temp C(10)) INSERT INTO temp (test) VALUES ('test') SELECT * FROM temp ; UNION ALL ; SELECT * FROM temp ; INTO CURSOR temp That select statement will throw a file requester asking for "temp.dbf". At this point, the cursor temp is now a table in some work area with the default single letter alias. If any of those 3 aliases in the SELECT are different, it works fine, just doesn't like all 3 the same. -- Regards Andrew Howell Tag: Getfile Q. Tag: 218317
  - 25
    - Add hyperlink in Word document Hi, I am using VFP 6 OLE to hyperlink some selected text in Word document. Then save the document as webpage. My problem is how do I insert the hyperlink in Word with target="_parent" using programatically? For example, I need the link to be like this : http://www.xyz.com/123.htm target="_parent" Thanks. Tag: Getfile Q. Tag: 218315

I am wanting the GETFILE() command to start in a specific directory. How do
I do this? I am a table called de_ctrl, my apps control file, and I have a
memo filed called m_media. I want the get file to use the path in the
de_ctrl.m_media. Your thoughts are greatly appreciated.

Respectfully,

Jonathan Morningstar

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

Re: Getfile Q. by Jack

Jack
Sun Nov 27 20:40:05 CST 2005

On Sun, 27 Nov 2005 21:00:08 -0500, "Quickbuzz"
<quickbuzz@<REMOVE>charter.net> wrote:

>I am wanting the GETFILE() command to start in a specific directory. How do
>I do this? I am a table called de_ctrl, my apps control file, and I have a
>memo filed called m_media. I want the get file to use the path in the
>de_ctrl.m_media. Your thoughts are greatly appreciated.

Assuming that the table de_ctrl is open and positioned to the correct
record:

LOCAL cOldPath, cFile

cOldPath = CURDIR()
CD (de_ctrl.m_media)

cFile = GETFILE()

CD (cOldPath)

Re: Getfile Q. by Cindy

Cindy
Sun Nov 27 23:09:49 CST 2005

Hi Jonathan,

I'm not sure why you're getting a "file" to start in a directory. Have you
considered GetDir() ?

--
Cindy Winegarden Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com
http://spaces.msn.com/members/cindywinegarden

"Quickbuzz charter.net>" <quickbuzz@<REMOVE> wrote in message
news:1133143374_35951@spool6-east.superfeed.net...
>I am wanting the GETFILE() command to start in a specific directory. How
>do I do this? I am a table called de_ctrl, my apps control file, and I have
>a memo filed called m_media. I want the get file to use the path in the
>de_ctrl.m_media. Your thoughts are greatly appreciated.