VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe

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
    - how to append value from textbox to foxpro table? Hello! I'm a beginner and I started to learn foxpro.... so can you help me with that? I just want type some text into text box and on buton press save that text into foxpro table. How to do that? I need simple source code, please... Can someone please help me with that? Thank's Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227402
  - 2
    - BeforeOpenTables "swap" in AfterCloseTables Hi to all, this is my first post to this NG. I'm using vfp6 sp5 and often source code in BeforeOpenTables is replaced with source code of AfterCloseTables and viceversa. Usually this happens when I'm saving forms. PC is winxp home ed. with SP2 and no virus or spyware was found. Anybody has experience about this trouble? TIA, paolo Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227400
  - 3
    - Access a vb.net DLL from VFP 8.0 I have a DLL written in vb.net that works great when it is called from another vb.net program. My problem is that I can't get it to work from VFP. The call that I use in vb.net looks like this: Dim pf As New PrintFile.PFile Private Sub Sub1() Dim rcpf As Integer rcpf = pf.PrintRawFile("HP LaserJet 8100 in Server Room", "c:\docs\ptest.prn") End Sub When I call it from Visual FoxPro with a method like the following: DECLARE integer PrintRawFile IN printfile string @ Pname, string @ Pfile tname = 'HP LaserJet 8100 in Server Room' + CHR(0) tfile = 'c:\docs\ptest.prn' + CHR(0) i = PrintRawFile(tname, tfile) I receive the message: "Cannot find entry point PrintRawFile in the DLL". From this we can determine that it is finding my DLL, it just can't find this entry point. Can anyone help me with how to access a non-COM DLL from VFP? Thanks in advance! Rex Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227392
  - 4
    - Copy To and memo fields? Hi, I'm writing an application to run on a Palm PDA using Satellite Forms and VFP 9.0. I have a problem in that SF doesn't support memo fields but it does support large character fields. I'm pulling my data from a SQL 2000 Server backend with remote views and then using the COPY TO... with the FOX2X file type. The reason here is that SF supports dbase file formats for it's tables. My question is, is there a way to convert a memo field to a large character field? I believe that the largest a character field can be in VFP is 256 characters which isn't enough for the data I'm trying to move around. Does this limit exist for dbase files too? In SF I can create a character field of over 4000 characters. I wonder if I can include a CAST() function in my COPY TO command, I'm guessing not. Any suggestions? Thanks in advance, Linn Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227390
  - 5
    - trigger on view Hi, We have a problem with a view that gets closed somewhere along the process of our program, but be have no clue where the error is. Is there some way to trigger code that is excecuted when a view is closed so we can trap the problem ? Something like a trigger for a table. thankx Xavier Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227381
  - 6
    - how to create a string of values that can be used to insert in SQL server I am trying to create a string depending on the cursor fields & its type to be used to pass it to insert command for SQL server. I am having 2 problems 1> How to include character fields with quotes, square brackets & other special characters. 2> How to send date fields. Rajesh Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227375
  - 7
    - top level form menu I have a menu on a top level form. When I select the menu pads with the mouse all works as expected. However, I'm having difficulty getting that top level form menu to activate on an ALT+ key sequence. Example: The \<File menu pad appears normally and appears that an ALT+F would activate it, but it does not. The menu is being called from the INIT() of the form as: SET SYSMENU OFF DO mymenu.mpr WITH this, 'mymenu' Are there any special considerations with top level form menus to get them to trigger when an ALT+ key sequences are typed? -- Alec Gagne Crimestar Corporation www.crimestar.com Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227367
  - 8
    - skype Hello and thanks in advance for the help. Has anyone developed apps using Skype? Do you have any sample code you'd be willing to share? I can't quite figure out what Skype wants me to do to use their control. Thanks for the help. Jeff Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227362
  - 9
    - VFP: Remembering maximized window position Hello, If I close a maximized form, I want the position maximized the next time the form is run. I suppose this is INI issue, but not sure how to implement. Please help. RS Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227354
  - 10
    - Editbox lost focus issue I can't reproduce the following 100% of the time, but it seems to me that if I exit an editbox in one of my forms by clicking on a listbox (and/or perhaps elsewhere) on the same form, the underlying tables are not always updated properly. The update is accomplished via sql statements in the lostfocus() event of the control. There is no controlsource and the fields in question are character memo fields. The lb does drive the table that stores the data, but I can verify that this is not a case of the data being written to the wrong record. One obvious question is: Is there any way to exit an eb control that won't fire the lostfocus() event? TIA. -Lew Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227351
  - 11
    - Monitor Network Activity Does anyone know of a way to monitor network activity to a specific IP Address programmatically? Hereâ??s the situation. We have an IP Phone system in the office (Itâ??s a Mitel system if that makes any difference). Our computers are all connected to our phone via network cables, which is then connected to our network. Each phone has its own IP (i.e. 10.10.2.x) Basically, Iâ??m looking for a simple way to check to see if someone is on their phone. We could become certified with Mitel to develop software for our phone system, but that requires training, time, money, etc... and it is probably overkill for what we currently need. So I figured if we could just pole the network activity to the phone, that would probably indicate to us that the phone is in use. Any ideas on how this can be accomplished? Is there any APIâ??s or something else that would work? Thanks in advance, Jerry Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227349
  - 12
    - Time limited demonstration program Where can I find instructions on the best way to create a time limited demonstration program? I'd like to create one of those that dies after so many days and they have to enter a registration code to get it going. Thank you Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227347
  - 13
    - converting from vb Hi there, need some help here. I'm developing a program to extract data from a smartcard. The sample program from the development kit that come with the smartcard reader was develop using VB. I'm having problem in getting the picture from the smartcard into my vfp form. In VB, the code is : Set Image1.Picture = MyKad1.Photo In my vfp form, I put Thisform.Image1.Picture=MyKad1.Photo but when the code is run, got error message, invalid data. Anyone knows how to do it in vfp. Mykad1 is actually an ocx for the smartcard reader. Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227340
  - 14
    - VFP 9 SP 2: How is It Running? I installed VFP 9 SP 2 not too long ago. Since then, I have observed a number of crashes. SP1 was stable. I write this as I just had to delete foxuser.* AGAIN. This time, it was because I could not modify a table that I needed to change for debugging. I would simply start VFP, do my normal setups, open the table, locate the row, browse, change the value in question, save, and BAM! C0000005 everytime! Deleting foxuser.* got rid of the problem. Rebooting did not. And how have your VFP 9 SP 2 experiences been? Is anyone using it? (Is it really my turn to be bleeding edge, or is everyone else doing fine with it?) Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227334
  - 15
    - Street Type Validation Anyone have a street type validation process? I need something that when given a string will return true if the string is a valid street type (including abbreviations). For example, if given "Avenue" or "AVE", it will return .T., but if given "Fred", it will return .F. I'm writing an address parser and need to be able to identify street types. Thanks! Charlie Parker Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227329
  - 16
    - VFP 9 SP2: Command Window ?Bug Twice now, my command window has become messed up. Normally, there is space between the leftmost character in each line and the left frame of the window. This has disappeared. Commands still work fine, but the cursor is no longer visible when it is at the beginning of the line. Since I frequently repeat previous commands, this is bothersome. Deleting foxuser.* does get rid of the problem. It also gets rid of my useful settings. At least I have not had to lose a bunch of debugger settings. This has happened only since switching to VFP 9 SP 2. I have not changed the general way that I use VFP since switching to 9. Am I missing a setting? Is there a workaround? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227324
  - 17
    - VFP 9: Maximum String Length According to the VFP 9 docs under "Visual FoxPro System Capacities", the maximum string length is 16777184. What is the true maximum, and where is it documented? Adding characters ten at a time, I created a string of 40 million characters. If I start with one character and double, I get an error 1903 (String is too long to fit.) after 16777216 (2^24). (This is odd since twice that is less than 40 million.) If I start with one character and double up to 16777216, then add 1 MB at a time, I get an error 43 (There is not enough memory to complete this operation.) after 383778816 (over 1/3 GB). Since it is possible to create some very long strings and yet get errors on shorter strings, what are the rules for l-o--n---g strings? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227323
  - 18
    - Illegal regursion in triggers I know there's a way to do this, but I just don't remember. I have a table with a timestamp field which contains the datetime() of the last update and I want it to be updated whenever any change is made to a record and regardless of any table buffering. I'd like to use the update trigger but, of course, updating the timestamp in the trigger just creates the illegal recursion error (as it should). Suggestions? -Lew Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227310
  - 19
    - SuperClass Utility for VFP 5 The one I found needs VFP 6 or above. Anyone got a version for 5? Please kindly attach here... -- iTech Consulting Co., Ltd. Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227300
  - 20
    - Where are the codings? Hi everyone, I've downloaded a class (.vcx). This vcx is based on a custom class. When I open up the vcx file, there is no coding in the methods but it is working when the method was called. How can this possible? Where are the codes? By the way, I'm new to vfp. Hope someone can explain this to me. Thank you. Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227294
  - 21
    - vfp 9 app running in Vista Hi, Our application when running under Vista RC2 has some issues with displaying the forms. Some vfp forms show up fine, but a lot show the form but no title bar or form border, just the grey form area is showing. Is this a known problem, any fixes? Thanks Tristan Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227290
  - 22
    - VFP9: Keypress via command button? Hello, This stupid question has got me stumped! How do I press F2 key within command button? Way back when I thought INKEY() was the answer, but.... Thanks for the help. RS Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227280
  - 23
    - Update SQL problem I'm having some troubles with an update statement, using VFP 9, and it's driving me buggy, might someone see what I've incorrectly done? I have two tables: Master - has dozens of fields, approximately 10000 records Corrections - Has five fields (item, serial, firstrent, origcost, acquired), 500 or so records The last three fields in the Corrections table need to be changed in Master, based on the combination item+serial matching in Master, so I know there are about 500 records that will be updated. When I use the code below, I get 0 records updating. I suspect it has to do with my Where clause, and have tried many different derivations. Can someone help? UPDATE Master; SET acquired = b.acquired, firstrent = b.firstrent, origcost= b.origcost; from Corrections b; where b.item+b.serial = Master.item+Master.serial Thanks- Brian Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227274
  - 24
    - Writing to/Reading From USB Device Directly I have a device on a usb port which I can successfully write directly to. However, I am experiencing difficulties reading directly from the port. Everything below works (the commands go to the device) until it gets to the readfile portion. The device is sending data back but the readfile() is not capturing it. Any ideas? *--lc_DeviceName is returned from SetupDiGetDeviceInterfaceDetail lh_Device = CreateFile(lc_DeviceName, ; GENERIC_READ + GENERIC_WRITE ,; FILE_SHARE_READ + FILE_SHARE_WRITE, 0, OPEN_ALWAYS,; FILE_ATTRIBUTE_NORMAL + FILE_FLAG_SEQUENTIAL_SCAN, 0) IF (lh_Device != INVALID_HANDLE_VALUE) && Later test using DeviceIoControl From Lh_Device also lw_Buffer = SPACE( MAX_PATH ) lcSendValue = [! U1 MCR 80 T1 T2] + CHR(10) + CHR(13) && a command the USB device recognizes lnWritten = 0 IF WriteFile(lh_Device, lcSendValue, LEN(lcSendValue),@lnWritten,0) <> 0 && 0 is failure *!!!! Success - the device responds to the command sent *!!!! Now capture the data returning from the device (the response) lcReadBuffer = REPLICATE(" ",MAX_PATH) lnBytesReturned = 0 lnCounter2 = 0 *--Latest attempt is to loop through a read for awhile DO WHILE lnBytesReturned == 0 lncounter2 = lncounter2 + 1 IF ReadFile(lh_Device, @lcReadBuffer, LEN(lcReadBuffer), @lnBytesReturned, 0) <> 0 lncounter = 0 DO WHILE lncounter < 50 lncounter = lncounter + 1 DOEVENTS IF !EMPTY(MakeANSI(lcReadBuffer)) ? lcReadBuffer ? MakeANSI(lcReadBuffer) ENDIF ENDDO * ADD GetQueuedCompletionStatus() ENDIF IF lncounter2 = 100 EXIT ENDIF ENDDO ENDIF CloseHandle( lh_Device ) ENDIF Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227273
  - 25
    - Trimming combobox length display I have a an array populated from a table [tablename(cid c(8), cdesc(100))] and bind it into a combobox as the rowsource. The problem that I have is the length of the display when using the combo box is showing the whole 100 characters even I only have a maximum 30 characters from my table. Is there anyway i can trim the display using the method above? Thanks. apa Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227268
