ERROR Creating OLE Object

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
    - Validating a Date in a Text box hi again, i am looking for a simple way to Validate the data entered into a textbox is a valid date. if they enter 010106 it should stop them and make them enter 01012006 if they enter 01010000 it should evaluate that to be wrong also. is this possible? well i know it is, currently i have set century on. My biggest problem is, this box is used for mostly char entry, so id like to keep it that way. i thought that using this.value = ctod(' / / ') would do it but no such luck. thanks agaiin. Tag: ERROR Creating OLE Object Tag: 220676
  - 2
    - Doug Henning at Chicago FUDG on 14 Feb 06 The February Chicago FUDG Meeting will be a Webinar on Stonefield Query. Doug Hennig is the author of Stonefield Query and of the Stonefield Database Toolkit and a guru of gurus. Doug wrote the Cursor Adaptor builder that is in VFP 9. Check out his site at <http://www.stonefield.com> Or attend the February 14th Foxpro Users and Developers Group meeting. Doug says it's not cold enough in Chicago in February. He'd rather stay home in Winnepeg Saskatchewan. Instead he'll be available via streaming video and Skype phone at our meeting. Here is more on the new release of Doug's Stonefield Query which will be discussed in detail at our meeting: The Report Wizard has been replaced with a more powerful and user-friendly Reports Explorer. Role-based security is available for report folders, individual reports, fields, and tables. The Advanced Report Designer was overhauled and includes a new _Expression Builder. Creating a setup executable is now a snap with the built-in setup generation tool. http://www.stonefieldquery.com/devedfeatures.html This is our first meeting where we bring in a guy from another part of the globe without paying the air fare. Let's see if webinars are the shape of things to come. Same time and place. See you there? Tuesday Feb 14th, 5:30 pm. Room 826 in the Monadnock Building in the Chicago Loop. 53 W. Jackson Boulevard. http://www.ChicagoFUDG.com -- Message posted via http://www.dbmonster.com Tag: ERROR Creating OLE Object Tag: 220672
  - 3
    - [OT] User-Defined string Functions Transact-SQL <-> VFP Ladies and Gentlemen, I am pleased to offer, free of charge, the following string functions Transact-SQL: AT(): Returns the beginning numeric position of the nth occurrence of a character expression within another character expression, counting from the leftmost character. RAT(): Returns the numeric position of the last (rightmost) occurrence of a character string within another character string. OCCURS(): Returns the number of times a character expression occurs within another character expression (including overlaps). OCCURS2(): Returns the number of times a character expression occurs within another character expression (excluding overlaps). PADL(): Returns a string from an expression, padded with spaces or characters to a specified length on the left side. PADR(): Returns a string from an expression, padded with spaces or characters to a specified length on the right side. PADC(): Returns a string from an expression, padded with spaces or characters to a specified length on the both sides. CHRTRAN(): Replaces each character in a character expression that matches a character in a second character expression with the corresponding character in a third character expression. STRTRAN(): Searches a character expression for occurrences of a second character expression, and then replaces each occurrence with a third character expression. Unlike a built-in function Replace, STRTRAN has three additional parameters. STRFILTER(): Removes all characters from a string except those specified. GETWORDCOUNT(): Counts the words in a string. GETWORDNUM(): Returns a specified word from a string. GETALLWORDS(): Inserts the words from a string into the table. PROPER(): Returns from a character expression a string capitalized as appropriate for proper names. RCHARINDEX(): Similar to the Transact-SQL function Charindex, with a Right search. ARABTOROMAN(): Returns the character Roman numeral equivalent of a specified numeric expression (from 1 to 3999). ROMANTOARAB(): Returns the number equivalent of a specified character Roman numeral expression (from I to MMMCMXCIX). AT, PADL, PADR, CHRTRAN, PROPER: Similar to the Oracle functions PL/SQL INSTR, LPAD, RPAD, TRANSLATE, INITCAP. Plus, there are CHM files in English, French, Spanish, German and Russian. Plus, there are versions for SYBASE ASA, DB2, Oracle, MS SQL SERVER 2005 SQLCLR. More than 8000 people have already downloaded my functions. I hope you will find them useful as well. For more information about string UDFs Transact-SQL please visit the http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115 Please, download the file http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115 With the best regards. Tag: ERROR Creating OLE Object Tag: 220668
  - 4
    - Licensing Folks, A prime advantage of Fox has always been its licensing policy. Once you purchased the original development edition you could produce applications which would run free of any extra charges (royalty free). My impression is that this has changed in the more recent versions. I haven't been able to find the information on the official MS site. Is my summary of VFP licensing correct? Are there changes? If so, what are the new restrictions? There is a good chance this discussion has transpired more than once. If so it would be nice to have a pointer to where I can find those threads or web pages. Appreciatively, John Tag: ERROR Creating OLE Object Tag: 220666
  - 5
    - Character translation In order to be able to send Japanese mails from my VFP application, I need to translate a Japenese string encoded as SHIFT-JIS to ISO-2022-JP. I found this library iconv.dll that should be able to do that but I can't get it do anything in VFP. Does anybody have experience with this? Robert Tag: ERROR Creating OLE Object Tag: 220663
  - 6
    - timer and report with >1 page I have a timer working in the background, which is checking for new messages in table1 -every 30 minutes. If at the same time somebody preview a report with more than 1 page and is trying to change page - report preview is disappearing....:-( I know it's because timer is changing current cursor (reports are used public dataenvironment), so i try to disable timer before report shows and enable after - works OK , but in this case if user will open any report in <30 min will never get messages prepared by timer... Is there a way to store curent "time to fire" of timer so it could start not from 0 ? Or maybe somebody have better idea how to get rid of this report behavior ? (I don't want to change it to use private dataenvironment) Thanks, Adam Tag: ERROR Creating OLE Object Tag: 220652
  - 7
    - How to determine if a DLL exists or is installed Hi, Is there a way to determine if a DLL exists or is installed? Most reside in Windows\System32 but some others are installed on WINDOWS\WinSxS subdirectories. Thanks. Demetrios, Greece Tag: ERROR Creating OLE Object Tag: 220651
  - 8
    - February letter posted on the Fox website http://msdn.microsoft.com/vfoxpro/letters/ -- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP cindy_winegarden@msn.com www.cindywinegarden.com Tag: ERROR Creating OLE Object Tag: 220644
  - 9
    - Can't preview 2 reports at the same time? I know report previewing has always been flaky with VFP, especially in the IDE, but I just noticed that with VFP9 you still can't preview 2 reports at the same time if you try to use right mouse to preview them. After spending a bit of time with this, it appears to be a continuation of the mouse right click crash bug. Open table. Create 2 reports that run against table. Open both reports in report editor. Right click a report, select preview. Right click other report, Menu manager internal consistency error occurs. Faulting application vfp9.exe, version 9.0.0.3504, stamp 436c14ff, faulting module vfp9.exe, version 9.0.0.3504, stamp 436c14ff, debug? 0, fault address 0x0021ab95 Happens with VFP9, VFP8, VFP7. Tag: ERROR Creating OLE Object Tag: 220642
  - 10
    - Field display on report question? Hi, Using VFP 9.0. I'm designing a simple report for one of my tables and I'm seeing something that seems odd to me. The field expression is: alltrim(lname) + ", " + alltrim(fname) So I should get 'lname, fname' on my report. It seems to be working except where fname is null, then I just get .NULL. on my report. I would have thought that if it were null then I'd just get 'lname, ' out on my report but instead I only get .NULL.. Can anyone shed some light here? Thanks, Linn Tag: ERROR Creating OLE Object Tag: 220638
  - 11
    - Transforming a number if i wanted to show on a frinted for the last 4 digits of an account nuber or a ssno number or any number, what is the best way to do this. Transform does not seem to be the correct function. Tag: ERROR Creating OLE Object Tag: 220633
  - 12
    - problems with installshield in 9.0 I am attempting to install build an install exe for vfp 9.0 runtime. When I run the exe on a machine that does not have 9.0 dev installed it chokes with the message "Visual Foxpro could not start. Could not load resources": I looked through postings here and found several suggestions and solutions that worked for others, such as 1. don't forget the vfp9r.dll 2. include the c## libraries 3. just copy the runtime dll into the exe directory and that is all you need. 4. be sure to register the dll 5. don't register the dll. At this point I am confused. I have tried all of the above and still it doesn't work. I have manually registered the dll and that didn't help. Is this an XP issue??? I have used the installshield with 7.0 distributions with no problems. Which c## libraries should I be including? Which boxes should be checked in the redistibutables section?? help??? Tag: ERROR Creating OLE Object Tag: 220621
  - 13
    - Dialog error message What would cause the following message to appear when a user is running an application I've written? I've not had it with other users running it. The user has an AMD processor with 523,000 KB mem running Windows2000 Professional. Error message: "Unable to open dialog" They then click on OK and continue with the program and all appears to work fine. It seems to have no consistent time it does it. Rusty OGES Systems Tag: ERROR Creating OLE Object Tag: 220618
  - 14
    - FPD and VFP 9 running on Vista - Proof of Concept. http://blog.jlcconsulting.com/PermaLink,guid,a4c0d684-e0bb-4338-b7c5-5409474 79f72.aspx Whew! I'm glad Juan's shown it to work - I had scheduled a pass/fail series of tests for later in the month. Mondo Cool! regards [Bill] -- =================== William Sanders / EFG VFP / mySql / MS-SQL www.efgroup.net/vfpwebhosting www.terrafox.net www.viasqlserver.net Tag: ERROR Creating OLE Object Tag: 220615
  - 15
    - Read from text file I have a text file with e-mail addresses seperated by Return key (chr13). I need to import the e-mail addresses into a table. To do this, I created a table with one C(100) field and was able to execute: append from textfile.txt type SDF with VFP6.0. All data got imported ok. However, when I do the same command in VFP9.0, all e-mail address in the table displayed as a square box - unrecognized character. What did I do wrong? -jesk Tag: ERROR Creating OLE Object Tag: 220612
  - 16
    - Attempting to Automate VSS 2005 w/ VFP9 I'm revisiting a problem that stumped me years ago. I'd like to automate the sharing of project files within the VFP IDE through VSS Automation, and everything's good to go except for the VSS "add file to source control" dialog - I'm hoping I might be able to use some of the new functionality VFP9 to get past this. Here are some options AFAIK: VSS's IVSSEventHandler interface - but would have to write a separate DLL. BindEvent() - to trap windows messages and perhaps get a reference to the dialog window. EventHandler() - but so far, I don't have a COM object to attach to. I think I need to get a reference to the dialog window's hWnd and do something like a SendKeys or a SendMessage, but the VSS automation doesn't seem to expose any objects I can grab a hold of.. Would appreciate all suggestions. Thanks. -- William Fields Code Contortionist MCSD - Microsoft Visual FoxPro US Bankruptcy Court Phoenix, AZ ".dll hell - .rpm hell - whatever. The grass is always greener" Tag: ERROR Creating OLE Object Tag: 220611
  - 17
    - How to append a Word doc to a general field and display it as an icon I need to append a word document to a general field and display it as an icon and edit it in word when you double-click it. The default option when you use the command "Append General <generalfield> From <file>" is to display the file content and edit it inside the oleboundcontrol. The only way I found to do this, is to check the "Show as an icon" option of the "Insert Obeject..." menu in the Create from file tab. Is there a way to do the same but programatically with the "Append General" command ??? Thanks in Advance !!! Best Regards, Geo L. Tag: ERROR Creating OLE Object Tag: 220606
  - 18
    - IDE annoyance In the Project Manager, Data tab, with Project Manager docked: Select a table in a db and double click on it. The Table Designer opens and operates normally. Close the Table designer, select a table again and press Enter. The Table Designer opens, but the window is not movable. </bitch> Tag: ERROR Creating OLE Object Tag: 220596
  - 19
    - Even Trigger Library for Monitoring a Folder This is a multi-part message in MIME format. ------=_NextPart_000_0060_01C629D7.5910D2A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, I have an application that will dump a whole bunch of file to a Folder, = I need to find an ActiveX or a library I can use from VFP9 that will = monitor this folder and trigger an event whenever a file is being = dropped in this Folder. =20 I know I can use a VFP timer to do just that but wanted to see if = somebody know of a better way of doing this with a library instead of a = VFP Timer. --=20 Edhy Rijo www.progytech.com Bronx NY ------=_NextPart_000_0060_01C629D7.5910D2A0 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>Hi All,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I have an application that will dump a = whole bunch=20 of file to a Folder, I need to find an ActiveX or a library I can use = from VFP9=20 that will monitor this folder and trigger an event whenever a file is = being=20 dropped in this Folder.  </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I know I can use a VFP timer to do just = that but=20 wanted to see if somebody know of a better way of doing this with a = library=20 instead of a VFP Timer.</FONT></DIV><FONT face=3DArial size=3D2> <DIV><BR>-- <BR>Edhy Rijo<BR><A=20 href=3D"http://www.progytech.com">www.progytech.com</A><BR>Bronx = NY</DIV> <DIV> </DIV> <DIV></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0060_01C629D7.5910D2A0-- Tag: ERROR Creating OLE Object Tag: 220586
  - 20
    - How to read mainboard serial no in vfp ? How to read mainboard serial no in vfp ? Tag: ERROR Creating OLE Object Tag: 220577
  - 21
    - Upgrade from FPW/DOS 2.6 to VFP6.0 I'm preparing to upgrade an application package that uses Foxpro 2.6 for Windows/DOS, to a newer package that uses Visual Foxpro Version 6. I have an opportunity to buy a used Upgrade version of VFP 6. Would that version consider the old Version 2.6 a qualifying version for upgrade purposes? Thanks for your help. Lakeside Tag: ERROR Creating OLE Object Tag: 220575
  - 22
    - SHARE_INFO_2 Hi everyone, I am trying to add a share in my system automatically, does anyone have a sample of the structure or an example of NetShareAdd Thanks in advance Tanya Tag: ERROR Creating OLE Object Tag: 220567
  - 23
    - Parent Child Data Entry w/ CursorAdapter & SQL Server 2005 Hello, Environment: VFP9.1 Using Cursor Adapters to access data on SQL Server 2005 using ADO Challenge: When adding a new 'parent' record, how can I get the primary key, so that I can set a foreign key when adding a new 'child'? Are we restricted to creating the parent, then attempting to save before adding child data? Tag: ERROR Creating OLE Object Tag: 220566
  - 24
    - Simple Changes in VFP These are a couple of little things that really would simplify my life.... When you open the Class Browser...please open to the same folder as last time and NOT to the current folder. All my classes are in one folder. I hate having to scroll back to that folder each time. The class browser opens in full screen sometimes and to another window size sometimes. This is annoying. The report controls toolbar should remain on the screen each time you open the report designer. Same for the layout toolbar. Thanks for listening, John. p.s. I'm using VFP8, maybe Ver 9 fixes this stuff. Tag: ERROR Creating OLE Object Tag: 220562
  - 25
    - split a string! Hi, I have a string which has the full address in it. It also has a comma (,) to seperate the address into line. I need to be able to read the string and then split it up at the comma, but ignore passing the comma over. i.e. I have: 34 Castle Road, Town, County I need to split it so that i have: 34 Castle Road Town County can someone please let me know the besh way to do this? Many thanks in advance Rob Tag: ERROR Creating OLE Object Tag: 220559
