How to Terminate a VFP COM DLL

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
    - SQL Query, difference between vfp7 and vfp9 This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C62844.9B774550 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a table of donors, their donations and the dates of donations. I want to produce a sql cursor of the total amount given by each person = and the date of the last donation for each person, along with some other = fields. I remember reading that the command syntax has changed in vfp9, = something to do with Group By, but can't remember what the change was. Is the correct sytax in vfp 9 this: sele cdonor, sum(ndonation) as ntotal, max(dDate) as dLastDate, = caddress, cgreeting from mytable into cursor printthis group by cdonor Many thanks Stephen ------=_NextPart_000_000E_01C62844.9B774550 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I have a table of donors, their = donations and the=20 dates of donations.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I want to produce a sql cursor of the = total amount=20 given by each person and the date of the last donation for each person, = along=20 with some other fields. I remember reading that the command syntax has = changed=20 in vfp9, something to do with Group By, but can't remember what the = change=20 was.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Is the correct sytax in vfp 9 = this:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>sele cdonor, sum(ndonation) as ntotal, = max(dDate)=20 as dLastDate, caddress, cgreeting from mytable into cursor = printthis=20 group by cdonor</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Many thanks</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Stephen</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_000E_01C62844.9B774550-- Tag: How to Terminate a VFP COM DLL Tag: 220539
  - 2
    - More SQL here is my code, as you can see i am running these in 2 queries. and then into a report. my report references the queries TOM AND TOM1. the problem is this, when i run the report, whch ever query is first, only shows the first record oover and over. is there any reason for this? i know that the number of records found could be more in one than the other..could that be the issue? SELECT AGENCY,DEPT,COUNT(*); FROM newmem ; where empdate between gomonth(checkhdr.procdate,-1) and checkhdr.procdate AND INLIST(dept,24,34,35,38); Group by 1,2; into cursor TOM1 SELECT AGENCY,DEPT,Count(*); FROM newmem ; WHERE empdate between checkhdr.procdate and gomonth(checkhdr.procdate,1) AND (INLIST(dept,24,34,35,38)); Group by 1,2; INTO CURSOR TOM report form f:\lopvfp\newmem\listing.frx preview Tag: How to Terminate a VFP COM DLL Tag: 220531
  - 3
    - Syntax error in remote view? Hi, I just spent yesterday and this morning defining a remote view on a SQL database. It was working fine until I just tried to reload the view to modify it. When I try to modify the view the view designer gives me a syntax error followed by a "View/Query designer is unable to reload your changes. Would you like to rebuild content from designer?" If I say, Yes, it gives me a blank designer screen and if I select No, it displays the SQL code but it's incomplete. If I run the view it works still even thought the designer is blank. Help! How can I recover my work? How can I tell what's wrong with the syntax of the view and why didn't it warn me when I created the view? VFP 9 sp1. Thanks in advance, Linn Tag: How to Terminate a VFP COM DLL Tag: 220530
  - 4
    - VFP6 Automated emails Aplogize in advance if this is redundant. Have a program that runs at set times. Need it to automatically send an email, with attached "csv" using Outlook already configured. Any sample code? - Ben Tag: How to Terminate a VFP COM DLL Tag: 220529
  - 5
    - VFP9: report with PROMPT and Chaining Hello. Could somebody help me with a problem: When chaining different reports in VFP9 into one printout I'm not able to get printed a range of pages picked by PROMPT dialog (it always prints all of pages). I'm using of course NORESET NOPAGEEJECT keywords etc. When prompted from print preview to print a range of pages - it works. Another issue is with _PAGETOTAL variable - when chaining report it never really works for me, when printing from a single report - again it works. M.Kujawa Tag: How to Terminate a VFP COM DLL Tag: 220526
  - 6
    - VFP9: REPORTBEHAVIOR 90 - dot matrix printers major problem Hello. Can somebody confirm this? I think - there is a major problem when printing on dot matrix printers when using new object based reporting feature of VFP9 (reportbehavior 90). Printouts are always too small or too large - never really match those printed on laser or ink printers. Tried several dot matrix printer drivers with no success. M.Kujawa Tag: How to Terminate a VFP COM DLL Tag: 220525
  - 7
    - unexpected slowdown with many indexes I have a local view with about 20 fields. For sorting purposes in a grid, I have created an index tag on most of the fields. My problem is, some operations become amazingly slow when all those tags exist. For instance, a simple COPY TO can take 30 seconds, even though the view has at most a couple thousand records, and usually far less. If I delete the index tags, operations are as quick as they should be. Anyone know what's going on? -- You can reach me at: p one six seven k b r (remove spaces and convert words to digits) at comcast dot net Tag: How to Terminate a VFP COM DLL Tag: 220514
  - 8
    - VFP to nTier/ASP.NET 2.0 Hello, I'm looking for and application framework that will help us migrate to an nTier world in VFP as well as provide an application design that will ease the transition/migration to an ASP.NET 2.0/.NET 2.0 world. I know the Mere Mortals framework has versions for both VFP8 and .NET 2.0, can anyone comment on these products or other products that may help in the transition? Thanks. -- William Fields MCSD - Microsoft Visual FoxPro US Bankruptcy Court Phoenix, AZ ".dll hell - .rpm hell - whatever. The grass is always greener" Tag: How to Terminate a VFP COM DLL Tag: 220512
  - 9
    - Utility to protect VFP6-9 executables from decompilation Hi, all and especially Josh Assing I have improved protection mechanism of beta version of Defox so it uses different keys for each protected file. So, if you know how to unprotect one protected file, it doesn't mean that you know how to unprotect another protected file. And I believe, that it is sufficiently difficult to create general unprotection utility. Limitation: Every file included in exe must be less than 16Mb Limitation of beta version: All protected programs will start with the messagebox stating about protection. This messagebox will be removed in the final release. Caution: few functions in protected executable may return different result, so force program to work differently. These are Program(-1), Sys(16) and may be some else. Except this, protected program must work absolutely the same as original. The utility is written in VFP6, so if you have VFP6SP5 runtimes, you may download only executable (~240Kb) www.grada.lv/defox/defoxb.exe If you don't have runtimes, you may download install package (~3.7Mb) www.grada.lv/defox/defoxb_setup.exe All feedbacks both negative and positive will be greatly appreciated. Sincerely, Leonid Tag: How to Terminate a VFP COM DLL Tag: 220509
  - 10
    - debugging with timers Hi, I have a general question about debugging : I have a program that uses some timers that fire every 200 msec or so. When I'm debugging code, the timers keep firing and makes it very hard to debug. Is there a way to prevent this when I'm in "suspend" mode ? thanks for the help Xavier, CPS Tag: How to Terminate a VFP COM DLL Tag: 220500
  - 11
    - Differences between .exe and development version I recently compiled a large project and have noticed some problems with differences between the .exe and the development version. 1. I get an error when calling createobject() saying that the class is not found. This doesn't happen in the development version. I know the class is available because once I call a form that has that class built-in, then the error doesn't come up any more when calling createobject(). 2. I have a special key that I trap in a form's keypress method. The keypreview property is set to .T.. It works fine in the development version, but is totally disregarded in the .exe. Any help would be greatly appreciated. Rick Tag: How to Terminate a VFP COM DLL Tag: 220496
  - 12
    - Users leaving form open Q. I have a "Sign In/Out" Board that works great but the users leave it open and walk away from their desks. How do I detect no movement or interaction with the form and close it down after so many minutes? Respectfully, Jonathan Morningstar ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Tag: How to Terminate a VFP COM DLL Tag: 220495
  - 13
    - SQL Gurus Welcome here. well from this forum i am learning SQL, and really dont know why i never used it before. but i have a Question. the following code will create get the correct Data. it returns a number of records. in those records i could have 10 agency 1 dept 1 records, and 5 agency 2 dept 2 etc etc... the query has them listed, i would like a report to show only Agency 1 Dept 1 10 recs not a list of 10 but a summary. USE F:\foxpro25\lopfi\dbases\checkhdr SELECT 0 USE F:\lopvfp\newmem\newmem.DBF SELECT AGENCY,DEPT,; FROM newmem; WHERE empdate between checkhdr.procdate and GOMONTH(checkhdr.procdate,1) AND (INLIST(dept,24,34,35,38)) ; INTO CURSOR TOM BROWSE *report form f:\lopvfp\newmem\listing.frx preview CLOSE DATA Tag: How to Terminate a VFP COM DLL Tag: 220481
  - 14
    - newbie SQL increasing Column size I have 2 columns that are Numeric 2.0 in an SQL Select (MyHours*MyDays) AS Atotal >From mytable Where (1=1) Into Cursor MyNew IF MyHours=99 AND MyDays=99, I get a "*********" in the table. (99*99)= 9801 The column Atotal is expecting a 2 digit number and NOT 4 digits. How do I increase the column size of Atotal to Numeric 4.0? Any Suggestions? TIA. Steve Tag: How to Terminate a VFP COM DLL Tag: 220478
  - 15
    - Stopping a "report sequence" Hi -- - I have a non-interactive sort of program that issues lots of different reports in a sequence. Is there a key or key sequence that can be used to abort the sequence (50+) of reports? In other words, stop the program in its tracks? - Repeated use of the ESC key does not stop the sequence. On the other hand, I don't want to use the ON ESC command in the program because I need the ESC key to "release" individual reports along the way that are not needed or for which there are no data. - Thanks for any help. - David Tag: How to Terminate a VFP COM DLL Tag: 220475
  - 16
    - Get Rich Take advantage of a great deal Tag: How to Terminate a VFP COM DLL Tag: 220472
  - 17
    - Append From? Hi, I am creating a new database and I have records in Excel that I want to import into my new table. I originally tried importing straight from the Excel workbook but had troubles so I saved the data in a tab delimited text file. The first field in the text file is the primary key field in my table but when I perform the import I get an error, "Uniqueness of index PROP_NO is violated". I've double checked my data and there are no violations that I can see, how can I determine where my error is? Or what am I doing wrong? Thanks in advance, Linn Tag: How to Terminate a VFP COM DLL Tag: 220462
  - 18
    - Contracting in the UK Hi All, I've been considering for a while contracting here in the uk. I've a mixed range of Foxpro DOS/Windows v2.60, Visual FoxPro v6 through to v9, SQL Server, MySQL and recently a bit of C#, all prodominantly in an client facing accounts environment. Has anyone else here experiance on the contractor market here in the uk? How would I go about setting myself up as a contractor, finding contracts etc. Is there a call for the skill set I possess? Or would I be better off finding a permanent position? Thanks in advance for any advice given. Cheers Tag: How to Terminate a VFP COM DLL Tag: 220456
  - 19
    - Translate-SQLServer How can I translate from Foxpro to SQLServer? Have a look, example: Foxpro: SELECT field1, field2 from table1 where field1=10 INTO TABLE table2 And SQLServer: SELECT field1, field2 from table1 where field1=10 ? How? Thanks in advance, very much. Catherine Tag: How to Terminate a VFP COM DLL Tag: 220452
  - 20
    - Mouseup event -- I have a screen(VFP9,sp1) with a grid. In the grid the RecordSourseType is Alias. I change the index of the file in Mouseup event. If I close the file and open again I lose the "Mouseup event". How can I recreate it programmatically? Thank you in advance. Sandor Tag: How to Terminate a VFP COM DLL Tag: 220444
  - 21
    - Member object removed -- cannot complete the Save operation error message Hello Has anyone seen this error message, and what do you do to fix. In my one form I occasionally get this message, no object was remove just some method code changed. If I rebuild the project it will lockup when compiling this form. Then I have to shutdown fox using the task manager and restart and most of the time it will be ok again, but I lose my work. Any ideas... Dave Tag: How to Terminate a VFP COM DLL Tag: 220439
  - 22
    - VFP6 .dbc Validation Errors It is nice to finally have FK RI working. This leads to the next questions which deal with error recovery. 1) If a column constraint is violated (error 1582), I get back a text message, but the column name would be nice, too. (Yes, I could simply return the column name and look up that in an error message table, but I am hoping for something simpler.) 2) Is it possible to find out which trigger failed? If I have a table with two FKs, how do I tell which is wrong? In this case, there is no unique text returned. Even getting the column name would help. (If I violate the uniqueness primary key constraint, error 1884 returns the column name. I want something like that here.) 3) Is there any guarantee of which order the constraints are checked / the errors are thrown? If not, what has been your observation of the order? Sincerely, Gene Wirchenko Tag: How to Terminate a VFP COM DLL Tag: 220424
  - 23
    - VFP 6 .dbc FK RI I have a couple tables where one has an FK into the other. How do I get the FK enforcement code into the .dbc in the first place? gendbc does not do it. Sincerely, Gene Wirchenko Tag: How to Terminate a VFP COM DLL Tag: 220415
  - 24
    - Compiler Error I've compiled my application, and gotten rid of all of the compiler errors except one. I have a report that uses an external array in the fields, and the compiler reports "myarray UNDEFINED". I have other forms that use external arrays, and I simply put an EXTERNAL command in. But I don't know where I can place an EXTERNAL command in a report so that it doesn't come up with the compiler error. The report works just fine, but there is just something about seeing the "0 Errors" at the end of your compilation. Rick Tag: How to Terminate a VFP COM DLL Tag: 220412
  - 25
    - VFP 9 - ODBC and C# I am creating an app that uses C# to access web services on the Net, I have my base data in VFP 9 tables, I want to bind a list box from the C# module with a username picked from the VFP tables. When I go to set up a VFP driver in ODBC it tells me to go download the latest ODBC drivers from the msdn site. When I go to the site, the only drivers I see are for W95 98 or NT, is that the one I need to use? Or is there an easier way to do this? TIA Tag: How to Terminate a VFP COM DLL Tag: 220410
