Non-Modal windows problem - VFP 9

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
    - Duplicate records I have imported a textfile to a table. In this file there is now records which has the same information. How is it possible to remove the duplicate records? I have tried with different index ,delete, remove,alter, update and queries but the duplicates is still there. Many thanks in advance Reidar Tag: Non-Modal windows problem - VFP 9 Tag: 222233
  - 2
    - RAID 1 OR RAID 5 - YOUR OPINION Our core processing software is written in Visual FoxPro. We have experienced some performance issues with this software - slow inquiry and slow processing speeds. We have received conflicting information from a couple of different sources regarding the type of RAID used on our server. I am asking for opinions, knowledge, etc. on whether RAID 1 OR RAID 5 works better when running a VF program. Any info would be greatly appreciated. Tag: Non-Modal windows problem - VFP 9 Tag: 222232
  - 3
    - Combo/Incremental Search/Space I have a combobox with style set to Dropdown List and Incremental Search = .t. Incremental searching works fine until I hit the space bar as part of mt search expression. For example, I want to search for "fred smith". I start typing the characters and the incremental search works fine until I get to the space character. Hitting the space drops down the list. How can I force the space character to be part of the searched-for expression and prevent it from driopping down the list? Brian Tag: Non-Modal windows problem - VFP 9 Tag: 222228
  - 4
    - Copy to Xls Command This is a multi-part message in MIME format. ------=_NextPart_000_0039_01C651DC.7517B220 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable From Vfp 9.0 issuing the command copy to excelfile type xls creates an excel file. All fields convert correctly except date column = which becomes "text" type in excel. How can I create an excel file with = the correct date format. ------=_NextPart_000_0039_01C651DC.7517B220 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.2802" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DTahoma size=3D2>From Vfp 9.0 issuing the = command</FONT></DIV> <DIV><FONT face=3DTahoma size=3D2></FONT> </DIV> <DIV><FONT face=3DTahoma size=3D2><STRONG>copy to excelfile type=20 xls</STRONG></FONT></DIV> <DIV><FONT face=3DTahoma size=3D2></FONT> </DIV> <DIV><FONT face=3DTahoma size=3D2>creates an excel file. All fields = convert=20 correctly except date column which becomes "text" type in excel. How can = I=20 create an excel file with the correct date format.</FONT></DIV> <DIV><FONT face=3DTahoma size=3D2></FONT> </DIV> <DIV><FONT face=3DTahoma size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0039_01C651DC.7517B220-- Tag: Non-Modal windows problem - VFP 9 Tag: 222222
  - 5
    - So Weird function execution problem - Trying to get the owner of a file. Functions included. Hi, I have written a program that scans a directory - local or network - and for each file gets the owner name and the domain name and updates a table list. I have noticed that something weird happens during the function execution (function included). The function sometimes does not return the owner and domain. Therefore I set up a mechanism of a couple of retries and maintain a counter of retries. Now the weird things. 1. Sometimes for example for the folder c:\, I may have 200 retries, some other times more than 1000 and some other times 50. 2. Furthermore, because I don't keep trying for ever, some files do not return their owner. When I interactively later request the owner I am able to get it, so there isn't a file specific prolem. 3. The most weird. During the program tests, I had noticed that each time, different files appear in the table list without their owner/domain. What exactly is going on? Is there a timeout problem? Demetrios, Greece -------------------------------- * GetFileOwner - Get the owner of an NTFS file * * VBCode in: http://www.devx.com/vb2themax/Tip/19292 * Runs over Windows NT or 2000, and works only with files in NTFS partitions * * Requires the GetFileOwner_APIs.prg * * Usage: * ------ * GetFileOwner_APIs() * Store "" to Domain, Owner * GetFileOwner(fileName, @Domain, @Owner) * * Example: * -------- * GetFileOwner("C:\Windows\hh.exe", @Domain, @Owner) * ? Domain, Owner LParameters szfilename, Domain, Owner #Define OWNER_SECURITY_INFORMATION 1 Local m.sizeSD, m.pOwner, m.ownerName, m.domain_name, m.name_len Local m.domain_len, m.nLength, m.deUse, m.sdBuf m.sizeSD=0 && Buffer size to store Owner's SID m.pOwner=0 && Pointer to the Owner's SID m.ownerName="" && Name of the file owner m.domain_name="" && Name of the first domain for the owner m.name_len=0 && Required length for the owner name m.domain_len=0 && Required length for the domain name m.nLength=0 && Length of the Windows Directory m.deUse=0 && Pointer to a SID_NAME_USE enumerated type && indicating the type of the account m.sdBuf=" " && Buffer for Security Descriptor bSuccess=GetFileSecurity(m.szfilename, OWNER_SECURITY_INFORMATION, 0, 0, @m.sizeSD) * Create a buffer of the required size and call GetFileSecurity again m.sdBuf=Space(sizeSD) * Fill the buffer with the security descriptor of the object specified by the * filename parameter. The calling process must have the right to view the specified * aspects of the object's security status. bSuccess=GetFileSecurity(m.szfilename, OWNER_SECURITY_INFORMATION, @m.sdBuf, m.sizeSD, @m.sizeSD) * Obtain the owner's SID from the Security Descriptor, exit if error bSuccess=GetSecurityDescriptorOwner(@m.sdBuf, @m.pOwner, 0) * Retrieve the name of the account and the name of the first domain on * which this SID is found. Passes in the Owner's SID obtained previously. * Call LookupAccountSid twice, the * first time to obtain the required size of the owner and domain names. bSuccess=LookupAccountSid(NULL, m.pOwner, @m.ownerName, @m.name_len, @m.domain_name, @m.domain_len, @m.deUse) * Allocate the required space in the name and domain_name string variables. * Allocate 1 byte less to avoid the appended NULL character. if m.name_len>1 ownerName=Space(m.name_len - 1) domain_name=Space(m.domain_len -1 ) * Call LookupAccountSid again to actually fill in the name of the owner * and the first domain. bSuccess=LookupAccountSid(NULL, m.pOwner, @m.ownerName, @m.name_len, @m.domain_name, @m.domain_len, @m.deUse) Endif Domain=m.domain_name Owner=m.ownerName Return Owner * GetFileOwner_APIs * Required from GetFileOwner DECLARE INTEGER GetFileSecurity IN advapi32; STRING lpFileName,; INTEGER RequestedInformation,; STRING @pSecurityDescriptor,; INTEGER nLength,; INTEGER @lpnLengthNeeded DECLARE INTEGER GetSecurityDescriptorOwner IN advapi32; STRING @pSecurityDescriptor,; INTEGER @pOwner,; INTEGER @lpbOwnerDefaulted DECLARE INTEGER LookupAccountSid IN advapi32; STRING @lpSystemName,; INTEGER lpSid,; STRING @lpName,; INTEGER @cchName,; STRING @lpRefdDomain,; INTEGER @cchRefdDomain,; INTEGER @peUse Tag: Non-Modal windows problem - VFP 9 Tag: 222221
  - 6
    - Running FPW 2.6 code in VFP 9 - Buttons are white I have an application written in FPW 2.6 that runs in 2.6 and VFP. I'm used to running it in VFP 7.0. I just set up VFP 9.0 on the machine and I've got the application running but the buttons on the FPW 2.6 screens are colored white. The backgrounds on the screens are grey or blue. Is there a way I can have the buttons the same color as the background? Thanks. Dan Tag: Non-Modal windows problem - VFP 9 Tag: 222210
  - 7
    - any fix to redraw problem yet? I still have this problem (VFP9 SP1, but it's been around for a while), where labels and controls with labels like option buttons and checkboxes, redraw themselves with a tiny < 1 pixel offset, when other controls on a form are refreshed. The net result is that those controls, after a few refreshes, become very icky looking, sort of bold-faced, only uglier. I can get rid of it by setting visible = .t. to those controls, but having to do this hack is getting really annoying. Has this at least been acknowledged to be a problem? Any better workarounds than mine? Tag: Non-Modal windows problem - VFP 9 Tag: 222209
  - 8
    - newbie Change Parent Class Location I have a VFP9.0 that was converted from VFP6.0. One of the parent class was on E:\.......\_base.vcx I need to change it to C:\......\_base.vcx Suggestions? TIA Steve Tag: Non-Modal windows problem - VFP 9 Tag: 222207
  - 9
    - attachments in cdo I copied code: LOCAL loCDOMSG AS CDO.MESSAGE loCDOMSG = NEWOBJECT( 'cdo.message' ) WITH loCDOMSG .Subject = 'Test CDOSYS Message' .TO = 'Joe@somecompany.com' .FROM = 'joe@somecompany.com' .TextBody = 'This is the body' .Configuration.FIELDS.ITEM([http://schemas.microsoft.com/cdo/configuration/s endusing]) = 2 .Configuration.FIELDS.ITEM([http://schemas.microsoft.com/cdo/configuration/s mtpserver]) = [SMTPHOST] .Configuration.FIELDS.ITEM([http://schemas.microsoft.com/cdo/configuration/s mtpserverport]) = 25 .FIELDS([urn:schemas:httpmail:importance]) = 2 .FIELDS([urn:schemas:mailheader:priority]) = 1 .Configuration.FIELDS.UPDATE .FIELDS.UPDATE .SEND ENDWITH loCDOMSG = NULL WAIT WINDOW [Mail Sent.] TIMEOUT 1 ?But how to attach a file thanks Tag: Non-Modal windows problem - VFP 9 Tag: 222206
  - 10
    - File() Function - VP9 If I'm searching for "c:\filepath\myfile.ext" by calling FILE("c:\filepath\myfile.ext") and "myfile.ext" is part of the "Other Files" section in the project, then the FILE() function returns true even though "myfile.ext" does not exist inside of "c:\filepath". This happends ONLY when the program is compiled as an exe. The file function works correctly when run from within the VFP IDE. The VFP Help file states: "If you do not include a path with the file name, Visual FoxPro searches in the default directory for the file. If it cannot find the file in the default directory, Visual FoxPro searches along the Visual FoxPro path, which is established with SET PATH." c:\filepath\ is included when i call the FILE() function and IS NOT part of the PATH set by SET PATH. Thanks! Tag: Non-Modal windows problem - VFP 9 Tag: 222205
  - 11
    - dynamicreadonly I have a grid. Is there a way to simulate the property "DynamicReadOnly" ? Mike Farnesi San Diego Tag: Non-Modal windows problem - VFP 9 Tag: 222201
  - 12
    - Is exclusive open of table faster If you open a table exclusively does that make processing faster? Anybody have any experience or documentation on this?? Tag: Non-Modal windows problem - VFP 9 Tag: 222193
  - 13
    - class not registered.. Hi..guys. I meet a problem in my customer side ..when calling the mscomm32.ocx ..its out a error 'Class not registered' in workstation Window XP SP2. is it the window xp setting problem? I used foxpro 6.0. regards, Orange Tag: Non-Modal windows problem - VFP 9 Tag: 222188
  - 14
    - Report Problem Hi All When I Run report with reportlistener Preview (reportpreview.app) From Button In Window TestForm Created in Top Form MainForm ShowWindow = 1 when report Finish All off properties Of The TestForm and data which I created in load form from sql database and Connections lost This Happen when Run From Exe File Only any Id I use Vfp9 Sp1 Thanks Tag: Non-Modal windows problem - VFP 9 Tag: 222187
  - 15
    - KB/913807 ; KB/913161 ; KB/913571 ; KB/905756 I Can't install this update. I receive this event : Produit : Microsoft Office Professional Edition 2003 - La mise Ã jour 'Security Update for Outlook 2003: Junk E-mail Filter (KB913161): OUTLFLTR' n'a pas pu Ãªtre installÃ©e. Code d'erreur 1603. Windows Installer peut crÃ©er des journaux pour faciliter la rÃ©solution des Ã©ventuelles erreurs d'installation des packages logiciels. Utilisez le lien suivant pour afficher des instructions concernant l'activation des journaux : http://go.microsoft.com/fwlink/?LinkId=23127 0000: 7b 39 30 31 31 30 34 30 {9011040 0008: 43 2d 36 30 30 30 2d 31 C-6000-1 0010: 31 44 33 2d 38 43 46 45 1D3-8CFE 0018: 2d 30 31 35 30 30 34 38 -0150048 0020: 33 38 33 43 39 7d 20 7b 383C9} { 0028: 37 35 33 42 42 33 39 46 753BB39F 0030: 2d 32 41 38 44 2d 34 39 -2A8D-49 0038: 45 41 2d 38 38 31 31 2d EA-8811- 0040: 32 45 33 34 44 41 39 34 2E34DA94 0048: 46 36 39 43 7d 20 31 36 F69C} 16 0050: 30 33 03 Tag: Non-Modal windows problem - VFP 9 Tag: 222185
  - 16
    - White b/g isn't white?! Hi, I'm trying to make the backcolor of my form pure white. But I can't get it to show that. The backcolor of the form and the page is 255,255,255 and the page's color source is 0 (Object's Color Properties). Yet the form is clearly not white. I'm a little color blind so I can't say for sure what the color is but it looks to me as slightly grayish with a bit of pink. The page tabs are white and it's quite obvious that the page itself is not. What am I missing? This is VFP9 Thanks, Frank Tag: Non-Modal windows problem - VFP 9 Tag: 222182
  - 17
    - VFP8 performance on low memory machines I have an app that we have recently upgraded from VFP6 to VFP8. On machines with a lot of memory the performance is very good, but on machines with less memory the performance has degraded significantly. The apps are being run locally. I have had a look at sys(3050) but I am not sure whether it is the right approach to take. Any suggestions? Tag: Non-Modal windows problem - VFP 9 Tag: 222162
  - 18
    - Another query design question... Hi, Using VFP 9.0 to remotely query a SQL database and I'm stuck once again... yeah I know, what else is new? :-) This time I'm trying to make a sort of lookup table(view) from two related tables: Table name: billing_code Fields: sys_id (pk) billing_code_set_ver_sys_id billing_code description create_timestamp modify_timestamp create_user modify_user Table name: billing_code_charge_code Fields: sys_id (pk) billing_code_sys_id chg_codes_code create_timestamp modify_timestamp create_user modify_user These tables are related on the billing_code.sys_id to billing_code_sys_id, for every billing_code record there's many billing_code_charge_code records. What I want is a table that returns chg_codes_code, billing_code and description. Sounds simple doesn't it? Here's the catch... The billing_code table is on the many side of a one to many relationship with another table, billing_code_set_version. This means that there are multiple records in billing_code with the same billing_code and description. So far I haven't figured out how to get my query with just one record for every chg_codes_code, billing_code and billing_code.description. The closest I've gotten is this: select distinct chg_codes_code, billing_code, description from billing_code_charge_code right join billing_code on billing_code.sys_id = billing_code_charge_code.billing_code_sys_id where left(chg_codes_code, 1) in ('D', 'F', 'E') order by chg_codes_code In many cases this returns duplicate chg_codes_code values. The main difference I see in the records is that for one the description is in all upper case and the description for the other record uses normal case. Any suggestions? I've been trying all sorts of combinations but so far no luck. Thanks in advance, Linn Tag: Non-Modal windows problem - VFP 9 Tag: 222156
  - 19
    - Blues on protecting executables After seeing Refox protection is breakable with the new tools, I'm looking a new way to protect an application in VFP7 SP1 Using Molebox my exe file don't work. I don't know what I'm doing wrong. Had someone used this tool.? I'm aware on Derefox, I think this is the name, although I think is a good tool, I consider a problem to have to include more resource files (VFP6). Thanks. Alejandro Fernandez Tag: Non-Modal windows problem - VFP 9 Tag: 222155
  - 20
    - Report Writer VFP 9 BUG Hi, I have a table with 200 records, contains 7 fields, one of them is a memo field. I designed a very simple report with 5 fields on one line in the details band & on the 2nd line in the detail band I putted the memo field with width of the page A4. In the print when of the memo field, I inserted a variable & if this variable is TRUE then the memo field will appear in the report else it won't. When launching the report with the variable set to FALSE, a list of the 200 records appear. When the variable is set to TRUE, the report show a blank page with a number of pages in the TITLE BAR of the report starting from 28500 pages & counting quickly, I waited about 30 seconds & the number is counting with more than 3 millions pages & the VFP is hanging so I closed it from the task manager. I retry the same action, & I obtained the same result. Any Help Tag: Non-Modal windows problem - VFP 9 Tag: 222148
  - 21
    - How to write click event Hi all, In my program, when my program is running, enduser can press a button to create another "command button". And now I have a problem of create a "command button" with coding in that "Click event method" at the same time in the above situation. -- Thanks ! Tag: Non-Modal windows problem - VFP 9 Tag: 222142
  - 22
    - How can I know the class calling the procedure Dear All How can I know the class calling the procedure ? For Example Define class parent_class as session Procedure some_method set proc to procedure_file do call_me() Return Endefine Procedure file.prg : Procedure call_me how do I know the "parent_class" calling me ? <---- Anyone enligthen me ? Return Tag: Non-Modal windows problem - VFP 9 Tag: 222140
  - 23
    - Running a distributed .exe from an installation on a network serve I have a client that is having trouble running my program from an installation on a server from a workstation. I know that it is being used that way on some other sites so I am thinking it is a rights issue. Are there any limitations, such as printing reports from the server, that a client accessing it from a short-cut is going to experience? Cory Bonallo Retail Services Developer Tag: Non-Modal windows problem - VFP 9 Tag: 222136
  - 24
    - Determining SMTP server I want to provide the application option to send email from Fox via SMTP instead of MAPI method. Does anyone know how to retreive the default SMTP server name from Fox or Windows API? ----------------------------------------------------------------- Paul Lee ........ Abri Technologies ........ http://www.abri.com/ 'Recover' - top rated FoxPro file repair utility. ----------------------------------------------------------------- Tag: Non-Modal windows problem - VFP 9 Tag: 222134
  - 25
    - download foxpro 2.6 distrubtion kit here here you can dl Foxpro 2.6 dist... kit tanks alot for all visitors email me for any unfounded link to mbksoft@gmail.com http://vetusware.com/output/id73-FPXPRODK.260.rar Tag: Non-Modal windows problem - VFP 9 Tag: 222131
- Next
  - 1
    - Debugging Fox COM object in IIS Hi all! My website uses a FoxPro COM object to perform some database operations. The Fox DLL is single-threaded. At times, the function calls within my website to the Fox COM object will stop responding and the website will hang. The last time this happened, I attached Microsoft's WinDBG to the website process to debug it. What I observed was what appeared to be an infinite loop of first chance access violations. The violation occurrs in "vfp8r.dll" and with symbols, one can see the function in which the crash occurs is "KBCopy2". Apparently some error handler is catching this violation because it never becomes second chance but the function is getting repeatedly called (infinitely it seems) and therefore locking up my COM object. Does anyone have any ideas about how I debug this further and find out exactly what is going on? Thank you! Matthew Tag: Non-Modal windows problem - VFP 9 Tag: 222126
  - 2
    - problem dragging file to explorer I posted in a xp newsgroup, but did not get an answer. I have a Visual Foxpro Application that reads a text file and stores the data in a table. The text file is created using a PDT (Portable Data Terminal). I use the software that came with the PDT to drag the text file from a PDT window (from within the PDT software) to a folder called c:\mobile. It works great on my test computers (both are Windows XP Home Edition....arghhh don't ask why!). Anyway on my client computer, which is a Windows XP Professional, I cannot drag the file. I can only drag it to the Recylce Bin. I think I have checked properly any rights for the c:\mobile folder and they are set to "read, write, etc....all rights are check". However, windows will not allow me to drag the file. What setting am I missing? I opened and saved a wordpad document in the C:\mobile folder so I do have rights. Thanks, John. Tag: Non-Modal windows problem - VFP 9 Tag: 222123
  - 3
    - Persistent VFP COM Server with GUI Hi, I'm trying to start a VFP application through automation. So I created OLEPUBLIC class. This class displays application's main form in Init code. Application is compiled as out-of-process EXE. In VB code I create instance of my COM Server: set oApp = createobject("Myapp.App") oApp.DoSomething() The main form appears and the application is working. But when VB code finishes and oApp variable is cleared, my VFP application is also closed! Q: How to preserve vfp automation server in case of releasing referencing variable in client code? Look at MS Excel. If I run following code written in VB: set oEx = createobject("Excel.Application") oEx.Workbooks.Add oEx.Visible = true After releasing oEx variable from memory, Excel is still visible and working! How do that in VFP? Thanks in advance, Janusz Czudek WORD Software www.wordsoft.com.pl Tag: Non-Modal windows problem - VFP 9 Tag: 222122
  - 4
    - Lost settings in IDE When I open VFP, all settings are lost. Whatever I do it in VFP now, everything will be disappeared after I reopen VFP. Any ideas? TIA. Tag: Non-Modal windows problem - VFP 9 Tag: 222113
  - 5
    - Null values in a textbox Hi, I made a screen with more than 40 textbox, I have only 3 fields which accept Null values. When the user type by mistake ctrl+zero on a field other the 3 fields, an error occurs & the application is closed. I tried to write code in the ERROR handling program such as: do case case error_num = 1581 Messagebox(dvgdfg) return 0 but still the application is closed. any help, Thank you Tag: Non-Modal windows problem - VFP 9 Tag: 222110
  - 6
    - SET TALK command (VFP6) The VFP command window can be used as a calculator. If I issue: CLEAR SET TALK ON USE sometable SET FILTER TO somefilter SUM FOR somecondition the system will show a count of the records it processed, and the sum of the numeric fields in the table. The results will be shown on the SCREEN, and the display will persist (and I can print it with PrtSc). It may look like this: 99999 records summed valuation 123456789.00 If, however, SET STATUS BAR ON, the sum will be displayed on the screen, but the count will be displayed in the graphical status bar. Moreover, the count will be displayed only for about 3 seconds, and then the status bar will be refreshed, wiping out the count. I find that the only reliable way to get the display I want is to SET STATUS BAR OFF SET TALK ON thus foregoing the benefit of the status bar.Also, I don't find the clauses like "SET TALK WINDOW somewindow" to work very well. Any comments? Tag: Non-Modal windows problem - VFP 9 Tag: 222108
  - 7
    - Modal browse windows I am attempting to open 3 browse windows from a VFP9 form. The intent is to be able to move the browse windows around so they can be arranged on the desktop. My problem is that they all open correctly but I only have access to the last one. They are acting like they are modal. The only way I can access other windows is to close the top one. Are we dealing with a foundation read issue here?? Is there any way to make this work. the command is browse noedit window <window name> nowait Tag: Non-Modal windows problem - VFP 9 Tag: 222103
  - 8
    - Deleted box does not show?? I'm using VFP 8.0 and have a view in my database. When I use and browse the view, it does not show the deleted status of the underlying table. Why? I can set deleted on and the deleted records DO NOT show in the view. However, I want them to show, but have the black square in the grid. What is a workaround? Thanks, John. Tag: Non-Modal windows problem - VFP 9 Tag: 222099
  - 9
    - Regional settings and dot on numeric keyboard I have a text field with inputmask set to "9999999.99" which is used to store info about money. Everything is OK when user have keyboard set to English, but when keyboard is set to PL (polish programmers) button '.' on numeric keyboard become comma. If user with PL keyboard press '.' key on numeric keyboard like he wants to write cents it does not move to cents digit.... How to override this behavior ? I was trying change it in Keypress event, but it doesn't work: LPARAMETERS nKeyCode, nShiftAltCtrl IF nkeycode=44 && IF polish keyboard change ',' to '.' nKeyCode=46 RETURN 46 ELSE ENDIF Thanks, Adam Tag: Non-Modal windows problem - VFP 9 Tag: 222097
  - 10
    - SQL Help please!! i am trying the following with errors. Select Agency, Dept,; Sum EmpDate <= checkhdr.procdate, 1, 0 As currentmonTH,; Sum EmpDate => checkhdr.procdate, 1, 0 As nextMonth; From newmem; what is the best way to get this data in SQL? thank you Tag: Non-Modal windows problem - VFP 9 Tag: 222093
  - 11
    - How do I run this from a click even ? I run this from the RUN dialog box: C:\AVD\PERU\pptview.exe /L "playlist.txt" How would I get this to run from a command_buttons click event? Your Friend From Afar ~ Respectfully, Jonathan Morningstar ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Tag: Non-Modal windows problem - VFP 9 Tag: 222082
  - 12
    - VFP 8.0 Remote View Bug with MySQL 5.0 production Hi Gang, I appreciate any you can give me on this one. I run VFP 8.0 SP1 and use remote views via the MySQL ODBC driver 3.511-11-2win to work with large MySQL Tables. I recently upgraded from MySQL 5.0a Beta to the MySQL 5.09 Production release version and I noticed two related but big problems: 1. Any remote view of a MySQL table which contains numeric or decimal fields will be automatically characterized as character fields when you attempt to build a remote view in VFP 8. It will get integers and datetime types right. (You can even see it in the DBSETPROP command if you view the SQL in the view builder). If you attempt to change the SQL manually in the view builder and run the query, Fox will tell you that you have a data type mismatch. Makes it a bit difficult with numbers. 2. If you attempt to just pull the data with the Fox SQLEXEC(handle,'select * from my_table,'sql_result'), the resulting Fox cursor will also convert numeric and decimals to the character datatype, even if you have used a CREATE CURSOR command to define the fields to match the MySQL table exactly, numbers and decimals come out as character fields. I re-installed the older version of MySQL 5.0a Beta and the problem went away. The problem seems to involve any table MySQL defines as a version "10." Legacy version "9" MySQL tables (don't modify them in MySQL or they become 10's) will continue to work normally. Has anyone else experienced this issue? Have you found a work-around or a version upgrade or fix that I am missing? Thanks a bunch! David L. Jacobson Tag: Non-Modal windows problem - VFP 9 Tag: 222079
  - 13
    - Date Time Picker auto dropdown Hi, I want my form to open with the calendar part of the MS Date and Time Picker control visible. I tried adding KEYBOARD '{ALT+DNARROW}' to several events (GotFocus, Refresh, UIEnable, etc.) but without any luck. Also, I'd prefer that the text box portion not be visible at all. Is there any way to do this? Is there another control I could use instead? Thanks, Frank Tag: Non-Modal windows problem - VFP 9 Tag: 222076
  - 14
    - Variable editing Is there a way in FoxPro to open a string variable in an editing window, like you can do with memo fields? I want to be able to assign a string to a variable then edit it using something like modify memo or modify command. I guess I could put it in a memo field, but it seems like you ought to be able to open a full-screen editing session with a string variable without having to copy it to a memo field. Any suggestions? Kevin Clark Seton Home Study School Tag: Non-Modal windows problem - VFP 9 Tag: 222075
  - 15
    - Child grid woes Hi, I have a parent grid and a child grid on a pageframe page. The child grid is set up with Linkmaster, RelationalExpr, ChildOrder, etc properties which work fine. The problem I have is that if I move to say the third record in the child grid, issuing a page refresh will reset the pointer to the first record. Is there any way to stop this happening, or a good way to send the pointer back to the correct record on a refresh (the child records have a unique id I could use). I'm using VFP9. Any help much appreciated. Neil Tag: Non-Modal windows problem - VFP 9 Tag: 222074
  - 16
    - Change scope? CHANGE is almost identical to BROWSE in what it can do. I just noticed however that CHANGE has a <scope> which is rather odd for a browse like command. Even more odd is how it works.. If I issue CHANGE NEXT 3 on a table with some records then I can actually change up to 3 records either "up" or "down" from my current position. As soon as I cross the 3rd record boundary the window closes. This is the case if I move "up, up" or "down, down" or even "down, up" etc. If I use the Record->Goto menu option then in fact I can go to any record I like any number of times and edit data provided I don't cross the record boundaries and the window will stay open. What is the meaning of <scope> in the context of CHANGE? Gene, is this good enough for your list of nasty questions? -- regards Andrew Howell Tag: Non-Modal windows problem - VFP 9 Tag: 222072
  - 17
    - System hang restart PC- data losed Hi..everybody.. I meet a problem is the enduser purposely restart the PC when system hang.. And the data key in all day was totally losed in .dbf after the end user restart pc..Foxpro 6.0 was used + foxpro tables database.. is it got any solution for me? regards, Orange Tag: Non-Modal windows problem - VFP 9 Tag: 222057
  - 18
    - Blank if zero(another choice) ? in vfp report, my client don't want to print zero and print - - instead ? How can I do that ? thanks Tag: Non-Modal windows problem - VFP 9 Tag: 222056
  - 19
    - frx to xls This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C64CC6.1C1D5DC0 Content-Type: text/plain; charset="windows-874" Content-Transfer-Encoding: quoted-printable Hi, which is the best tool for REPORT FORM frx TO xls ? I mean WYSIWYG = including line/box/fonts,etc. xfrx ? frx2any ? I have tried Amyuni Converter, but not really convert = exactly, and column of data missing too. plz recommend. Regards Hoe ------=_NextPart_000_000E_01C64CC6.1C1D5DC0 Content-Type: text/html; charset="windows-874" 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=3Dwindows-874"> <META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>which is the best tool for REPORT = FORM=20 frx TO xls ? I mean WYSIWYG including = line/box/fonts,etc.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>xfrx ? frx2any ? </FONT><FONT = face=3DArial size=3D2>I=20 have tried Amyuni Converter, but not really convert exactly, and column = of data=20 missing too.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>plz recommend.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Hoe</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_000E_01C64CC6.1C1D5DC0-- Tag: Non-Modal windows problem - VFP 9 Tag: 222053
  - 20
    - Currency Symbol How can I make the reports in my application show the "£" symbol instead of the "$" symbol. I've included SET CURRENCY TO "£" in the main calling program which doesn't help. The TOOLS>OPTIONS>REGIONAL is also set to £ Please HELP!! Tag: Non-Modal windows problem - VFP 9 Tag: 222052
  - 21
    - index problem I have a program which runs in a multiuser environment. The program has been running for many years and every once in a while I find a CDX file becomes corrupted. It can be any one of the index files of which there are many. I usually delete the index file and recreate it to fix the problem. This doesn't happen very often, but it does happen once or twice in a 5 or 6 month period of time. The program is written in VFP 6. Has anyone else experienced this sort of problem? Is there anything I can do to protect this from happening? Has anyone determined why this happens? The files are all flat tables as opposed to tables within a database container. --Elliott Tag: Non-Modal windows problem - VFP 9 Tag: 222048
  - 22
    - Installing VFP 8 Application under 64bit Windows I have run into an interesting problem. We distribute our product with basically two installs using the installshield express included with VFP (did I forget to mention we are currently using VFP8?) and have a customer who just bought their first 64 bit workstation with XP 64 on it. They went to install the second install (it's a workstation install from the installed files on their server) and it's telling them that the operating system is not sufficient for our software. Now I understand that VFP 8 is supposed to work find under XP 64 in 32 bit mode, but since we don't have any 64 bit machines (I wish we did as our MS Action Pack provides the OS) I have no way to experiment with it to figure out why it's not working or how to make it work. Does anybody have any answers on this issue? I know we told the install not to allow NT or 95, but I am not sure if that is the problem or not, since XP 64 is still XP is it not? If this is not the case, is there something we can have the customer change in the setup.ini or such without needing to generate a new install for them? Any help would be good. YOu can email me if needed at cywelch at metsysinc dot com if possible since that would get the answer to me quicker since I don't get time to read in here too often. -- Cy Welch Senior Programmer MetSYS Inc http://www.metsysinc.com Tag: Non-Modal windows problem - VFP 9 Tag: 222047
  - 23
    - Rich Text Control Hi, I am trying to use the Rich Text Format in Visual Foxpro 9 for the first time. I bring the text field from the Solution Samples & insert it in a new form with command buttons: Bold, Underline, ... The rtf field in linked to memo field in a table. I am trying to print but I don't know how to use the SELPRINT method from the RTF. I want to print the memo field in a FRX Report. Can you help me please ?? Thank you in advance Tag: Non-Modal windows problem - VFP 9 Tag: 222038
  - 24
    - Ink Sorry guys. The spam stuff was not my intent. I do oppoligies and won't happen again. I have never been on newsgroups before and not sure how to work them. I hope you guys can forgive a bad choice. Murphey Tag: Non-Modal windows problem - VFP 9 Tag: 222033
  - 25
    - Ink Man I have found this site that has the cheapest ink for any printer. You can compare prices and then review the companies on service and quality. <http://www.imagraphix.com> Let me know what you think Tag: Non-Modal windows problem - VFP 9 Tag: 222032

I am trying to instantiate several Non-Modal copies of a form in VFP
from the currently running form. I have set all of the properties
correctly as far as I know but, the forms end up being modal. I can
move the top one around and click on objects but cannot access the one
created before it without closing the last one it.
I have queried the windowtype in the modeless window and it is set to
0.

Any thoughts on what I am doing wrong here???

Jim

Re: Non-Modal windows problem - VFP 9 by Dan

Dan
Tue Mar 28 15:19:04 CST 2006

If the form doing the calling is modal, all called forms will be modal.

Dan

Jim Czeb wrote:
> I am trying to instantiate several Non-Modal copies of a form in VFP
> from the currently running form. I have set all of the properties
> correctly as far as I know but, the forms end up being modal. I can
> move the top one around and click on objects but cannot access the one
> created before it without closing the last one it.
> I have queried the windowtype in the modeless window and it is set to
> 0.
>
> Any thoughts on what I am doing wrong here???
>
> Jim

Re: Non-Modal windows problem - VFP 9 by Gene

Gene
Tue Mar 28 16:01:23 CST 2006

[reordered to chronological]

On Tue, 28 Mar 2006 13:19:04 -0800, "Dan Freeman" <spam@microsoft.com>
wrote:

>Jim Czeb wrote:
>> I am trying to instantiate several Non-Modal copies of a form in VFP
>> from the currently running form. I have set all of the properties
>> correctly as far as I know but, the forms end up being modal. I can
>> move the top one around and click on objects but cannot access the one
>> created before it without closing the last one it.
>> I have queried the windowtype in the modeless window and it is set to
>> 0.

>> Any thoughts on what I am doing wrong here???

>If the form doing the calling is modal, all called forms will be modal.

Where is this documented? Is there any way around it?

I ran across this in adding an informational form to my app. I
use modal forms, except for this one. I ended up converting it into a
toolbar. This means that I can not use cut/copy/paste. Guess what my
boss asked for some time later.

Sincerely,

Gene Wirchenko