TableUpdate Performanc

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
    - Selecting Duplicate records I need to select out the records that are "duplicated" in a table. Is it possible to do the reverse of a Select Distinct. I just cannot seem to get the SQL right? Tag: TableUpdate Performanc Tag: 181332
  - 2
    - Winfax + XP + SetNumber Problem The Following Code is work very well in WinME , however same coding in "WinXP" the winfax program seems cannot get the "number - 22645584" , There is a window prompt and asked me to input the number again, Please Help ~~~~~~~~~~~~~ From Agnes ------------------------------------------------------ SET PRINTER TO 'WinFax' oWinFax = CreateObject("WinFax.SDKSend") oWinFax.ShowCallProgess(1) oWinFax.ShowSendScreen(0) oWinFax.setUseCover(0) oWinFax.SetNumber('22645584') oWinFax.SetCompany('dts-agnes') oWinFax.SetSubject('hello') oWinFax.SetTo('dts-TT') oWinFax.SetPrintFromApp(1) oWinFax.AddAttachmentFile("") oWinFax.AddRecipient && Required oWinFax.Send(1) oWinFax.LeaveRunning() rptNumPages = 1 REPORT FORM myReportName TO PRINTER NOCONSOLE RELEASE oWinFax oWinFax = .NULL. Tag: TableUpdate Performanc Tag: 181331
  - 3
    - BROWSE fonts? Hi. Is there anyway to change the fonts of a given browse column? Got a client who wants certain columns in bold...Dennis Tag: TableUpdate Performanc Tag: 181324
  - 4
    - Where Are Buy (Purchase) Hotel Software For VFP Written ? Hi, Foxer. Where Are Buy (Purchase) Hotel Software For VFP Written ? Price? Web / Url ? Key features ? Please Tell Me, OK? Thanks. - Tuberose Tag: TableUpdate Performanc Tag: 181323
  - 5
    - column class foundation? Hi, I am working with VFP 6.0 and trying to create a new GRID class or subclass such that when a new column is added at run time, the new column control and/or the header or text controls have specific code inside some of the events. I have a found in the VFP foundation class libraries a class named GRID, but not a column one, and inside the GRID class there is no place where I can specify certain code to be inserted I have been adviced that VFP 8 has an option to BIND events, however I can not upgrade right now to a new version. Is it possible to do what I am trying to do? How? Thanks in advance for your comments Oscar Taboada Tag: TableUpdate Performanc Tag: 181305
  - 6
    - Class definition CRYSTALRUNTIME.APPLICATION is not found. Do I get this error because craxddrt9.dll is not registered on the client machine? The client machine has CR9 installed, so I would think the DLL would have already been registered... Any help would be appreciated. Tag: TableUpdate Performanc Tag: 181303
  - 7
    - Error Reading File I have a Visual Foxpro Version 6 application that I have been running since January 2003 on a Novell network with no problems. The PCs are running Windows 2000/XP and are connected to the network using Orinoco USB wireless network adapters and a CISCO access point. About a month ago we switched from Novell to a Windows 2000 server. I've since started getting a "Error Reading File" 1104 error messages. The number of times the users gets the error message varies daily. Some user's PC get it several times a day while other may not get it. Users who are not using the wireless network are not experiencing any problems. Does anyone have any idea what is causing the problem? Is the maybe a timeout issue being caused by the wireless network? The Corporate IT staff have not been able to resolve the problem. I would greatly appreciate any suggestions/help. Thanks in advance. Tag: TableUpdate Performanc Tag: 181300
  - 8
    - Putting More Child Records On Report Detail? I have a report that has a parent record (grouped) that prints in the group header and the child records print in the detail. Easy enough. There is only two fields per child record. I would like to print 4 or 5 child records per detail line to get rid of all the wasted space and to save paper. Is there and easy way to do this in foxpro. I know I could do it in a complicated way with arrays and such but I am looking for an easy way if there is one. There can be hundreds of child records sometimes. I wish there was a detail line setting that says 'wrap'/'unwrap' the detail line printing. Thanks, Rick Tag: TableUpdate Performanc Tag: 181289
  - 9
    - XMLAdapter-XSD headache I am trying to make use of VFP 8's XMLAdapter class and I am running into a problem when trying a LoadXML() on a document. I get the following error: "Incorrect definition for the root element in schema line 4, position 56. <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">" I've seen this exact line in various XML sites as being a valid start to an XSD file. Could someone please shed some light as to what the problem is?? Jon Tag: TableUpdate Performanc Tag: 181288
  - 10
    - Zapped tables in vfp 8.0 Hi all, i recently installed vfp 8.0 on my system and when i try to open (use) zapped dbf files from vfp 6 i get the following error: "Table 'C:\mytable.DBF' has become corrupted. The table will need to be repaired before using again." In the help Microsoft says that it is required a third party tool for repairing but with vfp 6 the file works fine. if i append a record from vfp 6 the file is accessible from vfp 8.0 but if it is zapped, no. I would like to know why this behaviour ??? Is something wrong on my machine??? Note: The behaviour is the same with both SET COMPATIBLE commands (ON / OFF). Tag: TableUpdate Performanc Tag: 181282
  - 11
    - Table Buffering Question Up to now I've used optimistic row buffering for multi-user applications. Now I'm trying to implement optimistic table buffering on the assumption that things will run faster if I don't have to call TABLEUPDATE() and check for update conflicts every time I want to move the record pointer. The help says that with CURSORGETPROP("Buffering","Mytable") = 5, TABLEUPDATE(.T.) will commit all changed records until it encounters a conflict, at which point it will throw an error. I've got a method for handling update conflicts that doesn't rely on trapping the error. Instead, it kicks in if TABLEUPDATE(.T.) = .F., resolves the conflict, and then forces the update. That works fine with row buffering because I call TABLEUPDATE() for every row. It appears that I'm not going to be able to do it this way with table buffering because, I assume, calling TABLEREVERT() puts a stop on the updating process, possibly leaving remaining rows uncommitted, and forcing the update with TABLEUPDATE(.T.,.T.) after resolving a conflict on one row would either stop the process or automatically force the update on all remaining rows. Am I understanding this correctly? Do I need to call TABLEUPDATE(.T.) recursively in a DO WHILE loop? Something like: DO WHILE TABLEUPDATE(.T.) = .F. * My conflict resolution method, in very simplified form, does: IF TheChangesAreOK TABLEUPDATE(.T.,.T.) ELSE TABLEREVERT() ENDIF ENDDO If it's more complicated than that, a sample code snippet would be very helpful. I haven't been able to find a clear explanation of what to do in this case in the VFP Help or in the books and white papers I've read. Thanks in advance. Ken Dibble Southern Tier Independence Center, Inc. Tag: TableUpdate Performanc Tag: 181276
  - 12
    - =?iso-8859-1?Q?I_need_to_detect_processor=B4s_speed.?= I need to detect processor=B4s speed. Screen resolution, color supported and related info will=20 be also very useful. Thanks in advance, Pablo Velazco Tag: TableUpdate Performanc Tag: 181263
  - 13
    - PDF Printing from withing VFP Hello All, Does anyone know of a utility (or technique) for printing Adobe Acrobat PDF files from within a VFP Application. I am scanning documents that need to be printed along with my report. Ideally I have code like this: report form myreport to print noconsole for each pdf file that needs to be printed print the pdf file next the line that says "print the pdf file" is the missing piece for me. Thanks in advance. -- Jeff Grippe Hilldun Corporation Tag: TableUpdate Performanc Tag: 181261
  - 14
    - alines() bug there seems to be a bug in VFP7+SP1 when alines() is called with len(cParsechar) is a multiple of 4 anyone else encountered it? I can not find any previuos reference to it. TEXT TO lcText this is part1 ----delimeter this is part2 ----delimeter and this is 3 ----delimeter ENDTEXT ? ALINES(aParts,lcText,.t.,'---delimeter') ? ALINES(aParts,lcText,'----delimete') ? ALINES(aParts,lcText,'----') ? ALINES(aParts,lcText,'--de') ? ALINES(aParts,lcText,'delimeter') Should return 3 4 4 4 3, but returns 1 1 1 1 3 (only the last has a cParselength that is not a multiple of 4) (fixed in 8.0) Tag: TableUpdate Performanc Tag: 181253
  - 15
    - Visual Fox Pro 6.0 hangs indefinitely Folks: I recently installed Microsoft Visual Studio 6.0 on my machine. All the individual components of Visual Studio work well, but with one exception. For some reason Visual Fox Pro 6.0 hangs indefinitely. I completely uninstalled the entire application, then I did a new reinstallation. The problem persists. I am using a Windows XP Home platform. Just wondering if anyone can throw some light on this problem. Thanks, John. Tag: TableUpdate Performanc Tag: 181245
  - 16
    - VFP questions Folks: I have a few quick questions about VFP. I currently have version 6.0 on my PC. I know that both versions 7.0 and 8.0 are already on the market. * Can I upgrade to V7.0 or V 8.0 for free or do I have to purchase these upgrades ? * Where can I find a good introductory video or audio tutorial to VFP - BOTH free and modest cost ? Thanks, John. Tag: TableUpdate Performanc Tag: 181242
  - 17
    - Using Word documents I am trying to use a word document and the program gives me an error on the "CreateObject" line below. I have made sure I selected ActiveX controls under the Tools/Options section. I started selecting a bunch of Microsoft programs. What am I doing wrong? Am I supposed to compile this code differently? The exact error message is: Class Definition Word.Application not found. I am guessing; I am forgeting to include an API library of some sort. But where? *********** code segment ******************************* cTargetFile = alltrim(pr_WFile) + ".rtf" if CreateWordInvoice(cTargetFile) local oWord oWord = CreateObject("Word.application") oWord.Documents.Open(dir_temp+cTargetFile) oWord.Documents(cTargetFile).activewindow.visible = .T. release oWord endif ********************************************************** Tag: TableUpdate Performanc Tag: 181235
  - 18
    - count all hi folks why after the command "count all to xxx" the command "delete" does not works ? Tag: TableUpdate Performanc Tag: 181233
  - 19
    - Diferent detail sections in the same report. Hi, everybody!!! I'm new user of VFP and I'm triying to figure out a report that can display information from 3 different tables, that is, a statement of incomes and expenses, as follows: -In the first table, I have all the codes for the people. -In the second table, I have all the incomes for each person of the first table. -In the third table, I have all the expenses for each person. My report would be as follows: Cod 1 - Mr. John Peterson Incomes: xxx - hhhhhhh - 1000 lll - fffffff - 2000 total 3000 Expenses jjj - ooooooo - 500 ppp - rrrrrrr - 100 total 600 Net amount 2400 I would appreciate any help and support you can supply me...!!! B.R. Tag: TableUpdate Performanc Tag: 181227
  - 20
    - Seek w/ ODBC Last month, I received some GREAT help on this forum on ways to use VFP and update Clipper NTX files using ODBC and SQL pass through functions for updates and appends (using my Merant ODBC driver). Is there a way to "SEEK" into those Clipper files while in VFP-8 using my ODBC driver and those same Clipper NTX- style index files? For example: Seek a certain date and loop through the DBF file while that date is the same, totaling other field info along the way (such as extended price). I'm sure there will be more clarification requested of me along the way. I just want to get the ball rolling here. Tom Tag: TableUpdate Performanc Tag: 181220
  - 21
    - Using a .NET component in VFP Hi All, I've been working on building a .dll in C# (framework 1.1) and using it in VFP8. As always, the example that runs so smoothly in the article fails at a rather basic point in practice. When attempting to create the object, After building a dll, I used RegAsm.exe to register and received "Types registered successfully" message. But upon trying to create the object in VFP, I get the error: OLE error code 0x80070002: The system cannot find the file specified. Anyone have an idea what (probably basic) thing I'm missing here? TIA, John Tag: TableUpdate Performanc Tag: 181217
  - 22
    - Running Foxpro on Windows 2000 When my (Windows 2000 SP3) users run a program created with FoxPro they get an out of Memory Error even though they have 256MB and 30GB Hard Drive with mass amounts of Virtual Memory. Any suggestions would be greatly appreciated. Karlita krbeam@longfibre.com Tag: TableUpdate Performanc Tag: 181214
  - 23
    - CDOEX with VFP HI There is somewhere a example for CDOEX with VFP ? I need to change a solution based on MAPI to a solution based on Exchange Server -- Philippe Harnois Tag: TableUpdate Performanc Tag: 181203
  - 24
    - Questions in VFP7OLEDBExampleVB sample Hi all, I try to run VFP7OLEDBExampleVB sample application on accessing VFP7 data using OLE DB from ASP.NET app, and I have a problem. Retriving data works OK, but the code give an error when try to update. The error is in the line Dim VFP7UpdateCommand As New OleDbCommand(strUpdateSelect, VFP7Connection) ' Execute the command VFP7UpdateCommand.ExecuteNonQuery() ' <-------- Line with error ' Close the connection VFP7Connection.Close() And the error is "Cannot update cursor" I checked the Update SQL statement, and it seems OK. Does anyone have a clue about what is happening? Thank you. Bogdan Tag: TableUpdate Performanc Tag: 181194
  - 25
    - 'No parameter statement is found' error with VFP3 Hi, Recently, I was doing some enhancement for a VFP3 written old application. When my menu call one of the form. The form will check whether one of the table is open exclusive for packing, if not, will prompt a message and return. However, I keep getting this message 'No parameter statement is found' on my return statment, with my messagebox not working. My menu is calling this form using a procedure which I had added a dummy parameter list, but it does not help as shown below DoBackup procedure called by menu option ======================================== PARAMETERS pvAns DO FORM frmBackup ------------------------------------------------ Part of FORM code that causing the above message ------------------------------------------------ SELECT backup IF NOT ISEXCLUSIVE("backup") =Messagebox("File not in exclusive mode") RETURN ENDIF Please advise how do I solve this simple problem. Thank you Tag: TableUpdate Performanc Tag: 181192
