Passing Macro Output Value to a Variable or TextFile ?

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
    - Using Fields within Memo Text and use in Report ? Is it possible in Foxpro 2.6 for Dos, to use Fields within Memo Text, and then print that Memo in Report, which should replace the field names with their values. Something like TextMerge option in foxpro. For example: I put following in Memo Field. My Name is <<<cName>>> When I print this field in report, it should display following. My Name is Luqman My Name is Usman My Name is Aman Is it possible ? Best Regards, Luqman Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212841
  - 2
    - VFP6 exception Falal Error Exception code = C00000FD called from - ar_invoice.apppageframe.page2.g_recordmaintenance.cmd_save.click (line 0) Windows\system32\vfp6r.dll Any hint? Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212839
  - 3
    - text search in a class lib Is there a good tool to do text search on classlib, listing the object.method containing the text? I tried class browser, but the find function doesn't quite work. Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212832
  - 4
    - VFP 9 Report gibberish Has anyone else had trouble with SET REPORTBEHAVIOR 90 printing gibberish either to a printer or to a PDF print driver? I was able to make the printer work by changing to a generic HP LaserJet III driver, but I still get black boxes instead of text for the Amyuni 2.50 PDF print driver and random alphanumerics for the Adobe Acrobat 4.0 print driver. I've turned off the Save Printer Settings checkbox, but no difference. The reports work fine with SET REPORTBEHAVIOR 80. Any suggestions? Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212828
  - 5
    - Controlling the Size of a TIF File I have a process that uses the report listener to output a TIF file. It works great except for one thing: The size of the TIF file. I set up the report to be only 6 in. high by 6 in. wide, but when the report is output as a TIF, the image has the actual report (6 x 6) in the upper right of an image that is 8.5 in by 11 in. How do I make the size of the TIF file be 6 in. by 6 in.? Thanks. Charlie Parker Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212827
  - 6
    - MSXML 4.0 merge modules The VFP9 Help file says there are two of these, and they are described, along with the VFP runtime, as required. However, I have inadvertently left them out of setups I've built, and gotten no problems (so far). Does anyone know what these things do? Something with XML apparently (which this app doesn't use), but if that's the case, why are they listed as required? Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212826
  - 7
    - CURSORADAPTER DOES NOT COMMIT DATA in MYSQL DATABASE Hi guys I am using a code that I have found in internet (CURSORADAPTER.ZIP) and I am using it to retrieve data from MYSQL database but after I change the data and use an "TABLEUPDATE(0, .F., 'cursor')" just the cursor data is changed adn MYSQL does not reflect the changes, I know I have to send an COMMIT command to MYSQL but How can I do this (send a commit to mysql) using this cursoradapter. Thanks. Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212825
  - 8
    - create a date field in a select stmt??? How do you create a date field in a select statement. In other words, I could create a numeric field called age by the following: select name, id, 000 as age from <table> order by name into <newtable> What if I wanted to also create a date field called birthdate. How would I do that? Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212813
  - 9
    - cursors Hi All How do I transfer the contents of a cursor created by an sql select into a table? SELECT * FROM issues WHERE keyfld=Tfind INTO cursor toutput I have got the select in a do while loop to pick-up steel issued to jobs (there can be multilple). I could probably do it with a join, but its tooooo hot and my brain packed in two hours ago! Phwew Steve Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212812
  - 10
    - Cursor position in EditBox VFP 8 I've defined a class derived from the EditBox. This class is used is a grid. The cursor behind the grid is "artliens_liens" define class editbox_artliens as editbox procedure interactiveChange modif_artliens=.T. modif_stock=.T. select artliens_liens replace modif with .T. endproc enddefine In this edibox, when simply imputing text; the cursor is always in position 0. (Input abcd and see in the editbox : dcba) If i remove the line with "replace", the problem does not occur. Is there a solution to this problem ? Thanks in advance for help, Regards, Guy Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212810
  - 11
    - Content of <A:Rtf> - Tag Hi Folks, ActiveSync compresses the content of the <A:Rtf>-Tag with (I mean) an LZ-compression Format. So then this output will base64-coded. First (Base64-coded) Data: ygEAAJoDAABMWkZ1zkgjmwMACgByY3BnMTI1gjIDQ2h0bWwxAzA/AQMB9wqAAqQD4wIAY2jBCs BzZXQwIAcTAoD/EAMAUARWCFUHshHVDlEDAd0Q1zIGAAbDEdUzBEYQ2fkS72Y0A8YRhRHjCO8J 9/Y7Gh8OMDUbPxsREeEMYM5jAFALCQFkMzYRYAulZDQgEAIqXA6yAZBnAR/wMyA8IURPQwBUWV BFIEhUTQBMIFBVQkxJQwAgIi0vL1czQ5EisERURCHENC4RYORUcgBydGkCIAdAIrAwRU4iPhHj IGcxOUMhICHTRElSPSCwcp8lACBzACEDMCbBZG8A4PMmwQqxXHEaACbBEPADMDcnJRFgICszIA AmIEVBykQlDTQO8DwvKt8g0II1EWA8Qk9EWSUN7Dk2ISAmgFYm+QAAKTcZIEk2NC9/KY8xNDiB ISBGT05UIGYA0EhlPScHEycgGZM9VCMwNZMgAJB6NIAy9y9rGDADMGMT8AOyAdApH/UlhjUvAS 80Aib5JwcprYI4IAAmbmJzcAKA+ScYJ2EBQDA/IMEBwCcH7wqiOtgKgCUsMCqhIxAvS7c63y0W M9EvLc8g0TcsIgsh4SUAfUaQ Base64-decoded Data (Hex-View): 0000:0000 ef bf 8a 01 00 00 ef be 9a 03 00 00 4c 5a 46 75 ï¿....ï¾....LZFu 0000:0010 ef bf 8e 48 23 ef be 9b 03 00 0a 00 72 63 70 67 ï¿.H#ï¾.....rcpg 0000:0020 31 32 35 ef be 82 32 03 43 68 74 6d 6c 31 03 30 125ï¾.2.Chtml1.0 0000:0030 3f 01 03 01 ef bf b7 0a ef be 80 02 ef be a4 03 ?...ï¿·.ï¾..ï¾¤. 0000:0040 ef bf a3 02 00 63 68 ef bf 81 0a ef bf 80 73 65 ï¿£..chï¿..ï¿.se 0000:0050 74 30 20 07 13 02 ef be 80 ef bf bf 10 03 00 50 t0 ...ï¾.ï¿¿...P 0000:0060 04 56 08 55 07 ef be b2 11 ef bf 95 0e 51 03 01 .V.U.ï¾².ï¿..Q.. 0000:0070 ef bf 9d 10 ef bf 97 32 06 00 06 ef bf 83 11 ef ï¿..ï¿.2...ï¿..ï 0000:0080 bf 95 33 04 46 10 ef bf 99 ef bf b9 12 ef bf af ¿.3.F.ï¿.ï¿¹.ï¿¯ 0000:0090 66 34 03 ef bf 86 11 ef be 85 11 ef bf a3 08 ef f4.ï¿..ï¾..ï¿£.ï 0000:00a0 bf af 09 ef bf b7 ef bf b6 3b 1a 1f 0e 30 35 1b ¿¯.ï¿·ï¿¶;...05. 0000:00b0 3f 1b 11 11 ef bf a1 0c 60 ef bf 8e 63 00 50 0b ?...ï¿¡.`ï¿.c.P. 0000:00c0 09 01 64 33 36 11 60 0b ef be a5 64 34 20 10 02 ..d36.`.ï¾¥d4 .. 0000:00d0 2a 5c 0e ef be b2 01 ef be 90 67 01 1f ef bf b0 *\.ï¾².ï¾.g..ï¿° 0000:00e0 33 20 3c 21 44 4f 43 00 54 59 50 45 20 48 54 4d 3 <!DOC.TYPE HTM 0000:00f0 00 4c 20 50 55 42 4c 49 43 00 20 22 2d 2f 2f 57 .L PUBLIC. "-//W 0000:0100 33 43 ef be 91 22 ef be b0 44 54 44 21 ef bf 84 3Cï¾."ï¾°DTD!ï¿. 0000:0110 34 2e 11 60 ef bf a4 54 72 00 72 74 69 02 20 07 4..`ï¿¤Tr.rti. . 0000:0120 40 22 ef be b0 30 45 4e 22 3e 11 ef bf a3 20 67 @"ï¾°0EN">.ï¿£ g 0000:0130 31 39 43 21 20 21 ef bf 93 44 49 52 3d 20 ef be 19C! !ï¿.DIR= ï¾ 0000:0140 b0 72 ef be 9f 25 00 20 73 00 21 03 30 26 ef bf °rï¾.%. s.!.0&ï¿ 0000:0150 81 64 6f 00 ef bf a0 ef bf b3 26 ef bf 81 0a ef .do.ï¿ ï¿³&ï¿..ï 0000:0160 be b1 5c 71 1a 00 26 ef bf 81 10 ef bf b0 03 30 ¾±\q..&ï¿..ï¿°.0 0000:0170 37 27 25 11 60 20 2b 33 20 00 26 20 45 41 ef bf 7'%.` +3 .& EAï¿ 0000:0180 8a 44 25 0d 34 0e ef bf b0 3c 2f 2a ef bf 9f 20 .D%.4.ï¿°</*ï¿. 0000:0190 ef bf 90 ef be 82 35 11 60 3c 42 4f 44 59 25 0d ï¿.ï¾.5.`<BODY%. 0000:01a0 ef bf ac 39 36 21 20 26 ef be 80 56 26 ef bf b9 ï¿¬96! &ï¾.V&ï¿¹ 0000:01b0 00 00 29 37 19 20 49 36 34 2f 7f 29 ef be 8f 31 ..)7. I64/.)ï¾.1 0000:01c0 34 38 ef be 81 21 20 46 4f 4e 54 20 66 00 ef bf 48ï¾.! FONT f.ï¿ 0000:01d0 90 48 65 3d 27 07 13 27 20 19 ef be 93 3d 54 23 .He='..' .ï¾.=T# 0000:01e0 30 35 ef be 93 20 00 ef be 90 7a 34 ef be 80 32 05ï¾. .ï¾.z4ï¾.2 0000:01f0 ef bf b7 2f 6b 18 30 03 30 63 13 ef bf b0 03 ef ï¿·/k.0.0c.ï¿°.ï 0000:0200 be b2 01 ef bf 90 29 1f ef bf b5 25 ef be 86 35 ¾².ï¿.).ï¿µ%ï¾.5 0000:0210 2f 01 2f 34 02 26 ef bf b9 27 07 29 ef be ad ef /./4.&ï¿¹'.)ï¾ï 0000:0220 be 82 38 20 00 26 6e 62 73 70 02 ef be 80 ef bf ¾.8 .&nbsp.ï¾.ï¿ 0000:0230 b9 27 18 27 61 01 40 30 3f 20 ef bf 81 01 ef bf ¹'.'a.@0? ï¿..ï¿ 0000:0240 80 27 07 ef bf af 0a ef be a2 3a ef bf 98 0a ef .'.ï¿¯.ï¾¢:ï¿..ï 0000:0250 be 80 25 2c 30 2a ef be a1 23 10 2f 4b ef be b7 ¾.%,0*ï¾¡#./Kï¾· 0000:0260 3a ef bf 9f 2d 16 33 ef bf 91 2f 2d ef bf 8f 20 :ï¿.-.3ï¿./-ï¿. 0000:0270 ef bf 91 37 2c 22 0b 21 ef bf a1 25 00 7d 46 ef ï¿.7,".!ï¿¡%.}Fï 0000:0280 be 90 ¾. How can I decompress this last (Base64-decoded) Data? Sincerely yours Nico Roßwinkel Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212809
  - 12
    - frx2any Anyone heard of this tool? Can it export correctly to Excel newer than 97? Or was it because I was using an old version of it? -- .~. Might, Courage, Vision. http://www.linux-sxs.org / v \ /( _ )\ Linux 2.4.30 ^ ^ 8:10pm up 41 days 8:19 load average: 0.31 0.55 0.45 Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212803
  - 13
    - wait after shellexecute ? Hi, Is it possible to wait after a process, which is started with ShellExecute() ? I'm calling a program and would like that myapp waits until that program has finished. regards christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212801
  - 14
    - high-lighting current record in grid If the grid is in focus, the current record will always be high-lighted as I moved the record pointer programmatically (SKIP, GO, SEEK, ...). Is there a way to keep the high-lighting to follow the record pointer without grid.setfocus() first? Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212795
  - 15
    - Word.Application I have the following code to call a word document in a readonly mode, which works fine. x1=CREATEOBJECT("Word.Application") WITH x1 .documents.open ("f:\test1.doc",,.t.) .visible = .t. ENDWITH Once in word, can someone point me to a right direction or show me how i can change the default drive in file "Save as" from drive f: to drive c: and preferrable to the user's "my documents folder"? Many thanks Shahriar Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212793
  - 16
    - Wanted: Genifer for FoxBASE+ Hello! An old client has decided to come out of retirement and restart his business. Although he retained copies of his in-house developed programs, he did not keep any of his old commercial software. To modify his old programs we have need of Bytel's Genifer with templates for FoxBASE+ v2.1. Does anyone have a copy that they would be interested in selling? If so, please let me know at ojn@zoominternet.net. Thanks, O.J. Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212790
  - 17
    - Is grid.AfterRowColChange broken? I posted on a related topic yesterday. See Subject: RowColumnChange property always 0 It seems that the AfterRowColChange event doesn't behave as documented. It appears to fire BOTH before AND after a row change even though the docs are clear that it only fires after the chage. This can be seen by setting a breakpoint anywhere in user code in that event. Also, and contrary to the docs, the RowColChange property seems to always be zero. Am I missing something? Has this been discussed before? VFP9. Thanks, Frank Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212789
  - 18
    - VFP 6: Erroneous Error to Watch Out For I was just updating the application I support and ran into an error. I could not open tables on the other workstations. I kept getting "File is in use by another." The actual cause of the error is that the volumes are password-protected. I recently rebuilt my system and no longer had the passwords saved. Once I connected through Windows Explorer which asked for the passwords, there was no problem getting through using VFP. This leads to the question: Is there a way in VFP to specify a password for accessing a file on a password-protected volume? Sincerely, Gene Wirchenko Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212788
  - 19
    - Ken Levy's July letter posted http://msdn.microsoft.com/vfoxpro/letters/ -- Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP cindy_winegarden@msn.com www.cindywinegarden.com Blog: http://spaces.msn.com/members/cindywinegarden Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212779
  - 20
    - VFP90: Help file Why when I press F1 or from menu "Help -> Help" the Help doesn't open? The file "dv_foxhelp.chm" exists and is set in "Tools->Options->File Locations->Help File". Meskis Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212778
  - 21
    - Send using OE but prompt Outlook profiles. i use msmapi32.ocx to send e-mail from my program. it seems to works perfectly on XP & 9x machines, but recently i found few 9x machine have problem. system will prompt to choose Outlook profiles when try to sent. those machine do not use outlook, and should not prompt this. as my default mail program already set to OE. any ideas to resolve this problem? Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212761
  - 22
    - buffering and sql I have a table opened in buffering mode = 5. I appended a record with table.amount=4. then I execute select sum(amount) on the table. It returned 0, not 4. Could I make the sql query to take into account of the pending changes? Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212754
  - 23
    - RowColumnChange property always 0 VFP9. I'm having trouble with the rowcolumnchange property. I have some code in the afterrowcolumnchange event that needs to fire if a row, not a column has changed. Problem is, the property always seems to resolve to zero so my code never executes. Here's a piece of the code in the afterrowcolumnchange event for the grid: IF This.RowColChange = 1 OR This.RowColChange = 3 RecSymb = RECNO("Symbols") SELECT se.Institutio, ac.ACName, se.Totshares, ; *** additional code ENDIF I have a breakpoint at the IF statement so that I can check the property. Also, the event seems to fire twice every time I change rows. What am I doing wrong? Thanks, Frank Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212752
  - 24
    - command + properties = ?? in vFP 9, when the command windows and properties are combined into each other, what's its window name? I found that my hide_all_vFP_system_toolbars router didn't work for the combination. Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212748
  - 25
    - Foxpro 9 SQL Select OK, what the heck am I doing wrong. The below statement returns a cursor if I Take Out everything after the WHERE h.lFinalized. I ultimately need to UNION, but need to get this working first... Thanks for your help SELECT d.cTick, h.cName, h.cPlant, h.dDate, h.dShpDate, d.cItemNr, + ; d.cDistNr, d.cItmDesc, d.nQty, d.cItmSize, d.eTotDlvPrice, d.nDlvDist, + ; h.cVPNo, d.cSuppNo, d.nPrcMdl, d.nItmWght, d.cSupItem, d.nAmt, d.ePAmt, + ; h.cSOGrPoNo, h.dSoInvDate, d.eSupFobCs, d.nSOtWeight, d.eVPDPAAmt, d.eDstShlAmt ; FROM SO_HEAD h ; INNER JOIN SO_DETL d ON d.csoTickno = h.csoTickNo ; WHERE h.lFinalized AND h.dsoDate BETWEEN CTOD(THISFORM.Text1.Value) AND CTOD(THISFORM.Text1.Value) AND ; d.cItemNo <> '999999' AND ; d.nSOQty <> 0 AND ; h.cSOType = '2' INTO CURSOR curReport Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212744
