delayed write errors

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
    - Is the paste offset user-definable? Through the years, I've gotten used to the fact that, in the VFP IDE, when you copy a control and paste it, the pasted copy is 8 pixels lower and to the right from the original location. Often, I am copying and pasting controls from one page or container to another and I want to retain the original location. Currently, I just automatically hit the left arrow 8 times and the up arrow 8 times to place the copy. I was wondering if this 8-pixel offset can be changed somehow. Anyone know? -- TRW _______________________________________ t r w 7 at i x dot n e t c o m dot c o m _______________________________________ Tag: delayed write errors Tag: 216794
  - 2
    - Trouble upgrading to VFP 8.0 I have a large application that we need to upgrade to VFP 8.0. I already built the application using vfp 8.0. But, when i made a slight modification and tried to rebuild, it gave me these errors: Compiling c:\program files\m2mwinv5\formcust\m2mform.vcx .aecmaudits[xx, 8] = {01/01/1900} Error in line 4003 of m2mentryform.commitecmaudit (record 81): Ambiguous date/datetime constant. Use the format: {^yyyy-mm-dd[,][hh[:mm[:ss]] [a|p]]} .aecmaudits[xx, 9] = {01/01/1900} Error in line 4007 of m2mentryform.commitecmaudit (record 81): Ambiguous date/datetime constant. Use the format: {^yyyy-mm-dd[,][hh[:mm[:ss]] [a|p]]} I don't know where to find the dates that need to be fixed. someone told me that commitecmaudit was a new thing in VFP 8.0. Thanks for your help. Tag: delayed write errors Tag: 216784
  - 3
    - FoxPro expertise gevraagd Wij komen graag in contact met een drietal Visual FoxPro programmeurs om werkzaamheden uit te voeren voor een Zorgverzekeraar die het gevolg zijn van veranderende wet en regelgeving. Start Asap, Locatie Eindhoven, 32 uur per week Belangstellenden kunnen hun CV e-mailen naar: SDMC Detachering BV e-mail: psanstra@sdmc.nl phone 0294 270019 www.sdmc.nl Tag: delayed write errors Tag: 216777
  - 4
    - Reports 'suprpcol'? what is it? I've had a report for which fields just won't print on the first page no matter what the data or 'print when' settings are. When I open the report as a table the only difference between fields that print and don't is that the column suprpcol=3 on fields that print and 0 on fields that don't. If I hack the frx by manually changing suprpcol to 3 and save it then run the report those fields magically appear on the first page again. But I can't work out what suprpcol is or how it is changed in report designer. Does anyone know? LH Tag: delayed write errors Tag: 216776
  - 5
    - Question about report dataenvironment class If I link a report to a dataenvironemtn class and then make some changes to the dataenvironment on a specific report, will these changes be kept when the dataenvironment class is updated and / or the report is run? Cheers David Tag: delayed write errors Tag: 216775
  - 6
    - Inserting characters in a memo field Hi everyone, Is there a way to insert a number of characters in a memo field? I may want to insert 2 words at the 20th position or 40 characters at the 1st position and so forth... Thanks Hutch -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com Tag: delayed write errors Tag: 216771
  - 7
    - October 2005 letter on Visual FoxPro web site October letter at http://msdn.microsoft.com/vfoxpro/letters/. This month's letter contains information about new content online about Visual FoxPro 9.0, news about the SP1 for Visual FoxPro 9.0 beta download, more in-depth information about Microsoft's roadmap for Visual FoxPro, plus recent content and community news. There is a new one hour audio podcast (MP3) interview on the FoxShow, FoxShow #24: Interview with Ken Levy with mentions of various members of the VFP team, Sedna, transparency, VFP roadmap, etc. Ken Levy VS Data Product Manager Microsoft http://blogs.msdn.com/klevy http://msdn.microsoft.com/vfoxpro -- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP cindy_winegarden@msn.com www.cindywinegarden.com Blog: http://spaces.msn.com/members/cindywinegarden Tag: delayed write errors Tag: 216767
  - 8
    - C0000005 on Windows2003 Hi, The following code (VFP8(SP1), MSXML4(SP2)) works properly on WindowsXP Professional(SP2) and Windows2000 Server(SP4) - parsing error is caught by a handler. The same code doesn't work correctly on Windows2003 EE(SP1) - C0000005 is raised. **************************** Local loException,rdr,hnd try rdr = CreateObject("MSXML2.SAXXMLReader.4.0") hnd = CreateObject("_XMLValidator") rdr.errorHandler = hnd * Valid XML rdr.parse("<catalog><book id='bk101'></book></catalog>") =MessageBox("Valid XML") * Invalid XML rdr.parse("<catalog><book id='bk101'></book></cataloge>") =MessageBox("Invalid XML. This message should never appear.") Catch to loException =MessageBox(; Ltrim(Str(loException.ErrorNo))+; loException.Message+; Iif(IsNull(loException.Details),""," "+loException.Details)) Finally EndTry Define Class _XMLValidator as custom IMPLEMENTS IVBSAXErrorHandler IN {F5078F18-C551-11D3-89B9-0000F81FE221}#4.0 &&"c:\windows\system32\msxml4.dll" **** IVBSAXErrorHandler PROCEDURE IVBSAXErrorHandler_error(; oLocator AS VARIANT, strErrorMessage AS STRING @, nErrorCode AS Number) AS VOID; HELPSTRING "Receive notification of a recoverable error." * add user code here =MessageBox("Error") ENDPROC PROCEDURE IVBSAXErrorHandler_fatalError(; oLocator AS VARIANT, strErrorMessage AS STRING @, nErrorCode AS Number) AS VOID; HELPSTRING "Receive notification of a non-recoverable error." * add user code here =MessageBox("Fatal Error") ENDPROC PROCEDURE IVBSAXErrorHandler_ignorableWarning(; oLocator AS VARIANT, strErrorMessage AS STRING @, nErrorCode AS Number) AS VOID; HELPSTRING "Receive notification of an ignorable warning." * add user code here =MessageBox("Ignorable Warning") ENDPROC ENDDEFINE ****************************** Please, advise Thank you. Tag: delayed write errors Tag: 216761
  - 9
    - Calling a Crystal Rpt file version 11 from VFP I see code for calling other Crystal versions from VFP but I am wondering how to do this for version 11. Thanks in advance. Tag: delayed write errors Tag: 216753
  - 10
    - ODBC for remote views Have always used ODBC to access data remotely in VFP 6. Been told this method is "outdated". The application primarily reads SQL data. Is ODBC still the most reliable and (more importantly) fastest method of accessing remote data in VFP6? - Ben Tag: delayed write errors Tag: 216752
  - 11
    - memo field Hi All, I have a table with memo field created in FoxPro 2.6. We've been using VFP 6.0 and now we want to move the data to SQL 2000, I have tried using the DTS, (comes with SQL 2000), to transfer the data, but some of the contents in the memo field are missing. Does anyone have a better way to transfer table with memo field to SQL 2000 without lossing contents in the memo field. Many Thanks, Nancy Tag: delayed write errors Tag: 216750
  - 12
    - resend: Windows Fax Service i'm able to send out fax using xp fax service. but how can i extract send status from Fax like what we see in fax consol in Foxpro ? Thanks! Tag: delayed write errors Tag: 216746
  - 13
    - VFP9 report data environment display bug I have a report data environment with many tables and many relations (> 20 tables up to 5 levels deep). Works fine in report data environment. However when I save the data environment to a dataenvironment class and reuse it on another report, the layout of the tables in the data environment is lost. They just appear in a straight line across the data environment designer. This in its self is not the problem, just an annoyance. The problem is that at some point, I can not get to the tables on the far right side of the data environment designer. The relation lines go off the right side and no matter what I do, I an not get to the tables to reorganise them. I tried resizing the form every which way, resiizing the screen resolution. Even tried editing the table directly. So, how can I get to these tables to lay them out neatly? Cheers David Tag: delayed write errors Tag: 216743
  - 14
    - Dataenvironment Is there any way to preserve the layout of the data environment once it is saved to a datanevironment class and reused on a report. It seems to lose the entire layout and reverts to a straight line across the dataenvironment designer.. Cheers David Tag: delayed write errors Tag: 216742
  - 15
    - Populate web page fields Hello, I need to populate a form on a web page with data from a single record. How do I map a table field to a web page field and then do the web page population? Make sense? Thanks RH Tag: delayed write errors Tag: 216739
  - 16
    - function syntax hi all, just to make this simple. I want to call a function, pass 3 parameters to the function and I want the function to pass back the total of the 3 parameters and the product (parm1 * parm2 * parm3). I thought the following will do it, but it doesn't. How is it done? Function returnvalues(parm1,parm2,parm3) numadded=parm1+parm2+parm3 nummultip=parm1*parm2*parm3 RETURN (numadded, nummultip) ENDFUNC thanks Hutch -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com Tag: delayed write errors Tag: 216731
  - 17
    - Error instantiating Class I can't seem to get rid of this message whenever I open this form. I am asked for the location of the Class, point it to the proper place and then save. My efforts at executing Project->Build, Project->Refresh, Project->Clean Up Project will not make this message disappear. I am Using VFP 9.0 and hope I do not have to completely rebuild this form! Thanks for your help Tag: delayed write errors Tag: 216727
  - 18
    - web service : using FFC\_WS3Client.vcx hi i have a small dll ( VFP 9 - mult subproc ) for consuming a web service i instantiate the dll on My PC with CreateObject and it's all right then, i put the DLL on the server i instantiate it with CreateObjectEX up to this point it's all right ... BUT it can't get the reference to "web service" at the method SetupClient( ) i'm using the FFC\_WS3Client.vcx class any idea ? thanks -- atte, Hernán Tag: delayed write errors Tag: 216719
  - 19
    - OLE Automation and Window handles I am working with automating some barcode label software in VFP 9. One of the OLE functions is used to draw a preview image of the barcode label in an image object. The parameter of the function requires a handle to the control that I want to paint the image in. This can be accomplished in Visual Basic by using the hWnd property of the image control. VFP does not have this functionality that I am aware of for controls. 1.) Is it possible to use this method of painting in an image control in VFP 9? 2.) If not, is it possible to use a form and draw the label preview directly on the form using the form's hWnd propery, maybe by using GDI? Thanks for any help you can give. Tag: delayed write errors Tag: 216715
  - 20
    - update conflict I have code like its CREATE SQL VIEW wfzby REMOTE CONNECTION dbccon AS ; select * from wfzby append blank repl ne with xx &&" 1001" tableUpdate(.t.) refresh() requery() skip -1 skip +1 replace rt with '1' skip -1 * here is error skip +1 what is wrong that is error: conflict update? Adam Rataj Tag: delayed write errors Tag: 216699
  - 21
    - Who Dunnit? Thanks in advance for the help. I have a nightly job which sometimes fails to run because a user stayed in the application and the nightly job can't get exclusive access to the files which need to be updated. I have the following questions: 1. Is there any way for me to get VFP to tell me which user has the file open? 2. Is there a way (that works) to have applications terminate at a specific time? I tried putting a timer on the main form but if the user stays in a sub-form, it never gets back to the main form (or the main form timer fires but can't close the app because a sub-form is open). Do I need a timer on each form? Do I need to write a routine like: FOR EACH OPEN FORM OpenForm.Close() NEXT If that is the way to go can someone tell me the actual code that will do this? Thanks, Jeff Tag: delayed write errors Tag: 216698
  - 22
    - error (108) "File is in use by another user" I have "discovered" that this can prevent a table opening ie if the file is in use with a REPLACE FOR/WHILE then another user cannot open the table. Is this correct or am i missing something?? i know i have set reprocess to 1 but i'm just trying to open the table not edit it Greg Tag: delayed write errors Tag: 216691
  - 23
    - Update syntax problem I try the following syntax in command window. but got errors. Does anyone can help me to correct it ?? Thanks in advance update blcostheader set jobperiod = jobheader.jobperiod from blcostheader ,jobheader where jobheader.jobno = blcostheader.jobno Tag: delayed write errors Tag: 216684
  - 24
    - Network Drive is there a function that can determine this drive is a NETWORK? Tag: delayed write errors Tag: 216683
  - 25
    - Default Directory Hi all, I am not sure why this is working like this. What am I doing wrong? all I want is to allow the user to select a directory and I want to set this selected directory as the default directory. here is the code: CLEAR tempdir = Getdir() && I am selecting the C:\Casino directory ?tempdir Set default To SET DEFAULT TO ("&tempdir") ?"Default Dir= "+SET('default') SET path TO (HOME() + 'ccalps') Additive ?"path =" +SET('path') and here is the output: (Notice how the Default Directory is showing as C: only !!!!!!) c:\casino Default Dir=C: path=C:\Program files\microsoft visual foxpro9\ccalps -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com Tag: delayed write errors Tag: 216676