- Next
  - 1
    - ToolTipText How does it work? I set textbox.tooltiptext="xxxxx", but when I mouseover the textbox, there was no tooltip! -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.06) Linux 2.6.18 ^ ^ 19:42:01 up 26 days 22:07 0 users load average: 1.00 1.00 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227265
  - 2
    - VFP 5: view parent code I couldn't find the button to view parent codes. Where is it? -- iTech Consulting Co., Ltd. Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227256
  - 3
    - Installing VFP6 on Win2K3 Hey All, I'm trying to install VFP6 on our new development "server" (my new workstation...) and I'm stuck at the point where it wants to install the Microsoft JVM. Since that's no longer supported and I'm running Win2K3 64 Bit I'm a little leery... Any words of wisdom? Thanks! Matt P.S. I do have the latest JDK and JRE from Sun installed if that matters. Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227240
  - 4
    - VFP 9 Display/Screen Big Problems Hi! All of a sudden, I can't see VFP 9 screen anymore. I deleted the foxuser files and I got a command window floating on my desktop. When I issue a command (like DIR), I can't see the output but it pauses for me to press a key. If anyone has any clue, please help!! Thanks -- Monique. Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227237
  - 5
    - Assigning colors to grid cells I wish to display a series of change records in a grid on a form. They are ordered by change date, so that the newest record is on top. I wish to change the color of any cell who's value is different than the cell below it, but am not able to make the grid work this way. I have played with the Dynamic* properties of the columns but this does not really work: On the initial load it seems to work by calling an EXECSCRIPT() which does skip 1 m.Val = table.val skip -1 if table.val = m.val return m.nHIGHLIGHT else return m.nNORMAL ENDIF However, as soon as you start moving through the grid, the colors are assigned strangely. Is there any way to do this using the Grid control, or do I need to build my own control from scratch? Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227230
  - 6
    - Class & Project menu popups... How can I get the pad & popup names for the pad/popups that are dedicated to active vfp desktop items? Eg I'm interested in adding stuff to the Class and Project popups. TIA -Lew Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227228
  - 7
    - buy fpd2.6 Hi I want to buy a legal version of FPD 2.6 for personal use. Where can I get it and how do I buy it? Thanx Charu -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/foxpro-general/200610/1 Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227221
  - 8
    - RS232 port Dear All, I have a digital scale connected to my PC through RS232 port. I would like to write a program - in VFP9 - what can read the scale's weight. Could anyone help me how can I start programming? Thank you in advance. -- Sandor Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227220
  - 9
    - VFP 9: window name What's the name of the window after the command window docked with the property window? I can't close them individually using their own names after they became one. -- iTech Consulting Co., Ltd. Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227215
  - 10
    - VFP 9: Command Window Display I have run into an bothersome difference in VFP 9. I am debugging an program and have a browse in the middle to look at a generated cursor. The command window now displays over the browse. This knocks out using a full-screen browse which I occasionally need. If I click on the command window to move it, I can, but at the cost of the browse disappearing. Is there a setting that I am missing? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227213
  - 11
    - Printing All, I am trying to get FP 9 to print using a print preview component that consists of an ocx wrapper for a dll. The dll will not register as an activex in FP, even though it is registerable with regsvr32. I can get all the way through defining the page layout, and send copy to the printer. At that point nothing appears to happen. No job in the printer object in the control panel, no print preview. I see this in "What's New if FP 8" (haven't got around to 9 yet): "You still can't print reports from within a dll-based vfp com object." So, I'm wondering, does this apply to what I am trying to do as well? Is this still unchanged in 9? Gleason Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227210
  - 12
    - FPW 2.6 + Windows 2003 Server + DHCP problems I think we've solved it, but looking for input from others that may have experienced this problem. We have 12 XP Pro clients running our FPW 2.6 application. We recently decommissioned the trusty old Netware 3.11 server and put the DBFs on a Windows 2003 Enterprise server shared folder. Each client has a mapped network drive to the shared folder. We were experiencing problems with the application getting sporadic "File read errors". We found http://support.microsoft.com/kb/297684 and ran "net config server /autodisconnect:-1" on the server. The file read errors continued. We finally traced the disconnects to the time of client DHCP lease renewal. Since we set all the stations to static IP addresses the problem seems to have disappeared. -- Paul Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227206
  - 13
    - Getting Started I want to develop a system using client/server using Visual Foxpro... 1. The Microsoft SQL Server, what version should I need if my OS is Windows 2000 Standard Edition? 2. If my OS is Windows 2000, what version of SQL should I need? I need your opinio please...Help me? Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227172
  - 14
    - VFP GRID PROBLEM hi all, i am working on client/server application, front hand VFP and backened SQL Server. I am facing the problem in grid. It acts very weird. If the record source of the Grid is SQL Table, sometimes it shows only one record and sometimes blank. In some places, just calling the child form and close it instantly, grid of parent form shows the records properly. It seems to like some refreshing problem. I already breakhead on this thing for long time but i cant get any solution. If any one knows about this problem, please let me know.. Thanks Regards Tassadique Humayun Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227169
  - 15
    - Report hangs in FPW 2.6 I am still using FPW2.6 for an application on a Windows2003 Server, with workstations that run Win2000 or XP. Until last week, every report printed fine, but now there is a report that always hangs (hangs both on preview and on printer). The report preview window opens up, but it remains blank for ever, until I kill the ntvdm.exe in the Task Manager. The config.fpw file contains MEMLIMIT=80,16384,32768 since ever. I get the same error on different workstations. I have tried with other MEMLIMIT configurations, but every time it still hangs. Any further suggestions? Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227158
  - 16
    - SYS(1104) returns a string value. As per Fox documentation, Sys(1104) should return numeric (0 if successful) data type. I am consistently getting a string value of '956' from within my application. I am using VFP8. Making this call in FoxPro, without starting my application, correctly returns 0. Anyone seen this before? Is this a bug? Thanks Sati Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227156
  - 17
    - case statement in remote view? Hi, I would like to create a remote view that includes a field that is populated based on a range of another field in VFP 9. For example, I have a view that returns contact last name, first name. For example: CREATE VIEW contacts CONNECTION contactdb SHARE AS ; SELECT RTRIM(contact.last_name) + ', ' + ISNULL(RTRIM(contact.first_name), ' ') as contact_name ; FROM contact ; ORDER BY contact.last_name I would now like to add another field, an integer, the value of which is determind by the first letter of the last name. The CASE statement appears to be the best choice to me but I'm not sure how to implement it in a view like this. I'm thinking last names starting with A - E = 1, F - J = 2, K - O = 3 and so on. DO CASE CASE BETWEEN(LEFT(contact.last_name, 1) , 'A', 'E') contact.sort = 1 . . . ENDCASE Of course adding the column sort as an integer. Any suggestions? Thanks in advance, Linn Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227155
  - 18
    - Data Type Mismatch??? Hi everyone. Can someone please take a look at this code? It's very simple. What I am trying to do here is insert a default date of "12/31/xx" into all inv_date column fields, xx representing the last two digits of the year that the user previously entered. I need to do this so that the original application still accepts the proper date format mm/dd/yy. Here is my code: y = Substr(Transform(lcinput),3,2) replace ALL inv_date WITH ("12/31" + (y)) If I type this code into the Command Window and type ?"12/31/" + y, I get the 12/31/02, if the user entered 2002. However, if I run this in my program, I get and error that states "Data type mismatch". Can anyone help me out with any ideas? Thanks. Arvin Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227149
  - 19
    - Microsoft Visual FoxPro Sedna - Community Technology Preview (CTP) October 2006 From http://www.microsoft.com/downloads/details.aspx?FamilyId=808E96E1-3D87-421F-9BA5-4AAFE70C7B21&displaylang=en This download contains latest binaries that are part of Microsoft Visual FoxPro Sedna and the Visual FoxPro 9.0 SP2. This CTP contains two downloads: The Sedna CTP download contains four components: Upsizing Wizard, Data Explorer, NET4COM and MY library for VFP. The VFP 9.0 SP2 CTP download contains a patch that can be applied to VFP 9.0 or VFP 9.0 SP1. This patch includes fixes to the core product and enhancements to the Reporting features. -- Cindy Winegarden MCSD, Microsoft Most Valuable Professional cindy@cindywinegarden.com Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227143
  - 20
    - Combobox Displaying Value VFP7 XPSP2 I have a combobox by builder to display 4 fields. when i click on the combo the 4 field are displayed near each and after selecting an item from the combobox, only one field is displayed. My question: i want when i select an item from the combo, the display value to be the 4 fields.as it is displayed when click on the combo before choosing an item. ths in advance Samir Ibrahim Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227136
  - 21
    - method parameter I am trying to use an activex method that takes a parameter described as (text as string @) . I know that an @ in front of a parameter makes a variable passed by reference to a function. The compiler gives the same error with the @ in front or without. Placing the @ after the variable name doesn't work either. What is the above syntax telling me? Gleason Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227126
  - 22
    - VFP Runtimes Hi, If I have PCs with locally installed runtimes and also the runtimes in the network application directory, do you know which ones it will use? Just thinking of some machines with VFP9 rt installed locally, and want them to ignore those and pick up VFP9 SP1 rt copied to the app directory. Will this work - can I be lazy? Thanks, Neil Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227119
  - 23
    - reportlistener orientation problem i can chain two reports together using the report listener just fine, but... report 1 in in portrait report 2 is in lanscape the second report previews only showing half the report. how do i get it to handle this corectly? Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227107
  - 24
    - How to reference control within a column Dear Programmers, If you want to set the property in/on a control within a column within a grid if it is a textbox, how do you refer to that. Here is some code within the INIT of the Grid, every thing works great except where noted. DoDefault() *** If the grid does not scroll horizontally, make sure the columns are sized *** properly so the grid doesn't scroll when you tab off the last column Local lnTotColWidth, lnCnt With This .lgridoverridecaption = .t. .AllowHeaderSizing = .f. .AllowRowSizing = .f. .HighlightRow = .f. .Highlight = .t. * set resizable properties For lnCnt = 1 TO .ColumnCount .Columns[ lnCnt ].Resizable = .f. .Columns[ lnCnt ].Movable = .f. .Columns[ lnCnt ].Readonly = .t. The following code generates an error **************** If alltrim(upper(.Columns[ lnCnt ].CurrentControl.class)) = "TEXTBOX_" .Columns[ lnCnt ].loverridewidth = .t. .Columns[ lnCnt ].lgridoverridecaption = .t. Endif ***************** Endfor If INLIST( .ScrollBars, 0, 2 ) *** Calculate the total width of all columns lnTotColWidth = 0 For lnCnt = 1 TO .ColumnCount *** Add-on the width of this column lnTotColWidth = lnTotColWidth + .Columns[ lnCnt ].Width + 1 *** work out if this is the last column If .Columns[ lnCnt ].ColumnOrder = .ColumnCount lnLastColumn = lnCnt Endif Endfor *** Add-on the width of the scroll bar (if required) lnTotColWidth = lnTotColWidth + ; IIF( .ScrollBars = 2, SYSMETRIC( 5 ), 0 ) + 2 *** Add-on the delete mark (if required) lnTotColWidth = lnTotColWidth + IIF( .DeleteMark, 8, 0 ) *** Add-on the record mark (if required) lnTotColWidth = lnTotColWidth + IIF( .RecordMark, 10, 0 ) *** Resize last column to ensure grid is completely filled .Columns[ lnLastColumn ].Width = .Columns[ lnLastColumn ].Width + ; ( .Width - lnTotColWidth ) -1 Endif Endwith Any suggestions ? Regards Craig C. Hudson Sr. Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227104
  - 25
    - VFP 9: Alternative to sys(1037) I have been using a keyboard-sys(1037) sequence to change printer orientation. This is a kludge, of course, and occasionally, when I was using the app, it would hang up wait on the printer form. (I never did identify exactly when, but it was when I had switched focus to another program, and only occasionally.) Surely, there must be a better way, one that does not count on the operator being "friendly". I have looked for code to do this. I found two on Universal Thread, but the documentation is rather sparse. Except for my recent excursion into the kernel API, I have not used external routines before in VFP. Is there a good writeup somewhere, something with examples so I can be sure I have it right? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Tag: 227103

Add to a form the pageframe1 with 3 pages (page1 page2 page3).
Add the Button1 into page1
Add the Button3 into page3
Insert ACTIVEX MicrosoftChartControl 6.0 (SP4) into page2.
Add the Button2 into page2 with the command THIS.parent.page1.setfocus()
into button2.click event.

Now run the form and you see button1.
Click page2. You see the chart and button2 OK!
Click Button2. You see now button1 AND the chart!!!!
Click page3. You see now button3 AND the chart!!!!

Only if you click page2 again and then page1 or page3 everything its OK
again...
_vfp.autoyield=.t./.f. does not matter.

Is it a bug?
Are there any work around?

TIA
Have a nice day (or night),
Nick Pofiris,
ErmisPliroforiki
Athens-Greece
www.ermis-pliroforiki.com.gr

Top

Re: VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe by AA

AA
Mon Oct 23 04:29:36 CDT 2006

What if you change pages the way we're supposed to: oPageFrame.ActivePage=
1|2|3
-Anders

"Nick Porfiris" <nickpor@ermis-pliroforiki.com.gr> skrev i meddelandet
news:%23$%239Rpj9GHA.3760@TK2MSFTNGP02.phx.gbl...
> Add to a form the pageframe1 with 3 pages (page1 page2 page3).
> Add the Button1 into page1
> Add the Button3 into page3
> Insert ACTIVEX MicrosoftChartControl 6.0 (SP4) into page2.
> Add the Button2 into page2 with the command THIS.parent.page1.setfocus()
> into button2.click event.
>
> Now run the form and you see button1.
> Click page2. You see the chart and button2 OK!
> Click Button2. You see now button1 AND the chart!!!!
> Click page3. You see now button3 AND the chart!!!!
>
> Only if you click page2 again and then page1 or page3 everything its OK
> again...
> _vfp.autoyield=.t./.f. does not matter.
>
> Is it a bug?
> Are there any work around?
>
> TIA
> Have a nice day (or night),
> Nick Pofiris,
> ErmisPliroforiki
> Athens-Greece
> www.ermis-pliroforiki.com.gr
>
>

Top