Answer Questions

• ayya Speed issue

  Hi I have an open table in VFP. I am using vb.Net to get the records from the table. I use the following connection string to connect to the open table. Provider=vfpoledb.1; Data Source=\\Commercial\Data; Provider=Microsoft.Jet.OLEDB.4.0; Data Source= \\Commercial\Data;Extended Properties=dBASE IV;" The open table has more than 3,604,393 records in it. When I give the following sql statement Sql = “select * from ordDet where 1=1 and comp_code = ‘01’ and Itemcode =’02’” cmd = New OleDb.OleDbCommand(Sql, gconnMDB_I) Dim rdDept As OleDb.OleDbDataReader = cmd.ExecuteReader() Do While rdDept.Read() dr = dt.NewRow() dr(0) = rd ...Show All

• Delpasso22 Purging data from Visual Foxpro using oledb in .Net

  Hi, Can any one help me on the below.... I am using Visual Foxpro as backed an Vb.Net as the front end... I am using the oleddb connection..... the following is the parameter.... "Provider=vfpoledb.1;Data Source= \\Data; Collating Sequence=general" I have a Visual Foxpro open table dabase which contains nearly a million record.... When I give select * from transcation where id='001' and cust='03' the time taken to purge this record is very high (nearly 5 min).... I have indexed the table on the basis of the above too (id, cust) feild. The purging of record is done thru front end vb.Net OleDB adapter Can any one tell me how to use the indexes which is creted in foxpro to return th ...Show All

• jsmartfoster Font Size Randomly Changing

  Has anyone experienced a problem in a FoxPro 9 application, where the font size of some controls on a form change It could happen going from form1 to form2, or form3 to form2.  The size changes from 9 to 8, 12, or 18. There doesn't seem to be a pattern, and it could happen today day and not happen for several days later. gdiplus is an option we have not explored. Is there a specific version of the gdiplus.dll that FoxPro 9 applications should be using This application has been upgraded from previous version but the gdiplus.dll that goes out with the application may not have been. I've thought that it might be that, but with the number of users experienceing the problem I don't believe that would be the probl ...Show All

• Hans_Schmucker Foxpro Power!

  Hai Everybody, I jus wanted to have some sort of opinion poll from u people. IS FOXPRO ONE OF THE POWERFUL TOOL AVAILABLE NOW In my opinion its really powerful and very much useful even now i am very much found of it.... Hey do not feel sorry about .Net developers, using .Net you might start to feel sorry for VFP programmers:) .Net has undeniable features and power. Both are (and also those many other languages/tools) powerfull. Hmm to say "no", first one should know it thoroughly. If someone knows it thoroughly then likely she/he is already thinking "yes" and using it:) The bottomline is each and every language/tool might be powerfull depending on how much you know of it a ...Show All

• TwilightBrigade Access Database

  hello, i'm a new user of visual foxpro, how am i going to open a ms access database can anybody help me thank you jason http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=565932&SiteID=1 ...Show All

• Jim Altrichter MSCHART AND VISUAL FOXPRO 9

  I am trying to use MSCHART with VFP9 and have some success until I want to set or change Legions, Titles, Colors etc. or to enter data into the second Y axis. Using any of the property / constant names only produces the message "Name Unknown". Any suggestions. No I didn't and that is why I said "try". I don't have VFP (nor any other thing including .Net framework) to test something (on this box). If you want to see working code, visit universalthread.com and search for codes that I sent multiple times. Making = arrData style is not important though. You can simpy use row,col in a loop (check the sample on UT for many different types of settings). I don't understand "of course" part. ...Show All

• VivekGupta2812 Imagelist control

  I want to add the imagelist control to the treeview control(ocx) but I keep getting a message that I have to initialize the imagelist control first. How is this done The treeview works fine. Both ocx controls are dropped on the form but I have been consistently getting the error. Appreciate the help. David, Thanks for your reply. What is the web site. John   alwayslearning wrote: Thank you very much for your answer. I placed this code into the init and I now receive: ole idispatch exception code 0 from treectrl: invalid object The bad part about this is that I have a functioning example of this tree control/ imagelist relationship in Fox ...Show All