- Next
  - 1
    - display select query in window ? If I run an query in prg file, say : select * from customers, I see the result. How can I view this query text "Select * from customers" after the prg is run, without opening the prg file. I actually want to view the last run query, not the result. I tried following:- Set talk on Set talk to window mywindows but it just give me: Selected 4 records in 0.00 seconds. I tried using display memory but could not get it. any idea please ? Best Regards, Luqman Tag: ERROR Creating OLE Object Tag: 220552
  - 2
    - Timer in VFP COM DLL I have written a VFP Multithreaded Com DLL and in my VCX lbrary, I have created a shutdowntimer class based on the Timer Class. n this class I have put code into the Timer Event to do what it needs to do. I have put the folloing into my initianlisation code for the COM DLL: PUBLIC ShutDownTimer ShutDownTimer = CREATEOBJECT("ShutDownTimer") ShutDownTimer.Enabled = .T. ShutDownTimer.Interval=10000 However, the timer never seems to fire. What am I doing wrong? Cheers David Tag: ERROR Creating OLE Object Tag: 220550
  - 3
    - VFP to .NET Resources I keep trying to play with the .NET stuff and get incredibly frustrated with most everything. Are there any resources out there for a silly Foxpro guy that wants to learn .NET? I usually try and learn a new Development environment by rewriting an existing application, and I get slammed real quick in .NET [2005]. For example, is there a cross reference somewhere that says: To Edit a PageFrame in VFP, right-Click->Edit. In .NET its a TabControl and you get at the properties in a much different way. I really do keep trying this offering from Microsoft, and I ain't impressed. Seems like things have gotten much more difficult. What happened to the KISS philosphy? Thanks for any advice Tag: ERROR Creating OLE Object Tag: 220547
  - 4
    - How to Terminate a VFP COM DLL 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 Tag: ERROR Creating OLE Object Tag: 220546
  - 5
    - 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: ERROR Creating OLE Object Tag: 220539
  - 6
    - 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: ERROR Creating OLE Object Tag: 220531
  - 7
    - 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: ERROR Creating OLE Object Tag: 220530
  - 8
    - 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: ERROR Creating OLE Object Tag: 220529
  - 9
    - 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: ERROR Creating OLE Object Tag: 220526
  - 10
    - 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: ERROR Creating OLE Object Tag: 220525
  - 11
    - 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: ERROR Creating OLE Object Tag: 220514
  - 12
    - 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: ERROR Creating OLE Object Tag: 220512
  - 13
    - 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: ERROR Creating OLE Object Tag: 220509
  - 14
    - 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: ERROR Creating OLE Object Tag: 220500
  - 15
    - 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: ERROR Creating OLE Object Tag: 220496
  - 16
    - 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: ERROR Creating OLE Object Tag: 220495
  - 17
    - 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: ERROR Creating OLE Object Tag: 220481
  - 18
    - 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: ERROR Creating OLE Object Tag: 220478
  - 19
    - 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: ERROR Creating OLE Object Tag: 220475
  - 20
    - Get Rich Take advantage of a great deal Tag: ERROR Creating OLE Object Tag: 220472
  - 21
    - 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: ERROR Creating OLE Object Tag: 220462
  - 22
    - 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: ERROR Creating OLE Object Tag: 220456
  - 23
    - 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: ERROR Creating OLE Object Tag: 220452
  - 24
    - 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: ERROR Creating OLE Object Tag: 220444
  - 25
    - 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: ERROR Creating OLE Object Tag: 220439

