Syntax colloring

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
    - DBC's store procedures I see that VFP 9 have alot of DBC's event store procedure. which can be trigger during opening of DBC or DBF and a whole bunch of events. Question : VFP 6 also have store procedure. but does it support the events when a database or is being open like what is offer by VFP 9 ? Thanks! Tag: Syntax colloring Tag: 205867
  - 2
    - Audit trail I would like to write one line of text to a file each time an event occurs and just keep appending the text. I have tried the set device to file but each time I write to the file it just keeps overwriting the file. I have tried the append but it appears I do not know what I am doing. Can someone give me a hand?? TonySper Tag: Syntax colloring Tag: 205865
  - 3
    - OCX Not Registering I have a VFP6 application that has been running fine on several W98 workstations for several years now. Recently we upgraded some of the workstations to XP. I have run the original application setup, but I found out some active-x controls are not registering in XP. I guess I have to manually register them using regsvr32.exe. Can anybody tell me what ocx's I need to copy and register for "active-x slider" control Thanks Tag: Syntax colloring Tag: 205861
  - 4
    - how to control whether a summary will be displayed in a report or not I want to programatically control whether the Summary will be available in the report or not. Currently if i try to do so, i get a blank page in the summary (but i don't even want a blank page). Any ideas? Tag: Syntax colloring Tag: 205858
  - 5
    - VFP and VS Quick question: Why VFP is not included in Visual Studio after version 6 ? Tag: Syntax colloring Tag: 205856
  - 6
    - vfp 9 toolbox not dockable I can't seem to dock the toolbox in VFP9 i right clicked the title bar, & nothing happens - documentation says that a context menu should appear, but no!!! what haven't i done? Tag: Syntax colloring Tag: 205852
  - 7
    - printing in a dot matrix printer and receipt printer Hello, i am using VFP 7.0 on Windows XP Platform, i have 3 printer ports installed on the computer the LPT1 is a laser printer and is the default, the LPT2 is a Dot Matrix Printer Okidata MicroLine 320 Turbo and the LPT3 is an EPSON TM U220 Receipt Printer. I can Print correctly the information, im using ? and ?? commands but the printer feed the paper and dont stop until the amount of paper is as big as a letter size sheet, the paper size determined for Windows for this Printer is Letter Size, and dont allow me to use a User Defined paper size, the same problem is with the receipt printer, i have tried several things like using reports but the results is not what i want, i appreciate your help, thank you, and your are welcome to ask for my help in any question that i can help you, thank you again and sorry for the long message -- Lazaro Del Rio System Analyst DREAM ISP Tag: Syntax colloring Tag: 205846
  - 8
    - Strange View Problem I have a view that works just fine and has 4 tables in it joined together. If I open it in the view designer, one table is missing(you can see the whole). If I do nothing to the view and just save it, it errors on the field in the missing table. If I add the table in, it errors on another field that was/is in the field list. After the error, I keep getting the error when I try to modify the view. I can't get it open. This is a very compicated view that I do not wish to recreate. Any ideas? As a work around, can I add a field to the view programmatically with dbsetprop() . The field is in a table that already exists in the view. Thanks for your help. Cory Bonallo Developer Tag: Syntax colloring Tag: 205845
  - 9
    - report design question Using VFP 7. Report in general looks like this Port id Acnt ID Acnt Description Charge Paid IRA ____________________________________________________________ 1234567 this is the main port casper 7 Starting accouint 10,994.66 625.00 n kelly 27 New accouint 325.23 18.00 n 12346528 The next port monday daily record 9.356.28 0.00 y Anyway. hope you get the idea. I am trying to do it using the wizard. Data comes from 2 free tables. My problem is getting it group like this. It's like a column but with colums 3-5 starting under colume 1-2. Trying to do this so it will fit on portrait size doc. Thanks , Kent Tag: Syntax colloring Tag: 205843
  - 10
    - VFP 6: Good Non-GUI Editor to Use The editor that I have been happily using for ages (WordStar 2000, since 1988) will not work on the new system that I am using. Apparently, it and Windows have issues. I want to find a suitable replacement. My most important criteria are: Non-GUI: Selected text does not work well for me for block operations as I frequently do find start of text, mark start of block, find end of text, mark end of block, perform block operation. I need to be able to search between defining the start and end of the block. Inexpensive: shareware, freeware, public domain, or the like. Configurable keys: This would be very useful though not mandatory. Failing this, the editor should use control key combinations rather than function keys. If you use an editor like this, what is your choice? Why? Where is it available from? Sincerely, Gene Wirchenko Tag: Syntax colloring Tag: 205835
  - 11
    - installshield for vfp; included files Since this is a special "VFP9" version of InstallShield, wouldn't you think it would include a project template for VFP9, rather than for VB and everything else we don't need? Also, how can I know what redistributables are required for my application? There's a long list of them, including eight separate ones named "Microsoft Visual FoxPro 9 Resource", plus three other VFP9 files. I know I need the runtime libraries, but what about the others? I need some of the C libraries too, I think, but I don't know which. Does anyone have this information? Is it documented anywhere? Again, since this is a special VFP9 version of InstallShield, the ones we need ought to be made obvious somehow. Tag: Syntax colloring Tag: 205821
  - 12
    - cursors not being deleted Using vfp8 on windows 2000 and xp. Alot but not all cursors are not being automatically deleted.I thought when the application closed the cursors would automatically be deleted. If I'm wrong, what should I do to correct the problem. They are not causing errors (I don't think) but they are taking a lot of space. Thanks sherry Tag: Syntax colloring Tag: 205819
  - 13
    - How to get the Date portion of an SQLServer DateType field? I'm trying to import an SQLServer table into Visual FoxPro (I've also posted this in the SQLServer forum). I need to test the Date portion of a SQL Server DateTime field against a user-entered Date. I tried the following: m_getagsc = SQLPREPARE(gnConnHandle, "SELECT * FROM AgentStateChange "+; "WHERE AgentStateChange.ToState > 2"+; " AND TTOD(AgentStateChange.Time) = ?m_rptdate", "agsc") m_getagsc = SQLEXEC(gnConnHandle) After this statement, m_getagsc = -1. This works without the "AND TTOD(AgentStateChange.Time) = ?m_rptdate". m_rptdate is a variable containing the user's entered date. TTOD() is Visual FoxPro's function for returning the Date portion of a DateTime field. What am I doing wrong? Thanks, GaryZ Tag: Syntax colloring Tag: 205798
  - 14
    - File(dbf) getting locked Hello EveryOne , I am using FoxFro Dos2.6 , we have a file(DBF.) accesed my multiple people in the office , everything will work fine but soemtimes the file(DBF.) gets locked and won't release unless we reboot . We keep getting the message can't access locked file , press ESc. Please Help as wht could cause the problem or how to solve it . Thanks a lot in advance. Tag: Syntax colloring Tag: 205797
  - 15
    - Cursoradapter wheretype recommendation We currently have our cursoradapter class wheretype set to the default of 3 - KEY AND MODIFIED. On some files we are getting the error SQL statement too long. We know we can set SYS(3055) to get around this problem but were wondering if we really should be using a wheretype of 1 - KEY only when the table has a primary key value. Is Wheretype only used by the updatecmd method? What problems might we hit if we have this set to 1. We are a bit wary that we might upset something. Thanks for any help, Bernie Tag: Syntax colloring Tag: 205796
  - 16
    - Why comes such error? This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C4F8E0.497343B0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable In vfp8 or former version, I can use the following sql sentences: Select distinct Alltrim(Badrs) From Emp Order By Badrs Into Cursor = TempCurs */* Badrs is one field of table emp But in vfp9, It's a wrong sentences? Why vfp9 hv such difference from the former version? Best Regards Chuen ------=_NextPart_000_000A_01C4F8E0.497343B0 Content-Type: text/html; charset="gb2312" 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=3Dgb2312"> <META content=3D"MSHTML 6.00.3790.218" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>In vfp8 or former version, I can use = the following=20 sql sentences:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial color=3D#800000 size=3D2>Select distinct = Alltrim(Badrs) From=20 Emp Order By Badrs Into Cursor TempCurs</FONT></DIV> <DIV><FONT face=3DArial size=3D2>*/* Badrs is one field of table = emp</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>But in vfp9, It's a wrong = sentences?</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Why vfp9 hv such difference from the = former=20 version?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Best Regards</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Chuen</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_000A_01C4F8E0.497343B0-- Tag: Syntax colloring Tag: 205793
  - 17
    - How to get VFP based program out if Internet is disconnected? I have a client running my purely VFP based program in terminal service environment. Sometimes, they donâ??t get the program out properly for some reasons, say Internet connection. The program is still running in the server. I know if reboot the server, the program can be terminated. But there are a few users using the server at the same time. I prefer to let users terminate the application via a program. Event binding may be used for this case. Any ideas? TIA. Tag: Syntax colloring Tag: 205790
  - 18
    - Integartion of a Foxpro 2.6 for windows application with a COM dll Is it possibe to integrate a Foxpro 2.6 for windows application with a COM dll. I would really appreciate the help. Thanks, Joyce. Tag: Syntax colloring Tag: 205789
  - 19
    - Problem with 'Snap To Grid' After Upgrade to VFP9 I just upgraded to VFP9 and now when working with all my existing forms, the designer tools and controls 'Snap to Grid' even though the I have the 'Snap to grid' box unchecked on the forms tab in the Options form. Additionally, I have set the Horizontal and Vertical spacings to 1 pixel each and the grid appears to be set at 12 regardless of what I have set it at.. With new forms, the cursor (mouse) does not snap to the grid. It only happens with the forms that existed prior to the VFP9 install. It is the beta version of VFP9 that I have installed. I can go back into VFP8 and do not have the problem. Has anybody else experienced this? Is there a way to reset the grid size? -- Jim D Tag: Syntax colloring Tag: 205782
  - 20
    - Remote Automation using Visual Foxpro Hi... Is there anybody found a way to overcome the "RestrictRemoteClients" setting on Windows XP SP2 (of course without set it to 0) ? But I believe (correct me if I am wrong), this shall be solve by Microsoft because there is no command under Foxpro which can control the RPC call. All the RPC call is done by Foxpro. Does Microsoft plan a SP for Visual Foxpro 8 to solve this issue or it has been incorporated to Visual Foxpro 9 ? Thanks in advance .... Rudy Tag: Syntax colloring Tag: 205781
  - 21
    - child nodes in XML files Hi Friends I need to create a XML file in the following format <?xml version=â??1.0â?? ?> Processing Instruction (1 of this type *). <Rootnode> Main Root Node â?? only one of these allowed. <ChildNode> Start of Child nodes (Records). <Field1>MyData</Field1> Start of Data (Fields and Values). </ChildNode> <ChildNode> Start of Next Record. <Field1>MyData</Field1> Start of Data (Fields and Values). </ChildNode> </Rootnode> and i've following code LOCAL oXMLadapter as XMLAdapter oXMLadapter = CREATEOBJECT("XMLAdapter") WITH oXMLadapter .AddTableSchema('nhi') && content parent node .AddTableSchema('medical') && child .AddTableSchema('diagnosis') && child .ForceCloseTag= .T. && maintain open and close tags .RespectCursorCP = .T. .UTF8Encoded = .T. *--XML file will created according to XSD file (schema) .XMLSchemaLocation = "C:\OpthalmologyVirtualConsultationPatientSchema.xsd" .ToXML('c:\xx.xml',,.T.) ENDWITH my abv code displaying child nodes as different parents i mean <?xml version=â??1.0â?? ?> Processing Instruction (1 of this type *). <Rootnode> &&this is NHI <Rootnode2> &&medical <Field1>MyData</Field1> Start of Data (Fields and Values). </Rootnode2> <Rootnode3> && diagnosis <Field1>MyData</Field1> Start of Data (Fields and Values). </Rootnode3> </Rootnode> any ideas on how to fix this Thanks -- cheers Tag: Syntax colloring Tag: 205780
  - 22
    - Pass data to Excel option button caGood day everybody, I am trying to control the Excel option button via VFP 8.0 Example : The option buttons in Excel are OptA, OptB, OptC My user input "1" in my VFP form, I need to make OptA.value = True. I tried macro recording in Excel but no code generate for option button selection, so I have no idea how to program it. I will appreciate if anyone can help me. Have a nice day. Best regards, Julie Tag: Syntax colloring Tag: 205778
  - 23
    - exclude a field in final output XML file Hi friends I am using xmladapter class to create xml files and my following code working fine. LOCAL oXMLadapter as XMLAdapter oXMLadapter = CREATEOBJECT("XMLAdapter") WITH oXMLadapter .AddTableSchema('nhi') && content to the xml file .ForceCloseTag= .T. && maintain open and close tags .RespectCursorCP = .T. .UTF8Encoded = .T. *--XML file will created according to XSD file (schema) .XMLSchemaLocation = "C:\OpthalmologyVirtualConsultationPatientSchema.xsd" .ToXML('c:\xx.xml',,.T.) ENDWITH and i've quick question i've a column in my cursor(nhi) which i dont want see in final XML file.my schema file does not have that element in it but still TOXML method still create that column in final output file. is there any way to exclude that column in final XML file ?? Thanks for ur ideas -- cheers Tag: Syntax colloring Tag: 205774
  - 24
    - newsgroup phrases & acronyms what do the following stand for, OTOH, Coffee Machine, & a whole lot of other such phrases & acronyms?? Where can i get a list of such phrases (at least a few). Becuase sometimes i find it tough to understand what they mean... FOr instance, i guessed that OTOH = On The Other Hand Thanks in advance, Paul Tag: Syntax colloring Tag: 205769
  - 25
    - VFP 9 reports how can i generate a bar graph from VFP 9? Jack Tag: Syntax colloring Tag: 205767
