How to set page height when printing through Selprint Method of Rich Text Box?

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
    - Web Dev and Foxpro I'm interesting in beginning to migrate my POS system and a Inventory Catalog System to a web environment. Basically, I want to start by displaying Foxpro generated cursors in a web browser. But in the long run I want to replace the systems with Web based interfaces. Where should I start? I have been looking at learning PHP and using ODBC to access Foxpro tables. Is this a good idea? Or should I look in another direction? Thanks for any input. John. Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196284
  - 2
    - Return value from a class Hi All I want to change a form as a class. But I don't know how to get value return the class as I'm usually used to get from a form with this command DO FORM myform TO leResult When I create an object SET LIBRARY TO myclass.vcx oForm=CREATEOBJECT("myform") oForm.show ....?? What is the next line in order to get the result returned by that class ? Thanks A Lot Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196282
  - 3
    - Data environment drag and drop Hi, I'm just starting to get into the DE, and I'll probably have a lot of other dumb questions in the weeks to come. I've setup a DE (about 10 tables), and then dropped the individual fields into pages of a pageframe on a form. All good and easy for design. But how do I bind the field to, for example, a subclassed textbox which is readonly instead of the default one? Another question. Which is the best buffermode/override property to use. It's a sales entry system with a sales header (one-to-many on sales items and payments tables, one-to-one on customer table), sales items (one-to-one on stock tables), etc. I've read varying opinions, but I'm wondering what the general consensus on Row vs Table and Pessimistic vs Optimistic buffering is. Any ideas or articles on the subject would be appreciated. Thanks, Neil Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196275
  - 4
    - registering dll's I have created a dll in fox. When I register the dll on another machine using regsvr32, regsvr32 says the dll has registered successfully. When I try to create an instance of the class with createobject() I get an error. On 2000server I get 'Class factory cannot supply requested class' On XP Professional I get 'Unspecified Error' In both cases the instance of the class is not created. I have compiled the dll as single instance and Multiuse using fox6 and fox7. The result is the same with both. Instances of the class can be created fine on my development machine. Any help would be appreciated. Dave Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196269
  - 5
    - Rebuild DBC I have developed a POS application with one DBC and about 100 tables which is used on small networks. I find my customers have to (should) frequently (2 or more time per day) re-index the tables to prevent corrupt data. Part of the re-index routine rebuilds the DBC by the following code snipet: Remove table MyTable Free table MyTable Add table MyTable Periodically, tables lose their link, etc to the DBC, requiring the above code. Is there a better way to rebuild the DBC? Am I approaching the problem incorrectly? TIA Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196261
  - 6
    - Illegal recursion in rule evaluation error in trigger Hi All, I have an update trigger written on a table. The stored procedure for the trigger is as follows: PROCEDURE updTicketTrigger DIMENSION tcount(1) as Integer select count(*) from <tablename> where <condition> into ARRAY tcount noconsole IF (tcount[1]) = 1 tcount[1] = 0 FOR i = 1 TO 500 DO WHILE .t. &&setting value1 and value2 for field1,field2 ENDDO INSERT INTO tablename(field1, field2) values(value1, value2) ENDFOR ENDIF RETURN .t. ENDPROC On execution of the trigger, the following error message is displayed on the very first insert itself! Illegal recursion in rule evaluation. Can't we use loops in triggers? Any help is greatly appreciated. Regards. Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196256
  - 7
    - FPW2.6a and ADIR Hello, I have a routine that processes tables with indexes. I did this by using ADIR(thearray,'*.*','AHRSD') and then walking the array, searching for either a CDX file to process or a subdirectory to recurse into. Unfortunately it trips up on larger directories with a memory error trying to execute the ADIR(). I decided to take a listing of subdirectories and CDX files to make the resulting array much smaller. How can I do this though? At first I tried ADIR(thearray,'*.CDX','AHRSD') but that will only include directory names that match the file skeleton (ie end in '.CDX'; which they don't.) Next I tried creating two arrays, one for CDX files with ADIR(filearray,'*.CDX','AHRS) and one for subdirectories with ADIR(dirarray,'*.*','D') but the latter matches all the files and directories which is prone to memory errors. Is it possible to get an array of all CDX files and all directories without creating an array of everything and filtering it in Fox code? This is FPW2.6a. -- TIA Andrew Howell Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196253
  - 8
    - What's the most efficient way to add DELETE constrain to a database Hi all, Database: SQL Server 2000 SP3a, front end application created with Visual FoxPro 8 SP1. To my surprise, I found out that somehow, *all of* my tables have lost their Primary Keys and Foreign Key assignment. While the apps still runs okay (because the Identity still intact, hence all insertions run as they should be and I don't use any SPs to maintain business rules), I understand clearly that this is something I *must* fix immediately. I used to create the relationship and maintain DELETE constrain in Edit Diagram window found on the MS Enterprise Manager. Since I have to recreate all relationship and constrain all over again, it's going to take some time if I use diagram. QUESTION: I know that instead of using diagram, I can use T-SQL statement via Query Analyzer, can anybody give me a clue how to add the constrain? There are about 90 tables on the database and I have to fix five databases with the same problem (and the same structure). TIA, Willianto Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196247
  - 9
    - Cancel button while Processing Hi to All, I am trying to run a FOR... ENDFOR process and want to have an OLE progressbar and an active CANCEL button. How can I do this? I've tried several times but the click event of my CANCEL button seems not to work while inside the FOR... ENDFOR process... Can you help? Allan Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196241
  - 10
    - Foxpro Application on Virtual PC for Mac Has anyone had experience running a Visual Foxpro application (VFP 7) running in a Windows emulation environment on a Macintosh? How effective is that as a means to deploy an existing application onto a Mac? thanks, pete Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196239
  - 11
    - VFP8 Stored Proc and ASP.NET I have existing database in VFP8 with some stored procedures in it. Front-end has been developed in ASP.NET and C#. How to call these SPs and return results in XML format? Thanks. Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196232
  - 12
    - update graph issue - append general in VFP8 under WinXP When I programmatically try to update a graph in a table issuing the APPEND GENERAL command I am recently getting spotty results. I have been using the current app on a desktop computer(PIII 700mhz) for a couple of years using VFP6/8 and Win2K with complete success but have recently tried to run the app on a laptop(P4 1.2 ghz) with WinXP and VFP8 and the graph that I am trying to change will *sometimes* not update. The graph will simply show the template graph that resided there originally. However, I can double-click the graph to open/modify and it will suddenly show (update) the graph as it should. The data for the graph in the general field is getting updated but not the graph. I found an apparently old KB article on the subject that referred to VFP3 and Windows for Workgroups and it said that MS acknowledged the issue and was researching it. The article suggested issuing the append general command twice but noted that this might not work. Has anyone else experienced this issue? Any other possible workarounds/fixes/suggestions? The KB article explains a little more in detail and has a sample to test with. MSKB - 137315 PRB: APPEND GENERAL DATA Not Working in Windows for Workgroups Thanks for any help, Jim Clay Team Resources, Atlanta Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196226
  - 13
    - vb.net and foxpro 8 Hello all excuse for my bad english I have database in foxpro tables with unique keys when i add a record in foxpro i use a fonction to add the new number unique (the standart fonction in the foxpro exemple of database) but when i 'm under VB.net with oledb select , update and delete work fine. i try to make a oledbcommand with insert i insert all the other rows but not the row of the key row and the number of this key is always 0 and thus the second insert makes an error because the key are not unique . Do you have a solution or must i read the number of the key in the other table and add in VBNET Thanks and good day Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196224
  - 14
    - HP 1300, frx and *****.** I've got a report that work well almost in any printer except in HP1300. I get ***** instead of the numeric field. I think there is a problem between VFP and the printer. Does anyboyd experience something similar??? Thanks MB Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196221
  - 15
    - SQL Express tech preview available (replaces MSDE) http://lab.msdn.microsoft.com/express/sql/ Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196219
  - 16
    - [VFP9 beta]: VFP8 cannot open forms that was edited with VFP9!!! Hi all, Here the story goes: after downloading VFP9, I use it daily to create and edit several forms on my current project. I really loved all the IDE enhancement (even though once I put any properties in the Favorites Tab, I still don't know how to get them out!). I didn't use any VFP9 specific feature (such as Report Listener), because I am going to compile it with VFP8. Problem begins today when I tried to open a form that was previously modified and saved with VFP9b. VFP8 refused to open the form and throw an error message; something like 'invalid value for property lDrawMode'. Trying to fix the error, I re-opened the form with VFP9b and set the property value to default. Didn't help. The error still there with another property in question so I tried to open the form as table. In the Reserved3 and Properties field of the scxs, I found some suspicious tags begin with _MemberData and there were more tags that looks like an XML tag. I deleted those tag, and tried to open the form in VFP8. Another error occurred; VFP8 said that there are invalid value for Alignment property in one of the Optiongroup control in the form. I opened the form as table once more, locate the row that contains the Optiongroup mentioned, and delete the alignment property ('Alignment = 6'). After that, I manage to open the form successfully in VFP8. <sigh> Great. Fortunately, I 'only' wasted half an hour fixing that (but I haven't count *other* forms). Is it just me, or is (are) there some setting(s) I missed? Or maybe, it's a bug -considering that VFP Team has spend so much time and effort to maintain compatibility. Or maybe, VFP9 Beta is actually just for fun and it should come with warning 'You can try this but don't-even-try-to open your real work with this' Um, on second thought, I think VFP9b *is* already come with that warning <sigh>. Oh well, I know that one should not deploy apps based on beta product, but today I learn another lesson: one should not use beta product for a non-beta work. Opinion anyone? TIA, Willianto Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196213
  - 17
    - Creating triggers using table designer Hi, How to use the table designer to create triggers which are stored procedures? I created a stored procedure and in Triggers group, I typed in the name of the stored procedure for the update trigger. I am getting an error informing me that the variable by the name of the trigger is not found? How do I specify stored procedures for triggers in the table designer? Regards Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196208
  - 18
    - CursorAdapter I got 30 fields need to call from MSSQL Server and create the cursor using cursoradapter builder. It show Error Message, 'The CursorSchema property must be no longer than 255 character", Any solution on this Visual Foxpro Version 8, SP 1, limitation ? Than you in advance. Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196207
  - 19
    - Checking all parts of an expression. Is there a way to make sure all parts of an expression are evaluated: In other words: x= .t. or badexp x= .f. and badexp both of these evaluate just fine, but I would like check ALL parts of ANY expression. I'm currently breaking the expression into individual parts and checking them all part by part. I'm looking for a more ELEGANT method if one exists. THANKS Mike Farnesi San Diego Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196190
  - 20
    - FLOCK() and SET REPROCESS in VFP8 Hello, My question is about the FLOCK() function in VFP8SP1. Using FLOCK() on an already locked table should fail, unless SET REPROCESS is set to automatically retry the lock. However I found cases where FLOCK() does not behave as I would expect. I have a form using a private data session. A first instance of the form successfully locks a table using FLOCK(). A second instance of the form, however, does not successfully lock the table. FLOCK() returns .F. right away, even with SET REPROCESS TO AUTOMATIC. I would expect the FLOCK() function to be retried indefinitely, but it is not the case. Does anyone know why this is so? Thanks in advance! Yanick Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196186
  - 21
    - How to suppress a message shown while retrieving remote data from MSDE? Hello everyone, I have an apps that utilize MSDE as the backend database. It's been running on my client for almost a year by now. Problem is, today my client complained that the apps began to give a 'strange message' sometimes. I went to their place and found that the message is something like this: 'Please wait while executing remote data. Press ESC to cancel'. The message shown in a wait...window. I assume that the message was thrown out because VFP runtime consider that the query would take some time to finish. But, it's a bit annoying. I mean, who would want to cancel? And if they do press ESC, the apps would stop. Question: Is there anyway to suppress the message -or better yet, to replace the message with something friendlier (like progress bar) with little or no change to the code? TIA, Willianto Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196181
  - 22
    - Returning the Default Windows printer? VFP8 How do I return the name of the current windows default printer? I don't want to use something like lcPrinter=getprinter() which opens a dialog box. Thanks, John. Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196178
  - 23
    - Delete these porno threads.... Could the moderator of this news group please delete the porno threads? Thank you. Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196177
  - 24
    - ADO in EXE / DLL For my 3-tier project I have created business object and data object. Both are type MTDLL. I use ADO for connecting to tables. Connecting to SQL-server and VFP ( via VFPOLEDB ) works fine. For DCOM I have to make EXE instead of DLL. When I do this, ADO stops working. Tips for solving this would be nice. Rolf Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196174
  - 25
    - FPW2.6a genxtab output field order? Maybe I should just give up with this program but having got it to actually do something [which has wasted most of the day,] I now find I don't seem to have much control over the order of the field names it generates. I have twelve months of data from 05/2003 to 04/2004 (May 2003 to April 2004 respectively.) I want the fields in chronological order from left to right. I know I can rename them in yyyymm format and then it will work because genxtab assumes you want them in ASCII order left to right. Is fiddling the name of the fields the only way? I'm tempted to patch genxtab to write out fields in the order they appear in the input data (surely more sensible?) -- TIA Andrew Howell Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196167
