program after program

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
    - Win XP Pro Colors I am having color issues in Win XP Pro. When on a Win2k box, the color for my command button is bright red/green (255,0,0/0,255,0) depending on whether an expression is valid or not. The problem is that in XP, the colors are pastel and on 2k the colors are the colors they should be. What is causing this and what can I do to correct it? Thanks, Scott Tag: program after program Tag: 203877
  - 2
    - Textbox Height in a Grid I am using VFP8 and have a grid with its RowHeight set to 20 and which highlights the selected row. In Column2 I have a Textbox that is that column's CurrentControl. The TextBox's Font is 9pt Verdana. When the TextBox becomes active, the SelectedBackColor of the TextBox does not fill the entire row height in the grid so that part of the grid's selected row highlighting appears above and below the TextBox's SelectedBackColor. I hope this makes sense. Does anyone know of a way to have the selected cell not display any of the grid row's highlighted color? -- Jim D Tag: program after program Tag: 203870
  - 3
    - VFP 8.0 grid losing focus and forcing a tableupdate() Has anyone else run into the following situation: I have a row buffered cursor. I have a grid on this cursor. when the grid looses focus an automatic tableupdate() is done and I lose the ability to issue a tablerevert(). The row does not change and no code is called to make the update happen. Alan Sheffield Programmer Park West Gallery Tag: program after program Tag: 203867
  - 4
    - vfp7, xp and displaying a pdf file I want to add a menu option so that my users can open up the manual as a pdf. However I don't know what version of Adobe Acrobat reader they will have so want if possible to run it by specifying the pdf file itself. I am not confident enough to unearth the required reader exe information from the registry or wherever !! I have tried RUN MANUAL.PDF RUN /N MANUAL.PDF RUN /N3 MANUAL.PDF RUN START MANUAL.PDF (which works in a compiled fpw2.6 exe on a Win98 machine but not in a compiled fpw2.6 exe on xp) Can anybody help? Many thanks Stephen Tag: program after program Tag: 203861
  - 5
    - How to tell what index tags are actually used Hello all and thank in advance for the help. I have an app that I maintain which I inherited from other coders. There are some tables for which over 50 index tags have been created and I'm certain that not all of them are needed. I can certainly tell which ones are referred to in the code by searching for all of the instances of SET ORDER in the project but that still leaves me with over 30 that may be unnecessary. Is there anything I can turn on that is similar to profiling that will tell me which indexes actually get used? I suppose that I could always remove them one at a time and see if anyone complains that their report or query has gotten really slow but I would prefer a more intelligent approach. Does anyone have any ideas? Thanks again. Jeff Tag: program after program Tag: 203856
  - 6
    - JOB for foxpro experts in Cyprus 2(two) System Analysts 2+years experience should include needs analysis, requirements gathering, application development, testing, deployment, user documentation, user training, and application support/maintenance. 4(four) Software Developers (Visual FoxPro ) The successful candidates should have 2+ years of experience in developing and maintaining Visual Fox Pro applications and to be very proficient in designing classes and writing object based solutions George Malekkos Managing Director __________________________________ www.powersoft.com.cy eXPerience the POWER of real SOFTware Tel +357.22.67.00.67 Fax+357.22.67.77.77 __________________________________ ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =--- Tag: program after program Tag: 203854
  - 7
    - Toolbar How to Create a toolbar buttons, without writing the source code for the same. As we can use the controls on the form for desiging the same. Toolbar can also be created. If yes, what is the source code. As i am a novice programmer i dont know how to use the same. I do not want to write the code for creating the cmd buttons. Tag: program after program Tag: 203852
  - 8
    - insert statements too slow?? Hi All, I have a foxpro master table, which consists of > 100000 records. those master records have to be copied to around 6 "children" table separately, according to their categories for example, records of "select * from master_table where category = 1" will copy to child_table_1 records of "select * from master_table where category = 2" will copy to child_table_2 ................ ................ ................ etc........... I was using the cursors to fetch the master table record one by one and insert into related child table, and i've found that it is very slow. The full process, copy from master table to different children, took me more than 3 hours !! I wonder if there is any faster method to do so? p.s. i am using foxpro 5.0 Regards, Angus Tag: program after program Tag: 203848
  - 9
    - Project Info, CodePage problem Hi, On Project, Project Info, Files One of my forms has incorrect code page How do I change the default code page of a form to another. The initial was none, and Updating the Native Code Page got the number 1252 and I want it to be 1253, because it does not store correctly the Greek words. Demetrios, Greece Tag: program after program Tag: 203843
  - 10
    - DateTime Picker Anyone knows of a replacement of the Datetime Picker? I've had nothing but bad luck in trying to make it work. I remember many of the conversations that dealt with this before, but I can't get it to work right. Does anyone have any clear instructions? or a replacement object to use? Thank you, 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: program after program Tag: 203839
  - 11
    - menu fonts Is it possible to specify menu fonts in the menu designer? It can be done in code. Except for the pads, which remain at the system-specified settings. What am I doing wrong? Tag: program after program Tag: 203833
  - 12
    - Checking if outlook has been setup with a server, and if email sen I'm using VFP8 (testing in VFP9) to automate Outlook (via outlook redemption). But before I try to send an email I need to know if the user has setup a server for outlook yet or not. anyone know where I should start looking for this info? Also if they did have a server setup and I create and send a email how can I check if it was sent successfully? -- John B Tag: program after program Tag: 203828
  - 13
    - Automation Question for WORD I have an application in which I used Automation for WORD. This has been working for years beginning with OFFICE 97 and then OFFICE 2000. I recently received a message from someone who trying a trial version of the application who indicated he received a message that the program would not work with OFFICE 2003. There is nothing exotic about my usage of Automation -- it just opens up an existing WORD document and allows the user to edit and save it. Question: are there any known differences in OFFICE 2003 vs OFFICE 2000 which would require changes in using WORD Automation commands? I don't want to go out and buy OFFICE 2003 just to find out if it is a problem with the customer's installation as opposed to a real difference in the two products. TIA --E. Myron -- To reply, change "invalid" to "net" Tag: program after program Tag: 203820
  - 14
    - Crystal reports Does anyone know how to set the maximum and minimum values of a range type parameter field in code. The code I have so far is.. * Create the CR Object LOCAL loCr AS CRAXDRT.APPLICATION loCr = CREATEOBJECT("CrystalRuntime.Application") * Open the report loCrRpt = loCr.OpenReport(ALLTRIM(sp_ReportPath) + "\"+ALLTRIM(treports.CODE)+STRTRAN(STR(treports.VERSION,3)," ","0")+".rpt") * Create the Database object oDB = loCrRpt.Database() * Get a references to the DatabaseTables collection ocDbt = oDB.Tables(1) * set the datasource of the report FOR EACH cPProperty IN ocDbt.connectionproperties IF cPProperty.name = "Data Source" cPProperty.value = gcDataPath endif endfor loCrRpt.DiscardSavedData() ocParm = loCrRpt.ParameterFields() oParm = ocParm.GetItemByName("cust") oParm.SetCurrentValue(lcCustFrom) oParm.AddCurrentValue(lcCustTo) This sets the start of the range value but produces an error when the addcurrentvalue() line runs. The error says the parameter is not range. I have checked the parametr and it si a range type parameter. The data type is string. Thanks in advance Dave Tag: program after program Tag: 203808
  - 15
    - field alias Dear sirs I'm trying to make an alias t my fields but these aliases have spaces as follows SELECT DEPTID as "dept id" , DEPTNAME as "dept name" FROM DEPTS INTO CURSOR slctCurs it gives me a syntax error how can I fix that?? thanks Mohammed Tag: program after program Tag: 203807
  - 16
    - Common dialog - problems I get error message 1429 when I use showopen or showsave. The other actions work fine. This is my code: Dialog = CreateObject('MSComDlg.CommonDialog') dialog.ShowOpen &&error dialog.AboutBox &&OK dialog.ShowHelp &&Nothing dialog.ShowPrinter && OK dialog.ShowSave &&Error I have tried it with VFP 7 and 8 with the same result. I'm running XP SP1 on a PC with 1G RAM. What could be the problem? Tag: program after program Tag: 203806
  - 17
    - two tables into one cursor Dear sirs Is there any way enables me to put the output of two SELECT statements into one cursor ex: select sid, sname from students into Cursor sCurs select did, dname from departments into Cursor sCurs so sCurs has the values of the two tables can I do that?? and how?? thanks Mohammed Tag: program after program Tag: 203797
  - 18
    - FLL - VB? Is it possible to create a FLL library in VB? Zeke Tag: program after program Tag: 203794
  - 19
    - FLL install directory Hi, Where should I install an FLL file. I usually install it in the program directory. On a new app when I changed the default directory the exe reports that it cannot find something. If I copy the FLL to the new directory then the program works fine. What do I do wrong? Demetrios, Greece Tag: program after program Tag: 203777
  - 20
    - mshflexgrid I am interested in making use of this control (MSHFLEXGRID)on my VFP application. How does one bound it to a table or to a SQL server. Is there s simple example somewhere that does not use ADO. The reading I did on it all point to ADO. If there is a better hierarchial control that someone knows for VFP I would appretiate it. Many Thanks Shahriar Tag: program after program Tag: 203775
  - 21
    - one excel file ? Dear all, I created a salary report program for user use. However, user wants the output is excel format. So, I use "copy to ...type xls" command to export data to excel file. My problem is : create many excel file after run program. Because, I separate each employee have one excel file. But user wants one excel file to store all employee(separate page in excel). I am no idea how to do that. Anyone have go that before? Please advice. Thanks Edmond Tag: program after program Tag: 203769
  - 22
    - Call me dumb but now have a problem I know I should not have installed it but I did I installed the 9 beta on the same machine as my production 8 and now I have problems with exe's created in 8 indexing is not working on dbf's I have tried issuing reindex in a routine and the indexing functions of 8 are lost I receive no errors but the dbf is not being indexed as it should be when sending reports to a printer when sending to preview it works but not sending to printer Help I have uninstalled the beta but the problem still persists what can I do? here is the very simple code which was working prior to install of 9 beta but is not now in 8 SELECT checkhdr SELECT checkdet SELECT CHECKDET SCAN xfer=SUBSTR(ALLTRIM(INV_DATE),4 ,2) xfer2=SUBSTR(ALLTRIM(INV_DATE),6 ,2) xfer3=alltrim(str(INT(VAL(SUBSTR(ALLTRIM(INV_DATE),1 ,3)))+1900)) xfer4=xfer+"/"+xfer2+"/"+xfer3 REPLACE INV_DATE WITH xfer4 endscan GO top SELECT CHECKHDR SCAN xfer=SUBSTR(ALLTRIM(CHKDATE),4 ,2) xfer2=SUBSTR(ALLTRIM(CHKDATE),6 ,2) xfer3=alltrim(str(INT(VAL(SUBSTR(ALLTRIM(CHKDATE),1 ,3)))+1900)) xfer4=xfer+"/"+xfer2+"/"+xfer3 REPLACE CHKDATE WITH xfer4 ENDSCAN SELECT checkhdr SET ORDER TO tag check_no GO top SCAN csz = ALLTRIM(checkhdr.city)+ SPACE(1)+ ALLTRIM(checkhdr.state)+ SPACE(1)+ ALLTRIM(checkhdr.zip) SELECT CHECKDET SET ORDER TO tag check_no SET FILTER TO checkdet.CHECK_NO = CHECKHDR.CHECK_NO GO top COUNT TO PAGER IF PAGER <= 13 thisform.lblStatus.Caption = "PRINTING CHECK NUMBER " + STR(CHECKHDR.CHECK_NO) REPORT FORM CHECKWRITER\CHECKWRITER3.frx TO PRINTER NOCONSOLE NOEJECT ELSE ENDIF IF PAGER > 13 thisform.lblStatus.Caption = "PRINTING CHECK NUMBER " + STR(CHECKHDR.CHECK_NO) csz = ALLTRIM(checkhdr.city)+ SPACE(1)+ ALLTRIM(checkhdr.state)+ SPACE(1)+ ALLTRIM(checkhdr.zip) REPORT FORM CHECKWRITER\CHECKWRITER4.frx TO PRINTER NOCONSOLE NOEJECT ELSE ENDIF ENDSCAN Tag: program after program Tag: 203760
  - 23
    - Adding a toolbar to a vanilla form Can anyone tell me if it is at all possible to dock a toolbar on a regular, vanilla, run-of-the-mill form? I have tried dabbling with formsets, but it seems that the foxpro toolbar only likes to be docked onto the 'main frame'. I say 'main frame' because my experience is from the MFC world. Thanks for your help! Tag: program after program Tag: 203758
  - 24
    - View Question Does VFP 7.0 have a problem with "not" filters. When I try to insert a not equels filter into the view below I get zip for the results: SELECT Pagelist.*, Skudata.upc, Skudata.minqty, Skudata.shelfpk,; Skudata.casepk, Skudata.dnb, Skudata.itemstat, Skudata.skustat,; Skudata.divnum, Pogjoinitem.pognum, Skudata.custdept, Skudata.skunum,; Skudata.vendornum; FROM progdata!pagelist INNER JOIN progdata!skudata; LEFT OUTER JOIN progdata!pogjoinitem ; ON Pogjoinitem.itemnum = Skudata.itemnum ; ON Pagelist.itemnum = Skudata.itemnum; ORDER BY Pagelist.itemnum The filter looks lile this: WHERE Skudata.itemnum <> Pogjoinitem.itemnum = .T.; I've also tried using the "NOT" button on the JOIN tab but I click it on. Cory Bonallo Tag: program after program Tag: 203751
  - 25
    - VFP9 report field alignment bug I have a detail band field in a VFP9 report (still running in VFP8 mode, no listeners or anything special) that evaluates to strings like "47/$123.50", "15/$50.00", "0/$0.00", "818/$3,996.00" etc. These strings are all fully trimmed and the report field is set to right justified, yet the those fields in the detail rows do not line up on the report preview - the right edges from one row to the next are misaligned by almost the full width of a zero. Fortunately, they line up much better - but not perfectly - when printed. Is this something I should report as a bug before release? To whom, and how? Maybe it's too difficult, or too late, to fix. Tag: program after program Tag: 203750
- Next
  - 1
    - Mousepointer on a grid This isn't a big deal but I would like to set the mousepointer for a grid. I noticed that it is only settable for the grid and the textboxes in the grid. I changed these to a regular pointer but it doesn't seem to work the way I want it. I want a normal pointer as move across the grid but it always shows the I cursor. Because the grid is there for the user to select a record they want to edit, it makes no sense to me that this should be an I. Also I would like to change the cursor for the grid header but that too does not have a property for the mouse pointer. Is there another simple way to change the cursor? -- Altman VFP8 SP1 Tag: program after program Tag: 203747
  - 2
    - Multi-thread Can anyone explain me how to convert from .EXE to a multithread option. What are pre-requisites for the same. Tag: program after program Tag: 203738
  - 3
    - Import from ... gives an error (Excel format) VFP 8.0 I try this command import from "C:\test\Articles_vyncb2-3-4.xls" type xl8 on the Excel file included in this archive http://adsl.ineo.be/Articles_vyncb2-3-4.zip I get the following error message : "Microsoft Excel file format is invalid". When i open this file in Excel, it appears correctly without any error message. What could be done ? Thanks in advance for your help, Kind regards, Guy Tag: program after program Tag: 203736
  - 4
    - Resolving relative filenames from project Hello, is there an easy way I can resolve the relative filenames in a project table to the full path so I can list all the source files and their full path in a project? eg: I have a project: "j:\dev\costing\kmcost.pjx" In that table, the first record has a name field of "j:\dev\costing\kmcost.pjx". There are also a bunch of source files with names such as "..\\common\c_det3.prg" Is there an easy way to resolve that to "j:\dev\common\c_det3.prg" or do I have to parse the ".." stuff myself? -- TIA Andrew Howell Tag: program after program Tag: 203732
  - 5
    - How to remove trailing blank lines (CR/LF) from memo field Does anyone know how to programatically remove blank lines from the end of a memo field? Sometimes my users will hit return in a memo field after the end of the data and this causes blank lines on reports. I have tried several suggestions found on Google groups archive but no success. Tried all the trim(s) and no luck Thanks in advance. Brian Hiatt Collectorpro Software Group, Inc. www.collectorpro.com Tag: program after program Tag: 203722
  - 6
    - Discussions forword mail hi sir. how can i receive all these Discussions to my email homoss1978@hotmail.com thanks mohamed Tag: program after program Tag: 203718
  - 7
    - landscape mode I'm using VFP6 SP5, windows all, local and network computers I need print using @..,.. say commands at landscape mode How could I set it programmatically ?? Alkots Tag: program after program Tag: 203712
  - 8
    - reports at run time Dear sirs I'm trying to create reprts at run time, i'm using the following command CREATE REPORT myReport FROM table1 but actually i want to change the labels of the fields which appear in the report i don't know how can i do that??? thanks Mohammed Tag: program after program Tag: 203711
  - 9
    - VFP8 Transparent GIFs not displaying transparent! Some of our images on button controls which display fine in VFP7, display with a white background in VFP8. I've used photoshop to make sure the GIFs are transparent and in Windows Explorer they look absolutely fine. I'm not using any Windows XP themes. The images that look ok are all old VFP bitmaps but according to Photoshop bmps can't be transparent??? Can anyone suggest any possible solutions? Thanks for any help, Bernie Tag: program after program Tag: 203702
  - 10
    - hyperlink Hi, I'd like to use the hyperlink property in textboxes for email addresses in our software. However for this to work the user has to type "mailto:" before the address. Is there away to avoid, so the hyperlink works when the user just types the mail address ?? thanks in advance. Xavier, CPS Tag: program after program Tag: 203699
  - 11
    - Multiselect Listbox woes I am again kicking myself for trying to use a multiselect listbox due to it's unreliable behavior. Here's my latest discovery: When the user selects, say 4 or 5 items in the list box using Ctrl+Click, then tabs to another control or clicks on another control, then tabs back to the listbox, all of the previously selected items are cleared. Huh!? How could this possibly be the desired behavior of this control? This happens in both VFP6 SP5 and VFP8 SP1. Haven't tried it in the VFP9 beta yet. Is the only way around this loss of user input to keep a separate array of the selected items, then when the control gets focus to re-select them? Then of course you have the hassle of the difference between tabbing to the list and clicking on the list... ugh. -- TRW _______________________________________ My e-mail: t r w 7 @ i x . n e t c o m . c o m _______________________________________ Tag: program after program Tag: 203685
  - 12
    - Web based Inventory/Tool/Equipment.... a company asked me about a web-based Inventory/Equipment/Tool Crib application that can handle three equipment issuing centers where a customer job can have equipment sent from any of the three locations. Know of a place to start? Tag: program after program Tag: 203675
  - 13
    - VFP 6: Cut/Copy of Output I wrote a small test program which outputs to _screen. I decided that I would like to copy this to a file. Unfortunately, I can not cut/copy this text. If I send the output to a form, I can not cut/copy from there either. For this case, I can simply set alternate or I can output to a editbox, but I would like a more general solution to this problem. I have had this general problem in the past with other output. One example of this is the text on a message box for which neither the alternate nor editbox approaches apply. Yes, I can cut/copy as graphics, but is there a way to capture screen/form output text AS TEXT? I am not concerned if I lose graphics content: I simply want the text. Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: program after program Tag: 203674
  - 14
    - SQL - APPEND How do I append using a odbc connection to a IBM iSeries database from a foxpro table/cursor. Aron Tag: program after program Tag: 203671
  - 15
    - Intellisense with azerty I found a topic about this subject in a newssearch, but there was no solution. Now i have the same problem. I use foxpro 2 weeks now. I got an azerty keyboard. Intellisense pops up by using: -capslock and the . key (. is the uppercase char of the key in azerty) -the . key of the numpad Intellisense DOESN'T popup when i use: -SHIFT and the . key (remember it's the uppercase char i need) I tried using numeral key remappers and macro players, but they don't seem to have a solution for me to use the shift-. combo VFP is the only development environment I have had this problem with. Anyone know of a solution for this problem ? There must be more azerty Fox users. Tag: program after program Tag: 203669
  - 16
    - PageFrame Bug When you add a pageframe without tabs to a container class ... Height is allowed to be less than 30, but when the class is saved and then reopened, you will get an error saying that the height is too small. You must then hack the VCX and correct the height in order to open the class in the designer. First, this is a bug. The height should not be checked when tabs are off. Second, I really hate it when I get an error like this, and then that's it. VFP doesn't try to open the VCX. It leaves you hanging, with no choice but to hack the changes. Why doesn't VFP just open the file? Just my two cents. Michael Wheat Tag: program after program Tag: 203666
  - 17
    - fatal error while building project Hi Friends I'm trying to build project and getting fatal error(C5) error and closes foxpro the error is. **** Fatal error: Exception code=C0000005 @ 30/11/2004 04:46:12 PM. Error log file: C:\Program Files\microsoft visual foxpro 8\vfp8err.log Called from - build line 191 {e:\vssshadow806\jab\develop\build.prg e:\vssshadow806\jab\develop\build.fxp} Called from - vbuild line 100 {e:\vssshadow806\vip\develop\vbuild.prg e:\vssshadow806\vip\develop\vbuild.fxp} ***** actual line of code that causing the error is BUILD PROJECT (lcProjName) &lcCompile FROM (FULLPATH ('main.prg')) when i opened .err file i see compiling e:\vssshadow806\vip\tx\tx.mpr I thought there's problem in the menu so i opened it manually and did generate menu which was fine. I tried rebuild again but same error.so this time i excluded menu from project and now .err file contains something like compiling e:\vssshadow806\vip\console\getwaiting.prg I even excluded that prg from project but getting different file name in .err file. so i realized the error in .err file is misleading. is there anyway to trace what causing the fatal error !! I tried deleting foxuser files and even rebooting the machine to no avail. Thanks for ur help -- cheers Tag: program after program Tag: 203664
  - 18
    - remote views vs spt I've been trying unsuccessfully to create a SQL Server remote view on a query like this (simplified): SELECT events.timeslot, events.leader1, SUM(IIF(attendance.paymethod = 'CASH' AND NOT attendance.reversed, attendance.amount, $0) AS cashrec FROM events LEFT OUTER JOIN attendance ON events.eventid = attendance.eventid WHERE events.startdt >= ?startDate AND events.startdt <= ?endDate GROUP BY events.leader1, events.timeslot This gets SQL error messages. I've tried using T-SQL too, like this: SUM(CASE WHEN attendance.paymethod = 'CASH' AND attendance.reversed = 0 THEN attendance.amount ELSE $0.00 END) AS cashrec ... but this gets VFP error messages. Is it possible to make a remote view like this or should I give up and use SPT? Tag: program after program Tag: 203661
  - 19
    - OT: Wizards 5 points for the first person who can remember the first Microsoft program to use "wizards". -- Regards Darren Woodford - MCP, MCSE Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk http://www.accountancy-software.co.uk/pegasus-opera-ii/pegasus-opera-ii.php Tag: program after program Tag: 203651
  - 20
    - Help debugging FP COM Server... Hi, I've have a FoxPro (FP) project that generates a COM Server which I can build/compile with debug information and register (using /regserver). Now I would like to startup another executable (in my case a C++ program which uses the FP COM Server type library) which calls routines in the FP code. I know how to set a breakpoint in FP, but how do I start the other executable in such a way that FP (debugger) breaks when reaching the breakpoint? I thanks in advance for all replies. /Michael PS. Any possible tricks involving Visual Studio for this kind of debugging? Tag: program after program Tag: 203650
  - 21
    - weird objtoclient() Hi (again) (It's seems that I'm getting all the weird stuff this week...) I have a textbox which in the keypress (Shift+F5) event I call a class.method to translate it's value. When the word to translate isn't possible (unknown word,misspelled...) another "translateform" with a grid is shown with other possible words and the possibility to add / alter the word or cancel it. So far so good and everythings works fine. Except I want it just underneath the textbox with the "problem" word. In the init of the "translateform" I place this so the "translateform" is placed right underneath the word this.Left = lcallform.left + OBJTOCLIENT(lcallobject,2) + (lcallobject.selstart * FONTMETRIC(6 , "arial", 8)) +5 this.top = lcallform.top + OBJTOCLIENT(lcallobject,1) + lcallobject.height + 32 when the first unknown word in the textbox is found and the "translateform" is shown everything is ok. In the same translatingloop of the keypress when there is another unknown word then ObjToClient() (Top and Left) returns suddenly BOTH Exactly 4000 !? All the other values lcallform and lcallobject are correct it returns the right objectreference and left and right and so on. And I never ever have any form that is that wide ? (sometimes I wish I could have ...) to check where the problem is I've place this in the translateform.init. So i know exactly that only objtoclient() is given me "weird" results. MessageBox(lcallform.name+CHR(13)+"left "+TRANSFORM(lcallform.left)+CHR(13)+" top "+TRANSFORM(lcallform.top)+; lobject.name+CHR(13)+"left "+TRANSFORM(lobject.left)+CHR(13)+" top "+TRANSFORM(lobject.top)+CHR(13)+; "objtoclient "+CHR(13)+"left "+TRANSFORM(OBJTOCLIENT(lobject,2))+CHR(13)+" top "+TRANSFORM(OBJTOCLIENT(lobject,1))+CHR(13)+; "this "+CHR(13)+"left "+TRANSFORM(this.left)+CHR(13)+" top "+TRANSFORM(this.top) ) Anybody an idea or maybe a workaround ? regards christophe In case you want to have a look at the translating code (it's more a replacing code) here it goes : Lparameters naartaal,origfield Local origtext, newtext,totwoord,curwoord,origfielda,lijstmeer,lijstmeerstd If .Not. Empty(This.Value) oldseltaal = Alias() ok=chkopen(f_vertaal,"translate") Do Case Case naartaal="NL" taal_="woord1" skip_="skip1" Case naartaal="EN" taal_="woord2" skip_="skip2" Case naartaal="DU" taal_="woord3" skip_="skip3" Case naartaal="FR" taal_="woord4" skip_="skip4" Otherwise taal_="woord2" skip_="skip2" Endcase ncurlet = 0 curwoord = "" skipwoord = .F. nieuwwoord = .F. origtext = Upper(Alltrim(This.Value))+" " lenorigtext = Len(origtext) origfielda = Substr(origfield,1,At(".",origfield,1)-1) *loop through the sence to translate each individual word Do While ncurlet <= lenorigtext ncurlet = ncurlet + 1 curlet = Substr(origtext,ncurlet,1) Do Case Case Isdigit(curlet) *when there is a digit in the word => no translation skipwoord = .T. Case Isalpha(curlet) .Or. curlet $ "-'" *" ' "and " - " is can be handled in 1 word curwoord = curwoord + curlet Otherwise *all other signs take this as the end of a word and start a new word nieuwwoord = .T. Endcase If nieuwwoord If .Not. skipwoord .And. .Not. Empty(curwoord) .And. Len(curwoord) > 1 newwoord = "" *lookup the dictionary table "translate" If Seek(curwoord,"translate","woord1") If translate.skip1 *no translation neccesary in any language skipwoord = .T. Else *no translation possible in a language skipwoord = translate.&skip_ Endif Endif If .Not. skipwoord newwoord = Upper(Alltrim(translate.&taal_)) lencurwoord = Len(curwoord) If Empty(newwoord) *no translation found *ask what to do This.SelStart = ncurlet - lencurwoord -1 &&begin pos lijstmeer = "Add Woord;Other Word;Skip Word;" *mymessagebox("WHEN FIRST TIME = OK, SECOND TIME ?!? Objecttoclient returns 4000") Do Form vertaalmeer Name "vertaalmeer" With This,Thisform,lijstmeer,curwoord,taal_ To newwoord Release vertaalmeer newwoord = Upper(Alltrim(newwoord)) Else *check if more possiblities nlijstmeer = 0 lijstmeer="" Do While curwoord = translate.woord1 clijstwoord = Upper(Alltrim(translate.&taal_)) If .Not. Empty(clijstwoord) nlijstmeer = nlijstmeer + 1 lijstmeer = lijstmeer + clijstwoord + ";" Endif Skip In "translate" Enddo If nlijstmeer > 1 *more translations possibilities found This.SelStart = ncurlet - lencurwoord -1 &&begin pos lijstmeer = lijstmeer + "Add Woord;Other Word;Skip Word;" *mymessagebox("WHEN FIRST TIME = OK, SECOND TIME ?!? Objecttoclient returns 4000") Do Form vertaalmeer Name "vertaalmeer" With This,Thisform,lijstmeer,curwoord,taal_ To newwoord Release vertaalmeer newwoord = Upper(Alltrim(newwoord)) Endif Endif *replace word with translation If .Not. Empty(newwoord) *alter cur pos with length newword If .Not. Empty(origfield) *textbox is in grid Replace &origfield With Stuff(Evaluate(origfield),ncurlet-lencurwoord,lencurwoord,newwoord) In &origfielda origtext = Upper(Alltrim(Evaluate(origfield)))+" " Thisform.gridpapyrus.Refresh Else *textbox is on a form This.Value = Stuff(Evaluate(origfield),ncurlet-lencurwoord,lencurwoord,newwoord) origtext = Upper(Alltrim(This.Value)) + " " Endif ncurlet = ncurlet - lencurwoord + Len(newwoord) lenorigtext = Len(origtext) Endif Endif &&not skipwoord Endif &&.not. skipwoord .and. .not. EMPTY(curwoord) .and. LEN(curwoord)>1 skipwoord = .F. nieuwwoord = .F. curwoord = "" newwoord = "" lencurwoord = 0 Endif &&nieuwwoord Enddo &&ncurlet <= LENorigtext Select &oldseltaal Endif Tag: program after program Tag: 203648
  - 22
    - Microsoft Web browser control I have added a Microsoft Web Browser control to a form. Whenever I open the form I get 0x80004005 unspecified error although the control still naviagates to the page required. Does anyone know why? I am using vfp8 sp1 Thanks in advance Dave Tag: program after program Tag: 203643
  - 23
    - Designing a system In my college days I learnt DBIV and Pascal. We were taught in those days to design in the following way: 1. JSP Diagrams. 2. Pseudo Code 3. Real Code. In our new OOP world JSP Diagrams don't seem to work. Instead I increasingly find myself just coding right off. I am sure there is a better methodology. What are you doing? How does UML fit in to all this? How do you define the flow of your application and the relationships between classes. Do you use a software design tool such as Rose or Visio? I used to use a progam called EasyCASE but I don't even know if it is still around. -- Regards Darren Woodford - MCP, MCSE Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk http://www.accountancy-software.co.uk/pegasus-opera-ii/pegasus-opera-ii.php Tag: program after program Tag: 203642
  - 24
    - CREATE SQL VIEW problem I have the following short VFP8 program: one_cust = '1234' CREATE SQL VIEW cust_view Remote CONNECTION AS400 AS ; SELECT cust_code,cust_name; FROM customer; WHERE cust_code =one_cust /Memo: customer is an IBM AS400 file/ If I run this program I get an error message: "ONE_CUST" is not part of the table. If I use a constans /....WHERE cust_code = '1234' the program works well. My question is : Is it possible to use a variable or not? Where did I make a mistake? Another question: How can I create a LOGICAL calculated field in this SELECT command? Could anyone help me? Thanks in advance. -- Sandor Tag: program after program Tag: 203619
  - 25
    - Accessing the menu (under the icon at the left) off a form Hi Is it possible to add options to the menu that appears when clicking the form's icon at the left of the form bar, under VFP 6? This menu (usually) contains only: Restore Move Minimize -------- Close Thanks, Demetrios, Greece Tag: program after program Tag: 203617

