March VFUG Newsletter is Now Online (Free!)

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
    - Does a method exist? How can I tell whether a method exists in an object? I have a process that is passed a form as a variable and I want to run a particular method if it exists on the form. Running TYPE("MyForm.MyMethod") return "U" even if the method exists. I could probably just instantiate the method and handle the erorr if it doesnt exist but there must be a more elegant way? Any ideas? Cheers David Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209220
  - 2
    - VFUG News Ticker Full Release Now Online! The VFUG News Ticker (VNT) is meant to be an extremely easy and very cool way of keeping up with Forum posts on VFUG.Org -- all for free!!!! VNT is written in 100% VFP and is extremely easy to install and use (just un-zip and and run!). VNT makes use of the TCP network and Web resources -- IOW, an integration of web services that encompass the full power of VFP, the native TCP network stack and Web Pages located on VFUG.Org. All that is required to use VNT is is an account on VFUG.Org and VFP 8 or 9 runtime. Try VNT once and you love it! Testimonials from actual VFUG Members who used VNT: ============== I just finished downloading it and i loved it. I don't know the entire usage of this application, but i find it great espacially when it is completely built in vfp (i am not that good a programmer). Now that i have seen it in action for five min. and viewed some of the threads, i thought of a suggestion. Instead of showing multiple entries of a same thread why not show it once. VFUG has been a great help and thanks for everything. Thanks, Jitendra Shahani =============== I just downloaded the News Ticker and I think it looks great! Great work Tom! I see plenty of potential here. Keith Bonin -- Enjoy! ~ Thomas O'Hare ~ President, RedTile, Inc. -- DBA: RedTile Software Web, Wireless, Network, Database & Systems Software 407-295-9148 http://www.RedTile.Com/ or http://www3.RedTile.Com/ Operations Manager, Virtual FoxPro User Group Tom@VFUG.Org http://www.VFUG.Org/ or http://www3.VFUG.Org/ Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209216
  - 3
    - Data relations Hello I have a database with parent and child records in different records. I want to take the parent record and put child names on the same record. What is the best way to do that? The reason why is I'm meging the data to a print stream that doesn't support realation data. Thanks Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209213
  - 4
    - VFP7: Better way to Edit:Update/Delete Transaction Records How I do it now : At the moment I copy the selected record to the temp/cursor file and after the user delete or update the record, I will delete all the selected records in the transaction file and append all the record from temp/cursor again. I have found it's a very stupid and no efficiency way to do it in VFP.Is there any better solution for me to do it? I am using free table for the program. Sorry for my english. Maybe I can use following example to make it more clear Transaction file (Sales.DBF) InvNo InvDate InvAcno InvQty InvPrice InvAmt When user press "Edit/Delete" button (I will copy the selected record to temp/cursor file) e.g. InvNo. IV10001 (total records are 5 for this InvNo.) copied to temp/cursor named "tmptrans" When use press "Save" button (I will delete all the selected record in Sales.DBF and appen from temp/cursor file again) e.g. Select Sales.DBF Delete for InvNo="IV1001" Appen from tmptrans (Only 4 records added coz 1 record deleted in temp/cursor by user) Thanks for any input. Enuz Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209209
  - 5
    - OpenSource Contact Manager like ACT! or Goldmine based on VFP? Anyone know of a Contact Manager similar in features to ACT! or Goldmine based on Visual FoxPro? Source Code would be ideal. John "J.J." Jackson Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209198
  - 6
    - Invisible button issue Here is a bit of an off-the-wall problem. I have an app converted from FPW to VFP. In FPW, if you set focus to an invisible button and press Enter, it fires the buttons valid code. In VFP, it gets weird: Condition one. The form has been run and focus has NOT been set to a non-invisible button. Set focus to invisible button, press Enter. Button click method fires, focus goes to next object. Contition two. The form has been run and focus HAS been set to a non-invisible button. Set focus to invisible button, press Enter. The cliick method of the Visible button you last set focus to fires - specifically, focus goes to the last visible button you set focus to, and fires the click method of that button. So - has anyone had any experience in this area? I would like the click method of the invisible button to fire when I set focus to it and press the Enter key. The docs are pretty sparse about the visible property, so I'm playing with this to see if there is an easy fix. Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209197
  - 7
    - GDIPLUS not working within mtdll com server Has anyone managed to get any class within _gdiplus.vcx to work within a MTDLL. I have done a short test program that works fine from the command line but if you then build a MTDLL around it then it no longer works. I have been running filemon.exe to check what is going on and where gdiplus.dll is being loaded from the problem seems to be in that direction. Fox command line seems to use gdiplus.dll from the Microsoft Shared/FVP dir. However when running from the MTDLL it seems to access mtdll from C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.2600.2180_x-ww_522f9f82. I've include the sample program below. To test it: 1) Make sure you have a jpg in c:\windows\web\wallpaper\azul.jpg (xp) 2) Copy to code below to test.prg 3) run test.prg 4) MODIFY COMMAND c:\gditest.txt Notice imageheight is displayed Test as MTDLL Create a project called test, add test.prg Build as MTDLL To test call from fox command line: lo = CREATEOBJECT("test.testgdi") ?lo.gdifunc() MODIFY COMMAND c:\gditest.txt Notice imageheight is NOT displayed Anyone have any ideas?? Thanks * Test GDIPLUS in MTDLL lo = CREATEOBJECT("testgdi") lo.gdifunc RETURN DEFINE CLASS testgdi as custom OLEPUBLIC FUNCTION gdifunc SET SAFETY OFF * * Set classlib to ffc _gdiplus.vcx * Make sure _gdiplus points to your dir * SET CLASSLIB TO libs\_gdiplus lo= createobject("gpimage") * * Malke sure lc points to a file * lc = "C:\WINDOWS\Web\Wallpaper\azul.jpg" lo.CreateFromFile(lc) * * Send the image height to a file for inspection * SET ALTERNATE TO c:\gditest.txt SET ALTERNATE ON ?lo.ImageHeight SET ALTERNATE TO ENDFUNC ENDDEFINE -- Miguel Villax Director MIGG Systems Limited Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209190
  - 8
    - Grabbing an email Address from a Form Article: 179728 of microsoft.public.fox.programmer.exchange Thread-Topic: Grabbing an email Address from a Form thread-index: AcUr28q9KCKFV5O1T9S1jFs1pPUUfA== X-WBNR-Posting-Host: 206.29.98.226 From: =?Utf-8?B?VG9t?= <Tom@discussions.microsoft.com> Subject: Grabbing an email Address from a Form Date: Fri, 18 Mar 2005 08:59:04 -0800 Lines: 25 Message-ID: <F3C056F1-CCF4-4639-874F-568BC1DBAE15@microsoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset="Utf-8" Content-Transfer-Encoding: 7bit X-Newsreader: Microsoft CDO for Windows 2000 Content-Class: urn:content-classes:message Importance: normal Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 Newsgroups: microsoft.public.fox.programmer.exchange NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29 Path: news.btopenworld.com!btnet-feed3!news-peer0-test!btnet!newshosting.com!nx02.iad01.newshosting.com!news.alt.net!msrtrans!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl Xref: news.btopenworld.com microsoft.public.fox.programmer.exchange:179728 hello, i am fairly new to all this. i have a contact form in a app we have. i want to grab the email address from the form and open up Outlook, have the address already in the .to and outlook just waiting for the user to input something in the Body and to send it. currently my code goes some of the way but not all. oOutlook = createobject("Outlook.Application") #Define olFolderdisplaynormal 0 oNameSpace = oOutlook.GetNameSpace("MAPI") oExplorer = oOutlook.Explorers.add (oNameSpace.Folders[1], olFolderDisplayNormal) oExplorer.Activate() #define olMailItem 0 oMailitem = oOutlook.createitem(olMailitem) WITH oMailitem .subject = "This is my Test Button" .to = ("what do i put here??? ") endwith oMailItem.save() i have tried the _miscbtn class in vfp6 and it does it, only it places the entire form contents in the Body of the message. its easy to pull addresses from the contacts folder but i cant from my form. thank you in advance for your help. Tom Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209184
  - 9
    - Re: Grabbing an email Address from a Form Article: 179837 of microsoft.public.fox.programmer.exchange From: "Fred Taylor" <ftaylor@mvps.org!REMOVE> References: <F3C056F1-CCF4-4639-874F-568BC1DBAE15@microsoft.com> <64012719-9E6A-410C-981F-9B584CC20FC4@microsoft.com> <eHhxRQdLFHA.3184@TK2MSFTNGP09.phx.gbl> <e0H8ifdLFHA.1396@TK2MSFTNGP10.phx.gbl> <9D44133E-26DA-49CD-A56D-2C399F3346DC@microsoft.com> Subject: Re: Grabbing an email Address from a Form Date: Mon, 21 Mar 2005 14:20:33 -0700 Lines: 97 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original X-Antivirus: avast! (VPS 0511-1, 03/17/2005), Outbound message X-Antivirus-Status: Clean Message-ID: <eVC3QvlLFHA.2492@TK2MSFTNGP14.phx.gbl> Newsgroups: microsoft.public.fox.programmer.exchange NNTP-Posting-Host: cpe-66-1-71-238.az.sprintbbd.net 66.1.71.238 Path: news.btopenworld.com!btnet-feed3!news-peer0-test!btnet!newshosting.com!nx01.iad01.newshosting.com!130.191.3.6.MISMATCH!newshub.sdsu.edu!msrtrans!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl Xref: news.btopenworld.com microsoft.public.fox.programmer.exchange:179837 This is the code I use: olMailItem = 0 oOutLookObject = CreateObject("Outlook.Application") oEmailItem = oOutLookObject.CreateItem(olMailItem) With oEmailItem .To = "somebody@anywhere.com" .CC = "somebodyelse@aywhere.com" .BCC = "newperson@anywhere.com" .Attachments.Add("c:\somefile.txt") .Subject = "This is the Subject" .Send() ENDWITH oOutLookObject=null -- Fred Microsoft Visual FoxPro MVP "Tom" <Tom@discussions.microsoft.com> wrote in message news:9D44133E-26DA-49CD-A56D-2C399F3346DC@microsoft.com... > using the .send() will send it right away, However it continues to send > messages while you are typing in the Body. > > so i have to use the .display, and the user clicks on send, if outlook is > closed the message goes to the outbox and waits until they open it. thats > the > problem. > > what about this, if Outlook is closed should i open it and leave it open? > right now if its open, i create anothe instance of it then close it when > im > done. is there no way to set some of the advanced e-mail props from code? > > thanks again > > Tom > > > "Fred Taylor" wrote: > >> I don't think you have to press "Send", but you do have to click "OK", >> that >> someother program is trying to send mail. You can't do it undetected >> behind >> the scenes anymore, at least not since Office 2K/Sp2? >> >> -- >> Fred >> Microsoft Visual FoxPro MVP >> >> >> "Paul Pedersen" <no-reply@swen.com> wrote in message >> news:eHhxRQdLFHA.3184@TK2MSFTNGP09.phx.gbl... >> >I think with the newer versions of Outlook, it's no longer possible to >> >tell >> >it to Send, even if Outlook is running. You have to get the user to >> >click >> >the Send button on Outlook. Someone tell me if I'm wrong. >> > >> > I think this was done for security reasons - there were too many >> > viruses & >> > such hijacking Outlook and sending emails without the users consent. >> > >> > >> > >> > >> > "Tom" <Tom@discussions.microsoft.com> wrote in message >> > news:64012719-9E6A-410C-981F-9B584CC20FC4@microsoft.com... >> >> aOk i answered my own question with the Following Code. >> >> >> >> oOutlook = createobject("Outlook.Application") >> >> #define olMailItem 0 >> >> oMailitem = oOutlook.createitem(olMailitem) >> >> WITH oMailitem >> >> .to = lagstat.pemail >> >> endwith >> >> oMailitem.display >> >> >> >> However it raised another. when a person sends in the above code, and >> >> outlook is not open, it waits to actually send the item untill they >> >> open >> >> up >> >> outlook. i need the mails to send when the user hits the send button, >> >> even if >> >> Outllok is Closed. >> >> >> >> Thanks again. >> > >> > >> >> >> Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209183
  - 10
    - Re: Grabbing an email Address from a Form Article: 179821 of microsoft.public.fox.programmer.exchange Thread-Topic: Grabbing an email Address from a Form thread-index: AcUuKiaOu+RN7UA4QZqoIsSDLTnOZw== X-WBNR-Posting-Host: 206.29.98.226 From: =?Utf-8?B?VG9t?= <Tom@discussions.microsoft.com> References: <F3C056F1-CCF4-4639-874F-568BC1DBAE15@microsoft.com> <64012719-9E6A-410C-981F-9B584CC20FC4@microsoft.com> <eHhxRQdLFHA.3184@TK2MSFTNGP09.phx.gbl> <e0H8ifdLFHA.1396@TK2MSFTNGP10.phx.gbl> Subject: Re: Grabbing an email Address from a Form Date: Mon, 21 Mar 2005 07:25:02 -0800 Lines: 64 Message-ID: <9D44133E-26DA-49CD-A56D-2C399F3346DC@microsoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset="Utf-8" Content-Transfer-Encoding: 7bit X-Newsreader: Microsoft CDO for Windows 2000 Content-Class: urn:content-classes:message Importance: normal Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 Newsgroups: microsoft.public.fox.programmer.exchange NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29 Path: news.btopenworld.com!btnet-feed3!news-peer0-test!btnet!newshosting.com!nx02.iad01.newshosting.com!news.alt.net!msrtrans!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl Xref: news.btopenworld.com microsoft.public.fox.programmer.exchange:179821 using the .send() will send it right away, However it continues to send messages while you are typing in the Body. so i have to use the .display, and the user clicks on send, if outlook is closed the message goes to the outbox and waits until they open it. thats the problem. what about this, if Outlook is closed should i open it and leave it open? right now if its open, i create anothe instance of it then close it when im done. is there no way to set some of the advanced e-mail props from code? thanks again Tom "Fred Taylor" wrote: > I don't think you have to press "Send", but you do have to click "OK", that > someother program is trying to send mail. You can't do it undetected behind > the scenes anymore, at least not since Office 2K/Sp2? > > -- > Fred > Microsoft Visual FoxPro MVP > > > "Paul Pedersen" <no-reply@swen.com> wrote in message > news:eHhxRQdLFHA.3184@TK2MSFTNGP09.phx.gbl... > >I think with the newer versions of Outlook, it's no longer possible to tell > >it to Send, even if Outlook is running. You have to get the user to click > >the Send button on Outlook. Someone tell me if I'm wrong. > > > > I think this was done for security reasons - there were too many viruses & > > such hijacking Outlook and sending emails without the users consent. > > > > > > > > > > "Tom" <Tom@discussions.microsoft.com> wrote in message > > news:64012719-9E6A-410C-981F-9B584CC20FC4@microsoft.com... > >> aOk i answered my own question with the Following Code. > >> > >> oOutlook = createobject("Outlook.Application") > >> #define olMailItem 0 > >> oMailitem = oOutlook.createitem(olMailitem) > >> WITH oMailitem > >> .to = lagstat.pemail > >> endwith > >> oMailitem.display > >> > >> However it raised another. when a person sends in the above code, and > >> outlook is not open, it waits to actually send the item untill they open > >> up > >> outlook. i need the mails to send when the user hits the send button, > >> even if > >> Outllok is Closed. > >> > >> Thanks again. > > > > > > > Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209182
  - 11
    - Re: Grabbing an email Address from a Form Article: 179823 of microsoft.public.fox.programmer.exchange Thread-Topic: Grabbing an email Address from a Form thread-index: AcUuKwGFZk9aur75Q6ucPbckQ/fxMw== X-WBNR-Posting-Host: 206.29.98.226 From: =?Utf-8?B?VG9t?= <Tom@discussions.microsoft.com> References: <F3C056F1-CCF4-4639-874F-568BC1DBAE15@microsoft.com> <64012719-9E6A-410C-981F-9B584CC20FC4@microsoft.com> <eHhxRQdLFHA.3184@TK2MSFTNGP09.phx.gbl> <e0H8ifdLFHA.1396@TK2MSFTNGP10.phx.gbl> <9D44133E-26DA-49CD-A56D-2C399F3346DC@microsoft.com> Subject: Re: Grabbing an email Address from a Form Date: Mon, 21 Mar 2005 07:31:09 -0800 Lines: 70 Message-ID: <B40A4DD4-DDAE-4A99-98C3-84EE5953C6F5@microsoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset="Utf-8" Content-Transfer-Encoding: 7bit X-Newsreader: Microsoft CDO for Windows 2000 Content-Class: urn:content-classes:message Importance: normal Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 Newsgroups: microsoft.public.fox.programmer.exchange NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29 Path: news.btopenworld.com!btnet-feed3!news-peer0-test!btnet!newshosting.com!nx02.iad01.newshosting.com!newspeer.monmouth.com!HSNX.atgi.net!news-hog.berkeley.edu!ucberkeley!enews.sgi.com!msrnewsc1!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl Xref: news.btopenworld.com microsoft.public.fox.programmer.exchange:179823 One other question, how can i ensure that the text entered is a valid e-mail. anyway to set the property of my text box to know? johndoe@ddd.com? "Tom" wrote: > using the .send() will send it right away, However it continues to send > messages while you are typing in the Body. > > so i have to use the .display, and the user clicks on send, if outlook is > closed the message goes to the outbox and waits until they open it. thats the > problem. > > what about this, if Outlook is closed should i open it and leave it open? > right now if its open, i create anothe instance of it then close it when im > done. is there no way to set some of the advanced e-mail props from code? > > thanks again > > Tom > > > "Fred Taylor" wrote: > > > I don't think you have to press "Send", but you do have to click "OK", that > > someother program is trying to send mail. You can't do it undetected behind > > the scenes anymore, at least not since Office 2K/Sp2? > > > > -- > > Fred > > Microsoft Visual FoxPro MVP > > > > > > "Paul Pedersen" <no-reply@swen.com> wrote in message > > news:eHhxRQdLFHA.3184@TK2MSFTNGP09.phx.gbl... > > >I think with the newer versions of Outlook, it's no longer possible to tell > > >it to Send, even if Outlook is running. You have to get the user to click > > >the Send button on Outlook. Someone tell me if I'm wrong. > > > > > > I think this was done for security reasons - there were too many viruses & > > > such hijacking Outlook and sending emails without the users consent. > > > > > > > > > > > > > > > "Tom" <Tom@discussions.microsoft.com> wrote in message > > > news:64012719-9E6A-410C-981F-9B584CC20FC4@microsoft.com... > > >> aOk i answered my own question with the Following Code. > > >> > > >> oOutlook = createobject("Outlook.Application") > > >> #define olMailItem 0 > > >> oMailitem = oOutlook.createitem(olMailitem) > > >> WITH oMailitem > > >> .to = lagstat.pemail > > >> endwith > > >> oMailitem.display > > >> > > >> However it raised another. when a person sends in the above code, and > > >> outlook is not open, it waits to actually send the item untill they open > > >> up > > >> outlook. i need the mails to send when the user hits the send button, > > >> even if > > >> Outllok is Closed. > > >> > > >> Thanks again. > > > > > > > > > > > > Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209181
  - 12
    - Re: Grabbing an email Address from a Form Article: 179808 of microsoft.public.fox.programmer.exchange From: "Fred Taylor" <ftaylor@mvps.org!REMOVE> References: <F3C056F1-CCF4-4639-874F-568BC1DBAE15@microsoft.com> <64012719-9E6A-410C-981F-9B584CC20FC4@microsoft.com> <eHhxRQdLFHA.3184@TK2MSFTNGP09.phx.gbl> Subject: Re: Grabbing an email Address from a Form Date: Sun, 20 Mar 2005 22:36:10 -0700 Lines: 45 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Response X-Antivirus: avast! (VPS 0511-1, 03/17/2005), Outbound message X-Antivirus-Status: Clean Message-ID: <e0H8ifdLFHA.1396@TK2MSFTNGP10.phx.gbl> Newsgroups: microsoft.public.fox.programmer.exchange NNTP-Posting-Host: cpe-66-1-71-238.az.sprintbbd.net 66.1.71.238 Path: news.btopenworld.com!btnet-feed3!news-peer0-test!btnet!newshosting.com!nx02.iad01.newshosting.com!130.191.3.6.MISMATCH!newshub.sdsu.edu!msrtrans!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl Xref: news.btopenworld.com microsoft.public.fox.programmer.exchange:179808 I don't think you have to press "Send", but you do have to click "OK", that someother program is trying to send mail. You can't do it undetected behind the scenes anymore, at least not since Office 2K/Sp2? -- Fred Microsoft Visual FoxPro MVP "Paul Pedersen" <no-reply@swen.com> wrote in message news:eHhxRQdLFHA.3184@TK2MSFTNGP09.phx.gbl... >I think with the newer versions of Outlook, it's no longer possible to tell >it to Send, even if Outlook is running. You have to get the user to click >the Send button on Outlook. Someone tell me if I'm wrong. > > I think this was done for security reasons - there were too many viruses & > such hijacking Outlook and sending emails without the users consent. > > > > > "Tom" <Tom@discussions.microsoft.com> wrote in message > news:64012719-9E6A-410C-981F-9B584CC20FC4@microsoft.com... >> aOk i answered my own question with the Following Code. >> >> oOutlook = createobject("Outlook.Application") >> #define olMailItem 0 >> oMailitem = oOutlook.createitem(olMailitem) >> WITH oMailitem >> .to = lagstat.pemail >> endwith >> oMailitem.display >> >> However it raised another. when a person sends in the above code, and >> outlook is not open, it waits to actually send the item untill they open >> up >> outlook. i need the mails to send when the user hits the send button, >> even if >> Outllok is Closed. >> >> Thanks again. > > Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209180
  - 13
    - RE: Grabbing an email Address from a Form Article: 179756 of microsoft.public.fox.programmer.exchange Thread-Topic: Grabbing an email Address from a Form thread-index: AcUsAYEiHph53JROQwaiesOZAkaJew== X-WBNR-Posting-Host: 206.29.98.226 From: =?Utf-8?B?VG9t?= <Tom@discussions.microsoft.com> References: <F3C056F1-CCF4-4639-874F-568BC1DBAE15@microsoft.com> Subject: RE: Grabbing an email Address from a Form Date: Fri, 18 Mar 2005 13:29:02 -0800 Lines: 16 Message-ID: <64012719-9E6A-410C-981F-9B584CC20FC4@microsoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset="Utf-8" Content-Transfer-Encoding: 7bit X-Newsreader: Microsoft CDO for Windows 2000 Content-Class: urn:content-classes:message Importance: normal Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0 Newsgroups: microsoft.public.fox.programmer.exchange NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29 Path: news.btopenworld.com!btnet-feed3!news-peer0-test!btnet!news-in.ntli.net!newsrout1-win.ntli.net!ntli.net!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl Xref: news.btopenworld.com microsoft.public.fox.programmer.exchange:179756 aOk i answered my own question with the Following Code. oOutlook = createobject("Outlook.Application") #define olMailItem 0 oMailitem = oOutlook.createitem(olMailitem) WITH oMailitem .to = lagstat.pemail endwith oMailitem.display However it raised another. when a person sends in the above code, and outlook is not open, it waits to actually send the item untill they open up outlook. i need the mails to send when the user hits the send button, even if Outllok is Closed. Thanks again. Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209179
  - 14
    - Re: Grabbing an email Address from a Form Article: 179789 of microsoft.public.fox.programmer.exchange From: "David Frankenbach" <sendnospam@sendnospam.net> References: <F3C056F1-CCF4-4639-874F-568BC1DBAE15@microsoft.com> <64012719-9E6A-410C-981F-9B584CC20FC4@microsoft.com> Subject: Re: Grabbing an email Address from a Form Date: Sun, 20 Mar 2005 11:45:59 -0600 Lines: 31 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-RFC2646: Format=Flowed; Original Message-ID: <O75JxSXLFHA.1176@TK2MSFTNGP15.phx.gbl> Newsgroups: microsoft.public.fox.programmer.exchange NNTP-Posting-Host: adsl-68-92-149-184.dsl.austtx.swbell.net 68.92.149.184 Path: news.btopenworld.com!btnet-feed3!news-peer0-test!btnet!newshosting.com!nx02.iad01.newshosting.com!130.191.3.6.MISMATCH!newshub.sdsu.edu!msrtrans!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl Xref: news.btopenworld.com microsoft.public.fox.programmer.exchange:179789 Tom, Check Outlook to see if it has a Send Immediately flag. I know that Outlook Express has this option and it controls whether or not the send happens instantly or is delayed until the next send/recieve pass is made. -- df - Microsoft MVP FoxPro http://www.geocities.com/df_foxpro "Tom" <Tom@discussions.microsoft.com> wrote in message news:64012719-9E6A-410C-981F-9B584CC20FC4@microsoft.com... > aOk i answered my own question with the Following Code. > > oOutlook = createobject("Outlook.Application") > #define olMailItem 0 > oMailitem = oOutlook.createitem(olMailitem) > WITH oMailitem > .to = lagstat.pemail > endwith > oMailitem.display > > However it raised another. when a person sends in the above code, and > outlook is not open, it waits to actually send the item untill they open > up > outlook. i need the mails to send when the user hits the send button, even > if > Outllok is Closed. > > Thanks again. Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209178
  - 15
    - nopageeject won't work Hi, Using VFP 8 and running this code from a .prg, Repo form x to prin noej Repo form y to prin will still eject the page. What am I missing? Thanks Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209169
  - 16
    - VFP6: Query Problem What is wrong with select left(workdesc,50) as wd,* from cwkt; where left(funccode,1)="$" and "P#"$wd order by wd where workdesc is a memo? I do not get an error message, but I also get no rows returned. I expected plenty, and the rows are there. If I replace the second conjunct with "P#"$workdesc it works. What is the difference in meaning between the two statements? ("P#" will normally be at the beginning of the memo.) Sincerely, Gene Wirchenko Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209163
  - 17
    - VFP 6.0 using SQL stored procedures I have a stored procedure in a SQL DB that accepts two parameters. Have used remote views to access SQL tables but never called a stored procedure. Tried using the VFP remote view wizard to access and the stored procedure isn't listed. What is the syntax to access a SQL stored procedure through remote view? Or, if that's the wrong way how to I access the stored procedure another way? Not talking about a VFP stored procedure, its on the SQL side. My code currently looks something like (stripped it down for brievity): ** Create connection Create CONNECTION MyConn; DATASOURCE alltrim(config.sourceodbcn); USERID alltrim(config.sourceodbcu); PASSWORD alltrim(config.sourceodbcp) ** Create view Create SQL VIEW 'vEmp' ; REMOTE CONNECTION 'MyConn' ; as SELECT *; FROM EMPLOYEES EMPLOYEES; WHERE Employees.HireDate = ?dDate ** Use the view dDate=ctod('02/05/2005') Use vEmp IN 0 Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209148
  - 18
    - Problem with Microsoft WebBrowser ActiveX Control : ReadyState incorrectly reporting complete This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C52EFD.93CB1250 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a problem with the MS WebBrowser ActiveX control which I have = added to a Visual FoxPro 9 form. I am trying to automate a process of logging on to a website and then = navigating to an account maintenance page and to then programatically = select a few check boxes on the web form and submit the form. I am trying to put together a container object framework which I can use = for this and any other project which will host a WebBrowser control and = will navigate to a given page and then call a function R_DELAY() to wait = for the page to complete loading before continuing to process a form on = the completed page. The problem I have is finding out when the navigation process is = complete so that I can then do something with the page that has loaded. My main tool was to be the ReadyState property which should read 4 once = navigation has stopped.=20 I currently use a loop - although I have used a timer event which also = did not work - which runs until ReadyState =3D 4 OR the loop times out. This works perfectly with the very first page I navigate to = (About:Blank) but for some reason, the WebBrowser reports ReadyState =3D = 4 long before any subsequent page loads. I have included WebBrowser.Document.ReadyState and WebBrowser.Busy into = the R_DELAY function but the function still either reports the page as = completed too early OR continues to execute the loops after the page has = been displayed in the WebBrowser control. This code to load a web page is: LPARAMETERS lcURL this.r_navend =3D .f. this.web1.navigate2(lcURL) IF this.r_delay() this.r_navend =3D .t. ENDIF=20 RETURN this.r_navend The code for the R_DELAY function is as follows: LPARAMETERS lnReadyState, lnMilliSeconds IF EMPTY(lnReadyState) lnReadyState =3D 4 ENDIF IF EMPTY(lnMilliSeconds) lnMilliSeconds =3D 4000 ENDIF DECLARE INTEGER Sleep IN WIN32API INTEGER nMSecs this.web1.SetFocus() sleep(1000) &&Looks like we need to give the browser time to start = before looking to see if it has finished lnX =3D 0 this.web1.SetFocus() &&this.web1 references an instance of Microsoft = WebBrowser ActiveX control DO WHILE this.web1.ReadyState # lnReadyState AND ; lnX < lnMilliSeconds DOEVENTS lnX =3D lnX + 1=20 Sleep(1) ENDDO lnX =3D 0 this.web1.SetFocus() DO WHILE ALLTRIM(this.web1.document.ReadyState) # "complete" AND ; lnX < lnMilliSeconds DOEVENTS lnX =3D lnX + 1=20 Sleep(1) ENDDO this.web1.SetFocus() lnX =3D 0 DO WHILE this.web1.busy AND lnX < lnMilliSeconds DOEVENTS lnX =3D lnX + 1 sleep(1) ENDDO=20 IF lnX < lnMilliSeconds RETURN .T. && Not timed out ENDIF RETURN .F. I think that about covers it. There was a note in the VFP documentation advising to set = APPLICATION.AUTOYIELD =3D .F. for the followig reason: "The AutoYield = property should be set to false (.F.) when a form contains an ActiveX = control. Setting AutoYield to false (.F.) prevents events for an ActiveX = control from executing between lines of user program code. For example, = if AutoYield is set to true (.T.), clicking an ActiveX control while = user program code is executing may cause an event for the ActiveX = control to execute, ignoring the user program code for the event, = producing undesirable or unpredictable results." Setting AUTOYIELD to .F. is supposed to do the following: "The instance = of Visual FoxPro does not process pending Windows events between each = line of user program code.All pending Windows events are placed in a = queue, and the events in the queue are processed when DOEVENTS is issued = or a wait state occurs. A wait state occurs when Visual FoxPro is = waiting for input from the user. The WAIT command does not create a wait = state." However, when AUTOYIELD is set to .F. then the program hangs totally so = I have changed this back to .T. Information: VFP 09.00.0000.2412 IE Version: 6.0.2900.2604 Windows XP SP2 (all critical updates applied) Kind regards Phil Hollingworth phil@wrltd.co.uk ------=_NextPart_000_0008_01C52EFD.93CB1250 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.3790.259" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>I have a problem with the MS WebBrowser = ActiveX=20 control which I have added to a Visual FoxPro 9 form.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I am trying to automate a process of = logging on to=20 a website and then navigating to an account maintenance page and to then = programatically select a few check boxes on the web form and submit the=20 form.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I am trying to put together a container = object=20 framework which I can use for this and any other project which will host = a=20 WebBrowser control and will navigate to a given page and then call a = function=20 R_DELAY() to wait for the page to complete loading before continuing to = process=20 a form on the completed page.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>The problem I have is finding out when = the=20 navigation process is complete so that I can then do something with the = page=20 that has loaded.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>My main tool was to be the ReadyState = property=20 which should read 4 once navigation has stopped. </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I currently use a loop - although I = have used a=20 timer event which also did not work - which runs until ReadyState =3D 4 = OR the=20 loop times out.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>This works perfectly with the very = first page I=20 navigate to (About:Blank) but for some reason, the WebBrowser reports = ReadyState=20 =3D 4 long before any subsequent page loads.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I have included = WebBrowser.Document.ReadyState and=20 WebBrowser.Busy into the R_DELAY function but the function still either = reports=20 the page as completed too early OR continues to execute the loops after = the page=20 has been displayed in the WebBrowser control.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>This code to load a web page = is:</FONT></DIV> <DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2><BR>LPARAMETERS = </FONT><FONT=20 face=3D"Courier New" size=3D2>lcURL<BR></FONT><FONT face=3D"Courier New" = color=3D#0000ff=20 size=3D2>this</FONT><FONT face=3D"Courier New" size=3D2>.r_navend =3D=20 .f.<BR></FONT><FONT face=3D"Courier New" color=3D#0000ff = size=3D2>this</FONT><FONT=20 face=3D"Courier New" size=3D2>.web1.navigate2(lcURL)<BR></FONT><FONT=20 face=3D"Courier New" color=3D#0000ff size=3D2>IF this</FONT><FONT = face=3D"Courier New"=20 size=3D2>.r_delay()<BR>    </FONT><FONT face=3D"Courier = New"=20 color=3D#0000ff size=3D2>this</FONT><FONT face=3D"Courier New" = size=3D2>.r_navend =3D=20 .t.<BR></FONT><FONT face=3D"Courier New" color=3D#0000ff size=3D2>ENDIF = <BR>RETURN=20 this</FONT><FONT face=3D"Courier New" size=3D2>.r_navend</DIV></FONT> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>The code for the R_DELAY function is as = follows:</FONT></DIV> <DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2> <P><EM>LPARAMETERS </EM></FONT><FONT face=3D"Courier New" = size=3D2><EM>lnReadyState,=20 lnMilliSeconds<BR></EM></FONT><FONT face=3D"Courier New" color=3D#0000ff = size=3D2><EM>IF EMPTY</EM></FONT><FONT face=3D"Courier New"=20 size=3D2><EM>(lnReadyState)<BR>    </EM><EM>lnReadyState = =3D=20 4<BR></EM></FONT><FONT face=3D"Courier New" color=3D#0000ff=20 size=3D2><EM>ENDIF<BR></EM><EM>IF EMPTY</EM></FONT><FONT face=3D"Courier = New"=20 size=3D2><EM>(lnMilliSeconds)<BR>    = </EM><EM>lnMilliSeconds =3D=20 4000<BR></EM></FONT><FONT face=3D"Courier New" color=3D#0000ff=20 size=3D2><EM>ENDIF<BR></EM><EM>DECLARE INTEGER </EM></FONT><EM><FONT=20 face=3D"Courier New" size=3D2>Sleep </FONT><FONT face=3D"Courier New" = color=3D#0000ff=20 size=3D2>IN </FONT><FONT face=3D"Courier New" size=3D2>WIN32API = </FONT><FONT=20 face=3D"Courier New" color=3D#0000ff size=3D2>INTEGER </FONT><FONT = face=3D"Courier New"=20 size=3D2>nMSecs<BR></FONT></EM><FONT face=3D"Courier New" = color=3D#0000ff=20 size=3D2><EM>this</EM></FONT><EM><FONT face=3D"Courier New"=20 size=3D2>.web1.</FONT><FONT face=3D"Courier New" color=3D#0000ff=20 size=3D2>SetFocus</FONT></EM><FONT face=3D"Courier New"=20 size=3D2><EM>()<BR><BR></EM></FONT><FONT face=3D"Courier New" = size=3D2><EM>sleep(1000)=20 </EM></FONT><FONT face=3D"Courier New" color=3D#008000 = size=3D2><EM>&&Looks=20 like we need to give the browser time to start before looking to see if = it has=20 finished<BR><BR></EM></FONT><FONT face=3D"Courier New" size=3D2><EM>lnX = =3D=20 0<BR></EM></FONT><FONT face=3D"Courier New" color=3D#0000ff=20 size=3D2><EM>this</EM></FONT><EM><FONT face=3D"Courier New"=20 size=3D2>.web1.</FONT><FONT face=3D"Courier New" color=3D#0000ff=20 size=3D2>SetFocus</FONT><FONT face=3D"Courier New" size=3D2>() <FONT=20 color=3D#008000>&&this.web1 references an instance of Microsoft = WebBrowser=20 ActiveX control</FONT><BR></FONT></EM><FONT face=3D"Courier New" = color=3D#0000ff=20 size=3D2><EM>DO WHILE this</EM></FONT><FONT face=3D"Courier New"=20 size=3D2><EM>.web1.ReadyState # lnReadyState AND ;<BR>    =     </EM><EM>lnX < = lnMilliSeconds<BR>   =20 </EM></FONT><FONT face=3D"Courier New" color=3D#0000ff=20 size=3D2><EM>DOEVENTS<BR>    </EM></FONT><FONT = face=3D"Courier New"=20 size=3D2><EM>lnX =3D lnX + 1 <BR>   =20 </EM><EM>Sleep(1)<BR></EM></FONT><FONT face=3D"Courier New" = color=3D#0000ff=20 size=3D2><EM>ENDDO<BR></EM></FONT><FONT face=3D"Courier New" = size=3D2><EM>lnX =3D=20 0<BR></EM></FONT><FONT face=3D"Courier New" color=3D#0000ff=20 size=3D2><EM>this</EM></FONT><EM><FONT face=3D"Courier New"=20 size=3D2>.web1.</FONT><FONT face=3D"Courier New" color=3D#0000ff=20 size=3D2>SetFocus</FONT><FONT face=3D"Courier New" = size=3D2>()<BR></FONT></EM><FONT=20 face=3D"Courier New" color=3D#0000ff size=3D2><EM>DO WHILE=20 ALLTRIM</EM></FONT><EM><FONT face=3D"Courier New" size=3D2>(</FONT><FONT = face=3D"Courier New" color=3D#0000ff size=3D2>this</FONT></EM><FONT = face=3D"Courier New"=20 size=3D2><EM>.web1.document.ReadyState) # "complete" AND = ;<BR>   =20     </EM><EM>lnX < = lnMilliSeconds<BR>   =20 </EM></FONT><FONT face=3D"Courier New" color=3D#0000ff=20 size=3D2><EM>DOEVENTS<BR>    </EM></FONT><FONT = face=3D"Courier New"=20 size=3D2><EM>lnX =3D lnX + 1 <BR>   =20 </EM><EM>Sleep(1)<BR></EM></FONT><FONT face=3D"Courier New" = color=3D#0000ff=20 size=3D2><EM>ENDDO<BR></EM><EM>this</EM></FONT><EM><FONT face=3D"Courier = New"=20 size=3D2>.web1.</FONT><FONT face=3D"Courier New" color=3D#0000ff=20 size=3D2>SetFocus</FONT></EM><FONT face=3D"Courier New"=20 size=3D2><EM>()<BR></EM><EM>lnX =3D 0<BR></EM></FONT><FONT = face=3D"Courier New"=20 color=3D#0000ff size=3D2><EM>DO WHILE this</EM></FONT><FONT = face=3D"Courier New"=20 size=3D2><EM>.web1.busy AND lnX < = lnMilliSeconds<BR>   =20 </EM></FONT><FONT face=3D"Courier New" color=3D#0000ff=20 size=3D2><EM>DOEVENTS<BR>    </EM></FONT><FONT = face=3D"Courier New"=20 size=3D2><EM>lnX =3D lnX + 1<BR>   =20 </EM><EM>sleep(1)<BR></EM></FONT><FONT face=3D"Courier New" = color=3D#0000ff=20 size=3D2><EM>ENDDO <BR></EM></FONT><FONT face=3D"Courier New" = color=3D#0000ff=20 size=3D2><EM>IF </EM></FONT><FONT face=3D"Courier New" size=3D2><EM>lnX = <=20 lnMilliSeconds<BR>    </EM></FONT><EM><FONT = face=3D"Courier New"=20 color=3D#0000ff size=3D2>RETURN </FONT><FONT face=3D"Courier New" = size=3D2>.T.=20 </FONT><FONT face=3D"Courier New" color=3D#008000 size=3D2>&& = Not timed=20 out<BR></FONT></EM><FONT face=3D"Courier New" color=3D#0000ff=20 size=3D2><EM>ENDIF<BR></EM><EM>RETURN </EM></FONT><FONT face=3D"Courier = New"=20 size=3D2><EM>.F.</EM></P></FONT></DIV> <DIV><FONT face=3DArial size=3D2>I think that about covers = it.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>There was a note in the VFP = documentation advising=20 to set APPLICATION.AUTOYIELD =3D .F. for the followig reason: <EM>"The = AutoYield=20 property should be set to false (.F.) when a form contains an ActiveX = control.=20 Setting AutoYield to false (.F.) prevents events for an ActiveX control = from=20 executing between lines of user program code. For example, if AutoYield = is set=20 to true (.T.), clicking an ActiveX control while user program code is = executing=20 may cause an event for the ActiveX control to execute, ignoring the user = program=20 code for the event, producing undesirable or unpredictable=20 results."</EM></FONT></DIV> <DIV><EM><FONT face=3DArial size=3D2></FONT></EM> </DIV> <DIV><FONT face=3DArial size=3D2>Setting AUTOYIELD to .F. is supposed to = do the=20 following: <EM>"The instance of Visual FoxPro does not process pending = Windows=20 events between each line of user program code.All pending Windows events = are=20 placed in a queue, and the events in the queue are processed when = DOEVENTS is=20 issued or a wait state occurs. A wait state occurs when Visual FoxPro is = waiting=20 for input from the user. The WAIT command does not create a wait=20 state."</EM></FONT></DIV> <DIV><FONT face=3DArial size=3D2><EM></EM></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>However, when AUTOYIELD is set to .F. = then the=20 program hangs totally so I have changed this back to .T.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial = size=3D2><STRONG>Information:</STRONG></FONT></DIV> <DIV><FONT face=3DArial size=3D2><STRONG>VFP = 09.00.0000.2412</STRONG></FONT></DIV> <DIV><FONT face=3DArial size=3D2><STRONG>IE Version:=20 6.0.2900.2604</STRONG></FONT></DIV> <DIV><STRONG><FONT face=3DArial size=3D2>Windows XP SP2 (all critical = updates=20 applied)</FONT></STRONG></DIV> <DIV><STRONG><FONT face=3DArial size=3D2></FONT></STRONG> </DIV> <DIV><FONT face=3DArial size=3D2>Kind regards</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Phil Hollingworth</FONT></DIV> <DIV><FONT face=3DArial size=3D2><A=20 href=3D"mailto:phil@wrltd.co.uk">phil@wrltd.co.uk</A></FONT></DIV></BODY>= </HTML> ------=_NextPart_000_0008_01C52EFD.93CB1250-- Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209146
  - 19
    - Making OptionGroups ReadOnly Hello and thanks in advance for the help. Is there a simple way to make OptionGroup controls readonly? Does anyone know why they don't have a readonly property (because they are container perhaps)? Thanks, Jeff Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209142
  - 20
    - Creating dbf from cdx I accidentally deleted dbf file, but I still have cdx. Can I recover part of the data (tag fields) from CDX? This is the situation. I have fields item, (some other fields), and tdate with tag (item+dtos(tdate)). Can I recover these tag fields from cdx file? If so, how can I do that? or Is there any program written already for it? Thanks. -- Daniel Kim compumate99@yahoo.com Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209137
  - 21
    - Here's an easy one (I think) Hello all and thanks in advance for the help: I think this one is easy if you know what to do. I have a form with a pageframe control, 8 pages, lots of other controls, etc. Sometimes I want the form to be readonly sometimes not. If will know this depending on the parameter I get in the init method. I think I know what code to write but I'm fuzzy on the details. It would meta-code to: For each control on the form If the control has a readonly property set it to the desired value endif next I would also be open to any easier way of doing this. I can't remember how to go through the controls on a form in code (The for statement). I don't think I've ever know how to check if a readonly property exists. Thanks again, Jeff Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209126
  - 22
    - Proper way to handle arrays passed as parameters I am using a method that gets an array passed as a parameter. When I run it in development mode it runs fine. When I try to build it though, FoxPro gives an error saying Unknown myArray - Undefined. What do I have to do to make it so that it doesn't give this error. I have the array as the parameter to the method and I am passing the array by using the @. this is basically what I am doing Select *; FROM sometable; into array testarray if _tally > 0 myProc(@testarray) ENDIF Procedure MyProc parameters myArray **do some stuff here with the array Endproc -- Altman VFP9 Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209125
  - 23
    - sql select problem the following code is working properly in developed machine (in vfp9 vesion) but not in the machine which has not installed vfp9. the result is cursor 'query1' not creating. Does anybody can help in this matter SELECT * FROM Invtrans WHERE invtrans.transNo=thisform.ainvno and invTrans.transType=thisform.ainvType ; ORDER BY 0 INTO CURSOR Query1 Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209122
  - 24
    - Kill a process Hi All, How to kill a process in vfp8? Thanks kd Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209118
  - 25
    - Tab Order Hi Guys, Can I enforce a strict tab order on a form? I want the user to enter data in the order I specify. Thx Steve Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209113