I have the following line in my program which worked fine for many years
until recently.

APPEND GENERAL PICTURE FROM <Name of Bitmap File eg "9999.BMP">

Now I get the the following message "Error creating OLE object"

I have tried this interactively with a new table and get the same result.

Please HELP!!!

Thank you.

Re: ERROR Creating OLE Object by Andrew

Andrew
Wed Feb 08 05:20:35 CST 2006

"shmiel" <shmiel@tiscali.co.uk> wrote in message
news:%23HVKGbBLGHA.3064@TK2MSFTNGP10.phx.gbl...
>I have the following line in my program which worked fine for many years
>until recently.
>
> APPEND GENERAL PICTURE FROM <Name of Bitmap File eg "9999.BMP">
>
> Now I get the the following message "Error creating OLE object"
>
> I have tried this interactively with a new table and get the same result.

Did you install something that works with BMPs or somehow mess with the OLE
handler / server for BMP?

--
Regards
Andrew Howell

Re: ERROR Creating OLE Object by shmiel

shmiel
Wed Feb 08 08:52:43 CST 2006

Not that I'm aware of.

Shmiel

"Andrew Howell" <ajh@work> wrote in message
news:O18i3GKLGHA.3276@TK2MSFTNGP09.phx.gbl...
> "shmiel" <shmiel@tiscali.co.uk> wrote in message
> news:%23HVKGbBLGHA.3064@TK2MSFTNGP10.phx.gbl...
>>I have the following line in my program which worked fine for many years
>>until recently.
>>
>> APPEND GENERAL PICTURE FROM <Name of Bitmap File eg "9999.BMP">
>>
>> Now I get the the following message "Error creating OLE object"
>>
>> I have tried this interactively with a new table and get the same result.
>
> Did you install something that works with BMPs or somehow mess with the
> OLE handler / server for BMP?
>
> --
> Regards
> Andrew Howell
>

Re: ERROR Creating OLE Object by Andrew

Andrew
Wed Feb 08 09:34:34 CST 2006

"shmiel" <shmiel@tiscali.co.uk> wrote in message
news:OFFqO9LLGHA.3276@TK2MSFTNGP09.phx.gbl...
> Not that I'm aware of.

Can you try it on a different machine?

The other thing the help file mentions is a lack of memory.. I assume it is
doing this for any (ie even a tiny) bitmap? If so, do you have MEMLIMIT
specified in config.fpw?
I'm guessing you are running this on a relatively modern machine (ie with
quite a lot of memory.)

--
Regards
Andrew Howell