- Next
  - 1
    - Running application installed by InstallShield Limited edition for VFP as limited account Hi, I have an application, which I install with InstallShield Limited edition for VFP. It has some ActiveX controls, and also I use several merge modules After installing, application works fine if I run it logged as Admin But if I try to run it logged on a limited account (which is member of users group only), I get an error, Class not registered (when application try to create an ActiveX object instance) I had another problem early, with write access in application root folder (because it is installed in Program Files), but I manage to handle it, by setting Permissions for install folder: I created an entry Users, and give it all rights. I try the same for ActiveX I use in my project (setting full permissions for them individually to Full) but still don't work Can anyone give me a suggestion howe to handle it? Thank you Bogdan Zamfir Tag: delayed write errors Tag: 216670
  - 2
    - working with to records. i have a table, and it has 101 records in it. 2 records for each person. i want to subtract field1 record 1 from field2 record2 of the same person and replace the value of field 1 with the result. is that asking to much without having to create a temp table? Tag: delayed write errors Tag: 216659
  - 3
    - Report Form xx PROMPT vs. Default Printer Hi All, Ever experienced super small 1/4 size printing on a report? In circumstances where you use the PROMPT and NOPAGEEJECT options on the REPORT FORM command so that the user can select the printer desired and so that a subsequent report will be part of the same print job, the subsequent report will always use the default printer driver no matter what printer the user selected. IOW, the PROMPT option of the report command only effects that specific report and not all the reports that are part of the same print job. Example: REPORT FORM A1 TO PRINTER PROMPT NOPAGEEJECT NOCONSOLE REPORT FORM A2 TO PRINTER NOCONSOLE If the user selects any printer other than the default when prompted the two reports above that are both part of the same print job will be printed to the same printer using different printer drivers for the first and second reports. (Keeping them part of the same print job is really handy when printing to a PDF file) . Using the wrong printer driver for a report going to a printer can give you strange results. Is there a way to force multiple reports that are part of the same print job and all going to the same printer to use the printer driver that is related to the PROMPT selection made on the first report? I have resorted to placing a sys(1037) in code just before my report rather than using the PROMPT option on a REPORT FORM command, to change the default printer. It is a kludge and does not present as nice a user interaction as the prompt option but it works. This seems like a minor bug to me... Anyone have a new information or ideas? -- Alec Tag: delayed write errors Tag: 216649
  - 4
    - Wish list : TOTAL... EXCEPT ... How about : TOTAL ON ID_EQUI TO m:\matable.dbf EXCEPT ID_EQUI Fabien Tag: delayed write errors Tag: 216648
  - 5
    - Wish list: update sql How about a: update <TableName> from name <ObjectName> where .... Tag: delayed write errors Tag: 216643
  - 6
    - form.click()? A form with a textbox. Click the textbox. enter a few characters. then the mouse click outside the textbox. what event is fired? Definitely not form.click().... -- .~. Might, Courage, Vision. http://www.linux-sxs.org / v \ /( _ )\ Linux 2.6.13 ^ ^ 21:57:01 up 9 days 43 min load average: 1.02 1.02 1.00 Tag: delayed write errors Tag: 216640
  - 7
    - SourceSafe hangs when multiple users access anything at the same t Does anyone else have the problem when using Visual SourceSafe and two or more developers start up VFP (or one starts up and another wants to modify a form) at the same time. Basically it seems hang when multiple users do anything at the same time, that accesses the VSS database. It hangs until one of the users kills VFP. It seems wired that this would happen when the purpose of SourceSafe is to allow you to develop in a multi-user environment. Has anyone else experienced this or is there something we could try to solve this? Thanks, Jerry Tag: delayed write errors Tag: 216639
  - 8
    - call32.dll questions I've been using Rick Strahl's call32.dll from FPW with fairly high success on Win95 and ntvdm under 2K and XP. It can be a bit painful at times (eg just trying to Declare32 a non existant function name will throw a GPF instead of something friendlier.) There's also an annoyance when trying to RegFN() - if you pass the whole path to the dll then the second and subsequent attempts to register a function claim there is no function of that name within the dll. Relative paths seem OK but since I can't be sure of current directory I found the easiest thing to do was change default to dll directory, register the functions and then change default back. Anyway, sometimes after a few function calls, a GPF will be thrown just trying to call any function in call32. It is always the same GPF and it persists between FPW sessions. I have found that if I kill off the ntvdm process using task manager then it starts working again (or, of course, reboot. Merely exiting all 16bit applications doesn't stop wowexec and ntvdm, they are left running for a quicker startup if you run another 16bit application.) Does anyone have any idea why it seems to go a bit screwy after a while? It's a little annoying because I thought I'd got it working stably but now I've put it into production the flakiness has been exposed. All the examples I've seen for calling functions in external dlls don't do anything to tidy up afterwards and I wonder if this is the problem? The next thing I'm going to try is the latest version of call32.dll, it was originally written for VB and Rick took the source and added a few other functions that may be useful to Foxpro programmers. The latest version has been updated a couple of times since Rick's build and there is an extra function to free libraries used. Anyone else have any experience with this module? -- TIA Andrew Howell Tag: delayed write errors Tag: 216634
  - 9
    - discrepancy between keyboard an mouse I have an textbox with an input mask of "999,999.99" The value is "0.00" Then the user used the mouse and hit the space on the left of the leftmost "0" in "0.00" and typed "1" The field now displayed like "1 0.00". If I used the mouse to exit the field (by hitting somewhere else in the from, the value become "10.00" If I hit <ENTER> key, the value becomes "1.00", which was what the user expected. Now, how could I make the mouse hit to behave as keyboard? -- .~. Might, Courage, Vision. http://www.linux-sxs.org / v \ /( _ )\ Linux 2.6.13 ^ ^ 19:42:01 up 8 days 22:28 load average: 1.00 1.02 1.00 Tag: delayed write errors Tag: 216633
  - 10
    - Screensaver Question I'm trying to deactivate the screen saver programatically using SystemParametersInfo DECLARE INTEGER SystemParametersInfo IN user32; INTEGER uiAction, INTEGER uiParam,; INTEGER @pvParam, INTEGER fWinIni when I use SystemParametersInfo(SPI_GETSCREENSAVEACTIVE, 0, @lnTemp, 0) or SystemParametersInfo(SPI_GETSCREENSAVERRUNNING, 0, @lnTemp, 0) I can detect whether the screen saver is running / active etc but neither SystemParametersInfo(SPI_SETSCREENSAVEACTIVE, .T., @lnTemp, 0) or SystemParametersInfo(SPI_SETSCREENSAVERRUNNING, .F., @lnTemp, 0) will turn it off, I've tried using .T. or .F. but it doesn't make any difference. Does anybody use these successfully? What am I doing wrong? Thanks LH Tag: delayed write errors Tag: 216629
  - 11
    - Autosize Problem I have a generic form with a label that is passed a variable size caption. I set the caption in the Init method. Autosize is set to .T.. I then resize the form in the Activate method in relation to the change in the size of the label. This works fine in VFP 8.0, but it doesn't work in 9.0. In 8.0, the change in size is recognized at the time of the Activate method, but this is not the case in 9.0. I can create a breakpoint in the Activate method and step through the critical lines of code and it will recognize the autosize change. Any suggestions? Rick Tag: delayed write errors Tag: 216628
  - 12
    - Select from an Array Can you do this? I have a single dimension array containing a list of different widgets. I would like to count the quantity of each widget in the array. Can I use a select statement for this? tia Tag: delayed write errors Tag: 216616
  - 13
    - Adding a picture to a general field VFP9. I want to programmatically add a picture (e.g. a .gif file) to a general type field for use in a report. I couldn't find how to do this in the doc. I tried the APPEND GENERAL command and looked at the sample, but my results only put the file name in the field and no picture showed on the report. I can do it interactively in the report designer, but I want the user to select the file for his/her own logo. Thanks for any help. Steve Meyerson Tag: delayed write errors Tag: 216615
  - 14
    - Object class is invalid for this container When I try to copy an OLE control from one class library into another, I get the error message "Object class is invalid for this container". Obviously that's a mistake, because the class already exists in a class library. Any suggestions? Tag: delayed write errors Tag: 216611
  - 15
    - Wish list: append from name <ObjectName> Any support for this? -Lew Tag: delayed write errors Tag: 216606
  - 16
    - Difference between fdate(,1) and ftime() Can anyone explain this, please? -Lew Tag: delayed write errors Tag: 216605
  - 17
    - MS Word Problem Lee: Thanks for the suggestion, but that caused no difference. It should also be noted that MS Word starts and opens the original document, but then displays an error "This cannot be completed because of a dialog or database engines failure. Please try again." Thanks. BR I can't reply to the earlier question. I get an error with an Infortion icon and 3 choices, but no words.? Tag: delayed write errors Tag: 216603
  - 18
    - MS Word Merge problems using VFP 9.0 I am having a lot of problems getting a MS Word Merge to work from VFP 9.0. I swear it used to work in 6.0. I am getting the error message "OLE IDispatch exception code 0 from Microsoft Word: Word was unable to open the data source..." Below is a majority of the code. The last line is what generates to error. TIA for taking a look. Thisform.Wordmailmerge1.cSQL = "" Thisform.Wordmailmerge1.cDataPath = SYS(5) + CURDIR() Thisform.Wordmailmerge1.cDataSource = "OUTPUTER" Thisform.Wordmailmerge1.cFormLetter = ALLTRIM(THISFORM.PrimaryDOC.VALUE) Thisform.Wordmailmerge1.lSave = .T. Thisform.Wordmailmerge1.cSaveAsFolder = FOLDERNAMEIS Thisform.Wordmailmerge1.cSaveAsName = FILENAMEIS Thisform.Wordmailmerge1.Merge Local oWord, lcFileName, lcConnectionString, oFormLetter If Empty(This.cSQL) Then This.cSQL = "SELECT * FROM " + This.cDataSource Endif lcFilename = addbs(This.cDataPath) + This.cDataSource + ".DBF" If !Directory(This.cDataPath) Then Messagebox("Invalid Datapath specified : " + This.cDatapath, 0, "Error") Return Endif If !File(Addbs(This.cDatapath) + This.cDataSource + ".DBF") Then Messagebox("Datasource " + addbs(This.cDatapath) + This.cDataSource + ".DBF does not exist", 0, "Error") Return Endif If !File(This.cFormLetter) Then Messagebox("Form Letter " + This.cFormLetter + " does not exist", 0, "Error") Return Endif lcConnectionString = "DSN=FoxPro Files - Word;UID=;PWD=;SourceDB=" + This.cDataPath + ";SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=MACHINE;Null=Yes;D eleted=Yes;" On Error Do MSMergeError oWord = GetObject(,"Word") *ON ERROR DO errhandler WITH ERROR( ), MESSAGE( ), MESSAGE(1), PROGRAM( ), LINENO( ) ON ERROR If Type("oWord") != "O" Then oWord = CreateObject("Word.Application") If Type("oWord") !="O" Then MessageBox("Unable to start MS Word", 0, "Error") Return Endif Endif With oWord .visible=.t. EndWith lnSelectArea=select() oWord.Documents.Open(This.cFormLetter, .F., .F., .F., "", "", .F., "", "", 0) oFormLetter = oWord.ActiveDocument oWord.ActiveDocument.MailMerge.OpenDataSource(lcFilename, 0, .F., .F., .T., .F., "", "", .F., "", "", lcConnectionString, This.cSQL, "") BR Tag: delayed write errors Tag: 216592
  - 19
    - How do you read postdata in a webbrowser control? I'm working on a VFP project for engineers designed to help them collect descriptions, links and images from manufactures sites to simplify creating design documents. Part of the time saving aspect of this project is to reduce the dozens of times each day they have to logon to each manufacture site and search/navigate to the pages they need for their projects. To accomplish this for non-programmers I need a way to capture POSTDATA from the beforenavigate2 event. I believe the datatype is a safearray. I've found code that is for VB that uses lenb and midb functions. It looks like this: Private Sub ctrlWB_BeforeNavigate2(ByVal pDisp As Object, URL As Variant, Flags As Variant, TargetFrameName As Variant, PostData As Variant, Headers As Variant, Cancel As Boolean) If pDisp Is ctrlWB.object Then Dim lCount As Long Dim lLen As Long Dim strPostData As String lLen = LenB(PostData) ' Use LenB to get the byte count If lLen > 0 Then ' If it's a post form, lLen will be > 0 For lCount = 1 To lLen strPostData = strPostData & Chr(AscB(MidB(PostData, lCount, 1))) ' Use MidB to get 1 byte at a time Next MsgBox strPostData End If End If End Sub But I can't seem to figure out what I need to do in VFP to capture and use this data. Many thanks in advance! Tag: delayed write errors Tag: 216591
  - 20
    - VFP 6.0 and Network Access Storage (NAS) Our Win2K server was recently migrated to Oa new NAS (Network Attached Storage) device. Since this time, some of our application have been receiving 'Cannot Update Cursor' errors. I've narrowed it down to when a 'PACK' command is issued. The application utilizes a control file that stores folder names in it associated with the server on the Q:\ drive (i.e. Q:\TEST). The application has been running for years and hasn't had updates in the past 9 months. Since the NAS migration, these errors have been experienced. Any thoughts on how to get around this? It is my understanding that this NAS device uses a Linux OS - so my guess is there are compatibility issues. Tag: delayed write errors Tag: 216590
  - 21
    - Advice for first time "contractor" I've been programming (in FoxPro) for around 10 years and working at it (W2) for 8 or so. I've had quite a few jobs. I am sometimes asked if I want to work as a contractor or as an employee and I have always said "employee" mainly because I've always done that. I figured I could probably easily take those jobs on a contract basis and figured that someday I'd have to (or even want to) but that day hasn't come until today. A recruiter got my resume off an employment recruitment site and has been lining me up for a position at one of their client companies and yesterday I was told that the decision has been made that I get the job (starting Monday). I am to be paid on an hourly basis as a contractor. They emailed me papers to sign yesterday. Generally, when I sign preemployment papers I scan them and sign, have a general idea what it's about, the legalese notwithstanding. Since I was at home this time, at my "leisure," I took the time to read this stuff carefully. Most of it looks pretty OK, although I'm rather inexperienced at this, obviously. There's a nondisclosure agreement, a W9 form - pretty standard stuff. Then there's the 5 page contract with an "Exhibit A" tacked onto that, being a purchase order for my services. That's a bit weird from my perspective, but probably standard, I figure. It states my hourly rate, basically, with a sentence or two with yet another guarantee by me that I won't make any agreements with the 3rd party for a year after the completion of my assignment, things of that nature. In the contract they want me to guarantee that if I do start working directly with their client, I will fork over 20% of my salary. I guess I'm OK with signing on that. However when I got to paragraph 12 in the contract, I did a double take: 12. INSURANCE. Contractor will obtain for itself and its personnel before providing services, at its own expense, comprehensive General Liability insurance coverage for projects covered by this Agreement, for limits of liability not less than $500,000 and will name <insert name of recruiter here> as an Additional Insured, provide a copy of the binder and policy to <insert name of recruiter here>, and hold <insert name of recruiter here> harmless for any damages or expenses, including attorney's fees, incurred as a result of misconduct of Contractor or its personnel involving <insert name of recruiter here>, the TPU (third party unit), or any customer of client of the TPU. Now, that's something I wasn't prepared for and I figure I'll be calling them first thing in the morning - their office won't be opening for at least 3 hours. You people with experience, can you tell me what this is about? Are they going to waive this for me? I can't believe that they recruited me with the assumption that I already have an insurance policy of this nature and didn't ask me up front. I'm a computer programmer, and they were careful to check out my references before making me the offer. In the past, the trust inherent in that type relationship has floated my boat. Please, in addition to answering that specific question, can I get some tips and hints to give me a more solid footing in embarking on my first gig as a contractor? I've had quite a few contractor-like assignments, but never actually been on a contract basis. I always figured it was going to be principally a matter of filling out some different or extra IRS forms, but I guess there's more to it. For one thing, it looks like I'm going to have to manage my own withholding of federal and state taxes and SS. Do I do that at tax time or do I have to manage that during the work year? This job is 6 months+ (I'm told it's funded for a year, possibly with extensions) but I will be on a trial basis, especially at the start. The TPU is contractually entitled to send me home for any reason at any time. The contract seems to carefully stipulate that I'm entitled to zero benefits, just my hourly rate with no possibility of extra compensation for overtime, no possibility of being compensated for training of any kind, etc. I am in California. Thanks for any help. Tag: delayed write errors Tag: 216589
  - 22
    - Can anyone recommend .. Know might not be the propper forum to ask but here I go and ask you guy that 'can anyone recommend me a VFP Magzine for subscription' ? It will be better if an on-line+Print edition are both available? Tag: delayed write errors Tag: 216586
  - 23
    - Remote View ODBC error (VFP6) I keep getting this error and have no clue why. Error: 1526 Connectivity Error: Unable to retrieve specific error information. Driver is probably out of resources I'm using a remote view which refreshes every 10 seconds. Runs fine about 100 times then this OR same error with a SQL deadlock. Any ideas? Thanks in advance for any help. - Ben Tag: delayed write errors Tag: 216582
  - 24
    - SQL Stump I am having problems coming up with an sql statement to get the data that I want. I would like to get the data in one SQL statement if possible and I cannot get my brain to work this morning. I have 3 tables, user, locations, and user_locations. The user to locations is a many to many hence the user_locations. The user_locations table basically just says what locations a user has access to example user table User1 User2 Location Table loc1 loc2 loc3 loc4 If I want user 1 to have access to location 1 and location 4 I would put these records in the user_locations table User_locations Table user1 loc1 user1 loc4 Anyway the query I want is a listing of all of the locations and a true or a false whether the user has access filtered of course by user select (need something here) where user = user1 would return loc1 yes loc2 no loc3 no loc4 yes Anyway I am stumped right now on getting the right SQL statement to give me my data. -- TIA Altman VFP9 Tag: delayed write errors Tag: 216562
  - 25
    - Alog problem , please help. I got two invoice table, InvHeader(company,invno) InvDetail.(ChargeItem, unitprice,invno) select Invheader.company,InvDetail.chargeitem,InvDetail.unitprice from InvHeader,InvDetail where InvHeader.invno = InvDetail.innvo into cursor pTempTable Scan select "InvInfo" append blank in "InvInfo" replace InvInfo.company with pTempTable.company Do case case InvInfo.chargeitem = "PEN" replace invinfo.pen with pTempTable.unitprice case InvInfo.chargeitem = "TOY" replace invinfo.toy with pTempTable.unitprice casel........ endcase endscan Now, the problem is , invinfo got over 10 different types. (pen, toy-car,toy-doll,toy-xxxx). I need to check each types and give one file tables to my client. If my invoice tables got over 10000 records, the above process need over 1 hrs to process. Any faster method to process it ??? thanks a lot. Thanks a lot Tag: delayed write errors Tag: 216560

We use vfp8.
In the last few months we keep getting delayed write error messages. Data
will be lost. We have lots and lots of free space. Our system gets very
slow and after a few messages will freeze up and we must reboot the server.
Is there any known reason for this?
thanks
sherry

Top

Re: delayed write errors by Matthew

Matthew
Tue Oct 04 11:26:37 CDT 2005

Delayed write error messages are system generated and usually means the hard
drive is defective, the network connection is unreliable, etc. This is not
the fault of VFP, but is a hardware failure in your network/server. Check
event logs, as these errors are logged and should tell you the device that
failed (hopefully).

"sherry" <sherry@discussions.microsoft.com> wrote in message
news:057E5A5F-B4F8-4B83-94D0-10704532DCBE@microsoft.com...
> We use vfp8.
> In the last few months we keep getting delayed write error messages. Data
> will be lost. We have lots and lots of free space. Our system gets very
> slow and after a few messages will freeze up and we must reboot the
> server.
> Is there any known reason for this?
> thanks
> sherry
>

Top

Re: delayed write errors by Dan

Dan
Wed Oct 05 11:04:04 CDT 2005

In addition to the very good advice Matthew gave you, make sure you've
turned off write cacheing on the server. You may actually have to turn this
off frequently. Many times a Windows service pack will turn it back on. :-(

Dan

sherry wrote:
> We use vfp8.
> In the last few months we keep getting delayed write error messages.
> Data will be lost. We have lots and lots of free space. Our system
> gets very slow and after a few messages will freeze up and we must
> reboot the server. Is there any known reason for this?
> thanks
> sherry

Top