FoxPro, Clipper and dBase for Pocket PC and SmartPhone!

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
    - combobox I created a combobox in a form (style=dropdown combo). user can input his own text or select from an existing one. I entered some text into it. After a thisform.refresh(), the combox.value was cleared. Why? how could I keep the user-inputted value persistent? As a result, I couldn't save the value to the combobox.controlsource. The underlying table is having buffering=5. Tag: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212881
  - 2
    - report form 1. How could print a logo on a report form with transparent background? Must I use a gif? 2. Could I use a variable in path property of a PictureOLE Bound object? Tag: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212880
  - 3
    - universalthread.com Not Up-to-date? There is no news today. The date at the top of the page is Bathurst, June 23, 2005 17:44 AST. Is anyone else seeing this? Sincerely, Gene Wirchenko Tag: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212866
  - 4
    - Data session issues - VFP9 Has anyone come across any quirks with VFP9 forms and reports with respect to using private data sessions? Several of us are running into intermittent issues. I've not yet been able to duplicate it 100%, but I'm working on that. Issue: You run a report from a program, and the find file dialog appears. No apparent reason. Suspend program immediately before report form is run. Open debugger, add set('datasession'). Edit report. Preview. Previews fine, datasession stays at 1. Immediately preview again. Datasession changes, find file dialog appears. Cancel. Preview again, previews fine. Preview again, find file dialog appearrs and datasessions is changed. Every other time we previewed the report, it would change datasession and error out, and every other time it would preview fine. Issue: Modify report. Ensure private data session is not selected. Save report. Edit report. Private datasession is selected. Unselect it. Save report. Edit report. Private datasession is selected. Issue: Create form. Set to private datasession. Add tables to DE. Save. Edit, set to default datasession. Save and run. Form opens in private datasession, even though you set it to default. We are seeing enough of these to establish a pattern, but not enough to duplicate it 100%. (and, no, I'm not the only one here that is seeing this :-P ) Tag: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212862
  - 5
    - VFP 8: Grids (bug problem) I have a container class that contains a grid. The grid was setup to have specific column names. I set the grid to point to a cursor during runtime. This allows me the ability to have multiple instances of the container using different cursors. The container is loaded onto a form at runtime as the user needs this interface. The code below is my standard way of "binding" the data to the grid. cTempFile1 = "somecursor" this.Grid_Codes.recordsource = 1 && Alias this.Grid_Codes.recordsource = cTempFile1 this.Grid_Codes.col_code.controlsource = cTempFile1 + ".cCode" this.Grid_Codes.col_desc.controlsource = cTempFile1 + ".cDesc" The problem I am having is, sometimes (hard to repeat), I get errors because the code is referring to the col_code column. VFP errors out stating "Unknown member COL_CODE". It turns out, that the grid has lost the names of the grid, and now has the names Column1 and Column2 instead of col_code and col_desc. Has anyone else seen this problem, and does anyone have a resolution? Thanks, Dan Tallent Tag: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212853
  - 6
    - Passing Macro Output Value to a Variable or TextFile ? 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 Tag: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212848
  - 7
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212841
  - 8
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212839
  - 9
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212832
  - 10
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212828
  - 11
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212827
  - 12
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212826
  - 13
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212825
  - 14
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212813
  - 15
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212812
  - 16
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212810
  - 17
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212809
  - 18
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212803
  - 19
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212801
  - 20
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212795
  - 21
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212793
  - 22
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212790
  - 23
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212789
  - 24
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212788
  - 25
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212779
- Next
  - 1
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212778
  - 2
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212761
  - 3
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212754
  - 4
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212752
  - 5
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212748
  - 6
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212744
  - 7
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212717
  - 8
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212716
  - 9
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212713
  - 10
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212693
  - 11
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212688
  - 12
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212684
  - 13
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212683
  - 14
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212681
  - 15
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212680
  - 16
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212679
  - 17
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212678
  - 18
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212669
  - 19
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212667
  - 20
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212658
  - 21
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212651
  - 22
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212650
  - 23
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212648
  - 24
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212646
  - 25
    - 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: FoxPro, Clipper and dBase for Pocket PC and SmartPhone! Tag: 212642

FoxPro, Clipper and dBase applications development for Pocket PC is already
available from:

http://www.fivetechsoft.com/english/fwppc.html

FWPPC uses Harbour (www.harbour-project.org), the open source Clipper
compatible compiler, already ported to Windows Mobile operating system.

Full DBFs, Indexes (CDXs, NTXs) support, plus all the Clipper language
features.

Lars

Top