insert / update triggers

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
    - Reprot Grouping on multiple detail bands? Is there a way to do grouping on individual detail bands in a multi band report? I have an invoice that prints parts and labour from 2 different tables. Works really well. I want to sub group the labour by Site ID, but not the parts. I this possible? Cheers David Tag: insert / update triggers Tag: 216810
  - 2
    - VFP8 won't install, won't run VFP 8 no longer runs on my box. It generates c0000005 on startup. I have deleted all foxuser files, cleared config.fpw. I uninstalled it with the installer, and that worked fine. I tried to re-install it, and it gives an error, so now I can't re-install it. I copied files from CD, which I have done before sucessfully, set them to read/write, but it still gives c0000005 on startup. VFP9 works fine on the same machine, other apps work fine AFAIK. Anyone run into this before? Tag: insert / update triggers Tag: 216808
  - 3
    - Anyone have experience with fingerprint scanners? Any tips, good sources of info, recommendations? -- You can reach me at: p one six seven (remove spaces and convert words to digits) at comcast dot net Tag: insert / update triggers Tag: 216799
  - 4
    - PC Install problem on certain Versions of Win XP with FoxPro 6.0B I have been using PC-Insall for years now, and lately I am unable to install successfully on certain versions of Win XP. The message states that the system file is not suitable for using MS-DOS or Microsoft Applications. Any ideas on what could be causing this message. Maybe autoexec.nt file settings? Thanks for any input. George Tag: insert / update triggers Tag: 216797
  - 5
    - delayed write errors 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 Tag: insert / update triggers Tag: 216795
  - 6
    - 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: insert / update triggers Tag: 216794
  - 7
    - 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: insert / update triggers Tag: 216784
  - 8
    - 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: insert / update triggers Tag: 216777
  - 9
    - 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: insert / update triggers Tag: 216776
  - 10
    - 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: insert / update triggers Tag: 216775
  - 11
    - 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: insert / update triggers Tag: 216771
  - 12
    - 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: insert / update triggers Tag: 216767
  - 13
    - 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: insert / update triggers Tag: 216761
  - 14
    - 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: insert / update triggers Tag: 216753
  - 15
    - 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: insert / update triggers Tag: 216752
  - 16
    - 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: insert / update triggers Tag: 216750
  - 17
    - 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: insert / update triggers Tag: 216746
  - 18
    - 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: insert / update triggers Tag: 216743
  - 19
    - 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: insert / update triggers Tag: 216742
  - 20
    - 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: insert / update triggers Tag: 216739
  - 21
    - 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: insert / update triggers Tag: 216731
  - 22
    - 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: insert / update triggers Tag: 216727
  - 23
    - 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: insert / update triggers Tag: 216719
  - 24
    - 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: insert / update triggers Tag: 216715
  - 25
    - 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: insert / update triggers Tag: 216699
- Next
  - 1
    - 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: insert / update triggers Tag: 216698
  - 2
    - 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: insert / update triggers Tag: 216691
  - 3
    - 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: insert / update triggers Tag: 216684
  - 4
    - Network Drive is there a function that can determine this drive is a NETWORK? Tag: insert / update triggers Tag: 216683
  - 5
    - 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: insert / update triggers Tag: 216676
  - 6
    - 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: insert / update triggers Tag: 216670
  - 7
    - 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: insert / update triggers Tag: 216659
  - 8
    - 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: insert / update triggers Tag: 216649
  - 9
    - Wish list : TOTAL... EXCEPT ... How about : TOTAL ON ID_EQUI TO m:\matable.dbf EXCEPT ID_EQUI Fabien Tag: insert / update triggers Tag: 216648
  - 10
    - Wish list: update sql How about a: update <TableName> from name <ObjectName> where .... Tag: insert / update triggers Tag: 216643
  - 11
    - 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: insert / update triggers Tag: 216640
  - 12
    - 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: insert / update triggers Tag: 216639
  - 13
    - 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: insert / update triggers Tag: 216634
  - 14
    - 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: insert / update triggers Tag: 216633
  - 15
    - 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: insert / update triggers Tag: 216629
  - 16
    - 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: insert / update triggers Tag: 216628
  - 17
    - 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: insert / update triggers Tag: 216616
  - 18
    - 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: insert / update triggers Tag: 216615
  - 19
    - 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: insert / update triggers Tag: 216611
  - 20
    - Wish list: append from name <ObjectName> Any support for this? -Lew Tag: insert / update triggers Tag: 216606
  - 21
    - Difference between fdate(,1) and ftime() Can anyone explain this, please? -Lew Tag: insert / update triggers Tag: 216605
  - 22
    - 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: insert / update triggers Tag: 216603
  - 23
    - 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: insert / update triggers Tag: 216592
  - 24
    - 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: insert / update triggers Tag: 216591
  - 25
    - 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: insert / update triggers Tag: 216590

Hi,

What is the best way to update a field whenever a new record is inserted or
updated?

i got VFP 9.

i tried the update/insert triggers, but during the trigger, the table header
appears to be locked?!

Kan

Re: insert / update triggers by Fred

Fred
Wed Oct 05 10:15:28 CDT 2005

You can't use the triggers to modify a field in the table that caused the
trigger, that would cause an endless loop. You need to use a validation
rule.

--
Fred
Microsoft Visual FoxPro MVP

"Kan Kan" <nospam4me@your.com> wrote in message
news:uAB5JMYyFHA.3812@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> What is the best way to update a field whenever a new record is inserted
> or
> updated?
>
> i got VFP 9.
>
> i tried the update/insert triggers, but during the trigger, the table
> header
> appears to be locked?!
>
> Kan
>
>

Re: insert / update triggers by Anders

Anders
Wed Oct 05 17:03:48 CDT 2005

CREATE TABLE x (xx C(2) DEFAULT 'XX', ... )
You can add defaults in the Table Designer window. For views there's a place
in the View Deszigner.
-Anders

"Kan Kan" <nospam4me@your.com> skrev i meddelandet
news:uAB5JMYyFHA.3812@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> What is the best way to update a field whenever a new record is inserted
> or
> updated?
>
> i got VFP 9.
>
> i tried the update/insert triggers, but during the trigger, the table
> header
> appears to be locked?!
>
> Kan
>
>

Re: insert / update triggers by Kan

Kan
Thu Oct 06 05:34:44 CDT 2005

Thank you.
I managed to get it done using the Record and Field Rules

Kan

"Anders" <anders@anders> wrote in message
news:#DevuhfyFHA.664@tk2msftngp13.phx.gbl...
> CREATE TABLE x (xx C(2) DEFAULT 'XX', ... )
> You can add defaults in the Table Designer window. For views there's a
place
> in the View Deszigner.
> -Anders
>
> "Kan Kan" <nospam4me@your.com> skrev i meddelandet
> news:uAB5JMYyFHA.3812@TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > What is the best way to update a field whenever a new record is inserted
> > or
> > updated?
> >
> > i got VFP 9.
> >
> > i tried the update/insert triggers, but during the trigger, the table
> > header
> > appears to be locked?!
> >
> > Kan
> >
> >
>
>