- Next
  - 1
    - FRX reference I need the ability to programmatically create/alter reports on the fly depending on certain situations the users are in. Is there a reference article or something to explain what each field and code means in the .FRX file? Thanks, Scott Tag: Syntax colloring Tag: 205766
  - 2
    - Help: Error when adding VFP 9 form to VSS Hello all I am trying to convert a VFP project from 8 to 9 and when I try to add a form to VSS I am getting this error. Error #9 in sortmethods (1349) Data Type mismatch. Has anyone run into this before and have a solution to this. Help on this is greatly appreciated. - Art Tag: Syntax colloring Tag: 205762
  - 3
    - Setting background color for individual cell in grid Does anyone know a way to do this? VFP9. I'm working on something which ideally needs to emulate Excel functionality with a DBF and keep the formatting intact, but also keep the data in a DBF file. Any ideas on a better approach than grids much appreciated. Thanks, Neil Tag: Syntax colloring Tag: 205760
  - 4
    - c0000029 bug report sent to Microsoft This is the bug report I sent to MS, in case anyone wants to play with this. This is a Visual FoxPro bug about FoxPro Version (pick one): 8.0 SP1 Reproduces (pick one): always Hardware and Software Details: Dell opteron 2.6 GHz Celeron Windows 2000 Happens on other machines as well. Other Development Environments? yes If yes which? Visual Studio .net 2003 Steps to Reproduce: 1) First create a database, and put a table in it, put some records in it. CREATE DATABASE ZOOT CREATE TABLE ZOOT (Z1 C(10), Z2 C(10), CHANGE T ) INSERT INTO ZOOT (Z1) VALUES ('ZOOT') 2) Set record validation Rule - we want this procedure in the DBC to execute when a record is changed: setchange() 3) Create stored procedure in DBC called SetChange: PROCEDURE setChange TRY IF glSetChange REPLACE CHANGE WITH DATETIME() ENDIF CATCH * WAIT WINDOW 'An error has occured' ENDTRY RETURN .T. ENDPROC 4) Run this code: USE ZOOT SET STEP ON REPLACE Z1 WITH 'NoZoot', Z2 WITH BadVarName Notice that glSetChange is uninitialized. This is by design. Notice that BadVarName is undefined. In order to reproduce this error, you need a two part REPLACE, and the first one (Z1 WITH 'NoZoot') must be valid, and the second one (Z2 WITH BadVarName) must be invalid IE have a runtime error such as uninitialized variable or invalid table/field name, etc. Observed Behavior: I step through the code via the above SET STEP because if you dont, sometimes VFP will just hard terminate, poof and it's gone. If you step through it, when you get to this line: TRY IF glSetChange You should get a c0000029. It varies according to the code in SetChange, but it will consistently crash. If I change the code slightly , I can get c0000005, c0000029. I also get MS VC++ Runtime Library error, Buffer overrun detected error. The code I posted above seems to consistently produce c0000029. This, for example, IF glSetChange .AND. 1 = 1 seems to produce a buffer overrun warning, other variations produce a mismatched push/pop type of message. Expected Behavior: A trappable VFP error should be generated, not a hard crash. Additional Information: I can get a crash in VFP7 by using this code in SetChange: PROCEDURE setChange ON ERROR llZOOT = .T. IF glSetChange REPLACE CHANGE WITH DATETIME() ENDIF ON ERROR RETURN .T. ENDPROC Since VFP7 does not support TRY/CATCH, I use traditional error trapping instead. In VFP9 the same process generates a c0000005 error. Tag: Syntax colloring Tag: 205753
  - 5
    - inserting new record Is it possible to insert a new record within a table? I don't have a way to sort. It's just a list that needs to stay in a certain order. I'm using vfp8. Thanks Sherry Tag: Syntax colloring Tag: 205749
  - 6
    - about font size of vfp 9.0 This is a multi-part message in MIME format. ------=_NextPart_000_0010_01C4F81D.55EC3520 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable Hi,All, I just compiled my vfp8 project and found a strange problem, Although my = label font size in every form is not changed(I set them all to 10),it = seems that font size 10 in vfp9.0 is more large than in vfp8?=20 Why?=20 B.Regards Chuen ------=_NextPart_000_0010_01C4F81D.55EC3520 Content-Type: text/html; charset="gb2312" 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=3Dgb2312"> <META content=3D"MSHTML 6.00.3790.218" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT size=3D2>Hi,All,</FONT></DIV> <DIV><FONT size=3D2>I just compiled my vfp8 project and found a strange = problem,=20 Although my label font size in every form is not changed(I set them all = to=20 10),it seems that font size 10 in vfp9.0 is more large than in = vfp8?=20 </FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Why? </FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>B.Regards</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Chuen</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0010_01C4F81D.55EC3520-- Tag: Syntax colloring Tag: 205742
  - 7
    - gibberish when printing in landscape VFP9 I have a very simple report, no calculations, no variables. Just simple fields. No report listeners. If I have paper orientation set to landscape and reportbehavior set to 90, the report is filled with gibberish. If portrait mode or reportbehavior is 80, it works fine. Obviously I have a workaround, since I'm not using report listeners, but I thought I'd ask whether others have seen this. I reported it already. Tag: Syntax colloring Tag: 205736
  - 8
    - printers Hello, I am wondering if anyone else who has created full applications in FoxPro has come up with the dilemma of how many possible ways can an envelope be fed through a printer. I am the programmer of a billing software built in Visual FoxPro. I have a feature where people can print envelopes addressed to their clients. I have a report strategicly built so that the return address and clients address are placed in the positions where once an envlope is fed there envelope comes out correct. There are three different types of HP printers at the office that I can take into account, but what about the other brands? Is there a proceedure I can use that can give me how the specific invoice takes in envelopes? Or do I have to figure out all possible ways an envelope can be fed through a printer? If this is the case can someone direct me to the correct place to look this up? I have been unsuccesful so far. Tag: Syntax colloring Tag: 205727
  - 9
    - firing the foxcode i've noticed that not only if we type SPACEBAR, but also typing the closing bracket ) will invoke intellisense. If one looks at the source code in XSource (in the FoxCode.prg), & places some code (preferably a messagebox in the DefaultScript() method, this will get displayed if you type ) Now, i want to know if we can control what characters invoke the foxcode. I don't want to be limited with only SPACEBAR & Closing Brackets. I a few other such key characters to invoke the intellisense (foxcode). Any ideas, any one??? Tag: Syntax colloring Tag: 205719
  - 10
    - new item under Options->File Locations is it possible to put in a new item in the listbox displayed under Options->File Locations I'd like to setup some development tools & want to plug the configurations of the files in here I've had a look at the xsource files, but could'nt find any code related to this Options screen. Tag: Syntax colloring Tag: 205718
  - 11
    - debugger problem in VFP9 I hate to quibble, but... In the Trace window, if you hover the mouse pointer over a variable or field, you get a ToolTip window showing the value of that variable. A very useful feature! But new to VFP9, if the value is a string, what's shown does not include the string delimiters, ie quotation marks. That makes it impossible to differentiate between 12345 and "12345". And it's difficult to tell between "ABC" and "ABC ". Tag: Syntax colloring Tag: 205717
  - 12
    - End Program What code ends a program like END in VB? Tag: Syntax colloring Tag: 205716
  - 13
    - Serial communication -> HOW ? Hi there, I need to somehow link a PC, via a serial port, to a weighting scale. I'm using Visual FoxPro 7 and I really don't know how to do that (I have tried some FOPEN (COM1) but it didn't work) Any ideas? Please... Daniel Tag: Syntax colloring Tag: 205707
  - 14
    - Tableupdate with Oracle (ODBC) Whenever I try to update an Oracle table through VFP remote view I have error message "Update conflict". Looking on internet I found one post that it is known VFP error related to the way how VFP sends fields of type varchar to Oracle (Rpad). Looks preaty catastrofic cause it eliminatas VFP as frontend with Oracle database. Did anybody knows more about it or found a workaround? Many thanks Tag: Syntax colloring Tag: 205702
  - 15
    - Connect to SQL server I would greatly appreciate a sample of the syntax required to connect from VFP 6 to a SQL server - either one on my own machine or one that resides on another machine that I can access by IP address. TIA. -S- Tag: Syntax colloring Tag: 205700
  - 16
    - location of db in de I'm playing around with different scenarios, and found this. In this app, the database consists solely of a connection and remote views, and is located in a subfolder of the project folder called data\. The database is included in the build. Forms are built with the data\ database in their data environment. At runtime, I open the database (no path, because it's included). I was concerned that the forms would not be able to locate their data, since the data\ folder does not exist at this time (I renamed the original to prevent confusion). Yet the forms seem to work fine. Can anyone elucidate? Is this behavior documented? Furthermore, I put a button on a form to display DBC(), and it shows c:\... runtime folder\data\databasename.dbc, even though the data\ folder and databasename.dbc do not exist on disk. (They could be temp files somewhere, but that's not what is shown.) Any help explaining this as a general and reliable rule would be appreciated. Tag: Syntax colloring Tag: 205698
  - 17
    - multiuser problem Hi, I am using VFP6 SP4 and develope an application In the multiuser environment. The form's datasession is 2-Private Data Session In the init event of the form, have the following environment setting set exclusive off open database Mydata shared set multilock on select mytable = CURSORSETPROP('Buffering', 5, 'mytable') users access to the same form (same table), got the error message " File acces is denied " Does anything wroing here ? Please give suggestions thank your very much Tag: Syntax colloring Tag: 205691
  - 18
    - Update Word links Hi foxpro experts, Once again I turn to you for some advise :) I have some Word documents that have linked objects, something like this : {LINK Word.Document.8 X:\\Path\Document.doc \a \f O \p}. Word stores a path to there objects, but once I copy them to a new place, the path is broken, and you have to update them. You can do this by hand ofcourse, but I would like to do it from Foxpro. I found a forum that where someone was able to make a macro to solve this issue, but I don't know enough about macro's to turn it into Foxpro code. I know how to go through "Story's" in Word, but not how to update the fields in there. Does anybody have a foxpro example on this or some help ? the forum is at : http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=wrd&Number=261488&page=&view=&sb=&o=&vc=1#Post261488 thanks very much ! Xavier, CPS Tag: Syntax colloring Tag: 205688
  - 19
    - Change of Paper size programatiically Hi I am using VFP6.0 with Windows XP for a system with Multi-USer I got a report using a Paper Size - Letter. But on some computer the paper size will change depending on the setting of the computer Is there any ways to set the paper size of the report before REPORT FORM Regards, Hughs Man Tag: Syntax colloring Tag: 205687
  - 20
    - Memory variables Vs Table buffering I learnt foxpro from an old foxbase programmer. I have only used up to VFP6. Ever since I collect memory variables from my input forms and update the tables field by field using the memvars. What benefit am I loosing by not using table buffering other than having to write more code(which I don't mind!)? How can I use table buffering when I need to do more than one record in a table (as in accounting entries)? Tag: Syntax colloring Tag: 205685
  - 21
    - How can I get the list of files of a directory with the correct case of letters How can I get the list of files of a directory with the correct case of letters as they really appear and not in upper case as ADIR returns them. Demetrios, Greece Tag: Syntax colloring Tag: 205683
  - 22
    - intellisense custom script Hi friends i've following intellisense script . when i type rk then it turns to "&& Rajani on 10/01/05". It saving lot of time for me when i write comments. ************* LPARAMETER oFoxCode Local lcRetval, lcCase,lccentury lccentury="SET CENTURY "+set('CENTURY ') SET CENTURY OFF oFoxcode.valuetype = 'V' && we want to return a value lcCase = oFoxCode.Case If empty(alltrim(lcCase)) lcCase = oFoxCode.DefaultCase && if not take default foxpro case endif lcRetval = '&' + '&' +'~' +' Rajani on ' + dtoc(date()) &lccentury && reset century Return lcRetval ********* abv code works beautifully without any problem. i am wondering if it is possible when i type my keyword(i.e. rk) on new line i want **Rajani on 10/01/05 if it is on a existing line then "&& Rajani on 10/01/05". any ideas on this will be great. Thanks -- cheers Tag: Syntax colloring Tag: 205679
  - 23
    - Recordlocking VFP8-SP1 Struggling with multiuserenvironment... A textbox with myView.myField (buffermode 3) as controlsource B user 1 writes Hallo to the editbox and clicks in another texbox - fires the first textbox´s valid-code: SET REPROCESS TO 3 SECONDS lcAlias = 'myView' SELECT (lcAlias) LOCK(lcAlias) tableupdate(2,.F.,lcAlias) && returns T UNLOCK ALL C user 2 on workstation 2 can see Hallo in his textbox D user 2 can do the same ("Hallo again") as B above && no error is reported E User 1 can´t se Hallo again If I replace LOCK(), UNLOCK with tableupdate(2,.F.,lcAlias) && returns T Select tblComp1 (the views sourcetable!!!!!!!!) skip 1 everything works fine! but this can´t be the right way... What am I missing???? Best regards Christina Tag: Syntax colloring Tag: 205673
  - 24
    - VFP web services I would like to set up an extremely basic web service application, just to get going. I only want an example that reads and updates a single field in a free table over internet. What would be the easiest way to achieve this - I don't have the time (or energy) to study hundreds of pages of web technology, and I would like to do it as much as possible within VFP 9.0. So - what's your suggestion? Tag: Syntax colloring Tag: 205661
  - 25
    - Data driving a class Hi, I am attempting to data drive code that can contain several methods by creating a table 'script_def' with two fields:- * script_name c(10) * exec_txt m - contains code to create the class. The test program below selects the appropriate record, creates the class and calls a method. MESSAGEBOX confirms that the correct record is selected and that test_script.prg contains the text from the correct record. However the code from the record that was selected the first time is executed - the .fxp appears to be in memory. Attempting to compile test_script.prg or delete test_script.fxp causes an error 'outstanding references exist' Any help in getting this to work (or a better way to do it) would be appreciated. TIA, John Pugh Adelaide, South Australia * Test data driving a class IF NOT USED('script_def') USE script_def IN 0 ENDIF SELECT script_def LOCATE FOR script_def.script_name='two' MESSAGEBOX(script_def.script_name) SET SAFETY OFF =STRTOFILE(script_def.exec_txt,'test_script.prg',0) SET SAFETY ON MESSAGEBOX(script_def.exec_txt) LOCAL o_test o_test = NEWOBJECT("test_class",'test_script.prg','') =o_test.test_method() RELEASE o_test RETURN *************Code in record one of script_def********************************* * Test class for data driving DEFINE CLASS test_class AS CUSTOM PROCEDURE test_2 MESSAGEBOX('test_method called from rec 1' ) ENDPROC PROCEDURE test_method =THIS.test_2() ENDPROC ENDDEFINE Tag: Syntax colloring Tag: 205656

Hello,

I am using VFP9 and I want to use the new option to see syntax colloring in
Memo fields, as far as i know, I have done the right settings in de
tools/option dialog but I don't see in happen.

Any idea?

John.

Re: Syntax colloring by Mike

Mike
Thu Jan 13 04:18:52 CST 2005

In distributed run-time applications, syntax coloring in Memo field editing
windows is disabled

"John Smith" <John789@hotmail.com> wrote in message
news:ui$PtCV%23EHA.600@TK2MSFTNGP09.phx.gbl...
> Hello,
>
> I am using VFP9 and I want to use the new option to see syntax colloring
> in Memo fields, as far as i know, I have done the right settings in de
> tools/option dialog but I don't see in happen.
>
> Any idea?
>
> John.
>

Re: Syntax colloring by Eric

Eric
Thu Jan 13 04:19:37 CST 2005

Hello, John!
You wrote on Thu, 13 Jan 2005 10:16:59 +0100:

JS> I am using VFP9 and I want to use the new option to see syntax
JS> colloring in Memo fields, as far as i know, I have done the right
JS> settings in de tools/option dialog but I don't see in happen.

Try setting the "Override individual settings" option for Memo fields, or
remove your foxuser resource files.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

Re: Syntax colloring by John

John
Thu Jan 13 04:47:18 CST 2005

Thanks that works!

"Eric den Doop" <ericdendoop@xspamblockxfoxite.com> wrote in message
news:uomEelV%23EHA.3124@TK2MSFTNGP11.phx.gbl...
> Hello, John!
> You wrote on Thu, 13 Jan 2005 10:16:59 +0100:
>
> JS> I am using VFP9 and I want to use the new option to see syntax
> JS> colloring in Memo fields, as far as i know, I have done the right
> JS> settings in de tools/option dialog but I don't see in happen.
>
> Try setting the "Override individual settings" option for Memo fields, or
> remove your foxuser resource files.
> --
> Eric den Doop
> www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8
>
>