- Next
  - 1
    - Cannot access CHM on a network drive with XP I have CHM for my application that I have been using for years. Today I discovered that I can open the CHM that is on a network drive with XP but cannot read any of the contents. The 'find' works and the table of contents is working but none of the pages are displayed. I have opened the file on the network drive in the recent past. If I copy the file to my local hard drive I can open it. I can open the file using WIN98 or WIN2K on the network drive without copying the file. None of my XP computers can read the contents of the file. What could have changed to cause this behavior? Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212717
  - 2
    - problem with a report logic hi all. this is a pretty difficult question to ask so i hope to describe it in the right way. i have a reprt to print that is causing me some problems. the cursor that i have when it is the time to print my detail is kind of this: cust #doc value #doc rif mrx 10 10 1a mry 20 25 1b mry 20 25 1c mrz 30 12 1d what i woul like to obtain is something like this: customer value doc number mrx 10 10 doc ref 1a tot val for mrx 10 mry 25 20 doc ref 1b doc ref 1c tot val for mry 25 mrz 12 30 doc ref 1d tot val for mrz 12 my problem is that with mry that has 2 records the value for the total is double (25 + 25 = 50) so i have for this customer something like this mry 25 20 doc ref 1b doc ref 1c tot val for mry 50 (<--------WRONG!!!) the total value is defined as the sum of the cursor single value. so this is the reason why it is double in the case of mry...i am able not to print twice the row of the document but the sum counts every record (even if not printed). Is there a way to let the sum works in the same way as the print (do not show repeated values -- do not count in the sum repeated values)? or is there a better way to solve this? thanks in advance and bye. Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212716
  - 3
    - PNG file to BMP file I need to programatically convert a PNG file to a BMP file. Anyone have a a method, routine, process, 3rd party control or whatever that will do this? Thanks. Charlie Parker Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212713
  - 4
    - Default Cap Lock on I know i can set the format of textbox is "!". However, Once i set it, i cannot change the textbox into small letters. So , Can I set the keyboard 's default "cap lock on" ??? Thanks Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212693
  - 5
    - Folder cannot be deleted Why is folders on my harddisk created from my program using MD command cannot be delete until i quit my Foxpro even the program has already ended ? my program use MD and copy files command. Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212688
  - 6
    - Rookie Questions - Emailing and FTPing with VFP I have VFP 7.0 SP1 How can I email and ftp programmatically with VFP? That is, I want to create some prgrams that email or ftp whenever the program calls for it. Is this possible? How are other people doing it if VFP does not give these capabilities? BTW when I say "email or ftp", I actually have two separate needs for communication. 1. I need to automatically email messages based on some triggers in my data. 2. Separate from the email, I have VFP creating some web pages, and I would like these to be automatically FTPed or transfered to my web site. On the last point of FTPing, I do know how to automatically FTP using scripts in WS-FTP. I was just wondering if there is a feature internal to VFP for doing this. Thanks. Best regards, Al http://www.affordablefloridainsurance.com http://www.americanbestmortgages.com Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212684
  - 7
    - A Touch OT: C++ App on PDA talking to VFP data Hi, Has anyone tried the above. The idea is an embedded Visual c++ app running on a Windows CE .NET 4.2 PDA talking to remote VFP tables or a DBC. Have had a look at ADOCE, but it doesn't want to play. To be honest, I'm not sure where to start here, but I can't run VFP natively, and have tried a web based app with FoxISAPI which works OK, but is less than ideal as I can't control focus well enough for the built-in barcode scanner. The PDA doesn't support the .NET compact framework, even though it is the CE .NET 4.2 OS (guess I assumed too much there?). If anyone's tried and succeeded along these lines, I'd be very happy to hear from you. I know the VFP OLEDB provider would be a nice way to go, and it works fine with c#.net, but this overly priced heap of crap (Symbol MC3000) won't take it. (sorry, frustrated and wondering if it really will take that number of drops onto concrete from that height). Regards, Neil Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212683
  - 8
    - Best way to reactivate application? VFP6 SP5 on XP Pro SP1 I have a long routine that, at one point produces some PDFs using the PDFWriter printer. When the PDF is produced, a little "Printing.." dialog pops up and tallies the pages as they are printed, then disappears. After it goes away, my application no longer is the active window. As a result, if the user presses any keys, they are not visible to my app (I allow the user to interrupt the process by pressing ESC). I'm sure there must be a reliable way to automatically make my app the active window again after printing to PDF. I just haven't found it yet. Any ideas? -- TRW _______________________________________ t r w 7 at i x dot n e t c o m dot c o m _______________________________________ Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212681
  - 9
    - Data changes but reverts. Hi, This is giving me a headache! I guess there's something I don't understand about BEGIN TRANSACTION/END TRANSACTION. Changes I make to two tables revert back. Below is some code executed when the user wants to change the key field in the Symbols table (the field name is Symbol). Referential integrity requires that I also change any occurrence of the changed Symbol in the Securities table. When I step through the code I can see the changes are being made. The comments in the code below indicate that. But when I exit the application, they revert back to the old values. Here are a few possibly significant factors. 1. Even though the field temporarily changes in the Symbols table, the modified record appears at the bottom of the table even though the index order is on that same field (Symbol). I expected the changed record to take its normal place in the index order. It doesn't. 2. I'm using the buttonbar that is automatically placed on the form when I use the Form Wizard. There is a lot of code in there (much of which I don't understand) that may be screwing things up. 3. This is VFP9 4. I've tried using "automatic" referential integrity in the database but when I omit the operations on the Securities table (in the code below); the rows in that table don't change. Any thoughts would be greatly appreciated. Thanks, Frank Code snipped begins here: BEGIN TRANSACTION SELECT Symbols REPLACE Symbol WITH m.NewName * The record does change SEEK(m.NewName) SELECT Securities m.recno = RECNO() m.OldFilt = FILTER() SET FILTER TO Symbol = m.OldName LOCATE REPLACE ALL Symbol WITH m.NewName * All records that match Oldname change to Newname. SET FILTER TO &OldFilt TRY GO RECNO CATCH GO TOP ENDTRY END TRANSACTION SELECT Symbols SEEK(m.NewName) ThisForm.pgefrmSYMBOLS.PgeSymbols.cmboSymbol.Requery =ThisForm.PgeFrmSymbols.pgeSymbols.REFRESH() end of code. Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212680
  - 10
    - windows explorer filename sort order question Windows XP explorer shows 4 files sorted by name as such: apple.dbf test04.dbf test031012.dbf zebra.dbf The 2 'test' files are sorted differently on Windows 2000 and earlier machines: apple.dbf test031012.dbf test04.dbf zebra.dbf How can I make XP use the older sort method? THX Mike Farnesi San Diego Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212679
  - 11
    - connect to sql server with app role I need to be able to connect to a remote instance of SQL Server using an application role rather than a user login. Can anyone help with the connection string? Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212678
  - 12
    - Textbox and ActiveChart This code works great for adding a textbox to an Excel sheet, but does anyone know the code to add a textbox to an ActiveChart? oExcel.ActiveSheet.oleObjects.add("Forms.TextBox.1") I thought it would just be: oExcel.ActiveChart.oleObjects.add("Forms.TextBox.1") but this doen't seem to work. Thanks Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212669
  - 13
    - Issues with Names hello, i need to be sure Names First, Last and suffixes print out right. in cases i will have Jane MCDOE, It need to be Jane McDoe or John Doe VII comes out like John Doe Vii using Proper, proper messes with my addresses to. still learning VFP, and the little tricks i get from you folks. will i have to write a Transform for each thing that may happen? what is my best route for this. thanks in advance Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212667
  - 14
    - Switching OE Identity when programmatically sending e-mail from OE, it will use currently logon identities to send out the email. how can change to diff account setup in diff OE identity base on condition ? Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212658
  - 15
    - Button invisible after preview ? As I run my program under window XP, Sometimes, after I preview the report , the userinteface 's button will become invisible, my menu bar got 10 image buttons , sometimes, it will invisble after preview. I need to quit the form and run it again. It is very strange that , only one form got such problem . Does anyone can help ??? Thanks in advance. Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212651
  - 16
    - VFP6 & VFP9 Coexist I know that developer have no problem of install and compile both VFP6 & VFP9 program in same pc. but can the user's pc able to run both ver6 & ver9 program at same time once their pc is being update with ver9's runtime files ? Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212650
  - 17
    - windows search how does windows search work? I right-clicked a foxpro source codes folder, and enter "form" into the word textbox, Windows replied nothing. That's wrong. Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212648
  - 18
    - Had someone used Inpout32.dll? This is a DLL to read and write the paralell port. Had someone used it in VFP? Thanks, Alejandro Fernandez Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212646
  - 19
    - wierd behaviour Does this happen to anyone else? If I have any text written to my VFP9 desktop and then launch Yahoo Messenger my VFP desktop 'clear's - all the text on my VFP desktop is erased ! I've tried launching others apps besides Yahoo Messenger but this is the only one that make VFP 'clear' the desktop. THanks Mike Farnesi San Diego Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212642
  - 20
    - How to change icon from fox to my own in windows explorer I want to changed the icon for the exe built in VFP displayed in Windows Explorer. Can anybody give a lead? Thanks. -- Daniel Kim compumate99@yahoo.com Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212640
  - 21
    - prg to vcx Dear All, How to convert prg to vcx. Thanks for help Rgds, Sutrisno Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212629
  - 22
    - VFP Messages Hey, I inherited this application with 200+ forms, and don't like the STATUS BAR, so mostly I turn it off. A couple of forms display the message "Selected 10,000 records in 0.01 seconds" and I have TALK OFF, STATUS BAR OFF, but still see this stuff. How do I shut this message off. Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212624
  - 23
    - Is there a more intelligent way to code this... Thanks in advance for the help. I have a prg to which I am adding a parameter. The parameter needs to have a default value of .T. if I don't want to change all of my existing calls to the prg so I'm doing the following: Old code: parameters pnFolio New code: parameters pnFolio, plIncludeBackup if parameters() = 1 plIncludeBackup = .t. endif I realize that I could make the parameter plOmitBackup and let it default to .f. but the code is much clearer if I call the parameter plIncludeBackup and have it default to .t. I guess what I would like is something like: PARAMETERS pnFolio DEFAULT 0, plIncludeBackup DEFAULT .t. but that doesn't exist. Anyone have any better suggestions than what I am doing? Thanks Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212605
  - 24
    - VFP 9 Now or wait for SP? Hello and thanks in advance: For those of you that are using VFP 9 already, do you think I should switch to 9 (from 7 SP 1) now or should I wait for the 9 SP to be released. It seems from reading this ng that there have been a lot of problems going from 6-7 to 8 or 9. Any recommendations, experiences, warnings, etc.? Thanks, Jeff Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212602
  - 25
    - vfp 9 and quit define class toplevelform as form ... showwindow=2 ... procedure queryunload local frmQuit, loParam nodefault loParam=createobject("MyParam") frmQuit=createobject("quitform",loParam) frmQuit.show() do case case loParam.toquit=0 clear events quit case loParam.toquit=1 case loParam.toquit=2 clear events dodefault() endcase endproc enddefine I found that the "QUIT" doesn't work under VFP 9. It just returned me to the command window. In VFP 6, the "QUIT" could work. -- .~. Might, Courage, Vision. http://www.linux-sxs.org / v \ /( _ )\ Linux 2.4.30 ^ ^ 8:01pm up 35 days 8:10 load average: 2.90 0.95 0.45 Tag: Passing Macro Output Value to a Variable or TextFile ? Tag: 212587

I am using TextMerge on Memo Field in Foxpro 2.6 for Dos.

use customer
set textmerge on
a="/ Dear <<Name>>"
&a 'This will produce Dear Luqman

Now, I need to print result of &a to report, how can I save this result into
a table or cursor ?

Best Regards,

Luqman

Top

Re: Passing Macro Output Value to a Variable or TextFile ? by Jack

Jack
Fri Jun 24 12:21:26 CDT 2005

On Fri, 24 Jun 2005 17:04:29 +0500, "Luqman" <pearlsoft@cyber.net.pk>
wrote:

>I am using TextMerge on Memo Field in Foxpro 2.6 for Dos.
>
>use customer
>set textmerge on
>a="/ Dear <<Name>>"
>&a 'This will produce Dear Luqman
>
>Now, I need to print result of &a to report, how can I save this result into
>a table or cursor ?

CREATE CURSOR xx (fld C(32))
INSERT INTO xx (fld) VALUES('&a.')

Top

Re: Passing Macro Output Value to a Variable or TextFile ? by Bernhard

Bernhard
Mon Jun 27 04:28:10 CDT 2005

Hi Luqman

> I am using TextMerge on Memo Field in Foxpro 2.6 for Dos.
>
> use customer
> set textmerge on
> a="/ Dear <<Name>>"
> &a 'This will produce Dear Luqman
>
> Now, I need to print result of &a to report, how can I save this result into
> a table or cursor ?
Afaik there is no direct way in FPD to get the result into table or cursor.

The long way would be:

SET TEXTMERGE TO dummy.txt
SET TEXTMERGE ON
TEXT
....
ENDTEXT
\ ...
\\ ...
SET TEXTMERGE OFF
SET TEXTMERGE TO
APPEND MEMO yourMemo FROM dummy.txt

Regards,
Bernhard Sander

Top