- Next
  - 1
    - Mike Feltman at LA Fox April 5 -- Active FoxPro Pages Using Active FoxPro Pages with Visual FoxExpress Visual FoxExpress is an n-tier framework for Visual FoxPro with a very rich object model and powerful data dictionary. In this session Mike will demonstrate classes he's created to make use of the Visual FoxExpress object model for web site development. Although the session will focus on AFP, the techniques covered here will also apply to using VFE with Web Connection, (Class) Active Server Pages and ASP.NET. ** Note that this is being held at a special date -- April 5 (not April 12) ** See you at LA Fox! http://www.lafox.org Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209109
  - 2
    - Running Forms/Reports From Menu I have created a modless form that I use to establish the variables (scope) for several different reports. I have defined properties in the form to hold the scope variables needed for the reports and use them as the control source for the various text & combo boxes. I use the same variables for for several reports so I don't want to define public variables since they could be used by more than one instance of the form and private variables declared in the form will not be visible to the report object. Problems arise when I use the "procedure" result option on the reports menu to launch the form. I use the procedure option to set some global flags that define the forms layout options and the report to run. For example: GoApp.RepTyp = 1 DO FORM FrmMsg1 The form object is not visible when I run debugger and am not able to pass the forms property values to the reports as variables. Any suggestions??? Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209106
  - 3
    - To CS or not to CS? I have 3 - 10 users making edits and adding records to tables of 3 - 20 MB in size, usually using views, but sometimes directly. Each change is no more than a handful of fields in one or two records, but as the tables grow, I'm starting to get complaints about slowness. In a file server system like this, does each user have to read and write an entire multi-megabyte table every time they make a small change? Or does the file server and/or network do some buffering and change management for me? In general, when is it time to consider switching to client-server? Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209089
  - 4
    - Can I SET ORDER to a different tag in related table I have a grid that uses two tables, let's say, Customer and Orders. The Orders tables is indexed by two fields, Customer ID and Order Date Descending. Customer table has a relation set to Order table on Customer ID feild. I want to retrieve all the orders for a customer and display them in the grid in descending Order Date order. I have tried setting the order of the cursor in Data Environment but it seems to be ignored, I think because of the relation. Is there a way I can achieve this without having to resort to creating a view etc. Any ideas ? Subhash. -- Subhash Chopra VFP 6.0, WIN XP PRO Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209083
  - 5
    - Outlook Global Address List I would like to be able to extract e-mail names and addresses from a Global Address List. The client has exchange server and microsoft outlook as the client. I have used a code sample from news2news.com/vfp/?example=407&function=33 that was useful insofar as it let me pull addresses from both the Global Address List as well as the contacts folder. Unfortunately it didn't return the recipient (e-mail) address from the Global Address List. Any suggestions? Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209073
  - 6
    - Scheduler Do you know a product to make a scheduler with a calendar and I can put some task and drag and drop easily. I have a product but I don't know if it's work with VFP. http://www.devexpress.com/Products/VCL/ExScheduler/ Do you test it or have another product ? I've tested DBI but I can't put easily stand alone task in a day. Fabien Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209072
  - 7
    - A Bug in VFP 9.0? - Error: 1808 Hi Guys I have encountered a problem when upgrading several projects from VFP 8 up to VFP 9. The code has not been changed in any way but we are now getting Error 1808 - SQL: ORDER BY clause is invalid (Error 1808) The help on this error is as follows: <help> Visual FoxPro 9.0 SQL: ORDER BY clause is invalid (Error 1808) One of the fields chosen for the ORDER BY clause is not in the SELECT list. This occurs only when using numeric indexing as in the following example where the number chosen exceeds the number of fields selected: SELECT a,b,c FROM table ORDER BY 4 This error will also be generated if you include a Blob type field in the ORDER BY clause. </help> Now I have never used numeric indexing as it poses too much of a headache if you ever want to change the fields you are selecting so I always reference Order_Item by the column name. So I am at a loss as to why this error is occuring. After playing around a little I have worked out what is happening and it may be that Microsoft have closed a loophole with their naming convention. It would seem that where you have a column which is calculated on the fly from a source table, you cannot give the newly created column the same name as the field it is derived from. To recreate this problem all you need to do is: 1. Create a free table called Table 1 and give it one field called Firstname which is of Character type and 10 chars long 2. Populate the table with a few rows 3. Run this query which works ok: SELECT distinct PADR(firstname,30) as fname FROM table1 ORDER BY fname 4. Run this query which fails: SELECT distinct PADR(firstname,30) as firstname FROM table1 ORDER BY firstname Obviously if I had not been lazy in my naming convention then this problem would not occur - but clearly VFP9 has been changed in some way to cause this error in pre-existing code. Any thoughts? Kind regards Phil Hollingworth phil@wrltd.co.uk Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209065
  - 8
    - VFP7 application booted out - DDE causing it? I posted the following a few days ago- At one of our customer sites, they are having frequent problems of being booted out of our VFP7 application after it has been minimised for a while. They are also running a GIS application (ArcView). The 2 applications actually communicate with each other using DDE services. It is happening on all their pcs. To me this sounds like Windows (2000 and XP) memory management not coping very well but are there other issues I should be looking at? This has only started happening since they upgraded from our VFP6 application version to our VFP7 one. They may have also had some network changes but it's hard to pin them down. The only replies mentioned that DDE is old fashioned. It is code from a few years ago and there hasn't been any reason to change it as it was working well with the VFP6 application. What should we be using now? Thanks for any suggestions. Bernie Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209061
  - 9
    - VFUG.Org News Ticker (VNT) RC2 Now Online! VFUG News Ticker (VNT) RC2 is Now Online and can be found on the first page of VFUG after log on or at: http://www.VFUG.Org/VNT/ This release fixes a bug in the auto-update routine, updates every 5 minutes, includes a new "Snap" feature, plus a number of minor changes. VNT is free to all VFUG Members -- VFUG Membership is required. -- ~ Thomas O'Hare ~ President, RedTile, Inc. -- DBA: RedTile Software Web, Wireless, Network, Database & Systems Software 407-295-9148 http://www.RedTile.Com/ or http://www3.RedTile.Com/ Operations Manager, Virtual FoxPro User Group Tom@VFUG.Org http://www.VFUG.Org/ or http://www3.VFUG.Org/ Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209050
  - 10
    - ACOPY() bug It has to be either a bug in FoxPro or an error in the documentation, right? Documentation says "If the destination array already exists, it is redimensioned to the size of the source array." DIMENSION arrayX(4, 5) DIMENSION arrayY(1, 5) ACOPY(arrayX, arrayY) && gets "Subscript is outside defined range" error Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209047
  - 11
    - Poss. Migrating to VFP from Paradox I presently have a number of applications written with ObjectPAL and Paradox 10 running presently, however am rapidly coming to the conclusion that I need to move away (Corel is not really doing much with it .. now). Problem is that most of the users who use these applications do not need SQL or anything heavyweight and am happy to stay with file-based databases and recently picked up the press coverage on VFP 9. It sounds pretty damn good for what I want/need and wondered if anyone else has had to migrate from Paradox to VFP in the past and has any useful hints/tips or pitfalls in making such a migration. Regards Jonathan Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209040
  - 12
    - Implementing WndProc in vfp Hi All, Is it possible to implement windows message loop in visual foxpro 8.0? If this is possible, it would be great if anybody could post an example of the same? Thanks kd Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209033
  - 13
    - Communicate with vb.net application Hi All, I need to communicate between two applications. One application is developed in visual foxpro 8.0 and the other is developed in vb.net. This being the scenario, could you please suggest the easiet and the bext way to communicate between the two applications? Thanks. kd Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209029
  - 14
    - VFP8 Help entry for Arrays and Select - SQL ... Wrong or what? I've copied the bulk of the VFP8 help entry for sending query results to an array below. If you look at the output for the company column, the values are all trim()/alltrim()'d -- a behavior I'd like to duplicate. Unfortunately, the best I can do is to trim() the appropriate results by hand after my queries execute. So...is the help entry wrong or am I missing something? -Lew SELECT - SQL is a versatile command for querying tables and can direct query results to an array. To send SELECT - SQL query results to an array, specify the INTO ARRAY clause with an array name. If the array doesn't exist, it is automatically created. If the array does exist, it is redimensioned automatically to accommodate the query results. Example In the following example, SELECT - SQL directs its query results to an array named RESULTS: SELECT DISTINCT a.cust_id, a.company, b.amount ; FROM customer a, payments b ; WHERE a.cust_id = b.cust_id INTO ARRAY results DISPLAY MEMORY LIKE results RESULTS Priv A TEST ( 1, 1) C "000004" ( 1, 2) C "Stylistic Inc." ( 1, 3) N 13.91 ( 13.91000000) ( 2, 1) C "000008" ( 2, 2) C "Ashe Aircraft" ( 2, 3) N 4021.98 ( 4021.98000000) ( 3, 1) C "000010" ( 3, 2) C "Miakonda Industries" ( 3, 3) N 9.84 ( 9.84000000) Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209026
  - 15
    - Select - SQL vs. SUM I have a grid whose recordsource is a table named _payments. In this table there is a column in which user enters the amount of payment received for the respective invoice. This column is no. 8 in the grid and is the last column. The table contains outstanding invoices for a particular customer. In the lostfocus event of the the column, I placed the following code: Thisform.txtUnused.refresh The txtUnused is a text box that displays the unused portion of the total payment received from that customer. The Text Box has its controlsource set to nBalance. I place the following code in Refresh Event of txtUnused: Select _Payments sum Thispmt to TotalPmt nBalance=nPayment-TotalPmt && nPayment is the total payment received. Select Customer This code works fine the way it is. However, when I change the code to a SELECT-SQL statement, I run into a weird behaviour. The SQL code reads: Select sum(Thispmt) from _payments into array TotalPmt nBalance=nPayment-TotalPmt With the SQL statement when I change the value in ThisPmt column for the first time and hit Enter key, the value in txtUnused is updated and the focus moves the 1st column in the grid which is a Checkbox control. Now, while staying on the same row if I navigate to the last column and change the value again, the txtUnused doesn't get updated. Except for the first time, no matter how many times I change the value in the ThisPmt column, the txtUnused stays the same as the first time value. When I press down arrow key and then up arrow again, then the value gets updated. With the SUM statement, it works perfectly fine. As soon the value is changed in that column and I press Enter Key, the value in txtUnused gets updated and focus moves to 2nd column in stead of 1st column as was the case when I use Select SQL statement. Can someone please explain this to me why it is happening the way it is. I would prefer to use the SQL SELECT in stead of SUM statement. Thanks a lot in advance. -- Subhash Chopra VFP 6.0, WIN XP PRO Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209023
  - 16
    - MSMQ in VFP8.0 Hi All, I am using VFP8.0. I' ve heard that MSMQ has been incorporated since VFP6.0; but it seems to me that MSMQ has not been installed on my machine. How do I install MSMQ? Thanks. kd Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209017
  - 17
    - Detecting when a "modify ... NOWAIT" is complete I am using vfp6 I want to be able to detect when a programmer has completed modifying files. I will start the edit from a button click but I want to use the NOWAIT option on the modify command. Then when the file has been modified I would like to do some processing on it. I would prefer not to use a timer to check whether the forms are still being modified. I want something closer to an event. I have tried bindevents, but it doesn't seem to work with a form. I get "No such interface supported". The other option is to watch the date and times on the files in a particular directory but again I wanted to avoid using a timer for polling. Any help would be appreciated. Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209013
  - 18
    - Transparent bitmaps for buttons in our application (VFP 7) we have a toolbar that has a series of buttons on. I have created a .MSK file for each button to be able to have their background transparent but there is still some apparent pixel bleed in some of them. Is there a tool that can easily create the .msk file for the bitmap being used? thanks pete Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209006
  - 19
    - AutoInc problem, VFP8 Just wondering if anyone else has come across this problem, it's the first time I've seen it. One of my tables has a pk, inst_id, which is set to autoinc. I bombed today on the uniqueness of my key which seemed strange considering I have no reason to manipulate any autoinc'd pk's directly. Nevertheless, it did turn out that the next val somehow or other had become set to a ridiculously low value ( 3 in a table of 50 entries). I have not experienced any data corruptions; and I always open my dbc's with the validate clause. Tag: March VFUG Newsletter is Now Online (Free!) Tag: 209000
  - 20
    - Grabbing an email Address from a Form hello, i am fairly new to all this. i have a contact form in a app we have. i want to grab the email address from the form and open up Outlook, have the address already in the .to and outlook just waiting for the user to input something in the Body and to send it. currently my code goes some of the way but not all. oOutlook = createobject("Outlook.Application") #Define olFolderdisplaynormal 0 oNameSpace = oOutlook.GetNameSpace("MAPI") oExplorer = oOutlook.Explorers.add (oNameSpace.Folders[1], olFolderDisplayNormal) oExplorer.Activate() #define olMailItem 0 oMailitem = oOutlook.createitem(olMailitem) WITH oMailitem .subject = "This is my Test Button" .to = ("what do i put here??? ") endwith oMailItem.save() i have tried the _miscbtn class in vfp6 and it does it, only it places the entire form contents in the Body of the message. its easy to pull addresses from the contacts folder but i cant from my form. thank you in advance for your help. Tom Tag: March VFUG Newsletter is Now Online (Free!) Tag: 208976
  - 21
    - memory file is invalid I have a database with 3 tables. These were originally created in vfp 5. Now are used in vfp 8. When I try to Restore from Memo <fieldname> I get a message 'memory file is invalid' What can I do to fix this problem. (I don't want to purchase any 3rd party software.) Thanks sherry Tag: March VFUG Newsletter is Now Online (Free!) Tag: 208969
  - 22
    - Scrolling in textbox I have limited real estate on this one form and need to include a text box to store an email address. I can't draw the box as wide as some emails might be. When I type in characters, it stops at the end of the box. How can I get it to scroll so that I can enter more characters? Many thanks Stephen Tag: March VFUG Newsletter is Now Online (Free!) Tag: 208952
  - 23
    - Application minimising onto toolbar I have a small single form project with the following settings: _screen.visible = .f. desktop = true Showwindow = As Top Level form If I create a desktop shortcut and run it with nothing else open, everything is fine, it appears in the centre of the screen. If I run the program by double-clicking on it via Windows Explorer, or if another program is open, it immediately minimises onto the task bar. How do I get it to run and appear on top of any windows already open? Many thanks Stephen Tag: March VFUG Newsletter is Now Online (Free!) Tag: 208950
  - 24
    - buffering & transactions It is not necessary to buffer a table for transactions to work. Nevertheless, I usually buffer a table (or use a view), then if a transaction is necessary, put the transaction only around the TABLEUPDATE in order to keep the transaction short. But I'm really guessing here. Am I approaching it in the best manner? What general rules are there for handling buffering and transactions? Also, I occasionally want a transaction to cover changes to several tables, with some calculation done during the process, and even a couple nested transactions. The whole thing could take a few seconds (in a multi-user environment). Is there anything specific I need to look out for? Other than the limit on transaction levels, I mean. Tag: March VFUG Newsletter is Now Online (Free!) Tag: 208939
  - 25
    - Accept ONE character no need to hit enter in window? I have a bunch of activate window routines where I make a choice with an Accept to memvar command My choices are the Enter key (enter nothing) or enter a single character, e.g. the letter "K" to Keep something the same etc. Is there a way to force the program to continue execution after ANY key is pressed, not just the Enter Key. Say as soon as I hit the "K" key I don't have to hit the enter key, I'm done, I only want to accept a single character. Thanks. John "J.J." Jackson Tag: March VFUG Newsletter is Now Online (Free!) Tag: 208938

The March edition of the VFUG.Org Newsletter -- a great free resource
for all VFP developers -- is now online. If you did not get an email
copy, feel free to log on www.VFUG.Org and select the "Newsletters"
section.

You can also specify in your VFUG user profile if you want the VFUG
Newsletter delivered straight to you mailbox every month -- free!
--

~ Thomas O'Hare ~
President, RedTile, Inc. -- DBA: RedTile Software
Web, Wireless, Network, Database & Systems Software
407-295-9148 http://www.RedTile.Com/ or http://www3.RedTile.Com/
Operations Manager, Virtual FoxPro User Group
Tom@VFUG.Org http://www.VFUG.Org/ or http://www3.VFUG.Org/

Top