vfp9 code page

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
    - Scrolling in a Grid Hi, Is there a way to check if the Record Pointer in a Grid is not anymore visible when a user scrolls the Grid? What I want to do is when the user scrolls and the record pointer is not visible, I will set the record pointer to the record on the top row that is visible. Thanks. Tag: vfp9 code page Tag: 231550
  - 2
    - Minimize window outside application For maintenance purposes, I find it very convenient to start a vfp9 application from a batch file. Is there a way for vfp to know how it was started and to then find and minimize the command window? Thanks Tag: vfp9 code page Tag: 231545
  - 3
    - SET variable for VFP 6 and 9 How can I point my VFP 6 and 9 to different CONFIG files? Right now, we use SET foxprocfg for the DOS version and SET foxprowcfg for VFP 6/9. TIA. -S- Tag: vfp9 code page Tag: 231542
  - 4
    - External array not working - VFP 9 sp2 I have a program system with a main program that calls lots of forms. In the main program I define an array gaAccess as public In some of the forms I reference the array in the refresh method of some of the buttons. external array gaAccess this.enabled = gaAccess[2] != 'R' I have also put the external array command in the load event. when I build the project I am still getting the undefined error and would like to clean them up. What am I doing wrong???? czeb Tag: vfp9 code page Tag: 231540
  - 5
    - Sys(1037) and GetPrinter() Hi, Since changing to Vista we have a problem saving the printerenvironment. The sys(1037,1) button doesn't have the "printer" button anymore, so you need to call the Getprinter() first. I changed my code like this : use myreport.frx sys(1037,2) && Restore old printer info lcPrinterOld = SET("PRINTER",2) lcPrinter = Getprinter() if NOT lcPrinter = lcPrinterOld SET PRINTER TO NAME (lcPrinter) SYS(1037) && Call the page setup SYS(1037,3) && Save current printer settings endif When I try this, it just restores my report settings to the default settings. Also the helppage on this subject is very confusing. Thanks for any help Greetings Xavier Tag: vfp9 code page Tag: 231534
  - 6
    - Can This Grid Behavior Be Altered? Hello and thanks in advance for the help. Suppose you have a grid that is based on a cursor. Lets say that 10 rows are visible on the screen. Lets also say that there are 30 records in the cursor that is being "browsed" by this grid. If you use the down arrow on the scroll bar to scroll through the cursor, it will keep scrolling until the last record of the cursor is in row 1 of the grid. The behavior that I would prefer is that it stop scrolling when the last record is fully visible in the grid (row 10 in this example). Is there any way to make this behavior happen? Thanks, Jeff Tag: vfp9 code page Tag: 231532
  - 7
    - PETITION asking to Microsoft to continue with the Visual FoxPro development This page is opened by an idea from the Visual FoxPro Spanish community, this page is opened for doing a campaign asking to Microsoft to continue with the Visual FoxPro development, release the full source code as Open Source or make an agreement with a 3rd party for continued development of future versions of VFP. MasFoxPro campaign: http://www.masfoxpro.com Martin Brtna Tag: vfp9 code page Tag: 231529
  - 8
    - Distorted Image Hi, Im trying to display Employee Pics in a Form from a general field in a table. form.stretch = Isometric. Picture is distorted. What is the best way to display a Picture from a General field? Thanks, Herbert Tag: vfp9 code page Tag: 231527
  - 9
    - Space bet Detail Band & Page Footer Hi, Recently upgraded to VFP9 and my reports from VFP8 suddenly have a space between the Detail Band & the Page Footer. Is there something I need to change in my report. I have tried set Report Behavior to 80 & 90 but it has the same result. Thanks, Herbert Tag: vfp9 code page Tag: 231526
  - 10
    - VFP 9 project question I have a vfp system where the source is in two folders. Dev folder for forms, prgs, frx, etc. Plus a sub folder containing all graphics, bmp, jpg, gif, ico, etc. The graphics are mainly used on forms and buttons on forms. I have added a createobject routine that creates a form from a prg. this form contains a graphic that is not used anywhere else. I manually added the graphic file to the project in the other files section. It is not marked as excluded When I build the project no errors are encountered but when I run the exe from the production location the graphic cannot be found. I tried placing a reference to the graphic into the main program within an if statement that is never true but this didn't help either. If I copy the graphic to the production folder to the same relative folder location as development it is found. Why isn't this found. Anyone with experience in getting this to work correctly??? Czeb Tag: vfp9 code page Tag: 231518
  - 11
    - how to get the no of month of a given date range Dear friends How to get a no of months & years of a given date range e.g. dldate=date(2000,05,25) now if i substract the dldate from current date ie. x=date()-dldate it will give result no of days but i want no of months in a single statement. if any function is available in VFP6 or any other way to get it. Thanks -- sanjib Tag: vfp9 code page Tag: 231507
  - 12
    - [fw] Display the tree shown by Class Browser http://fox.wikis.com/wc.dll?Wiki~ClassBrowserTree~VFP Next step is to scan the forms .... -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: vfp9 code page Tag: 231504
  - 13
    - Oracle ODBC driver from Microsoft vs Oracle Hi, I have some applications written in VFP9 accessing Oracle databases thru ODBC, for some unknown reason, I always install the ODBC driver provided by Oracle, but it seems to be more heavy and time consumming to install it, so I wonder how would it be to use the ODBC driver provided by microsoft that is already installed on any PC, has somebody onthe forum used the microsoft driver? I would appreciate any advice or info about comparision and reliability of both ODBC drivers thanks Oscar Taboada Tag: vfp9 code page Tag: 231502
  - 14
    - VFP 9: Compiling in a VFP .exe The build procedure for my app has gotten a bit more complicated, so I want to automate it. How do I get build project and build exe to execute in a VFP .exe called from the command line? I got a feature not available message when I tried. There is a full VFP system on the computer I used. I am trying to get both the build and zip done in a batch file. Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: vfp9 code page Tag: 231500
  - 15
    - Any last requests? I could work with VFP for a while more if only I could read and write = UTF-8 in Sql Server without double byte translations leading to ??? = (unless somebody knows how to do this with the current VFP) What are other requests that people would still have? Robert Tag: vfp9 code page Tag: 231490
  - 16
    - Making a calling form invisible I have developed an Output class to handle reporting, exporting etc. This is called from scores of forms with a few parameters. After it has all been designed I have decided that I would like to make invisible whatever form calls the Output form. I can do this by: thisform.visible = .F. DO FORM <outputform> thisform.visible = .T. but I would like to avoid having to edit so many forms. Is there a way I can achieve this from the Output class without having to edit all these calling forms. I am NOT passing the calling form as an object parameter to the class. I wish now that I was! Thanks Stephen Tag: vfp9 code page Tag: 231475
  - 17
    - What's in the 71st byte of FXP files? We're using an utility who checks differences between FXP from different releases of a VFP software, and it uses a simple file compare logic. We cannot base that on "data and time modified" because these are unreliable, expecially after another utility recompiles all of the files. This morning we started noticing that the comparison found differences in all of the FXP even if we modified only a few, and the reason is that the 71st byte is always different from the past releases. It looks like something has changed in the output of the "compile xxx nodebug" command, starting from yesterday or today. Has anyone else had an issue as this? What could have triggered this situation? And, BTW, who knows where I can find info on the FXP file structure, of about the 71st byte of FXP's? -- Microsoft News Tag: vfp9 code page Tag: 231474
  - 18
    - Combine aggregate records from a UNION? Say I have 2 tables of invoices, one containing 2006 invoices and the other 2007. In a single SQL statement, I want to sum up the invoice amounts, grouped by customer number: SELECT CustNo, SUM(Amount) AS InvTotal FROM Inv2006 GROUP BY CustNo UNION ALL SELECT CustNo, SUM(Amount) AS InvTotal FROM Inv2007 GROUP BY CustNo INTO CURSOR Tmp ORDER BY CustNo If a given CustNo exists in both Inv2006 and Inv2007, the UNION will produce 2 records for this CustNo: one with the total amount for 2006 - the other the total for 2007. How can I modify my SQL statement to consolidate the results of the UNION so that I only end up with ONE record for the CustNo - with InvTotal equal to the total customer spent in 2006 plus 2007? Many thanks! -Mike Tag: vfp9 code page Tag: 231461
  - 19
    - missing subreport? ireponame = 'REPT_360.rpt' isubreponame = 'subtotal' SetCrRpt(thisform.olecontrol1) with Thisform.olecontrol1 .reportfilename = ireponame .datafiles(0) = fnd .connect = 'DSN=TEMP' .subreporttochange = isubreponame .datafiles(0) = fnd .connect = 'DSN=TEMP' .subreporttochange = '' .destination = outputtype .printreport() endwith I found that there is no "subreport.rpt", only a "rept_360.rpt". Is this sub-report a fake? -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: vfp9 code page Tag: 231459
  - 20
    - Tableupdate failure-index does not match..... I have a parameterized view. I put a few records in it. I update the records. I issue tableupdate. If I don't update the first record in the view, the tableupdate fails, and aerror() shows me Index does not match the table..., error 114. I know for a fact that there is nothing wrong with the index, and this only happens if I don't enter a value in the first record. I've seen this before, but don't remember where or when. Anyone recognize this issue? Tag: vfp9 code page Tag: 231456
  - 21
    - Customzied papersize setting Hi all, I have defined a new label size for printing labels using barcode printer. It works fine in my pc when running my foxpro program. However, when it is printed from the others pc, the label size gets the other size although new label size is already set. I have tested many times by setting the default printer which refered to the new label size. It still failed. Finally, I discovered that it's the problem of papersize. My PC papersize for the new label is 134 and it works in my pc but not on the others. However, I have set the papersize to 154 and it doesn't work on my pc, but it works on one of my colleagues pc. Is there any default papersize setting that refer to customized size on window XP ? Thanks a lot! -- sze Tag: vfp9 code page Tag: 231455
  - 22
    - Disable Menu Items Hi, How do I disable Menu Items (Using Define Menu) when I preview a report? Thanks, Herbert Tag: vfp9 code page Tag: 231453
  - 23
    - How to get the form object ? Dear All, How to get the "Form Name or Form Object" in object "ytxt" ? e.g. ytxt = thisform.pgf1.page1.pgf2.page3.txtbox Thanks ! Tag: vfp9 code page Tag: 231441
  - 24
    - test -- Thanks ! Tag: vfp9 code page Tag: 231440
  - 25
    - Import UTF-8 text from Excel Is it possible to import or read texts from an Excel file that include = UTF-8 texts? Robert Tag: vfp9 code page Tag: 231435
