How to make a user interface like Windows Explorer?

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
    - Replace question and table precision * make sure there are no DBCs open create cursor zoot (zz n(3,1)) append blank replace zz with 9.9 ? zz && prints 9.9 replace zz with 999 ? zz && prints 999 The last replace command should not work, but it does. Why? I've learned from experience that VFP is pretty sloppy about numeric fields if the table is not associated with a DBC, but I figured they would have fixed this by now? Is this left in for legacy purposes? Tag: How to make a user interface like Windows Explorer? Tag: 215004
  - 2
    - [OT] User-Defined string Functions Transact-SQL <-> VFP Ladies and Gentlemen, I am pleased to offer, free of charge, the following string functions Transact-SQL: AT(): Returns the beginning numeric position of the nth occurrence of a character expression within another character expression, counting from the leftmost character. RAT(): Returns the numeric position of the last (rightmost) occurrence of a character string within another character string. OCCURS(): Returns the number of times a character expression occurs within another character expression (including overlaps). OCCURS2(): Returns the number of times a character expression occurs within another character expression (excluding overlaps). PADL(): Returns a string from an expression, padded with spaces or characters to a specified length on the left side. PADR(): Returns a string from an expression, padded with spaces or characters to a specified length on the right side. PADC(): Returns a string from an expression, padded with spaces or characters to a specified length on the both sides. CHRTRAN(): Replaces each character in a character expression that matches a character in a second character expression with the corresponding character in a third character expression. STRTRAN(): Searches a character expression for occurrences of a second character expression, and then replaces each occurrence with a third character expression. Unlike a built-in function Replace, STRTRAN has three additional parameters. STRFILTER(): Removes all characters from a string except those specified. GETWORDCOUNT(): Counts the words in a string. GETWORDNUM(): Returns a specified word from a string. PROPER(): Returns from a character expression a string capitalized as appropriate for proper names. RCHARINDEX(): Similar to the Transact-SQL function Charindex, with a Right search. ARABTOROMAN(): Returns the character Roman numeral equivalent of a specified numeric expression (from 1 to 3999). ROMANTOARAB(): Returns the number equivalent of a specified character Roman numeral expression (from I to MMMCMXCIX). AT, PADL, PADR, CHRTRAN, PROPER: Similar to the Oracle functions PL/SQL INSTR, LPAD, RPAD, TRANSLATE, INITCAP. More than 4000 people have already downloaded my functions. I hope you will find them useful as well. For more information about string UDFs Transact-SQL please visit the http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115 or http://nikiforov.developpez.com/ (the beautiful French language) Please, download the file http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115 With the best regards. Tag: How to make a user interface like Windows Explorer? Tag: 215002
  - 3
    - VFP 6: clear events with Nonmodal Forms You might recall my question not too long ago about copy-cut-paste with toolbars. I am now looking at using nonmodal forms. I have a couple of problems. 1) Where do I put the clear events command? If I do not have it, my program does not terminate when all forms are closed. Since any form might be the last, what is the best placement? If I am using a menu, then presumably, I put it in the exit selection, but if I am not using a menu, what do I do? I suppose that I can have if _screen.formcount=0 && or 1, I am not sure clear events endif in a suitable event's (.unload()?) code, but it looks kludgy. 2) What is the best way to store the object references (so the forms stay in scope)? A global array? Do you have hardcoded references to array elements, search for a free element, or do something else? Sincerely, Gene Wirchenko Tag: How to make a user interface like Windows Explorer? Tag: 215001
  - 4
    - VFP8 Intellisense issue I'm writing an ActiveX control (non-attributed ATL project in VS7). I've noticed a problem when testing this ActiveX control in Visual FoxPro 8 and 9. If I type "ThisForm.oleCtrl.", the trailing "." which triggers the intellisense code completion, causes vfp to shut down with a Buffer Overrun error message shown below. Anyone encountered this problem? Thanks, Greg ... Microsoft Visual C++ Runtime Library Buffer overrun detected! Program: ...ogram Files\Microsoft Visual FoxPro 8\vfp8.exe A buffer overrun has been detected which has corrupted the programs' internal state. The program cannot safely continue execution and must now be terminated. ... Tag: How to make a user interface like Windows Explorer? Tag: 214997
  - 5
    - Connecting To DBF Using vfpoledb I have the need to connect to a remote DBF table across the network. Currently, I able to do this using a mapped drive which maps to the remote system where the DBF is stored, as such. Provider=vfpoledb;Data Source= \\remoteserver\dbffiles\; Mode=ReadWrite;Collating Sequence=MACHINE; However, mapped drives can be finicky. Now, the purpose of this post is to ask; "Is there a better way to do this, without the need for a mapped drive?" Tag: How to make a user interface like Windows Explorer? Tag: 214982
  - 6
    - Printing on a dot matrix with vfp9 When I set report behavior 90, The fonts no longer print out correctly on a dot matrix printer. When I set report behavior 80 everything is fine. What Can I do to insure the fonts print out correctly? I tried saving the printer environment and it did not help. Sending output to generic text printer driver does not work well either. Tag: How to make a user interface like Windows Explorer? Tag: 214979
  - 7
    - Migration from XBase++ to Visual FoxPro 9 Hi, I am working on a project in Visual FoxPro 9 which will eventually replace the existing software written in XBase++. During this migration process, I will use the existing XBase++ tables with cdx indexes. Does anyone have any recommendations or any data recommendations during this migration. I seem to have random index problems. The problem will not be there and then it shows up. I then delete the index file and reindex with the XBase++ software and the VFP9 software will still show the error. I then open the free table and the index in VFP9 and then issue reindex (This is done without trying to browse the table). All is cured. The table is still accessable from XBase++ software and VFP9 software. Anybody know what is going on here and what I need to start doing in order to make this work? Thank you, Mike Tag: How to make a user interface like Windows Explorer? Tag: 214973
  - 8
    - PCL Codes Can you embed PCL printer codes to directly control the printer in a VFP report? Tag: How to make a user interface like Windows Explorer? Tag: 214971
  - 9
    - Change colors of the Window Globaly ? I want all the windows in my application - which is already running and using different back ground colors - to have a specific color say blue - irrespective of the colors the windows are defined with - ? Is it possible either ? I am looking for a solution like a hook which keeps on looking whenever a user defined window becomes visible OR no matter is defined its back ground color changes to that specific color. Tag: How to make a user interface like Windows Explorer? Tag: 214963
  - 10
    - CREATE OBJECT I develop application in vfp9 using the command CREATE OBJECT for link ole application and work fine with EXCEL, WORD and PP, but i cant do the same to link with WORDPAD or NOTEPAD, i will appreciate if could help to to fix these problem. Thanks. Tag: How to make a user interface like Windows Explorer? Tag: 214962
  - 11
    - writing map software Not sure if this is the right place or not, but does anyone know how mapping software is written? i'd like to write a baby program to map out my building and where the different meeting rooms are located (time and distance to each room from a disgnated spot, etc). if anyone has any suggestions please send me an email. Tag: How to make a user interface like Windows Explorer? Tag: 214960
  - 12
    - Keypress event F2 works in VFP6 but not VFP7 onwards I am converting an application from VFP6 to VFP9 and have discovered an issue that I hope someone can help with. I am trying to capture the F2 key being pressed within a textbox on a form in the keypress event (nKeyCode=-1). This would not work in VFP9 so after trying many things I built a basic form with one text control and a capture of the key press events to screen. It appears that in VFP6 the textbox keypress event happily tells me that F2 has been pressed, however in VFP7 onwards it appears that the F2 is not captured and nothing happens. The ON KEY LABEL is not active and F3, F4 etc are all working e.g. nKeyCode=-2, nKeyCode=-3 etc. This happens only with F2 (nKeyCode=-1). Does anyone know why? Is there something I am missing? This seems too simple an issue to be a bug? Thanks John R. Tag: How to make a user interface like Windows Explorer? Tag: 214955
  - 13
    - DOS Filenames I am integrating an ActiveX control into my app. One of the properties is 'FileName'. Works fine till the property is set to a string containing the '~1' characters one gets from SYS(2023). Is there a utility/command that will convert the DOS path to a the real pathname? tnx, Howard Tag: How to make a user interface like Windows Explorer? Tag: 214953
  - 14
    - Foxpro dll and Installshield I built a multithreaded com server (dll) in FoxPro 9 and put it into my installshield to install. When it tries to build the installer I get this message. The build was unable to extract COM information from the file <my dll file> in component <my dll file>. Please ensure that the file is self-registering and verify that the self-registration process does not fail. I can register it fine manually with regsvr32 but I do not want to manually register it. Is there any way around this or do I have to manually register this? -- TIA Altman VFP9 Tag: How to make a user interface like Windows Explorer? Tag: 214948
  - 15
    - Predict Page Count When printing out a report, is there a way of counting the pages before you print them so that you can print something like Page 1 of 20. page 2 of 20 etc: on each page in the header? TonySper Tag: How to make a user interface like Windows Explorer? Tag: 214945
  - 16
    - VFP6: open excel file and dump to .dbf Need to open a spreadsheet (Excel 2k) and dump contents to .dbf file using VFP6. Pretty generic really, sorry if this request isn't a challenge! Any sample type code would be appreciated. - Ben Tag: How to make a user interface like Windows Explorer? Tag: 214942
  - 17
    - Rounding question and trig functions set decimals to 4 ? SIN(1)*COS(1) 0.45464871 ? .5*sin(2) 0.45465 VFP rounds the result, but why does the first get rounded to 8 digits, and the second get rounded to 5? SIN(1)*COS(1) is the same number as .5*sin(2), but VFP somehow treats the above calculations differently. If I put them in the watch window, they display the same as what is printed to _screen, with the same inconsistent rounding. Tag: How to make a user interface like Windows Explorer? Tag: 214938
  - 18
    - sys(1500) This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C5A28A.658070B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am just experimenting with this command. On a form with an editbox and = a commandbutton I have this code in the commandbutton click() _CLIPTEXT =3D "Hello world"=20 ThisForm.Edit1.SetFocus() SYS(1500, '_MED_PASTE', '_MEDIT') thisform.Refresh() The first time I click the button the edit cursor appears in the edit = box but nothing else. Thereafter every time I click the commandbutton, = the phrase appears as expected in the edit box, concatenating with the = previous paste.. Can somebody explain why it doesn't appear the first time? Many thanks Stephen ------=_NextPart_000_0006_01C5A28A.658070B0 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.2722" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I am just experimenting with this = command. On a=20 form with an editbox and a commandbutton I have this code in the = commandbutton=20 click()</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>_CLIPTEXT =3D "Hello world"=20 <BR>ThisForm.Edit1.SetFocus()<BR>SYS(1500, '_MED_PASTE',=20 '_MEDIT')<BR>thisform.Refresh()</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>The first time I click the button the = edit cursor=20 appears in the edit box but nothing else. Thereafter every time I click = the=20 commandbutton, the phrase appears as expected in the edit box, = concatenating=20 with the previous paste..</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Can somebody explain why it doesn't = appear the=20 first time?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Many thanks</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Stephen</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0006_01C5A28A.658070B0-- Tag: How to make a user interface like Windows Explorer? Tag: 214931
  - 19
    - Append data into excel file Dear All, Do anyone know how to append data into excel file from dbf file. Thanks for any reply or solution Choi Tag: How to make a user interface like Windows Explorer? Tag: 214926
  - 20
    - MYSQL Database Has anyone converted a MySql database to a VFP table? I have a guy who has his database on MySql and would like me to enter it into a VFP Database table. I have not looked at it yet so do not know what to expect. Any ideas?? TonySper Tag: How to make a user interface like Windows Explorer? Tag: 214922
  - 21
    - won't stay docked every time I open vfp8 I need to uncheck the dockable on all windows. How do I make it permanent? thanks sherry Tag: How to make a user interface like Windows Explorer? Tag: 214918
  - 22
    - Using custom PAGE objects in a custome PAGEFRAME Hi I have been reading 1001 Things which seems to mainly reference VFP 6. I am trying to create a base _PAGE class for use in my base _PAGEFRAME class with some custom methods and properties. I can't work out how to trick my _PAGEFRAME to use my _PAGE class rather than the standard VFP Page object. In 1001 we are told that you cannot visually create a Page object - clearly this is no longer the case with VFP 9 so can anyone tell me how i can implement my visual _PAGE object? -- Kind regards Phil Hollingworth phil@wrltd.co.uk System spec: Win2k3 / VFP 9 (All fully service packed / updated etc) Tag: How to make a user interface like Windows Explorer? Tag: 214912
  - 23
    - Derfining a color Scheme ? How can I define a Color scheme at runtime based on the color scheme of certain control ? Want to have separate values for Red, Green and Black instead of using a single color value ? Tag: How to make a user interface like Windows Explorer? Tag: 214908
  - 24
    - Custom window Color ? I want to set the color of a window which is to be determined at run time .. will be picked from the property of a color ? Don't know how to set it up like this ? Tag: How to make a user interface like Windows Explorer? Tag: 214905
  - 25
    - Define a Window with Custom Color ? I want to define a window which should borrow a color from another controls Back Color Property to be determined at run time ? Not aware how to set it up ? Urgent pls help ? Tag: How to make a user interface like Windows Explorer? Tag: 214904
