Answer Questions

• webmonsta Launching Adobe Reader Programatically

  Is there a way to launch Adobe Reader with a file name from within VFP90   I want my users to be able to print PDF files without having to search for the files - the search would be done through the GUI. Thank you, Wow, thank you very much. FUNCTION ShellExec LPARAMETER lcLink, lcAction, lcParms   lcAction = IIF(EMPTY(lcAction), "Open", lcAction) lcParms = IIF(EMPTY(lcParms), "", lcParms)   DECLARE INTEGER She ...Show All

• pistolpig define window

  How could we show a define window into a top level form, where-in screen visible is set to FALSE Because I try it, and it doesn't show-up, maybe i got wrong in coding. Thanks for any help Amado Thank you very much, for the help. I will try that You don't want to close myCursor just yet as it will dissappear forever. Remember a cursor is not a real table (DBF) so it will not have persistence on disk to be reopened later. What you do ...Show All

• Ben Molk programmatic registration of com.exe

  I want to registrate a Com.exe by program (like "run xx.exe /regserver"). I found only a solution for registrating Dlls (with "DllRegisterServer"). May be I could use "CoRegisterClassObject". Has anyone a code-example See the reply and example code I posted on Foxite for you( www.foxite.com ) You can use ShellExecute. declare long ShellExecute in "shell32.dll" ...Show All

• Yicong Shen a child form needs 2 clicks to close

  I have a form calling a secondary form. In order to close the latter I have to click twice the button that has the following statements in the CLICK method: ACTIVATE SCREEN "CLICK fired " THISFORM . Deactivate () THISFORM . Destroy () THISFORM . Hide () THISFORM . Release () 4 statements are there out of desperation. I tried them separately and in many combinations. I see on the SCREEN that the event fir ...Show All

• DannyC how to change field values?

  I am looking for a way to address fields to change their values. I cannot understand how it can be done in VFP. For instance, if I use two statements which open a database table with a few fields in it, what do I do next USE DatabaseVfp1 tcp_ip IN 0 as cTableAlias SELECT ALL FROM cTableAlias cTableAlias.fieldName1 - what does this expression give me Is it the field value or just a field name Can I write: cTableAlias.fieldName1 = ...Show All

• William Choong Needed help regarding VFP 9 Installation....

  Hi, I've installed the VFP 9.0 in a Win XP(SP 2) environment. Though I've installed I'm still unable to use any of the wizards or the sample files provided. Even i'm unable to invoke the help. When I press F1 the message " out of memory.... swtich to...." appears. When I invoke the wizards, "File corrupted...." sort of message appears. Can anyone help me out. Thanks in advance... Markish Hi, th ...Show All

• Muthu Krishnan.R How to play a Windows Media Audio format (WMA) in VFP?

  Hi all, I am now trying to create a small program to play media audio files. I'm now using the MultiMedia ActiveX control (mci.ocx) to play these files but this ocx seems can not play WMA files while this type of file is getting more and more popular to music-lovers. Could anyone tell me how to play WMA files in VFP. Note:I want to play them directly in VFP with MCI control or with some API function that VFP can handle,  ...Show All

• ashutosh.soni03 New to Word integration using DDE

  We currently are using word integration that involves a foxpro table where each field represents a mergeable item.  The data from the foxpro table is pumped into an excel spread sheet and then into Word.  I want to eliminate excel as well as get around the limit of being only able to have 255 merge fields.  To this end I want to have one foxpro table that contains two fields , the first field will hold all the merge field names, a ...Show All

• richard12345 Question about using left join and where clause together.

  Hi, I have a select statement as follows: SELECT ;     a.cust_id as Customer, ;     a.store_no as StoreNo, ;     b.pd_code, ;     c.pd_sdesc, ;     sum(b.ord_qty) as OrderQTY, ;     sum((b.cs_uprice + b.handle_fee) * b.ord_qty) as OrderAmount ; FROM ;     sspdodhd a, sspdoddt b, sspdcd c ; LEFT JOIN ;   ...Show All

• Victoria W Clearing a cursor

  I am working with a cursor that I use to import XML information to. When I am done with the XML information, I want to clear the cursor for other input from the same area; however, I am unsure as how to go about this. Any ideas Andy, Thanks for the extension. Hi Dave Ahem....if I may be permitted to extend your note.... CREATE CURSOR ( ... ) cursors and those created by SQL PassThrough (SQLEXEC()) are read/write b ...Show All

• Martin Szugat can i use SQL sort by special expression?

  my user want the data is sort by the field's content. the content is "I","E","C","A" and BLANK if just ascending and desc ,it's easy. but now they want sort by this sequence "I","C","E","A" then blank so how can i do it thank you SELECT * ;       , at ( data, "ICEA " ) as _ORDER  ;     FROM table  ;    ORDER BY _order I ...Show All

• Michael Boniwell cannot generate an exec file

  I just finished a large project and tried to generate an .exe file from it. I encountered the following problems. BUILD EXE FROM ..... issued from the Command Window gives me a series of errors. The first one is entirely unexpected. It claims that a file "inpARR" could not be found. When I click on "locate' it offers me a file dialog box to find it. I definitely do not have any reference to a file by this name anywhere in my pr ...Show All

• Benzi runing total in vfp report

  hi; how i print runing total in vfp report thanking you >> how i print runing total in vfp report Use a report variable to accumulate it as the detail lines are processed. If you need more information you'll have to give us a lot more than you have here... ...Show All

• Snkscore Convert month to numeric

  Dear all, i using vfp7. Do there a function i can convert "June" to 6 i mean to numeric formats. Thanks in advance. sorry i dun un wat is -1,1,1,1+2+4+8 even i had read help files haha please explain .... thanks AFAIK there is no function in VFP that does parse a monthname to its numeric format nor parse a date/datetime that contains monthnames (such as June 3,2006 to 6/3/2006). You can create your own Mo ...Show All

• victorashi Back To Front (MSFlexGrid)

  My Form containts a MSFlexGrid (MSFG) and a textbox (txtCell). I want to use txtCell to update value for MSFG. This code in MSFG.EnterCell method: With This Thisform.txtCell.Visible=.T. Thisform.txtCell.Move .Top+.CellTop, .Left+.CellLeft, .CellWidth, .CellHeight Thisform.txtCell.ZOrder Thisform.txtCell.SetFocus EndWith But MSFG is always front of txtCell. Please help me! Thanks! Unfortunately that's the ca ...Show All