Answer Questions

• Virendra Wadekar Copying a file to EXCEL from FoxPro.

  PLEASE HELP! I'm using Visual FoxPro 6.0 and EXCEL 2003.  I created a query with FoxPro 6.0 and copied the data to EXCEL 2003.  The Table size is 33827 records and it only copied 16384 records.  It only copied half the code.  Why is this Here is the code. close data all set talk on set dele on SELECT 0 USE "c:\documents and settings\bartech\my documents\fmpdata\software code\fmp reports\fmptables\line02.dbf" shared select *;  from line02;  group by 3,4,5,6;  order by 3,4,5;  into cursor x select x copy to c:\line02wmake&model.xls type xls Use TYPE XL5 rather than XLS. XLS is Excel 2.0, which had a smaller limit than XL5. Tamar select * ;   ...Show All

• Prasenna using tow field index with codebase

  Hi, I'm using codebase to create table and index and i use VFP 9.0 to open the table and execute querys. when i'm creating an index for one feild : "CREATE INDEX ind ON person(age)" every thing works fine and there the index is working well. when i'm creating an index for two fields or more: "CREATE INDEX ind ON person(age,name)" VFP cant open the table. what seems to be the problem thanks ishay If you think is .cdx file, why don't you re-create it What do you mean: "converted database in foxpro format" i'm using the "codebaseODBCStandfoxpro" driver to create the tables and indexs, so what kind of conversion did you make ...Show All