- Next
  - 1
    - VFP licencing under MSDN Below is the answer, direct from Microsoft : MSDN Universal, MSDN Enterprise, MSDN Professional and MSDN Operating Systems are licensed for single users, and can only be used by licensed subscribers. All products that ship in MSDN Subscriptions are for development and test purposes only, and cannot be used in a live production environment. This seems to infer we should not be using any VFP version shipped with MSDN for live production. Presumably a separate site licence is really required. Is that how everyone else reads this? Thanks for any comments. Bernie Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196164
  - 2
    - FPW2.6a cannot get genxtab to work Hello, I'm trying to generate a cross table from a query but genxtab is throwing an error "unexpected end of file encountered" Closer examination of the program seems to be the line of code APPEND FIELD (FIELD(1)) FROM xtabtemp I think this line of code is supposed to create all the row possibilities in the empty output table. It is appending blank records for me; this means when the program goes on to insert the data it cannot find the correct row. Why? xtabtemp has all the values for the different rows, I've looked up "APPEND" in the help file and there is no "APPEND FIELD" clause documented. Here is a test case: ************************ CREATE CURSOR test (period C(7), ; type C(1), ; qty N(5,0) ; ) INSERT INTO test (period, ; type, ; qty ; ) ; VALUES ('01/2004', ; 'A', ; 100 ; ) INSERT INTO test (period, ; type, ; qty ; ) ; VALUES ('01/2004', ; 'K', ; 200 ; ) DO (_genxtab) WITH 'XTAB',.T.,.T.,.T.,2,1,3,.T. ************************ -- TIA Andrew Howell Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196162
  - 3
    - Scan taking place from previous record;works normally in debug mod Hi All, I have a strange behaviour with record pointers within a cursor. Consider the following commands Next button click: SCAN NEXT 7 ... ... ENDSCAN Previous button click: SKIP -(number of records displayed + 7) SCAN NEXT 7 .. .. ENDSCAN I click on next to display the next set of 7 records, then I click on previous to display the previous set of 7 records and then when I click on next button again, one record from the previous page is displayed. The program behaves as expected in debug mode. Does anybody know why such a thing is happening and how it can be solved. Thanks Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196160
  - 4
    - Finding the beginning of the result set Hi All, I have stored the result of a query in a cursor. My program is such that I need to scroll back and forth in the result set. How can I at any point of time, check whether, I am at the beginning of the result set; so that I don't try to scroll before the beginning of the file? if cursor_name.bof() .. .. endif cursor_name.bof() is giving an error - Object cursor_name not found! Any suggestions to solve this problem would be greatly appreciated. Regards Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196153
  - 5
    - Newbee Questions Hi I am fairly new with Visual Foxpro V6.0 having done most of my programming in C++, VB and delphi. I am quite comfortable with VFP and the language but am having trouble with GUI side of things. I wish to have a richtext box that allows the user to change font, font size and colour I see that there there is an example that comes with foxpro in the foundation classes under text formating where it makes the desired changes to the active control but I can't see how the connection between the font toolbar and the active control is made. I have encountered this connection type problem on many of the example's that I have looked at. On the RTF control how is the text printed I have had a lot of trouble controling what I want to print in foxpro there just not seem to be simple calls to print dialogs and print type statements. Any help would be greatly appreciated. Warren warrenjw@austarnet.com.au Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196146
  - 6
    - CursorAdapter, Parameters sql command not working I use cursoradapter builder to build a class and compile it to a datacls.exe file. I issue the command : odatacls = NEWOBJECT( "mtn08", "Datacls", "Datacls.exe" ) odatacls.selectcmd = 'select * from mtn08 where code = ?lcmyvar' lcmyvar="ST" odatacls.cursorfill() to query a parameters sql results, the Error message show as : Microsoft OLE DB Provider for SQL Server : No Value given for one or more required parameters. How to pass the parameters into the query? Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196144
  - 7
    - Questions about _supermover1 in VFP class library Hello, I am trying to use the supermover from the VFP class library but I can't seem to find a way to activate it. I drop an instance of the class on my form, set up the required SQL cursor as the data, and run the form. The data does successfully get loaded on the source listbox, but everything appears grey, including the 2 listboxes, the data in the source box, and even the add and remove command boxes. I check "enabled" and it is set to .T. But I can't figure out why it's still not activated. Anybody tried using this class and can show me what I'm doing wrong? Thank you. -- jw Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196139
  - 8
    - Databases I have been advised to issue a set default to stmt to change the path of "training" data, that is a copy of the "live" data that a user can train and learn with. Issuing a new set default to, such as set default to c:\MyApp\Train does not change the reference in the database of the form and the form continues to use the table referenced in the form. What am I missing? Tia Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196136
  - 9
    - Databases I have been advised to issue a set default to stmt to change the path of "training" data, that is a copy of the "live" data that a user can train and learn with. Issuing a new set default to, such as set default to c:\MyApp\Train does not change the reference in the database of the form and the form continues to use the table referenced in the form. What am I missing? TIA Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196134
  - 10
    - Databases I am not able to change the "database" in a form by issuing the statement "set default to c:\MyApp\Train" When I do issue the statement, the form continues to display the original database such as c:\MyApp. Running the form continues to use the table that is part of the database that was in use when the forms DE was use at the time the tables were added to the form. Is there another way to change the forms database, or am I missing something? TIA Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196133
  - 11
    - Command to be continued on to the next line Hi All, If I have a long line of command which I want to continue on the next line, what combination of characters do I give at the end of the first line? Thanks. Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196130
  - 12
    - Questions about moving items between list boxes Hi All, I have this list boxes controls that I copied from the moverlists class in "Solution" of VFP6.0. I have the following 2 problems when moving items between the list boxes. 1. It seems I can only display multi columns for the two list boxes by setting RowSourceType to 2 or above. Setting RowSourceType to 0 or 1 makes the listbox to display only 1 column. Since I need to clear the listboxes often so I'd prefer to set RowSourcetype=0. If I do that is it still possible to set them to display multi columns? 2. If I specified RowSourceType to 6 for both listboxes, The code SCAN List.AddItem(table.field) ENDSCAN fills both (source and destination) boxes instead of only the source listbox. Anyone knows why I am doing wrong here? I am using VFP6.0 sp5. Thanks for any inputs. -- jw Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196125
  - 13
    - Menus, Problems & Errors Hello, I have trouble using different menus with different forms. I am using VFP 8.0 SP1 1) Main form has top level menu name 'main'. 2) Second form is MDI has menu 'order' called when form is called & release when form is release . Problem#1 with Method 1 When second form is called, Main menu is deactivated when lost focus & activated when got focus. Problem is it's change position of menu & first bar can't be accessed because of icon place from second form. Problem#2 with Method 2 When second form is called, Main menu is released using 'Release Menu " command, when lost focus & called using 'do main.mpr' when got focus. Problem is after few uses, got an error "Not enough Memory to complete this operation'. Problem#3 with Method 3 When second form is called, Main menu is released using 'Release Menu Extended " command, when lost focus & called using 'do main.mpr' when got focus. Problem is after few uses, got an error "Menu Manager internal consistency Error'. I tried all commands related to menu, but no success. Please suggest me best solutions to use different menus with different forms in one program. I wonder why menu system in VFP is so complicated, compare to VB. TIA Jit Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196123
  - 14
    - How to send shapes object in the container to printer? Hi all, I have an apps with an ability to draw lines. The 'drawing pad' is actually a container and the the drawing are collection of shapes that each has specific length, top, left, and width properties. By saving those values on tables, my apps can save and open the drawing. The shape objects has several proprietary properties that are used for specific calculations, the drawing is just used to somehow visualize the entry. Problem begins today when my clients asked me to upgrade the application such that he can print the drawing. Question: Any idea how to send the drawing (which are actually shape objects in the container) to printer? TIA, Willianto Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196122
  - 15
    - Defining the dimensions of an array Hi All, Is it possible in vfp to declare an public array (so that the array is visible anywhere in the application) and then define its dimensions at a later stage (when I know what the size of the array is going to be)? Something like redim in visual basic... Regards. Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196117
  - 16
    - Databases I have developed an application. Now I want to add a "Training" feature that will will the same tables as the "real" application. I have a new database for the training, but all the forms have the database as the original. How can I tell each form that the database has changed from MyData to MyDataTr so that the tables in the training folder can be used with the forms that were created using the original database of MyData? In other words, is there a way to programatically change the database property within each form? Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196107
  - 17
    - FoxPro ODBC Driver? Hi: I am building an application with AccessXP and need to connect to a FoxPro DOS tables (v.25/v.26). The ISAM driver use A97 has been discarded in AccessXP in favor of the Microsoft Visual FoxPro ODBC driver. Can you tell me where the link is on the Microsoft site to download the VFP ODBC driver? Currently on the machine at the client site the driver is v6.01.8629.01 dated 9/21/1999 for vbpodbc.dll. His is a Win98 machine. On my machine, a Win XPPro, the VFP driver is 1.00.02.00 dated 8/29/2002. I am having a problem when I link using the old VFP driver. I have a field called Active that is type Logical (boolean). If I query the table it presents all records. However, if I filter it to all records where Active is True/-1 or False/0 no records are returned. If I create a calculated field where I compare Active to True, those that are true = -1 and those that are false = 0. However, if I attemp to filter on that field again I get 0 records. So something must be wrong with the ODBC driver on the client machine where the ODBC freaks on logicals. Any link to a VFP driver that would be more up-to-date would be appreciated. Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196100
  - 18
    - UDF's in FoxPro indexes I am trying to share foxPro files with Clipper apps using CDX-compatible drivers. The problem is that the index expressions include function names that are incompatible with FoxPro. Some are easy to fix - the Pad() function can be replaced with PadL() for example. However, the Descend() function allows mixed ascend/descend indexes, such as INDEX ON CUSTCODE + DESCEND(INV_DATE) TO... As you can guess, this will produce a sort order of ascending costmer codes, but descending invoice dates. I know how to reproduce the functionality of Descend() in FoxPro by creating a UDF, but I also need to know how to make sure that it is always available every time VFP8 runs - without the user having to explicitly load any procedure files. What is the best practice for this? Also, is it possible to create a DLL or something containing UDF's for index expressions athat can be attached to an ODBC, OLE DB or ADO objects so that other apps using an instance of the FoxPro data engine can also automatically have access to these functions? TIA Carlo Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196096
  - 19
    - UDF's in index expressions I am trying to share foxPro files with Clipper apps using CDX-compatible drivers. The problem is that the index expressions include function names that are incompatible with FoxPro. Some are easy to fix - the Pad() function can be replaced with PadL() for example. However, the Descend() function allows mixed ascend/descend indexes, such as INDEX ON CUSTCODE + DESCEND(INV_DATE) TO... As you can guess, this will produce a sort order of ascending costmer codes, but descending invoice dates. I know how to reproduce the functionality of Descend() in FoxPro by creating a UDF, but I also need to know how to make sure that it is always available every time VFP8 runs - without the user having to explicitly load any procedure files. What is the best practice for this? Also, is it possible to create a DLL or something containing UDF's for index expressions athat can be attached to an ODBC, OLE DB or ADO objects so that other apps using an instance of the FoxPro data engine can also automatically have access to these functions? TIA Carlo Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196095
  - 20
    - Calendar control & VFP9b I'd like the click event of the calendar ocx to update the value property of a textbox which is elsewhere on the same page. However, as soon as any code I put in the click event begins to fire, the calendar reverts to the default date, and I can only get a value for today. Guess I need a calendar control tutorial. Can anyone help? -Lew Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196089
  - 21
    - determine the name of the popup which will be called from the pad I'm creating a menu in the system toolbar, using the following coding, DEFINE PAD PadShortCut OF _MSYSMENU PROMPT "\<Shortcuts" COLOR SCHEME 3 KEY ALT+S, "" ON PAD PadShortCut OF _MSYSMENU ACTIVATE POPUP ShortCuts DEFINE POPUP ShortCuts MARGIN RELATIVE SHADOW COLOR SCHEME 4 Some where else, i want to PUSH the popup ShortCuts, but for this i need to know this name, It could be ShortCuts or ShortCut, or PopShortCut So, basically, given the Title of the PAD, CAN I determine the actual name of the PopUp which will be called?? Regards, Paul Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196086
  - 22
    - disappearing menus Has anyone experienced a situation where the pull-down menus will disappear or somewhat collapse. They get reset once the user logs-out and logs-in again. Thanks, Chris Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196081
  - 23
    - Contract FoxPro Programmer Available for NJ or offsite projects I am a foxpro developer for about 10 years. I was recently laid off and I am looking for any projects related to Visual Foxpro, data processing, website maintenance, and complete rewrites of legacy 2.6 apps to Visual FoxPro. I have a base of solid OOP framework based on the MEI standard that can be used as a good staring point for any new application. If you are in need, please visit my website and give me a call. Thanks Jim www.datacontracting.com Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196077
  - 24
    - tableupdate Hello Is there any way of finding out excacly what table update translates into. ie can i find out the sql command it generates???? any help will be appreciated regards simon haynes Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196063
  - 25
    - TableUpdate() Dear Sir/Madam We are using Visual Foxpro (Version 8 Sp1) and ODBC (Visual Foxpro Driver 6.01.8629.01). We have a severe problem in that when a table has more than 50 fields in it and we are doing a tableupdate() the program crashes with a fatal error: C0000005. I have noticed that this error occurs at the same point (record) as if you have done a copy to array on the table. I.e. at the point the array has reached its 64k limit. (does tableupdate() use an array - if so can this array be cleared?) We have managed to code around the error by saving each reacord after 30 fields have been replaced . Ie using TableUpdate more than once on the table. The problem with this though is that performance is decreased enormously (so much so that the software is unusable). Could you please advise on how this issue could be resolved. Regards Simon Haynes Tag: How to set page height when printing through Selprint Method of Rich Text Box? Tag: 196056

Any help?

Thanks in advance

RE: How to set page height when printing through Selprint Method of Rich Text Box? by Leemi

Leemi
Thu Jul 01 09:12:22 CDT 2004

Hi R.K.:

I did not find any VFP code that does this task; however, I found this
Visual Basic article that might be useful:

146022 HOWTO: Set Up the RichTextBox Control for WYSIWYG Printing
http://support.microsoft.com/?id=146022

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 Public Beta Now Available!! --*
Download the VFP9 beta here: http://msdn.microsoft.com/vfoxpro/

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

>How to set page height when printing through Selprint Method of Rich Text
Box?
>Any help?
>Thanks in advance

Top