frx2word

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
    - installshield The InstallShield of VFP 9 really `scared` me.. So much complicated than VFP6's setup wizard... -- .~. Might, Courage, Vision. http://www.linux-sxs.org / v \ /( _ )\ Linux 2.4.31 ^ ^ 8:48pm up 37 min 5 users 1.57 1.66 Tag: frx2word Tag: 215029
  - 2
    - FPW2.6 check if report available programmatically I'm writing a program that uses a report. This program is usually compiled into .exes, and when building, the project manager finds the report and includes it in the .exe. However, this program is sometimes called from a standalone prg I run in the IDE. The report almost certainly won't be visible at run time and I don't want to make an identical copy elsewhere (although that would work.) What I would like to do is something like IF isexe() REPORT FORM report.frx TO PRINTER PROMPT ELSE REPORT FORM <full path to report>\report.frx ... ENDIF The best I've thought of is an ugly error trap: m.lno_frx=.F. ON ERROR m.lno_frx=.T. REPORT FORM report.frx TO PRINTER PROMPT ON ERROR IF m.lno_frx REPORT FORM <full path>.... ENDIF Any other ideas? -- TIA Andrew Howell Tag: frx2word Tag: 215019
  - 3
    - How to update characte(binary) field on dbf table using cursoradap i create a dbf table that have some binary char fields and i want to use cusroradaptier via ADO to update. it cannot update when execute tableupdate() command. aerror() get the error as following error : 1435 Microsoft Cursor Engine : Multiple-step operation generated errors. Check each status value. it is same error either set mapbinary property on cursoradapter object to .t. or .f. sample code : ******************** IF !file("c:\test\test.dbf") CREATE TABLE c:\test\test.dbf (testval c(10) nocptrans) APPEND BLANK USE endif set multilocks on oca=createobject("cursoradapter") oca.alias="catest" oca.buffermodeoverride=5 oca.cursorschema="TESTVAL M" oca.datasourcetype="ADO" oca.keyfieldlist="TESTVAL" oca.mapbinary=.T. oca.selectcmd="Select * From test" oca.tables="test" oca.updatablefieldlist="TESTVAL" oca.updatenamelist="TESTVAL test.TESTVAL" loConnDataSource = createobject('ADODB.Connection') loConnDataSource.ConnectionString = [Provider=VFPOLEDB.1;Data Source=c:\test;Password="";Collating Sequence=MACHINE;] loConnDataSource.Open() oca.DataSource = createobject('ADODB.RecordSet') oca.DataSource.CursorLocation = 3 && adUseClient oca.DataSource.LockType = 3 && adLockOptimistic oca.DataSource.ActiveConnection = loConnDataSource oca.cursorfill() SELECT catest replace testval WITH "test" IF TABLEUPDATE(1) else =AERROR(amessage) =MESSAGEbox(amessage(2)) endif ******************** i'm using vfp9. -- Ray Tag: frx2word Tag: 215018
  - 4
    - Third party tool required I need a third party tool to repair a corrupt dbf file. Thanx in advance Regards Nishu Tag: frx2word Tag: 215012
  - 5
    - What does this mean ? I have come across a code snippet which I am unable to understand - the color statement - Can anybody help me understand this thing ? What does these so many RGB means in the deffinition ? MODIFY WINDOW lw_invoice NOGROW ; COLOR RGB(0,0,0,192,192,192), ; RGB(0,0,0,255,255,255),,,,,,,, ; RGB(0,0,0,192,192,192) ; FONT "Courier New", 9 Tag: frx2word Tag: 215011
  - 6
    - How to make a user interface like Windows Explorer? Windows Explorer-style user interface is more kindly for user. how can I make it? TIA Song Tag: frx2word Tag: 215009
  - 7
    - 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: frx2word Tag: 215004
  - 8
    - [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: frx2word Tag: 215002
  - 9
    - 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: frx2word Tag: 215001
  - 10
    - 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: frx2word Tag: 214997
  - 11
    - 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: frx2word Tag: 214982
  - 12
    - 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: frx2word Tag: 214979
  - 13
    - 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: frx2word Tag: 214973
  - 14
    - PCL Codes Can you embed PCL printer codes to directly control the printer in a VFP report? Tag: frx2word Tag: 214971
  - 15
    - 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: frx2word Tag: 214963
  - 16
    - 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: frx2word Tag: 214962
  - 17
    - 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: frx2word Tag: 214960
  - 18
    - 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: frx2word Tag: 214955
  - 19
    - 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: frx2word Tag: 214953
  - 20
    - 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: frx2word Tag: 214948
  - 21
    - 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: frx2word Tag: 214945
  - 22
    - 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: frx2word Tag: 214942
  - 23
    - 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: frx2word Tag: 214938
  - 24
    - 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: frx2word Tag: 214931
  - 25
    - 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: frx2word Tag: 214926
- Next
  - 1
    - 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: frx2word Tag: 214922
  - 2
    - 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: frx2word Tag: 214918
  - 3
    - 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: frx2word Tag: 214912
  - 4
    - 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: frx2word Tag: 214908
  - 5
    - 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: frx2word Tag: 214905
  - 6
    - 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: frx2word Tag: 214904
  - 7
    - 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: frx2word Tag: 214903
  - 8
    - 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: frx2word Tag: 214891
  - 9
    - 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: frx2word Tag: 214890
  - 10
    - 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: frx2word Tag: 214885
  - 11
    - 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: frx2word Tag: 214880
  - 12
    - 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: frx2word Tag: 214865
  - 13
    - 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: frx2word Tag: 214863
  - 14
    - 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: frx2word Tag: 214860
  - 15
    - 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: frx2word Tag: 214855
  - 16
    - 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: frx2word Tag: 214847
  - 17
    - odbc dsn How can I create a system dsn programmatically Tag: frx2word Tag: 214844
  - 18
    - 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: frx2word Tag: 214843
  - 19
    - 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: frx2word Tag: 214842
  - 20
    - How to detect Word is running ... Hi, a question which should have been asked hundred times ... how to detect Word is running ? Tag: frx2word Tag: 214832
  - 21
    - 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: frx2word Tag: 214825
  - 22
    - 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: frx2word Tag: 214816
  - 23
    - 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: frx2word Tag: 214810
  - 24
    - 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: frx2word Tag: 214809
  - 25
    - 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: frx2word Tag: 214807

I use for my reports frx2word.
All reports works. But by some windows 2000 Computer with office 2000 it
dosnt work.It comes no Error Messages. But the doc file is empty.
Thanx
--
Cengiz Zengin
CZ Computer

Top