- Next
  - 1
    - Intermittent Error 12 - Variable Not Found I have a situation where I am intermittently getting Error 12's trapped to my application (VFP7 based). The code path is something like the following: In my form: snparptr = 0 =gnssadd(,,,,) In gnssadd the following code is executed: =gnaddrec() REPLACE fddate WITH DATE(), ; fcsnaptime WITH TIME(), ; fnparent WITH snparptr, ; fccancel WITH vccancel, ; fctable WITH lctable, ; fcaction WITH vcaction, ; fnrecno WITH lnrecno, ; fcprompt WITH vcprompt SAVE TO MEMO fmdata ALL LIKE f* The gnaddrec either adds a new record to a table or reuses a deleted record. The error 12 error nominates the snparptr as the variable that is not found I cannot see a code path were the snparptr variable is disposed of. The problem is very intermittent and in most cases once the error has been received you can re-enter the program and execute the same function and have it work fine. Is there some resource that is being depleted that is causing this error? or any suggestions of another cause? thanks pete Tag: vfp9 code page Tag: 231428
  - 2
    - eReports on vfp6 untracable error Using DBX tech eReports, we have a report to pdf conversion that works fine in the IDE and locally compiled but returns a code 124 on a clients system running under terminal services. the oReports.ErrorLog seems not to be returning a string any help to resolve this would be appreciated John Tag: vfp9 code page Tag: 231426
  - 3
    - do work intellisense , form , with , endWith This is a multi-part message in MIME format. ------=_NextPart_000_00B0_01C76FB5.AC335F00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all i would like to have intellisense for my form, With the operator With = EndWith i would like to have my custom Method or Custom Property. With ThisForm as Form of G_RUE.SCX EndWith it's doesn't work , have you an idea ? thank's=20 Olivier ------=_NextPart_000_00B0_01C76FB5.AC335F00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.3059" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><STRONG><FONT face=3DArial color=3D#000080 size=3D2>Hi = all</FONT></STRONG></DIV> <DIV><STRONG><FONT face=3DArial color=3D#000080 = size=3D2></FONT></STRONG> </DIV> <DIV><STRONG><FONT face=3DArial color=3D#000080 size=3D2>i would like to = have=20 intellisense for my form, With the operator With = EndWith</FONT></STRONG></DIV> <DIV><STRONG><FONT face=3DArial color=3D#000080 size=3D2>i would like to = have my=20 custom Method or Custom Property.</FONT></STRONG></DIV> <DIV> <DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2><BR>With = ThisForm as Form of=20 </FONT><FONT face=3D"Courier New" size=3D2>G_RUE.SCX</FONT></DIV> <DIV> <P><FONT face=3D"Courier New" size=3D2>EndWith</FONT></P> <P><FONT face=3D"Courier New" size=3D2><STRONG><FONT face=3DArial = color=3D#000080>it's=20 doesn't work , have you an idea ?<BR><BR>thank's=20 <BR></FONT></STRONG></FONT><STRONG><FONT face=3DArial color=3D#000080=20 size=3D2>Olivier</FONT><FONT=20 face=3D"Courier New"></P></FONT></STRONG></DIV></DIV></BODY></HTML> ------=_NextPart_000_00B0_01C76FB5.AC335F00-- Tag: vfp9 code page Tag: 231416
  - 4
    - vfp9 speed issue group, our app has several screens with hundreds of objects. They open instantaneously in vfp6 but they take over 10 seconds in vfp9, making 9 totally useless for us. Has anyone come across this type of behavior? We use vfp9sp1. Wade Tag: vfp9 code page Tag: 231410
  - 5
    - Active Directory User name and Password How can I read the user name and password from Active Directory? in other words how can I authenticate a user through Active Directory? Thanks HME Tag: vfp9 code page Tag: 231406
  - 6
    - print dbf file How do i print dbf file Tag: vfp9 code page Tag: 231382
  - 7
    - Which Tags Are Used? Hello and thanks for the help. Is there any data in the CDX file that would indicate that last time an index tag was used? I have a table with a lot of tags some of which I sure are never used. I can search the code but that doesn't tell me which ones might have been created to speed up an SQL query. Is there any index tag usage data available? Thanks, Jeff Tag: vfp9 code page Tag: 231367
  - 8
    - Fox Programmer .... Need Jobs Sir, My name is Tommy from Thailand. With my Visual FoxPro experience more than 6 years. I need more jobs. Who have jobs for me, feel free to contact me anytime Thanks Tag: vfp9 code page Tag: 231366
  - 9
    - Check to see if SQL table has been updated by another user Hi... What's the quickest and simplest way to check if a row has been changed (by another user) on a remote SQL table? Obviously TABLEUPDATE returns .F. if it encounters and error but it would be better to 'test' the condition before even attempting to perform the update. Any help would be much appreciated. Tag: vfp9 code page Tag: 231364
  - 10
    - buffering select 0 use tablea shared select tablea cursorsetprop("buffering",4) set filter to type="A" select use tablea again shared alias tableb set filter to type="B" * 1. is the following necessary? select tableb cursorsetprop("buffering",4) ... ... show form to edit these values ... ... * 2. if I tableupdate() tablea, * will tableb be tableupdated() as well? 3. Any other things I need to remember? -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: vfp9 code page Tag: 231355
  - 11
    - help, cash denomination.... hi experts, anybody can give me some example that of cash denomination, like for example, the given is 1525.75 and the output would be.... 1000 - 1 500 - 1 100 - 0 50 - 1 20 - 1 5 - 1 .50 - 1 .25 - 1 thanks in advance.... Tag: vfp9 code page Tag: 231353
  - 12
    - Vista and Elevation Hello all! I have been working for 2 days trying to figure out how to change my application (written in VFP9) to work with Vista. The first objective is writting to the registry. The way our application works... the first time you launch it, it asks for a Code. The user enters this code and the program saves it to the registry under HKEY_LOCAL_MACHINE. This works great under XP. This way if they change users or they are running terminal server, they all find this entry in the same location. In order to write to the HKEY_LOCAL_MACHINE on Vista, you must be elevated to Administrative level. I have read several articles on how to achieve this, but the common belief is to create a separate program that can be run from your main program. This new "separate" program should be setup to require administrative rights using a manifest file. Now the trick I needed to pull off was to be able to call this program and wait for it to close. I tried a few solutions... but the one that seemed to work best for me was to create a third program. This third program will be a COM Object accessable by Foxpro, with the sole purpose of running the "separate" program mentioned above and wait for it to close. I call the COM Object from VFP and it stops the VFP programs execution until the separate program is closed. Perfect! It seems like I found the answer.. but because I knew it had to be too good to be true I decided to test a little. I created two shortcuts on my Vista desktop. Both shortcuts run Foxpro 9, but one is flagged as "Run as Administrator" and labeled "Admin". The other shortcut runs as Standard User is titled "Standard". When I run the Standard VFP shortcut and execute the Com Object, everything is perfect. Life if great! Now I tried to run the VFP shortcut "Admin" and access the COM Object. Here is where the problem is..... Class definition x.y is not found Help! I don't know what to do next. When I run the "Admin" shortcut, Vista prompts be to "Allow / Cancel". It is elevating my instance of VFP to Admin level. But when I attempt to execute the COM Object it cannot find the class definition. Any ideas on how to get around this "little" problem? How is everyone else handling this? Thanks Dan Tallent Tag: vfp9 code page Tag: 231330
  - 13
    - Gefile on terminal server Hi, a client reports following situation with our Application (built on VFP9SP1): Every dialogue, where we use the putfile or the getfile function, does not appear. They had to delete the local profiles of the user on the server, because there were problems in the encryption module, and after that, the getfile() - function does not show the input form. the command is totally ignored... How can I make the dialogue appear? Thank you! Bastien Tag: vfp9 code page Tag: 231316
  - 14
    - Winsock and ip address changes Hi and thanks in advance for the help. This isn't strictly a Fox question but since I develop in Fox I thought I'd see if any of you have any ideas about this. I use the MS WinSock control. One of the properties is LocalIP which should be your machine's IP address. It is set by the control and not changeable in code. My application stopped working and I was looking at the LocalIP property. It said 0.1.4.0 instead of 192.168.0.33 which is my correct ip address (fixed, no dhcp involved) Once I rebooted, the LocalIP went back to 192.168.0.33 I'm curious as to how it got changed. Did I have some poorly behaved software? Did my machine need a re-boot and the funny IP Address was a symptom? Is something more evil going on? If anybody knows anything about this please tell me. Thanks, Jeff Tag: vfp9 code page Tag: 231310
  - 15
    - Upgrade from VFP 6 to 9 - RUN command fails I have the RUN command in a long-standing app that I am now running under VFP 9 for the first time, but even from the command window, a simple RUN cmd or RUN command both fail. I'd appreciate suggestions on what to look into next. The RUN command is an integral part of this application and we need it to work. If I do a DIR <batchfilename> from within VFP 9, the file is there, and I can edit it from a cmd window (which I just did) and save my changes, and I also just ran it from a cmd window, but this is a cmd window opened by the operating system (me clicking on the shortcut on my desktop labeled "dos box") and not from within VFP 9. Thanks in advance. -S- Tag: vfp9 code page Tag: 231308
  - 16
    - Problem with VFP9 report In group footer we have: in 1st line - field object with Fix relative to top option in 2nd line - field object attached to memo field in table with Fix relative to top and Stretch with overflow options in 3rd line - field object with Float option in 4th line - field object with Float option If memo field has up to 20 lines everything is ok, but if memo filed is longer than 20 lines footer continues on next page but it does not print 3rd and 4th line. Thanks in advance Tag: vfp9 code page Tag: 231298
  - 17
    - FoxPro with MySQL how to use Foxpro to access MySQL database ? some sample will be good. thanks! Tag: vfp9 code page Tag: 231297
  - 18
    - List of all Foxpro base properties? I am trying to write a program to document the custom classes I made. How could I obtain a full list of base property names of all base classes, so that I could auto-magically know the property is a custom one or a base one? -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: vfp9 code page Tag: 231293
  - 19
    - Patches for VFP 9.0 I just installed VFP 9. On this page: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx The first item is SP1, and the second item says what's in it is already in SP1. What about the remaining items on the page - do I want/need them? XSource FFC VFPCOM Utility There is a brief explanation of each on the web page but I'm afraid it's a little too brief for me. TIA. -S- Tag: vfp9 code page Tag: 231291
  - 20
    - Delete query Can someone tell me why the following does not work? I have two tables, cps and complete. I need to delete all the records in cps that match the records in complete. Here's my query: DELETE FROM cps.DBF WHERE Cps.invoice = Complete.invoice When I run that above Foxpro tells me that 0 records were deleted. Any help would be greatly appriciated. Jim Tag: vfp9 code page Tag: 231286
  - 21
    - Sending report to file I have a large VFP application I inherited. There is a function I made to create a PDF from a report and email the PDF file. I send the output to a file using the command REPORT FORM MyReport NOCONSOLE TO FILE MyResultFile.ps I then use GhostScript to create a PDF. Everything works fine the FIRST time, but the next time I run the REPORT FORM command, the output is sent to the default printer and not a file. In trying to find the problem, I have used DISPLAY MEMORY TO FILE both times to compare the contents of memory. I have done the same with DISPLAY STATUS. I do not see any glaring differences that would prevent the output to a file the second time around. If I exit the application and reenter each time, the report is sent to a file successfully. It only fails if I _don't_ exit the application and it only fails after the first run. I have verified the printer is being set correctly and the SET('PRINTER', 3) is the printer with the postscript driver. This definitely seems like a bug in VFP since a file is not created and the REPORT FORM command should produce a file because of the "TO FILE". Any ideas? Tag: vfp9 code page Tag: 231285
  - 22
    - Question: Is VFP a Developing tool or a Database ? If you believe so, please take a look at the following link which is there since 2004: http://www.microsoft.com/usability/enrollment.htm Demetrios, Greece Tag: vfp9 code page Tag: 231278
  - 23
    - Project Documentation Machine What is "repair object hierarchy in progress"? -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: vfp9 code page Tag: 231271
  - 24
    - VFP9: Weird Event Issue A central part of my app is the Invoicing Wizard. It gives the operator a display of Work Orders and the opportunity to select one for invoicing. Because of the nature of the business, there are many things to check before invoicing, so the form has thirty-two buttons. While this might seem to be a good entry for the Interface Hall of Shame, it does work rather well. (Yes, I have used the app as well as having written it.) There is a peculiar behaviour that I noted when working on a related matter. Each Work Order listed has a textbox next to its details. Putting a "Y" in it selects the Work Order for invoicing. The textbox has input validation for whether it will allow the Work Order to be selected for invoicing. Among the things that is checked is the Work Order Type. If it is "E", then a messagebox asks whether this is what was really intended and should the system change the type to "F". If yes is chosen, the Work Order is updated and so is the display. If not, the Work Order is not selected. If "Y" is entered into the textbox, focus is moved off it (say, with <Tab>), and then the "Generate Invoice" button is clicked, invoicing will start. However, if "Y" is entered into the textbox, but focus is not first moved off the textbox before clicking "Generate Invoice", when the Work Order Type is "E", the messagebox will appear, a yes response will result in the Work Order and the display being updated, BUT invoice generation will not start. The focus will be on the Generate Invoice button, but the button's click will not get executed. My question is why does the button's click not get executed. Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: vfp9 code page Tag: 231262
  - 25
    - SQL query problem with character comparison. Hi, I have a problem in Foxpro. We have a query like Select * from Account, Bank where alltrim(account.bank_id) = alltrim(bank_bank_id) and alltrim(account.Bac) = alltrim(Bank.Bac) and alltrim(Bank.Bac) = '0000991' and not Deleted() Bank table has a column Bac which is type Charater(7). The application always inserts 7 charactes in this column. Eg. for 71 it will insert 0000071. But i have some records in the table which are marked deleted and they have bac column as 0001 i.e is less than 7 characters. The problem is above query does not return a result set even though there are records present. Moreover if i pack the table Bac, the query works fine. I also tried changing the query to Bank.Bac = '0000144'. Initially it worked fine and returned me 400 records. Then i zapped 300 records from account and executed the query. this time it agan gave me no records. By some trial and error i found that the modified query worked if there were more than 170 records. For any less it gave blank recordset. I want to find out the reason for such weird behaviour and if this some Foxpro limitation Please reply. Thank you Tag: vfp9 code page Tag: 231250

Group,
Our app was ported from the mac 8 yrs. ago so the tables have code page
10000. Windows has code page 1252 (english). Should that make a difference
in speed when opening screens with hundreds of objects linked to database
table fields? Should we change all the many tables to code page 1252? Any
thoughts will be appreciated.
Wade

Top

Re: vfp9 code page by Dan

Dan
Fri Mar 30 23:13:46 CDT 2007

I know next to nothing about code pages but it comes up often. Yes, it will
make a performance difference.

CPCURRENT() should match CPDBF(), IIRC.

Dan

"W.Davis" <wdavis3@cinci.rr.comNOSPAM> wrote in message
news:%23Q1RrxzcHHA.4260@TK2MSFTNGP02.phx.gbl...
> Group,
> Our app was ported from the mac 8 yrs. ago so the tables have code page
> 10000. Windows has code page 1252 (english). Should that make a difference
> in speed when opening screens with hundreds of objects linked to database
> table fields? Should we change all the many tables to code page 1252? Any
> thoughts will be appreciated.
> Wade
>

Top