- Next
  - 1
    - Exe Problem I just compiled my project into an .exe with vfp9/sp1. I installed it on a server. The application runs fine on that box. However, I wish to run the application on the workstations. I map the network drive on the workstation and place a shortcut on its desktop which points to the .exe on the server and the working folder is the same as the .exe on the mapped drive. When I click on the shortcut on the workstation, it just beeps at me. Clicking on the .exe in Windows Explorer produces the same results (or should I say, non-results). What am I doing wrong? Is there something more that I need to do at the workstation level? Rick Tag: How to Terminate a VFP COM DLL Tag: 220405
  - 2
    - TableValidate question I've been having some read errors in files over the network and I saw that someone suggested setting TableValidate to 0 for no validation. The help file, though, says the following about TableValidate: "You must first open the table exclusively before using the SET TABLEVALIDATE command." I don't understand what that means because you can open a table in shared mode after your set tablevalidate to 0. Does it mean that TableValidate is ignored unless a file is opened exclusively? Kevin Clark Seton Home Study School Tag: How to Terminate a VFP COM DLL Tag: 220399
  - 3
    - SQL SELECT and exact values I have a table with a field (ITEM) that contains the values "ITEM1" through "ITEM72." - The SQL SELECT statement below does NOT include the values "ITEM10", "ITEM11", etc., because these values begin with "ITEM1..." - SELECT * ; FROM mytable; WHERE .NOT. INLIST(item,'ITEM1') - How could I alter the SELECT statement to eliminate "ITEM1," but keep "ITEM10," "ITEM11," etc., in the results? - Many thanks, David Tag: How to Terminate a VFP COM DLL Tag: 220396
  - 4
    - found a free anonymous service found a great site to surf free,fast,anonymous. http://www.anosurf.net Tag: How to Terminate a VFP COM DLL Tag: 220390
  - 5
    - vfp/webservices/web gardens We have a vfp exe running as a com server fronted by web services. This runs and works fine. However when we increase the number of worker processes in the web garden the responses get slower and slower. Eventually errors are returned as the requests time out. Up to 5 worker processes works ok (but slow) above this they time out. Would appreciate any help/suggestions Thanks Greg Tag: How to Terminate a VFP COM DLL Tag: 220378
  - 6
    - fox9 Hello, I have increased the size of my forms in fox 9 due to popular demand. Now the people viewing with a resolution of 800 by 600 can't see some of my buttons. Is thee a way to tell the form to make it big in relative to the resolution? Emily Tag: How to Terminate a VFP COM DLL Tag: 220367
  - 7
    - Code Librarian / Code snippets library (or whatever else you want to call it!) Can anyone recommend a "code library" for use with foxpro (v9) Steve Tag: How to Terminate a VFP COM DLL Tag: 220357
  - 8
    - How do I retrieve an old menu version from SourceSafe? I am getting bizarre behavior in my FoxPro app, so I'm trying to go back to a previous version of code. I want to get an old version of my menus and then look at them to see if they contain the expected version of the setup code. I do Show Differences on the two most recent versions of my menu, and it shows me that the old version contains the code I want to execute and the new version contains the suspicious code. So I get the old version. Then, in the menu editor, I open the menu, and it has the newer, suspicious code! No matter what I've done, I can't get a version of my menu with the old code out of SourceSafe! What do I have to do? Thanks very much! RobR Tag: How to Terminate a VFP COM DLL Tag: 220349
  - 9
    - foxuser.dbf Hi, Can I control the place where the foxuser.dbf table is created ? one of my exe create it on the Desktop, not by me (at least not my intentions) but who did it ? If I delete them the simply come back. thanks in advance regards christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- Tag: How to Terminate a VFP COM DLL Tag: 220340
  - 10
    - Database Design and Key Fields Hi All, My table design's usually takes this kind of format. LookupTable nUniqueID N 10 cCode C 10 cDescription C 40 where nUniqueID is automatically updated by my code when a new record is added and is unique to that table. cCode is unique and added by the user, cDescription is just that, any old description. I'd then have a transaction table for example TransactionTable nUniqueIID N 10 cCode C 10 otherfields again nUniqueId is unique to that particular table, cCode however, is the link to cCode in the LookupTable. This design has worked well for me for more years than I care to remember. However, one customer now wants cCode in the lookup table not to be unique. Not a major problem, just modify my code to store nUniqueID from the lookup table, rather the cCode. My question is basically, how do you guys design your table's for this sort of scenario. I appreciate that I could use nUniqueID from the lookup table instead of cCode, to store in the transactions table, but for support purposes, it just seems easier to - BROWSE FOR cCode = "A001" rather than nUniqueId = 123487 Cheers All Justin Tag: How to Terminate a VFP COM DLL Tag: 220330
  - 11
    - ctrl+c / v and inputbox() Hi, Could it be that this is working while developing but not working in the exe ? At least can somebody confirm this or know why it isn't working with me. regards christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- Tag: How to Terminate a VFP COM DLL Tag: 220328
  - 12
    - Database documentation tool I have a application that uses a free table database and was wondering if there is a tool available that I can use to document the database. thanks pete Tag: How to Terminate a VFP COM DLL Tag: 220325
  - 13
    - How to read the NT Server date & time from Workstation PC ? How to read the NT Server date & time from Workstation PC ? Tag: How to Terminate a VFP COM DLL Tag: 220322
  - 14
    - Publishing Fox Web Services Hello all: in WinXP/Fox9/IIS (client) and Win2003/IIS6 (server). I am trying to get web services working and having trouble. The web service works sucessfully (locally) on the client computer. I have two questions: 1. When I am publishing the web service from the Task Pane, in the "advanced" tab there is a "namespace" page. What are these fields for and how should they be filled in? Is it necessary to modify these to make the web service work? 2. After publishing locally, I copy the .dll and the .wsdl and the other files over to the server. In IIS on the server, I go to "web service extensions", add the .dll as a web service and select "allow". I verify that IUSR_computername has read/excecute access but I receive timeout errors when trying to run the service from clients. Any suggestions would be most appreciated. Peter Tag: How to Terminate a VFP COM DLL Tag: 220318
  - 15
    - Outlook "A program is attempting to send..." Message Using the latest versions or VFP, XP, and Outlook. I'm trying to automate the sending of email notifications via a VFP application using Outlook. When trying to send the composed e-mail I get the dreaded "A program is attempting to send the following e-mail message on your behalf" message prompt halting the operation and waiting for a Yes No response. How can I bypass this prompt and make this notification process totally unattended? Thanks in advance. Tim Cairns Tag: How to Terminate a VFP COM DLL Tag: 220315
  - 16
    - VFP9 Reports from VFP8 reports Btw, i did a sample test report in vfp9. when i printed it in my dot matrix (epson LX-300+), using reportbehavior80, the print out was okay. but when i changed it to reportbehavior90, the printer printed out the report with a condensed font. any idea why this is happening. This is just simple report (it will just list the first name and the last name). Please help. -- TreborS ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: How to Terminate a VFP COM DLL Tag: 220302
  - 17
    - Too many files open Error in Foxpro 2.6 for Dos, under Windows XP ? What is the reason for Too many files open Error in Foxpro 2.6 for Dos, under Windows XP ? Best Regards, Luqman Tag: How to Terminate a VFP COM DLL Tag: 220298
  - 18
    - Exact position relative to printer Using legacy @ say... printing method, I am unable to find the exact x,y coordinates of printer object. It always changes wrt to fontsize and font type. Is there anyway to solve this problem? Sample code: ------------- set printer font 'Arial' font,12 nRow = 0 for i=1 to 100 nRow = i @ nRow, 1 say i if nRow > 54 then nRow = 0 eject else nRow = nRow + 1 endif endfor ---- 1. It works well in FoxPro2.5, but in VFP number of exact lines is not predictable. Regards Nats Tag: How to Terminate a VFP COM DLL Tag: 220292
  - 19
    - App focus is lost on startup I have a VFP6 app that loses focus when it is first started. If I start it from explorer, explorer retains the focus If I start from a shortcut on the desktop, with no other apps open, its seems that nothing has the focus (no function keys do anything and alt printscreen does not clip anything) The app starts with some code that opens a form which is set to run as a top-level form in the desktop, the code then waits at a read events statement till the form is closed. In the init of the form I have tried setting focus to the user id text box - but this focus is only scoped to the app. Does anyone know what might give rise to this behaviour or how I can reset focus back to my app. Thanks John D Tag: How to Terminate a VFP COM DLL Tag: 220289
  - 20
    - Non-standard Characters I occasionally need to enter non-standard (U.S. anyway) characters for people's names. Can VFP 9.0 handle that in typical text/memo fields? And, if so, how would I enter that? Some sort of CTRL or ALT combination? The character in question right now is a small "e" with a carrot on top (similar to the one above the #6 key on the keyboard). Thanks. Tag: How to Terminate a VFP COM DLL Tag: 220284
  - 21
    - Remote view / cursor oddity I just ran into something that I don't understand. VFP 8 SP1, although I doubt that matters. With nothing open in the data environment, open a remote view: USE track IN 0 ALIAS track_curs * At this point 'track_curs' is the only thing open. * The following statement apparently reads data from track_curs, * since when it completes there is no alias 'track' open. SELECT * FROM track WHERE ... INTO CURSOR xxx * At this point 'track_curs' and 'xxx' are open. * Likewise, the following statement inserts into track_curs: INSERT INTO track ..... If the initial USE is removed, the SELECT will silently open the remote view 'track' and leave it open, and the INSERT will insert into that remote view, which is the expected behavior. Is inserting into the alias when the remote view name is used the expected behavior? It seems wrong to me. Tag: How to Terminate a VFP COM DLL Tag: 220282
  - 22
    - msword merge with foxpro table Hi, I've made a "msWord template" with multiple collums and a connection to a foxpro table. which works fine. I've then set up a loop to alter the Word template and "saveas" with different tables contents. which also works fine. But, and here it comes, I use OfficeXP my client uses Office 2000 ? Each time the template opens and tries to connect to the table (in the background) the template ask which type of table it is, and the my client as the option to choose Dbase or Foxpro table ! Can this be done programmatically ? Or can somebody translate this to foxpro readable code and that it can be used with Office 2000. This is what the macrorecorder told me : ActiveDocument.MailMerge.OpenDataSource Name:= _ "C:\PROGRAMM\sst\data\rpt\10000.DBF", ConfirmConversions:=False, ReadOnly _ :=False, LinkToSource:=True, AddToRecentFiles:=False, PasswordDocument:= _ "", PasswordTemplate:="", WritePasswordDocument:="", _ WritePasswordTemplate:="", Revert:=False, Format:=wdOpenFormatAuto, _ Connection:= _ "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=C:\PROGRAMM\sst\data\rpt;Mode=Read;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=18;Jet OLEDB:Data" _ , SQLStatement:="SELECT * FROM `10000`", SQLStatement1:="", SubType:= _ wdMergeSubTypeAccess thanks in advance regards christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- Tag: How to Terminate a VFP COM DLL Tag: 220275
  - 23
    - The record pointer is always to the bottom of the table after Upda In Asian language setting Windows (please see http://www.vfug.org/Newsletters/Newsletters2.Afp?!_1360S63NLDate=09/01/2003#mmd), if you run Create Cursor Customer (customer_name c(10)) Insert into Customer (customer_name) values ("IBM") Insert into Customer (customer_name) values ("Microsoft") Insert into Customer (customer_name) values ("Oracle") Update Customer set customer_name="Google" where customer_name="Microsoft" Select Customer Browse Close All You can see the record pointer is to the bottom of the cursor. But in English setting Windows, the record pointer is to the second line. One of my clients is using Chinese setting Windows. They get unexpected results from my VFP-based application. It is normal? Is it possible to make the record pointer to the updated line rather than the last one? Please advise. TIA. Tag: How to Terminate a VFP COM DLL Tag: 220270
  - 24
    - VFP9 Reports from VFP8 reports Can i ask what do you mean by running it under a higher resolution? Lee Mitchell wrote: > [B]Hi Robert: > > I don't know of a way to create auto resizing text in a report. > However, > you might want to try a different font. Have you tried Arial Narrow? > Do > you still see the problem if you run under a higher or lower > resolution > than what you are using now? > > I hope this helps. > > This posting is provided "AS IS" with no warranties, and confers no > rights. > > Sincerely, > Microsoft FoxPro Technical Support > Lee Mitchell -- TreborS ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: How to Terminate a VFP COM DLL Tag: 220269
  - 25
    - Active Window in OleMMess Hi, I noticed that after I create and close an email using OleMMess the Active Window or Window on top is not my VFP application. Any idea on the problem? Thanks, Herbert Tag: How to Terminate a VFP COM DLL Tag: 220267

I have a VFP 9 COM DLL which is working fine. However, whenever I go to
replace the DLL, I need to run IIS Reset to remove it from memory. I cant
rely on the calling application to neatly remove it.

I have put a timer into the DLL to check for a shutdown trigger but I am not
sure how to shut it down properly so that it is removed from memory.

If it was a VFP app, I would use omething like Cancel or Quit. Is this the
same for a COM DLL or is there some other way.

Cheers
David

Top

Re: How to Terminate a VFP COM DLL by Claude

Claude
Thu Feb 02 20:37:54 CST 2006

Mark Frank has done quite a bit of work with this to make it run smoothly:
FUNCTION DESTROY
DestroyEvent(This) && in External FXP
IF this.lClearProgCache
IF ATC("MyCOMutil.FXP",SET("procedure",1)) > 0
RELEASE PROCEDURE MyCOMutil.FXP
ENDIF
CLEAR PROGRAM
ENDIF
ENDFUNC
The external fxp is called by the vfp mtdll and can be replaced at will with
no locking. ActiveVFp also uses this technique.
Another way (not sure it still works in IIS 6) is to run the vfp mtdll in
pooled or high isolation in IIS. Then you can simply 'unload' the mtdll by
pressing the unload button in IIS under the virtual directory it's in.
That's better than iisreset since an unload will only affect your vfp mtdll,
not other applications or the entire web site.
Finally, you could actually put the vfp code in the HTML pages by using
CodeBlock or VFP's scripting. Then those pages can be replaced at will.
This is also available in ActiveVFP...
"David Younger" <davidyounger1@hotmail.com> wrote in message
news:exdjiZGKGHA.3732@TK2MSFTNGP10.phx.gbl...
>I have a VFP 9 COM DLL which is working fine. However, whenever I go to
>replace the DLL, I need to run IIS Reset to remove it from memory. I cant
>rely on the calling application to neatly remove it.
>
> I have put a timer into the DLL to check for a shutdown trigger but I am
> not sure how to shut it down properly so that it is removed from memory.
>
> If it was a VFP app, I would use omething like Cancel or Quit. Is this the
> same for a COM DLL or is there some other way.
>
> Cheers
> David
>

Top