- Next
  - 1
    - Statusbar Color Scheme ? Can anybody tell me what color scheme is used by the VFP 8.0 StatusBar ? I want to use my own status bar but with the same color scheme as being used by the VFP StatusBar. My Statusbar control will appear in only selected segments of the application. Tag: How to make a user interface like Windows Explorer? Tag: 214903
  - 2
    - Protecting your code Hi, How to protect your code when distributing class libraries (vcx) and Databases. How to stop some customer to make "improvements" to your stored procedures? I do not want to include the Databases and or class libraries in the project(s) as some of the libraries are shared by multiple APP/EXE and the Databases need to change depending on customer needs (like for example adding a new index to a table or to repair indexes and reestablish relations). Is there a way to make the source code (equivalent to a prg) disappear? Tag: How to make a user interface like Windows Explorer? Tag: 214891
  - 3
    - Menu Path solve Taking the "IN LOCFILE(.....) portion out of the menu generator allows menues truely to be integrated in APP/EXE files. With the standard menu generator you will have to include the menu.mpx in the original location which also does not allow to make a true setup where the enduser selects the destination directory. Scenario. app directory: F:\myproject source fiels: F:\myproject\source The menu on the developing machine with the other SCX and prg is in the source directory. Running the "standard" Menu generator will generate some code like ON SELECTION PAD _1hv06ai6t OF (m.cMenuName) ; DO _1hv06ai6u ; IN LOCFILE("\Myproject\sourc\MyMENU" ,"MPX;MPR|FXP;PRG" ,"WHERE is MyMENU?") Now if on the destination machine there is no directory Myproject\source then the above menu code will popup that file selection box asking for the MyMENU even though the menu had been included in the project and compiled into the app file and had been already executed with the "DO Mymenu.mpr ....." Command earlier in the code. Changing the code to ON SELECTION PAD _1hv06ai6t OF (m.cMenuName) ; DO _1hv06ai6u - ommitting the LOCFILE part will work and resolve the above problem. Tag: How to make a user interface like Windows Explorer? Tag: 214890
  - 4
    - True case structure of file path? Hi. Believe it or not, I'm using Visual FoxPro to generate JavaScript code. This code references images found on a web site. Problem. The server must be case sensitive. In other words, if I generate [./ygl casket offerings/metal caskets/premier metals/pharaohfrontppt_thumb.jpg], I get file not found. I need to generate [/YGL Casket Offerings/Metal Caskets/Premier Metals/PharaohFrontPPT_thumb.jpg]. Is there a function or utility that will retrieve the true case structure of a given file and it's path? The only other option is to convert all files and folders to lowercase before publishing them in Frontpage. Any advice would be really appreciated...Dennis Tag: How to make a user interface like Windows Explorer? Tag: 214885
  - 5
    - How to kill a process? This is a multi-part message in MIME format. ------=_NextPart_000_0036_01C5A18A.6426CB70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I want to be able to kill a process that is running (W2K or XP). I know = I saw a Win API call for this, but can't find it now. ------=_NextPart_000_0036_01C5A18A.6426CB70 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.2668" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I want to be able to kill a process = that is running=20 (W2K or XP). I know I saw a Win API call for this, but can't find it=20 now.</FONT></DIV></BODY></HTML> ------=_NextPart_000_0036_01C5A18A.6426CB70-- Tag: How to make a user interface like Windows Explorer? Tag: 214880
  - 6
    - Serial Port. Hi, I am supposed to interface with the serial port (RS232) from a VFP9.0 app. Need to send. receive set baud rate etc. Now I have not done that since DOS 5.0 (guess I am old). So any libraries, OCXs, controls to do that TIA Tag: How to make a user interface like Windows Explorer? Tag: 214865
  - 7
    - Foxpro 8.0 can't find network printer I'm running Foxpro 8.0 and a wired ethernet network. setting my printer like this: set printer to \\pos1\receipt1 everything works fine until I turn on my DSL modem which is attatched to the USB port. Then foxpro can't find the network printer. After about 3 mintues it finally finds the printer. If I cut the modem off, foxpro immediately finds the modem. Any ideas will be appreciated! John Tag: How to make a user interface like Windows Explorer? Tag: 214863
  - 8
    - Quiting Programs Im using an external command in visual foxpro, the problem is that the external program does not quit or exit when i quit my program in visual foxpro this is the command is used : 'RUN /N7 psc.exe' any idea.... thanks gernan Tag: How to make a user interface like Windows Explorer? Tag: 214860
  - 9
    - Need help! Need older version of FoxPro and/or help. I was a database developer using FoxPro back in the early to mid 90s. (I cannot remember which version we used.) I have not touched FoxPro since 95 and do not have the program or manuals from what ever version that may have been. I got Visual FoxPro version 8.0 a couple of years ago and I'm just now trying to get into it. I have to say I don't like it a bit! I was very comfortable with the older environment where all the code was written out in command files, except for reports and forms. The help file in version 8.0 does not include enough of the old commands and syntax for me to develop my program command files. I also do not like the form and report generators. I am not writing just to complain, rather I would like some help to see if any of you would know what version was used 10 years ago and if anyone has an old copy they would part with. I really need the help file! I know I should learn the newer version, but I'm just an old dog. Does anyone have any ideas? I would kill for all of my old source code, but that belonged to the company which was sold in 95. Thank you, Doug Maples -------------------------------------------------------------------------------- Tag: How to make a user interface like Windows Explorer? Tag: 214855
  - 10
    - Resolving Path I got a form class with the following custom properties menu - which contains the menu name for the form defpopup - which contains the default popup to get opened on the form This is the code in the init snipped DO (THIS.MENU) WITH THIS, THIS.TAG IF TYPE("THIS.DefPopup") = "C" AND !EMPTY(THIS.DefPopup) AND POPUP(THIS.DefPopup) ACTIVATE POPUP (THIS.DefPopup) NOWAIT ENDIF etc. etc Works great - only problem is that when I distribute the app only I also got to distribute the mpx or I get an error - Now the menu is included in the project and the command DO (THIS.menu).... works fine - so in this case it can find the menu inside the app/exe files only if the mpx is missing the command ACTIVATE POPUP ... will open up a window looking for the mpx. Any way to avoid that? Also same seems to be true for frx files. REPRORT FORM (lc_reportname) will look on the disk and not inside the app where the report is located. TIA Tag: How to make a user interface like Windows Explorer? Tag: 214847
  - 11
    - odbc dsn How can I create a system dsn programmatically Tag: How to make a user interface like Windows Explorer? Tag: 214844
  - 12
    - push char into Windows keyboard buffer I don't know Visual C++ so I was planning to do it with Foxpro. How could I [rogrammatically push key into the Windows buffer (so that another app that's in focus would get it)? Is it as simple as calling the right Win32API? Which one? -- .~. Might, Courage, Vision. http://www.linux-sxs.org / v \ /( _ )\ Linux 2.4.31 ^ ^ 11:24pm up 6 days 10:52 load average: 1.12 1.25 2.13 Tag: How to make a user interface like Windows Explorer? Tag: 214843
  - 13
    - Exchange GUI/Service Interface Architecture Does anyone know if the Exchange GUI/Service interface is based on SNMP or some other standard? We have a Visual FoxPro application that we want to turn into a service and are looking at different ways to implement the GUI interface to the service. We want similar results to how Exchange works: it runs as a service, or a as several services, but you can launch a GUI to get information about it and administer it. Is SNMP an appropriate choice for this sort of interface? Any pointers along these lines would be greatly appreciated. Thanks! -- tom c Tag: How to make a user interface like Windows Explorer? Tag: 214842
  - 14
    - How to detect Word is running ... Hi, a question which should have been asked hundred times ... how to detect Word is running ? Tag: How to make a user interface like Windows Explorer? Tag: 214832
  - 15
    - date time field to date Dear All, Would anyone tell me how to convert date time field to date field. thanks in advance wa Tag: How to make a user interface like Windows Explorer? Tag: 214825
  - 16
    - VFP6: SQL deadlock (1526) Still having a problem with inadvertent SQL deadlocks when I use my remote view. Can't nail down when/why. Is there any way to set the view read-only or prevent the deadlock with another SQL process? Or, what would be the best way to handle when I encounter this? Right now the program just stops. Thanks in advance for any advice. - Ben Tag: How to make a user interface like Windows Explorer? Tag: 214816
  - 17
    - How to determine if an index tag exists Is there any way to determine if a specified index tag exists for any given alias? I have looked at KEYMATCH() but this needs you to know the index number. -- Kind regards Phil Hollingworth phil@wrltd.co.uk System spec: Win2k3 / VFP 9 (All fully service packed / updated etc) Tag: How to make a user interface like Windows Explorer? Tag: 214810
  - 18
    - specifying format in SQL Hello and thanks in advance for the help. How do you specify the format of a field in and SQL query? Example: I have a field called OPEN_BAL which is N (9,2). All values are > 0. I have another field called TRAN_TYPE which is C(1) and can have the value 'D' or 'C' For reporting purposes I need the 'C' types to subtract so I have a query: SELECT IIF(TRAN_TYPE = 'C', OPEN_BAL * -1, OPEN_BAL) AS OPEN_BAL.... This works fine except that the resulting field size in the query output is 9,2. If OPEN_BAL happens to be > 100,000.00 (example 123,456.78) the value will be -123,456.7. I need to tell the query to have the resulting field be N (10,2) so that it can accomodate the possible 6 digit number without losing a digit. Can someone tell me what I have to do to make this happen? Thanks, Jeff Tag: How to make a user interface like Windows Explorer? Tag: 214809
  - 19
    - array[2,1] vs array[2] gotcha It turns out INSERT INTO <alias> FROM ARRAY <array> can insert more than 1 record. This is not documented and appears to be controlled by whether the array is dimensioned with 2D syntax or not. I'm sure it's old news but it had me scratching my head for a few minutes, thinking someone else's code was wrong. Then realising it was in fact working but I couldn't see why (he was selecting a field to an array so the DIMENSION clue wasn't visible.) CREATE CURSOR test (test C(10)) DIMENSION foo[2] foo[1]='record1' foo[2]='record2' ?foo[1] ?foo[2] * this inserts 'record1' only INSERT INTO test FROM ARRAY foo DIMENSION foo[2,1] ?foo[1] ?foo[2] * this inserts both records INSERT INTO test FROM ARRAY foo -- Regards Andrew Howell Tag: How to make a user interface like Windows Explorer? Tag: 214807
  - 20
    - grid.column.textbox.valid() could lock focus A form with one commandbutton and a grid. Grid has one column. Column1.currentcontrolset is a textbox. Code in grid.column1.textbox.valid(): if empty(this.value) return .f. endif return .t. I found that whether the textbox.value is empty or not, the commandbutton could always be pressed. The textbox.valid() didn't stop textbox.lostfocus() from happening when the object clicked is a commandbutton. Why? And how could I prevent that? Tag: How to make a user interface like Windows Explorer? Tag: 214796
  - 21
    - Transfering general data currently i can import image files to a general field, but how can i transfer from one field to another in different table ? transfer from TABLEA.GenFieldA to TABLEB.GenFieldB pls help. Tag: How to make a user interface like Windows Explorer? Tag: 214795
  - 22
    - Error Handling I really like the TRY..CATCH, but I have a pretty good error handler build into my current large application. It writes to an ERRORLOG so I can check it every week for those errors the users never report. Should I leave the ON ERROR DO ErrorHandler WITH ERROR(),PROGRAM(),LINENO(1)... in my current app, and then in the CATCH DO ErrorHandler WITH ERROR(),PROGRAM(),LINENO(1)... or not even bother with it?? Thanks for your advice Tag: How to make a user interface like Windows Explorer? Tag: 214791
  - 23
    - foxpro position avaliable around los angeles hi, looking for a foxpro middle level programmer, 2+ year experience would be good. job located around los angeles, interested party please call 626.964.8862 and ask for tony. Tag: How to make a user interface like Windows Explorer? Tag: 214790
  - 24
    - Error Handling I really like the TRY..CATCH, but I have a pretty good error handler build into my current large application. It writes to an ERRORLOG so I can check it every week for those errors the users never report. Should I leave the ON ERROR DO ErrorHandler WITH ERROR(),PROGRAM(),LINENO(1)... in my current app, and then in the CATCH DO ErrorHandler WITH ERROR(),PROGRAM(),LINENO(1)... or not even bother with it?? Thanks for your advice Tag: How to make a user interface like Windows Explorer? Tag: 214789
  - 25
    - Determine user's permissions on network server This is a multi-part message in MIME format. ------=_NextPart_000_0013_01C59D95.3E62AFB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I need to find a way to determine a user's permissions on a network = folder. Specifically, I need to know if a user has more than list or = read-only access to a know folder. Our servers are running Win2000 = server or Win2003, the work stations are running XP. I'm still = developing with VFP5. Thanks in advance. Steve ------=_NextPart_000_0013_01C59D95.3E62AFB0 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.2668" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3D"Comic Sans MS" size=3D2>I need to find a way to = determine a=20 user's permissions on a network folder.  Specifically, I need to = know if a=20 user has more than list or read-only access to a know folder.  Our = servers=20 are running Win2000 server or Win2003, the work stations are running = XP. =20 I'm still developing with VFP5.</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2>Thanks in = advance.</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" = size=3D2>Steve</FONT></DIV></BODY></HTML> ------=_NextPart_000_0013_01C59D95.3E62AFB0-- Tag: How to make a user interface like Windows Explorer? Tag: 214784

Windows Explorer-style user interface is more kindly for user. how can I
make it?

TIA

Song

Re: How to make a user interface like Windows Explorer? by Eric

Eric
Thu Aug 18 00:40:56 CDT 2005

Are you referring to the toolbars? VFP has its own toolbar class which can
do pretty cool things. And VFP8 and up respect Windows XP Themes settings.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts
VFP MVP

"Song ZhongLiang" <Song@pumch.ac.cn> wrote in message
news:Ow1EvE6oFHA.3828@TK2MSFTNGP12.phx.gbl...
> Windows Explorer-style user interface is more kindly for user. how can I
> make it?
>
> TIA
>
> Song
>

Re: How to make a user interface like Windows Explorer? by swdev2

swdev2
Thu Aug 18 08:32:34 CDT 2005

Yo Song -
sometimes ppl like the 'OutLook' type of Look and Feel, as well -
there are some Outlook ToolBars that work with VFP - check the d/l section
at
www.universalthread.com

Also - have u posed yer question to the great Guru who lives at
www.vfptop.com ?
xie xie [Bill]
--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.dotnetconversions.com
"Song ZhongLiang" <Song@pumch.ac.cn> wrote in message
news:Ow1EvE6oFHA.3828@TK2MSFTNGP12.phx.gbl...
> Windows Explorer-style user interface is more kindly for user. how can I
> make it?
>
> TIA
>
> Song
>
>

Re: How to make a user interface like Windows Explorer? by Song

Song
Thu Aug 18 20:54:41 CDT 2005

Thank you two£¬Eric and swdev2.

Song

"swdev2" <wsanders@dotnetconversions.bob.com> wrote in message
news:umxPHk$oFHA.3120@TK2MSFTNGP09.phx.gbl...
> Yo Song -
> sometimes ppl like the 'OutLook' type of Look and Feel, as well -
> there are some Outlook ToolBars that work with VFP - check the d/l section
> at
> www.universalthread.com
>
> Also - have u posed yer question to the great Guru who lives at
> www.vfptop.com ?
> xie xie [Bill]
> --
> ===================
> William Sanders / EFG VFP / mySql / MS-SQL
> www.efgroup.net/vfpwebhosting
> www.dotnetconversions.com
> "Song ZhongLiang" <Song@pumch.ac.cn> wrote in message
> news:Ow1EvE6oFHA.3828@TK2MSFTNGP12.phx.gbl...
>> Windows Explorer-style user interface is more kindly for user. how can I
>> make it?
>>
>> TIA
>>
>> Song
>>
>>
>
>