J have a myBAT.BAT file like this:
prog1.exe
prog2.exe
prog3.exe

Prog1.exe, prog2.exe, prog3.exe are written and compiled by FoxPro 3.0 or
6.0.
Problem:
after Start\run myBAT.BAT prog2.exe starts before prog1.exe ends.
Prog2.exe have to wait until prog1 ends.
How can I achieve this?

Sorry for my poor English

Miroslaw

Re: program after program by Scott

Scott
Fri Dec 03 14:58:50 CST 2004

@call prog1.exe
@call prog2.exe
@call prog3.exe

or write a small Fox app to say
Do prog1
do prog2
do prog3

Scott

"M Stepien" <MStepien@discussions.microsoft.com> wrote in message
news:096A3196-8D9F-49CC-8DDD-8CEA5D312176@microsoft.com...
>J have a myBAT.BAT file like this:
> prog1.exe
> prog2.exe
> prog3.exe
>
> Prog1.exe, prog2.exe, prog3.exe are written and compiled by FoxPro 3.0 or
> 6.0.
> Problem:
> after Start\run myBAT.BAT prog2.exe starts before prog1.exe ends.
> Prog2.exe have to wait until prog1 ends.
> How can I achieve this?
>
> Sorry for my poor English
>
> Miroslaw
>

Re: program after program by Davide

Davide
Fri Dec 03 16:52:16 CST 2004

Miroslaw,

> after Start\run myBAT.BAT prog2.exe starts before prog1.exe ends.

try:
START /WAIT Prog1.exe
START /WAIT Prog2.exe

Kind regards
Davide Guolo
--------------------------------------------------------------
Printfil - Windows Printing System for Applications
http://www.guolo.com/printfil
Odbc4All - Connection to ODBC Data Sources for any Application
http://www.guolo.com/odbc4all
--------------------------------------------------------------

" <MStepien@discussions.microsoft.com> ha scritto nel messaggio
news:096A3196-8D9F-49CC-8DDD-8CEA5D312176@microsoft.com...
> J have a myBAT.BAT file like this:
> prog1.exe
> prog2.exe
> prog3.exe
>
> Prog1.exe, prog2.exe, prog3.exe are written and compiled by FoxPro 3.0 or
> 6.0.
> Problem:
> after Start\run myBAT.BAT prog2.exe starts before prog1.exe ends.
> Prog2.exe have to wait until prog1 ends.
> How can I achieve this?
>
> Sorry for my poor English
>
> Miroslaw
>