=?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?=

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
    - VFP database stability What's the VFP 8 database stability? I tried (long time ago) to work on i'ts database in version 4.0 and and it was terrible (constant damages and inconsistency) - since then I work on plain dbf. Is it in version 8 any better? And btw what about fpt files in this version (fpt files often loses their record links with dbf's). Jader Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205589
  - 2
    - Report Engine Error: Not enough system resources Hello, I am running Visual DBASE 5.5 on a new machine that was just installed with WinXP. The software runs on other machines, but for some reason when I try to runit on this newly configured machine, I get the following error: "Report Engine Error: Not enough system resources". I get it when I try to print a report with the built-in Crystal report tool. Does anyone have any idea as to why I am getting this error? Thanks, Eddy. Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205585
  - 3
    - New Method Why is it after I define a new method: ie, GetRecord that Foxpro dies when I assign this method as follows: THISFORM.GetRecord ( and the moment I enter the ( I get the following error: Fatal Error Exception Code=C0000005. This Method has LPARAMETERS and I am simply trying to pass them. This is VFP7 with SP2 and thats as good as it gets. If I paste GetRecord ("Delete") it works fine, as long as I don't do this within the Foxpro environment... Am I missing some important update? Thanks for your help Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205584
  - 4
    - Hiding main foxpro window Hi I am new to foxpro and am having a problem with the way it executes. In the program I call a form using a do form command and then a read events command right after it. I have compiled this and my form comes up with the data I want on it but theres a MicroSoft Visual Foxprow window behind it that I don't want to see. I assume its the window executing my code until the read events command. How can I hide this window? Thanks and cheers Jerry Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205573
  - 5
    - Unable to find an API Can anyone tell me why I'm getting the following error when I try to compile my program? Program c:\source\vbpf\prgs\procedures.prg has the following errors: Unknown _WFINDTITL - Undefined Unknown _WHTOHWND - Undefined I have this line of code in my main program SET LIBRARY TO SYS(2004) + "FOXTOOLS.FLL" ADDITIVE I have this procedure in a different program PROCEDURE TileVertically LOCAL lnhWnd * Get the Active Form's window handle lnhWnd = _WhTohWnd(_WFindTitl(_SCREEN.ActiveForm.Caption)) * Get the form's parent window lnhWnd = otile.GetParentWindow(lnhWnd) otile.TileVertical(lnhWnd) ENDPROC Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205566
  - 6
    - check if filename is legal Hi, Is there a way in Foxpro to check if a filename the user entered is legal before creating it ? thanks ! Xavier Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205554
  - 7
    - outlook class with MDI form with pageframe Hi, Can anyone show me the code to create a pull down menu with following :- - outlook class at left hand side - mdi form with pageframe at right hand side - on click of outlook class button the mdi form change accordingly ? Regards Hoe Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205549
  - 8
    - OLE error code 0x80020006: Unknown name All, I have a VFP7 application that manipulates the Outlook Inbox - searches for incoming emails and does some processing to them. One of my clients has just started receiving "OLE error code 0x80020006: Unknown name" on this line... m.FINDCNAME = UPPER(PADR(ThisForm.oItem.SenderName, LEN(cName))) Any clues? Thanks, Brian Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205547
  - 9
    - sql cursor Hi, SQLEXEC(nConnect,'select * from mytbl') I read user guide that the result will be stored into cursor SQLRESULT. But when I call 'SELECT SQLRESULT', an error 'alias not exist' shown. What am I missing ? Regards Hoe Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205544
  - 10
    - Hidden/protected object test function? Is there an easy way to test if an object is hidden or protected? I'm grabbing a likely property, BASECLASS, and using pemstatus(....,2). Just wondering if there's anything more direct. -Lew Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205541
  - 11
    - VFP table lookup on a PDA Hi, I've got a fun new project, where people in the warehouse want to be able to key in a stockcode on a PDA and return data from from our central VFP tables about current stock levels and stock location over a wireless LAN connection. PDAs will be Windows Mobile based. I realise that native VFP apps won't run on these, but there are still a few different approaches to this - various web based ones, .NET apps, etc. I'm not sure which would be best, easiest or cheapest. (got .NET through MSDN as an option, but never had time to try it out seriously.) Is anyone running a similar app? Any pointers would be very much appreciated. Cheers, Neil Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205539
  - 12
    - distributing DLL Hi friends I've created a DLL in vfp8.i want to distribute to some software vendors . my question is do i need to distribute vfp runtime files also along with my DLL? i tried using my DLL in VB on a machine which has no foxpro s/w and got runtime errors(like activex objects cant.....etc.,) but it worked fine when i copied vfp runtime files to the folder where my DLL exist. could u guys tell how you u normally distribute a DLL created in vfp. Thanks -- cheers Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205531
  - 13
    - EXE size differs when I rebuild project. I have a project. I built the EXE about 2-3 weeks ago. This morning I build it again, and the EXE it produces is a couple hundred bytes larger. Nothing has changed, the project is kept in sourcesafe and I did a get latest into a clean directory. What would cause the EXE to be different in size when rebuilding it a few weeks later? I rebuilt it in the same directory structure, but my environment changed in that I have more mapped drives. I can't think of anything else that might have changed. Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205529
  - 14
    - Comma Seperated String I was just wondering if there was a built in VFP function for converting a Comma Seperated String variable into an array. Or if there was any other function that dealt with a Comma Seperated String. I could make my own functions but if they already exist I would rather use those. -- Altman VFP8 SP1 Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205523
  - 15
    - EditBox with .NULL. value Using VFP 6.0, I have an editbox on a form and everytime the control source, which is tied to a field in a table, is .NULL. I can not change/add any information in the editbox. Is this a bug with VFP6.0 and if so, is there a way around this? Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205522
  - 16
    - Field Names Hi! I would like to just extract or print the field names, type of field and size from a table. Is this possible? Thanks Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205519
  - 17
    - Temp files Hello and thanks in advance for the help. I have the following lines in my config.fpw tmpfiles=c:\foxtemp sortwork=c:\foxtemp progwork=c:\foxtemp editwork=c:\foxtemp My applications (EXE's) reside on a folder on the user's PC and access data on network drives. The applications are started from the folder on the local PC. It seems that all of the temporary files which result from SELECT * FROM WHATEVER INTO CURSOR MYCURSOR READWRITE and any resulting index files are placed in the startup directory. Is there a configuration setting to tell VFP where to put these files? Thanks, Jeff Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205513
  - 18
    - test ignore Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205508
  - 19
    - Treeview Control Does anyone know how to change font/color of nodes in the treeview control? Is that even possible? If not, is there a better control to use instead? Many Thanks Shahriar Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205501
  - 20
    - how to get all remote cursors connection in current data session? Hello all, Continuing my problem regarding connection to MSSQL, here is the latest progress (and question) about my effort to find the solution. Because my thread 'A lot of lockings and connections to SQL Server. Is it normal or bad?' in this ng didn't get any reply, I decided to cross post in microsoft.public.sqlserver.programming (I put the discussion in this post for your convenience in case you're willing to read). Anyway after giving more thought about the problem, here is what I found: I found out that each time I run any form in my apps (the form is child window, in-top-level, private-data-session), after I close the form, there were two or three external connections still intact. I can easily 'kill' those external connections by running following break.prg. *!* Break.PRG ON ERROR * FOR i = 1 TO 200 SQLDISCONNECT(i) ENDFOR ON ERROR *!* end of break.prg Regardless whether I kill those connections or not, after I run another form, there would be other two or three external connections added (and other locking as well - although I don't understand what kind of locking MSSQL do). All connections belong to one apps would be immediatelly close if I closed the apps. Yes, I know that this would be my own fault and I should learn more. That's why i already purchase a copy of Client Server with VFP6, and will certainly read the book cover-to-cover. Anyway, what I need now is a quick-and-dirty fix to my problem. What I have in mind is to explicitly close the connection with SQLDISCONNECT( ) on the Destroy event of each form. I can easily put that in my baseclass form and it will affect all forms in my apps. Problem: Anybody knows how to get (and to traverse) all cursors (remote views and cursor from SPT) in current (active) data session? I cannot run break.prg on Destroy event, because that would kill other connections needed by other window. I'm looking forward to hearing from you! TIA, Willianto Following is the discussion I mentioned above: My original post: --------------------------------------------------------- Hi all, First of all: *** HAPPY NEW YEAR TO YOU ALL!!! :) *** then, here it goes; I've downloaded SQL Spy 6.0 from Hybridx (got it from http://files.webattack.com/localdl834/sql_spy_setup.zip). It's a freeware tools to monitor SQL Server activity. I use this tool to watch how my apps (created with Microsoft Visual FoxPro 8.0 SP1, connect with SQL Server thru ODBC) interact with SQL Server. I found out that on some parts of my apps (where there are lots of traverse and calculation), the number of locks on the SQL Server could go up to 700 and the external connection could go up to 15 or 20. And I tested that on my box (that means; I run my apps on the server and no workstation connect to the server). Whilst the apps so far running fine, it's never been really tested to the max. The traffic are quite low and the concurrent user has never exceed eight users. Yet, looking at the numbers, I'm afraid that there something that I don't do effectively. My Questions: 1. Is the number normal? 2. Anybody here can give me advices on C/S programming, I mean just a quick thumb rules what should and what, like should I make a connection, get the data, and disconnect immediately. Or should I share all SPT in one connection?, or any other rule what should and shouldn't? Thanks in advance Willianto ====================================== Following is the reply from Louis --------------------------------------------------------- This is the open question of all times. Without looking at the code, the best that can be said is that you might be fine, or you might have written a terrible app (something we all have done at one time or another :) Lots of locks are fine, as long as you don't have lots of users contending for those locks. You say you have 8 users, is that all you are planning for? If everyone is happy, it might be fine. Bottom line is that you need to get some literature and read up on design, internals, optimization, etc before you can decide if your application is well written, and experience is a must. Without being able to magically aquire this (and it takes a while and sadly we learn from failure!) I would suggest that you take this statement: > Whilst the apps so far running fine, it's never been really tested to > the max. Define what max means and test for it. If it works fine under max conditions, then your application is fine. ====================================== And my reply again: --------------------------------------------------------- Hi Louis: Thanks for your reply. > best that can be said is that you might be fine, or you might have > written a terrible app (something we all have done at one time or > another :) Lots of .. [skipped] Looks like my case is the second one :( As I stated in my post, the application runs fine, but it runs with a very minimum load. That's because the company using my apps is a machinery trading company. The activity is very low. To give you a clue how 'low' is that; they only have to create less than 10 invoices a day. Actually, that's the best numbers they got for years (that means less than ten sales a day - but, hey, the profit of selling one machine could cover three months expenditure!). Anyway, what I did is I backup the database, call up some of my fellow, line up eight computers, and massively attack the system with all the apps feature (purchasing, receive goods, stock preview, stock opname, delivery order, customer order, etc...). After an hour we manage to hang the server which by then, got about 350,000 locking and 80,000 external connections :( So, using SQL Server as a backend is not _that_ easy... Oh well, at least I know for sure that the problem won't appear in my client for a near future. Regards, Willianto Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205492
  - 21
    - how to post a message in my application to the users i want to display a message to the users of my application a message when certain administrative tasks are to be done (esp indexing of the files, or forcing the clients to log out). How can i display these messages to the users of my application? Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205490
  - 22
    - how to bring my vfp screen to the front if my vfp application has lost focux (ie the user is now using another application), then how can i forcefully bring up my application (to the front). i remember seeing some API functions for this. Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205489
  - 23
    - Combo and Exit Routine I thought that if I wanted to exit the ComboBox (VFP7) I could press ESC and in the KeyPress Event I would RETURN 0. This seems to fire the Valid event, where I am checking for LASTKEY() = 27 and once again returning 0. Does not seem to work. What important steps am I missing here? Thanks for your help Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205480
  - 24
    - ReadOnly property hi friends I am created a custom class programatically and want create a readonly proerty. e.g. DEFINE CLASS myclass AS Custom cVersion ='1.0' && i want this to be readonly ----other code here ---- enddefine Thanks -- cheers Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205478
  - 25
    - Form not coming up in exe New to Foxpro and have an application using a form. When I run the program from within foxpro the form comes up and works fine but when I create an .exe file the program excutes but the form doesn't come up for any user input. Don't know where to go from here. Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205477
- Next
  - 1
    - creating DLLs Hi Friends Can someone suggest a good document on how to create DLL and related issues. I am using vfp8 Thanks -- cheers Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205474
  - 2
    - Report data environment affecting form data environment Hello, I've embedded a report within a form. Running the report moves the record pointer of the forms data environment. Setting AutoOpen and AutoClose of the report data environment had no effect. How can I prevent the report data environment from affecting the forms data environment? BTW: Both report and form data environments are the same, even table relations. Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205465
  - 3
    - After closing a form, a connection doesn't disconnect thoroughly I just found out that whenever I closed any forms (in which I use remote views), than the connection doesn't disconnect automatically. Is this a normal behavior or do I miss something? I could not literally put SQLDISCONNECT because there might be other forms use the connections. I checked the connection using SQL Spy as I stated in my previous post. On my forms, I use Private Data Session, connect to the SQL Server via ODBC. Please advice. TIA, Willianto Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205459
  - 4
    - Color Change of 'WAIT WINDOW' Does somebody have an idea on how to change the default grey color of the WAIT WINDOW to any other color ? I am working on VFP 8.0 Thanks, Ted Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205444
  - 5
    - Help with FoxPro and DirectX 9 Hi, every time i try to use the video control from MS TV Video Control (MSVidCtl.dll - DirectX 9), FoxPro always Crash. Does anyone knows what is hapening? Any work arround? Thx -- Livrinho Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205436
  - 6
    - Report Page Number Hi, Is this possible in a single report? I want to be able to group my invoice report and somehow reset page numbering. I tried counting the lines and using variables but had problem when data overflows. Page 1 of 1 Page 1 of 2 Page 2 of 2 Page 1 of 3 Etc. -- Thanks, Karma Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205430
  - 7
    - World Country & Cities Codes Is there anywhere I can download a complete list of world's country code and it's respective cities code ? Thanks in advance! Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205427
  - 8
    - Link VFP char/varchar data in ESRI ArcView 8+ Does anyone in this group have experience with ArcView 8 or 9? I am having no luck getting ArcView 8 or 9 to link spatial attribute data to my foxpro table. The field type I am trying to link with is a VFP char or varchar. The resulting link returns NULL in ArcView. This problem did not occur in ArcView 3. Hope someone out there can help... Thanks! Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205415
  - 9
    - Messagebox-like .bmp's I've written my own messagebox-like dialog class and I'd like to display the standard messagebox graphics. The only complete set I can find is a bunch of icons which display with white backgrounds in the image control. Is there any (easy) way to make the backgrounds transparent so I can have a more professional look? -Lew Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205407
  - 10
    - Conversion of Foxpro 2 Source to Latest Version of Foxpro or VB.Ne I have a client that wants a Foxpro 2 application updated to the latest version of the language or VB.Net. They have the source code. Any suggestions on how best to proceed? Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205406
  - 11
    - Empty Objects This function can be useful for handling lightweight objects: *--------------------------------------------------------------------- * EmptyObject(fieldsList) * Receives a list of fields separated by comma * Returns an empty object with empty properties *--------------------------------------------------------------------- * Test: Customer = EmptyObject("Name,Address,Phone,Contacts[5]") Customer.Address = EmptyObject("Street,City,State,Zip,Country") Customer.Name = "John Doe" Customer.Phone = "555-1234" Customer.Address.City = "Sunny Beach" Customer.Address.State = "FL" Customer.Address.Zip = "12345" Customer.Contacts[1] = "Jane Doe" Customer.Contacts[2] = "Jim Doe" Set Step On && Check out Customer object Return Customer *--------------------------------------------------------------------- Function EmptyObject LParameters fieldsList As String If Empty(fieldsList) Then Return Null Endif Local Array fieldsArray[1] Alines(fieldsArray,fieldsList,.T.,",") Local oEmpty oEmpty = NewObject("Empty") Try For Each item In fieldsArray AddProperty(oEmpty,item,"") Endfor Catch oEmpty = Null Endtry Return oEmpty EndFunc *--------------------------------------------------------------------- Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205402
  - 12
    - How to allow the user only to select a drives? Hi everyone, I need to allow the user only to select a drive from the machine. I need to create a predefind path in a drive. For this I need the user to select the drive where to create it. Is there a way where I can prompt the user to select the drive like in GETDIR()? Thanking in advance. Nadee. Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205389
  - 13
    - Urgent! Can you help? I need someone to help me to work out the VFP solutions for the following within the next 4 hours. Who can help? Many thanks!!! 1) N!*M!(N-M)! 2) the square measure of a triangle 3) the summation of the even numbers from 1 to 200 Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205387
  - 14
    - How Do I Ask VFP8 if a Folder Exists? In VFP6, ? FILE('MyFolder\NUL') returned .T. if MyFolder existed. VFP8 returns .F. even if MyFolder exists. I used MD with an error trap as a kludgy workaround. Is there an easier way (or function) in VFP8 to determine if a folder exists? TIA Steve Meyerson Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205382
  - 15
    - Corrupted method code It's time for my semi-annual rant on this subject. I had hoped that Microsoft had fixed this, but it appears to still be there. Today I'm working on a form, and out of the blue, I open the form and find this in a dozen different methods: http://zootal.no-ip.info/stuff/evilvfp.jpg At this point the code that was there is irretreivably lost. Gone. Permanantly corrupted. This represents the loss of two days work, since that is how long since my last backup. This is something I have observed since VFP6. It happens with VFP6,7, and 8, Win98/2000/XP, fat32 and ntfs, and doesn't matter what machine I work on or where <sigh>.......and now I get to redo what I've spent the last two days doing....<sob>... Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205379
  - 16
    - return value Dear sirs In my program I've a form which should return more than one value I use DO Form frm TO var but this method only returns one value which is (var) How can I return more than one value or an array of elements??? thanks Mohammed Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205375
  - 17
    - How to Put a Array in a Report ? Dear Foxer There is a Array in a Report. After Build a .Exe file, has the following errors: Unknown xxxxx - Undefined How to do ? Thanks. - Tuberose Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205366
  - 18
    - can save report as image file hello sir, can i save the spool of print report to printer as physical file print it any time later or can i save the report as image physical file attache in mail the problem i want to attache the receipt (payroll system) of every employee to him email and send it to see as image file or print it thanks mohamed nour Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205359
  - 19
    - Intellisense - Webservice I have a web service and I am trying to register it in the intellisense manager. Based on the documentation and other readings I have found, it indicates that after I click on Tools-Intellisense Manager-Type-Webservices, I should be prompted to enter a name for the service and the WSDL url location. I am using VFP8 and I am only prompted to enter the WSDL location. Where do I enter a name for the service so that I can use the methods and properties in my code using intellisense? Many thanks and happy new year to all. Regards Shahriar Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205358
  - 20
    - A lot of lockings and connections to SQL Server. Is it normal or bad? Hi all, First of all: *** HAPPY NEW YEAR TO YOU ALL!!! :) *** then, here it goes; I've downloaded SQL Spy 6.0 from Hybridx (got it from http://files.webattack.com/localdl834/sql_spy_setup.zip). It's a freeware tools to monitor SQL Server activity. I use this tool to watch how my apps (created with VFP8SP1, ODBC, RVs and SPTs) interact with SQL Server. I found out that on some parts of my apps (where there are lots of traverse and calculation), the number of locks on the SQL Server could go up to 700 and the external connection could go up to 15 or 20. And I tested that on my box (that means; I run my apps on the server and no workstation connect to the server). Whilst the apps so far running fine, it's never been really tested to the max. The traffic are quite low and the concurrent user has never exceed eight users. Yet, looking at the numbers, I'm afraid that there something that I don't do effectively. Anybody here can give me advices on C/S programming, I mean just a quick thumb rules what should and what shouldn't. Thanks in advance Willianto Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205357
  - 21
    - MSMQ in VFP I am wanting to implement MSMQ in my VFP app. I found Randy Brown article on MSMQ from VFP 6.0. There is so much to read and I know so little. I do not want to reinvent the wheel and Mr. Brown's article is dated 1999 so some of it may be out of date. Where should I start? I do not mind reading or even purchasing 3rd party products to aid im implementation but I really do not know where to start. I found a link to documentation for version 2.0 but nothing to 3.0. Do I need the SDK? Thanks for any guidance. John Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205353
  - 22
    - WTB DBFtrieve or other Btrieve access Anyone have a copy of DBFtrieve they want to sell? Or some other access to Btrieve data that's programmable and preferably has a small footprint? Please contact me at the address below or in the ng. -- Email to (remove spaces and make other obvious corrections): p p m b 2 0 0 4 - n g at y a h 00 Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205352
  - 23
    - store tables to server while installing app, how Hi, This is probably easy to most of you but is my first trial. I have an app that utilitize free tables stored in the server under a directroy "app_data" To access the data I have this set path command hard coded in my main.prg: SET PATH TO "F:\APP_DATA" This is working fine except now I would like my program to be installable on any workstation on which the server is mapped to some other drive letters instead of F:. What changes would my program need in order to allow the user to store the tables in any directory he desires while running setup of the app, and the app still knows where to find these tables? How exactly is it done? Thanks for all help. -- jw Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205343
  - 24
    - Runtime reports I have generated an insurance claim form using the GDI+ and the render method of the report listener. The form prints and previews perfectly when I run it as an .APP from within VFP9, but will not generate any print or preview output when I run it as an .EXE outside VFP9. The report is rendering, there is just no output. What am I forgetting to compile into my .EXE to get the output? -- Marina Nelson Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205337
  - 25
    - calling a Webservice from VFP I am trying to test calling a webservice created in VS.net. I can access the webservice from ASP itself. When I try to access it via VFP, i get the following error message. OLE error code 0x8002801d: library not registered. My vfp code is o=CREATEOBJECT("MsSoap.SoapClient30") ?o.MSSoapInit("http://localhost/WebService4/Service1.asmx?wsdl") Is there something else that need to be registered? I am using VFP8. Many thanks Shahriar Tag: =?ISO-8859-1?Q?HOWTO=3A_Insert_Tables_in_a_Word_docu?= Tag: 205331

Continuing spreading the VFP knwoledge, here's a great code about
Automating MS-Office with VFP.

--- HOWTO: Inser Tables in a Word document ---
http://www.panoramabox.com/GoPub.aspx?IdObj=2363

As usual, the site is in spanish, but the code is in Universal Language
(VFP).

HTH

--------------------------
Esparta Palma
SysOp www.PortalFox.com
Mexico

Top