• sl0140 Fonts, ? and set alternate

  Hi; I have lots of older code that uses commands and set alternate to create a text file and then it uses modify command to view the file. I have noticed that on my development PC, this created a file with Fixedsys font. On the installation pcs the font is "Courier". Is there a way to determine what font will be used when issuing commands to a set alte file I know that I can use the font clause in the command itself but I was wondering what determines the default font used. Thank you all for puting up with my "oldie" questions. Your what You mustn't change the font settings on and end-user's machine! If you want this to display in a given font at run time, use DEFINE WINDOW (which ...Show All

• Eric Anderson Printing from com dll

  I'm trying to print a report from a Com dll file. I keep getting the OLE IDispatch exception code 2031: User-interface operation not allowed at this time. Is there any way to make this work without building to an .exe file I'm using VFP 9 thanks in advance -m The error indicates that you are using some form of UI - which is NOT allowed in a VFP DLL. Are you trying to use the Preview winodow If so you cannot do so unless you re-compile as an EXE and no, there is no way around it. Either dispense with the preview or use the DLL to return the data for the report to the calling application and have IT handle the display and print. This is built into the compiler for DLLs because a DLL may b ...Show All

• wms103006 Visual Foxpro report writer

  I have a dbf with following fields bill no, bill date, cust name,item name,qty,rate,amount and i have 553 records. i want a simple report on 132 column stationary. i dont want totals also. (so no page footer or summary). i used visual foxpro report writer. but the report does not print with proper ejection i.e. second page starts printing from bottom of first page and third page prints from bottom of second page and so on. printer is absolutely fine because documents from excel and word print with proper page breaks. can anybody help no. us std fanfold is paper size. i am putting the paper in spraket. i.e. sticking the paper in holes. and it is a portrait layout. i am using continuous stationary only. but i cam ...Show All

• David Joyce Connect to Outlook Express and Microsoft Outlook

  Dear Expert, Can I know how to connect to the Outlook Express and Microsoft Outlook using FoxPro Like the data in a memo feild how I connect or send out using the Outlook Express and Microsoft Outlook Or Can I generete email using FoxPro Thank you.     WITH THE ABOVE CODE I GOT THE FOLLOWING ERROR' THE MESSAGE COULD NOT BE SENT TO THE SMTP SERVER. THE TRANSPORT ERROR CODE WAS 0X80040217. THE SERVER REPOSONSE WAS NOT AVAILABLE. Aleniko wrote: Can one use CDO if the SMTP server is an ISP You mean that the SMTP server is not installed locally Absolutely, all you need to know is how to access the SMTP ...Show All

• dvanderboom Will VFP6 work with Windows Vista

  My company operates a series of VFP6 runtime databases successfully in the Windows XP environment. We currenly have one PC loaded with Windows Vista. When the runtime setup is run it does not install the runtime files onto the Vista PC. Can VFP6 work in the Windows Vista environment How can this problem be overcome Many thanks in anticipation. >> We currenly have one PC loaded with Windows Vista. When the runtime setup is run it does not install the runtime files onto the Vista PC. Vista has introduced lots of new "security" so one issue may simply be that you don't have rights to install - I think you have to logged in as a System Adminsitrator and maybe eve do something ...Show All

• gobby74 How to let user choose a data path?

  I wish to let the user choose a folder to dump data. How can I achieve that    To be user friendly, I whish to give them an interface like putfile() or getfile() screen. Not a text box to manualy enter the path.  Thanks. Great! Thank you, CetinBasoz. cmyDir= GETDIR ("c:\data\","Select a folder","test",64) The easiest way is using GETDIR([ cDirectory [, cText [, cCaption [, nFlags [, lRootOnly ]]]]]) which calls a Windows interface window familiar to users.  See: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/e6109205-e91d-440f-b5ae-d2ccaa78c602.asp frame=true for det ...Show All

• clintsinger Execution of function or command is not allowed in context of SQL command.

  Hi; I got this error when I try to issue a quit command from my error trapping routine. Clicking help (Just like many other cases) is no help at all. I couldn't find this error anywhere in the VFP help or in google... Any ideas why this happens, and how I can avoid it Thanks. >> Just wanted to describe my SQL statement. Please let me know if you still think it is odd Yes, it is odd because if you don't have a join condition, then you will get a cartesian product from a query like this. This occurs when the SQL Engine joins all records in one table, to all records in the other. So if you have more than one record in the 'tmpcpo' record you could get some strange results ...Show All

• sfx1 Grid columns populated with incorrect data

  I have a grid with a bunch of columns. First, I suspect that the control source for the columns in this grid 'resets' itself to 'none', but I am not sure about this. Second, When I manually fill in the control source for the columns, some of the columns get populated by the next field in the cursor regardless of what I have specified in the control source. Help... Aleniko You're doing a select *. Maybe the order of the fields have changed and do not match one to one columns. Instead of select * you can specify the fieldnames in the order you want. Second, you're selecting into a cursor and making that cursor the recordsource of the grid. You could directly make the select itself the ...Show All

• Joao Pinto accessing a foxpro table on my website

  I have a simple FoxPro table sitting on my website. I need to read and write data to it in an standalone application on my pc. I can get to where I can read the data but I cant change the data. Any help would be greatly appricated.   It doesnt have to be fancy I just need a simple way of doing it. Thanks If you are after a very simplistic thing, then download Visual web builder from MS site ( http://msdn.microsoft.com/vstudio/express/ ) and follow one the walkthroughs. I think you can do that in one day (considering you have never done before). I was in the process of following a suggestion from his site of simply using the USE statement to access the table on ...Show All

• TGirgenti Help on Report Writer Wizard

  Hi guys, Hellllpppppp. I am very new with VFP and already getting frustrated. I would appreciate a little help from you gurus. Using the Report Writer Wizard always gives me this error message: "The DBC containing the selected table was previously opened non-exclusively and the field(s) you chose for sorting are not in existing index tag. Please select field(s) which already have an existing index tag or exit the wizard and reopen the DBC exclusively." I have done ALL of them and I still get the same error message. Thanks You may find the solution here: http://support.microsoft.com/kb/141074 Thank you so much DocPro77. I will definitely try it. ...Show All

• Samuel369 Random Sample

  I have a table containing 3773 records, and i need a random sample of 2500 of these records. Does is there any easy way to to this w/ foxpro or do i have to come up w/ an algorithm myself Thanks in advance, Mike The Rand() function will let you do this. Something along these lines: * Assume nNumToPick is the number you * want to select * Seed RAND() RAND(-1) * Set up a cursor to know which records you * already have. PK here represents the primary * key for your table. SELECT PK, .F. AS lChosen ; FROM YourTable ; INTO CURSOR Picked nRecCount = _TALLY nTotalPicked = 0 DO WHILE nTotalPicked < nNumToPick nRec = INT(_TALLY * RAND()) + 1 GO nRec IN Picked IF NOT ...Show All

• bencoffin DLL Language in Portuguese

  This is my first Post :) I work with VFP since '99 and has been always in english. Dealing with english is not a problem, but for my custumers yes, especially with error messages prompted from VFP (due to program code error ou just a crash). Is there a possibility to translate a Resource DLL to portuguese just like exists in Spanish, French, etc. This avoid me have an error routine to translate some messages (one of the common messages is "The visual foxpro support library is missing or invalid"). thx, DaCosta11. I was partly involved (among several others) in translating the resource file to Spanish for VFP8 and VFP9. It is not an easy job and requires more than one person, plus the collaboration of Microsoft. As Andy ...Show All

• cobain81 How to manipulate BROWSE NAME objects?

  I am trying to manipulate a browse object. I'm doing a browse nowait and then I make changes to some properties of the object. But then, I can't set focus to the browse window. The following runs through the code all the way to the 'Done'. How can I activate the browse window Thanks. CREATE CURSOR tmprug (rugno c(6) ) INSERT INTO tmprug VALUES ("000001") INSERT INTO tmprug VALUES ("000001") GO top define wind rugs from 06,0 to 18,90 font "Tahoma",10 grow brow fields item=recno():4:w=.F.,rugno NAME oBname wind rugs nowait oBname.AllowAddNew = .T. oBname.column1.setfocus() ACTIVATE WINDOW tmprug WAIT "Done" wind No I'm not referring to any message. I haven't read the mes ...Show All