- Next
  - 1
    - Need some lost dll's I was given a stand alone EXE of a Foxpro App sometime ago. I've since moved computers, as has the developer. I kept the EXE but have lost the associated DLL's. Where can I find them? I think I need.. vfpole50.dll (or greater) vfp500.dll vfp5enu.dll vfpodbc.dll Can anyone help? Please email if possible since I don't check these boards often. Thanks much in advance! Tag: TableUpdate Performanc Tag: 181180
  - 2
    - [Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor. Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor. /_asp/test.asp, line 11 It's been a week now figuring out how to solve this problem ("cannot update the cursor"). I am using IIS 5.1 in Windows XP Professional and Visual FoxPro ODBC Driver (6.01.8629.01). System DSN is configured properly. I never have this problem before when I was using IIS 4.0/5.0 in NT 4.0 and Windows 2000 Professional OS. Any suggestions? Thanks in advance. Here's the code for reference: <% language="VBScript"%>  <html> <head><title></title> </head> <body> <% Dim oConn Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open("DSN=UNR;UID=sa;PWD=pwd") oConn.Execute("UPDATE nursegen SET FNAME = 'XXXX' WHERE imgcode = '0000000001'") oConn.Close Set oConn = Nothing %> Tag: TableUpdate Performanc Tag: 181179
  - 3
    - Minimize Window Hello All, I want to minimize a non-FoxPro window in a FoxPro program. I've been told I can do this with Win API calls, but this is uncharted territory for me. Can someone tell me 1) if this is possible and 2) where I might be able to find some examples? Thanks, Brad Tag: TableUpdate Performanc Tag: 181175
  - 4
    - how to modify the method on run time? Hi, I have a form with a GRID to wicj I have to change the ColumnCount property on user´s demand, however I need all columns have some specific code on the Resize method . First thing I tried was to use the WriteMethod method but it seems it will be not useful because it works only at design time (I don't understand what is called design time on this context, but it seems it will be not a solution) Second try was to crete a custom GRID class based on the normal VFP GRID class, however I found that I would also need to create a custom COLUMN class. at least because I am creating the custom class visually instead of using code. It seem to me there is some way to create the custom GRID class without having to create also a Column custom class, but I don't know how Thanks in advance for your comments Oscar Taboada Tag: TableUpdate Performanc Tag: 181169
  - 5
    - - How can I SELECT triplets of records as a single record within the same query? I have a table which looks like this: iId | cName | -------------- 001 | aaa 002 | bbb 003 | ccc 004 | ddd 005 | eee 006 | fff 007 | ggg 008 | hhh ... | ... What I need to do is this: iId1| cName1| iId2| cName2| iId3| cName3 ---------------------------------------- 001 | aaa | 002 | bbb | 003 | ccc 004 | ddd | 005 | eee | 006 | fff 007 | ggg | 008 | hhh | ... | ... Can this be done as a single SELECT statement? Tag: TableUpdate Performanc Tag: 181164
  - 6
    - HELP! How to wait until a form is released (after a DO FORM) to run next code? Hi all, I've been banging my head over this problem for two hours by now: I have a modeless form which called another Modal form with a click of a button: DO FORM form_b Messagebox ("This should only appear AFTER form_b is released!") Is there any way that I could force VFP not to run the messagebox BEFORE form_b is being released? The messagebox keep on appearing on top of form_b regardless what I do. In a desperation I tried: - Change the value of form_b's WindowType Property from Modal to Modeless - Put DOEVENT [FORCE] before the 'DO FORM... ' command - Alter AutoYield property (yes.. I know it has nothing to do with this) - Put the form in a base class and create an instances instead of 'DO FORM' it - Put a bag of ice in my forehead - Eat a Mars bar - Drink two cup of coffee None solve the problem! And this is my last effort: yell for a help in this ng! Ideas anyone??? TIA, Willianto Tag: TableUpdate Performanc Tag: 181162
  - 7
    - Source is out of date Hello, When I'm in "Modi Poject" stage, and I make changes to a PRG file. The changes will not take effect until I completely out of "Visual FoxPro" and come back. In the "Command Box", I tried to delete the FXP file, It will tell me "file is in used" and not allow me to delete. Especially when I tried to debug a program using "Set step on", If I don't exist out of "VFP", it will give me the "Source is out of Date" message. How can I get around this problem?? Thanks a million in advance! Nancy Tag: TableUpdate Performanc Tag: 181145
  - 8
    - call of a function of web browser activeX Hi In VFP6 SP5, I use the WebBrowser control (same as IE) How to call the copy or print function that you can find in the right click menu ? Thanks-- Olivier (enlever les 3X pour la réponse) Tag: TableUpdate Performanc Tag: 181142
  - 9
    - How to use blat.dll to send attach file ? Hi, with VFP6 SP5 In a form, I have a button "mail to the autor this file" 1. What is the right syntax of the string passed to the send function of the blat.dll (I dont know the adress of the sender, le recipient adress is my own adress BlackSabbath@hell) 2. Is it necessary to register the blat.dll during the installation by the client ? Thanks-- Olivier (enlever les 3X pour la réponse) Tag: TableUpdate Performanc Tag: 181139
  - 10
    - VFP 8.0 and Windows It says in the online documentation that VFP 8 requires Windows 98 or later for runtime programs. Does anyone know if this is completely and absolutely true? i.e. will runtime programs actually run under Windows 95? And if so, are there any particular problems? (I have a small user community of W95 users!) Tag: TableUpdate Performanc Tag: 181135
  - 11
    - How to list all open Window in a menu? Hi all, The main window of My_apps is a top-level form, and other 'child' windows are 'In-top-level'. Problem: I want to add an ability to list all open window in my_apps in a menu. Just like the one we have when we click on Window in VFP IDE. Can anybody show me the how-to? TIA, Willianto Tag: TableUpdate Performanc Tag: 181117
  - 12
    - Ejecting a CD using foxpro code? Hi, Does anybody know how I can eject a CD/DVD from foxpro. Is there any examples or API calls? Thanks, Tristan McElhinney BackPack Product Manager www.backpackpro.com [Zip Backup Software, Internet Enabled, Free 30 day Trial] Tag: TableUpdate Performanc Tag: 181104
  - 13
    - Insert Picture into Word I have the book " Microsoft Office Automation with Visual FoxPro" and have been trying to open a Word application and then inserting a picture into it using the following code: GOODAPP = 'TRUE' ON ERROR GOODAPP = 'FALSE' oWord = CREATEOBJECT("WORD.APPLICATION") IF GOODAPP = 'TRUE' oWord.Documents.ADD() oWord.visible = .t. oRange = oWord.Paragraphs[1].Range() oWord.InLineShapes.AddPicture("C:\elks\artwork\elk1.jpg", .F., .T. ,oRange) ELSE WAIT 'AFTER ELSE STATEMNET IT DID NOT OPEN' WINDOW ENDIF The word application opens up and I have a blank screen but I cannot get it to insert the picture. The picture is located at C:\elks\artwork\elk1.jpg Of course elk1.jpg is the picture and it is at that location. I must just be reading or writing something wrong that I can't see. Any help would be nice. Tony Tag: TableUpdate Performanc Tag: 181102
  - 14
    - How to put line feeds into email sent by VFP? How does one add line feeds to the body section of email prepared in VFP? I'm using the ShellExecute method, as in: ShellExecute(0,"open",lcMail,"","",1) where lcMail is built from vars holding adddress, subject, CC, body, etc. data. All the sections work fine except for the body...it comes out as a single long line of text. For example, if I define two line items I want to put in the body, such as: lcLine1 = 'hello world' lcLine2 = 'goodbye' lcBody = lcLine1 + lcLine2 I want it to appear in the email body as: hello world goodbye Instead, it ends up on a single line as: hello worldgoodbye I've tried adding CR/LF's to it, as in: lcLine1 = 'hello world' + chr(13) + chr(10) lcLine2 = 'goodbye' + chr(13) + chr(10) I've tried various combinations of chr(13) and chr(10), to no avail...the body lines always just run together. This is VFP6(SP5) and Outlook Express. What's the secret line feed character for email? I assume it's the same for all email apps. Any suggestions? Thanks :) Tag: TableUpdate Performanc Tag: 181101
  - 15
    - Address formats for English speaking countries Anybody have a list of these or a reference to one (or even some of them)? tia anthony shipley - Military Intelligence..... still an oxymoron! Tag: TableUpdate Performanc Tag: 181099
  - 16
    - How do I store and retrieve double byte characters in a foxpro table? VFP 6.0 SP5 I have an existing application that stores U.S. and European HTML documents and now I have been asked to include the Pacific Rim. I need to store html files, with double-byte characters, in a table's memo field, then retrieve them and display in IE. Do my tables have to be in a specific code page? Does anyone know the exact steps to store double-byte characters and then retrieve them so that they will display correctly in Unicode compatible controls? Thanks in advance, Craig Tag: TableUpdate Performanc Tag: 181098
  - 17
    - A matter of style I'm writing a visual foxpro based application for sale, and I have a question regarding style. There are two forms in question: the main data entry form, and the form that handles printing. The main form has a print button that can call up the print form. The print form has two buttons: Print and Print Preview. My question is this: should I (1) - leave the print preview button where it is and leave the main form alone, (2) - create a new button on the main form for print preview and retain the print preview button on the print form, or (3) - move the print preview button to the main form from the print form. It's a little thing, the coding is no problem either way, but I would like to know. Thanks for your help! Tag: TableUpdate Performanc Tag: 181091
  - 18
    - help Hello: I am new with Visual Studio FoxPro 6.0. I am encountering an error message "Source code out of date". The FoxPro help file indicates this means the .FXP is not matching with the source code. But no where in the help files was I able to find how to fix it. I have compiled the program multiple times. I selected Build Application and Build Project. What am I doing wrong? Emily Tag: TableUpdate Performanc Tag: 181081
  - 19
    - Com+ Hi All I need Example to How Send and Retrieve data From busines rule Com+ Server With ADO Conncted With SQL Server 2000 Tankes Tag: TableUpdate Performanc Tag: 181076
  - 20
    - Comm already open? Hello I am using a form with MSCOMM to comunicate with A MICR Reader connected to it on com1. I have the com port set on the ININ Event thru passed variables from the calling procedure. I then wait for input from the MICR reader and simply write each line to a .dbf. The form works fine in development under foxpro but when I compile the project i consistantly get an error "OLE IDispatch exception code 0" from the forms "MICRREAD.CPORT.INIT" Procedure which contains this.commport = micrcom && 1 this.settings = micrset && "9600,N,8,1" THIS.PortOpen = .T. What would cause it not to run compiled as an exe but to run ok under foxpro? Thanks Glen Tag: TableUpdate Performanc Tag: 181072
  - 21
    - Printing DBF structure Hello, I have a strange printing problem! When "list struture" to the printer, it always take up 2 or more lines because of the spaces between columns. I tried everthing I could think of. I know is not the printer, because, it used to print fine. I tried different printer, differnt printer fonts, still didn't make any differnt. I tried the "Shift- Format", but that only changes the display on the screen. Can some one please help me. Is difficult to read the way it prints. Thanks a bunch in advance Nancy Tag: TableUpdate Performanc Tag: 181056
  - 22
    - COM object string We have purchased a third party com object that requires the sending of a userkey to initialize it. I am having problems with it and I am trying to pinpoint why I am having problems. One of my problems is that the user key that was given to us is 256 characters. I read in VFP help that strings can only be 255 characters. I was wondering if this could be my problem. Can I send 256 characters as a parameter to a method of a COM object? -- Altman VFP7 SP1 "No matter how foolproof you make a system, 'fools' can be remarkably ingenious." Tag: TableUpdate Performanc Tag: 181051
  - 23
    - MS Web Browser in a form Hi All (again), I've got a Web Browser control on a form that gives an error, OLE error code 0x80004005, on startup but functions just fine from that point on. I know I've seen a workaround that involved something like adding a dummy line of code (like m.Dummy = .T. in the Init) but can't recall. Any ideas? TIA, John Tag: TableUpdate Performanc Tag: 181045
  - 24
    - Vfp7r.dll is missing or damaged When I install my VFP7 application on some W95 and W98 machines, I get the message 'Vfp7r.dll is missing or damaged' when running the application. Any ideas? James McKelvie Tag: TableUpdate Performanc Tag: 181042
  - 25
    - VFP on Linux? Wiew please links: http://appdb.winehq.com/appview.php?appId=296 http://www.openfox.org Tag: TableUpdate Performanc Tag: 181035

Has anyone notice a performance issue with the
Tableupdate function in FoxPro 8

I have been converting a large application from Visual
FoxPro 7 to Visual FoxPro 8. The application uses local
views exclusively to perform record updates. I discovered
yesterday an issue with the TABLEUPDATE function between
FoxPro version 7 and 8. The TABLEUPDATE function
performs noticeably slower in FoxPro 8. I have read many
postings on the universal thread concerning this issue.
I have been able to work around most of the slowness
issues based on my readings, however, the workarounds
have not worked in all cases. The update process on an 8
record local view should not take tens of seconds. It
should take milliseconds to update the local views parent
table especially on a 3.0 GHz processor with 768MB of RAM.

Top