• Bill YU appending to a grid

  ok - this is kind of a weird question - is there a way to append to a grid in the background What I would like to do (if it's possible) is to still have functionality to my form while the program is taking the time to append. Does that make sense If so is that possible You do not append to a grid, but to the table bound to the grid. Why are you looking for this Is the dataset too big; takes too long to load Maybe that could be optimized. You gave no details so it's impossible to know. If it is a query (cursor, or view, whatever) from VFP data, when properly Rushmoe-optimized it should be fast in most instances. If the data comes accross the wire from a remote SQL Server DB, for example, you could fetch asynchronously and disp ...Show All

• Jeepster42 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. Of course not. I wanted to change the default font for VFP on the machine. But the modi wind font would work too. thx. TOO ...Show All

• Staun Can Foxpro list "Directory Names" or "Folder Names" to a table?

  I am trying to produce a list of the sub directories contained within a folder in Windows. Can I Is there a foxpro command that allows this functionality to a table or array or something I am using Visual FoxPro 7.0 Thanks in advance. Richard Peterson Thank You. I can take what you have built and use it, thanks very much. here is my coding to list all folders... SET DEFAULT TO &PcHistpath LnCnt = Adir(Gcdir,"*.*","D",1) FOR lnCnt = 1 TO LnCnt IF "D" $ Gcdir[LnCnt,5] mHist = gcDir[LnCnt,1] next Hope can help .... There is: ADIR() Filer.dll that comes with VFP Scripting.FileSystemObject ( ...Show All

• HARSH_JOSHI Proper Practice: Running a report without disturbing data

  I have created a class which contains a textbox to display an order#. I usually drop this class in a grid. The double click of the textbox does something like this: select tmpCpo go top set relation to cpono into cpo select cpo set relation to acct into Customer select tmpCpo report form cpo01 preview How should I prevent disturbance to the current data 'status' when the user dblclicks on the instantiated object Basically I would like to restore my environment to what is was before the user initiated the report. In the old 2.6 world this would be a hassle so I was wondering if new tools like the session class should be used in VFP9 in order to achieve this... Thanks you all. ...Show All

• Naveeeen Returning control from a modelless form.

  Hi; I have a form which displays a text file in an editbox. I call this form from a PRG which has a window defined. If the form's WindowType property is set to modal, the form works fine. If I change it to modeless, the form returns control to the calling prg but the active window stays the form itself. How would I keep a form modeless but return the active window to the window that called the form I hope I make sense... Thank you all. do form otherform thisform.Show() A variety of Modeless forms (browsers, lists, etc.) have various solutions you can work with in crude fashion (which your user won't care) I've (personally) ...Show All

• Andy Ho Grid Reusable Form or Active-X question. Any Help?

  Hi, A problem I am always facing when I am creating a new software is the following: I usually need in every software a grid to display my records in some sort of way from a table of cursor. Ok the grid will change a bit from form to form and from software to software (different row colors, sometimes I ll need to sort by columns somentimes not, different fonts, buttons in grid or not or others things etc etc). Is there anywhere around the Internet such a ready made form-grid or Active X control that will do my job instead of each time spend a day of recreating it from almost scratch If it is also free (or cheap!) it would be really really very very nice :) Any help Thanks, Athan PS. Also any other forms - or links that ...Show All

• nate-d-o-double-g impersonateloggedonuser and Getfil()

  Iam running VFP 9 with SP1 under windows 2k. In order to protect my database/table files on a network I have created a single user who has access to the folder where the files are contained. This is the only user with access to the folder. When an individual on the network runs the application the application logs on as that user and has access to the database files...the code goes like this.... #define LOGON32_PROVIDER_DEFAULT 0 #define LOGON32_PROVIDER_WINNT50 3 #define LOGON32_PROVIDER_WINNT40 2 #define LOGON32_PROVIDER_WINNT35 1 #define LOGON32_LOGON_INTERACTIVE 2 #define LOGON32_LOGON_NETWORK 3 #define LOGON32_LOGON_BATCH 4 #define LOGON32_LOGON_SERVICE 5 #define LOGON32_LOGON_UNLOCK 7 DECLARE ...Show All

• hdp203 How to implement Mouse leave for a form.

  I have a very small form that opens up to display some info. I'd like the form to close when the mouse leaves the form. I noticed there is no mouseleave or mouseenter for forms. Any other method to do this Thx In vfp 7 you have: MouseLeave Event - mouse moves out of an object. You may drop a rectangular shape at margin of the form. When mouse leaves the object (aprox.same area with the form) form will close. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=905860&SiteID=1&mode=1 Perhaps note my own elementary use of "define window ... name" (command) here (today). ... with addobject() of an image object to the resultant form-container. ... as a workaroun ...Show All