Answer Questions

• Han Qiao Clip art suitable for VFP 9

  Hello -- I am just starting out with 9 (have done just a little in 7 before). I am going systematically, creating classes now. The first problem I came across was where to get (free, preferably) graphics files (.bmp mainly) that would be fit for menu buttons and the like (e.g. the exit symbol, a man running towards/though a door). I do not think the .bmp files in VFP9 are enough. I know, this is a simplistic question, but it is important to me. Thanks in advance for your help. Hans L Sorry that my reply post did not come last. Every forum is different :-( Hans L Perhaps google :"@icon sushi" for that precious freeware. I've only had it 4-5 weeks. Just cu ...Show All

• Jim Holloway Not a table message...

  Hi All, I have a Visual FoxPro table which I use as a backup table. I have a lot of records in it at the moment. When I was trying to open it yesterday I got the following error: Not a table. I can't seem to open the table at all. The table must have got corrupted etc. Is there any way I can retrieve the contents of this table without having to do a restore from a previous backup. Pablo. I know what my problem is now, the table which is corrupted is over 2GB in size. This is a limit which should not be exceeded in Visual FoxPro. I have purchasd a product called FoxFix which I am using to repair the corrupted table. Their is an option called FastSplit which is one of the tools available. I want ...Show All

• KSmitty CursorAdapters and UDF in FoxPro 9

  Hi, I like to know if is possible to create a Cursoradapter (ADO) with a select CMD using a function. For example if I have a function concat(par1,par2) that returns par1+par2. I like to use as select command something like select concat(lastname,firstname) as name from personal Thanks Ivan Taking this concat function just as an example. I dont have problems with ADO Cursor adapters with Oracle because this is a native function; for SQL Server I created this function and I use as dbo.concat and works fine, but with FOXPRO it does not work, even if I have this function in a program and defined with SET PROCEDURE TO MY_RUTINE. Again using native cursoradapters FOXPRO can detect this function but with ADO Foxpro ...Show All

• Keith Newton convert text files to certain format

  Hi there, I would like to convert the text file to a text file but with "" and ; to separate the data. How could I do that Pls advice whether foxpro itself can do that or need to convert it to dbf in order to get the format. Need urgent help. Thanks. Hi there, I have a file as below format. EQ0003929307:18:22M01208162520NLR105.5 904 NL0004 000000.0010/07/06 I would like to change it to e.g.: "1234","abc","xyz" format. How could I do that Pls advice. Thanks. Create a cursor file and append the orignal text and copy with delimited CREATE CURSOR cursorFileName ( Fld1 C(10), Fld2 c(8), Fld3 c(3) ..... ...Show All

• Konstantinos Polychronis Foxpro7 crashing with "fatal error exception code=c0000005 ..."

  Hi I have a tricky issue in my VFP7 application. At least tricky for me.  The application is crashing with fatal error C0000005. Sometimes I see a message like this one in the eventlog: "Faulting application <appname>.exe, version 1.4.82.0, faulting module ntdll.dll, version 5.1.2600.2180, fault address 0x00010f29.". Sometimes the application just hangs. I also see the Windows error "The instruction at "0x...." referenced memory at "0x.....". The memory could not be "read"", and then the application is closed, of cource. The error does only appear in situations where I print, but it does not occur in an exact pattern, or when I pass a particular code line. I use a third party dll called foxpp.dll ( ...Show All

• Pete_M foxpro for windows

  Hai, I hope i am not troubling you all. i have installed foxpro for windows 2.6a on win 2000 server. but when i am trying to run that i get a error divide by zero or over flow error. how can i run foxpro for windows. please help me. I am very greatful to you. now i can run foxpro for windows in win 2000. There's a patch for this at http://support.microsoft.com/kb/240982 ...Show All

• rkwarning calling someone

  hi i want to be able to tell the modem to dial and certain number. my overall goal is to be able to have a call button in my client form. I'm glad I don't have to concern myself over dialup any longer. You may get some mileage out of how to use the MSCOMM32.ocx within VFP if you want to go that direction. How to send to the serial port by using Mscomm32.ocx http://support.microsoft.com/kb/139526 How to transmit and receive binary data by using the VFP MSComm32 control http://support.microsoft.com/kb/154741 MarshallSoft DUN Dialer for Visual FoxPro http://www.marshallsoft.com/mdd4fp.htm You can use the Windows TAPI functions (Telephone API) to do this but i ...Show All

• vijayshankark Seperators in toolbars.

  Hi; I have put a few cmdButtons in a toolbar. I am trying to space them but when I put a spacer they alwars go to the beginig of the toolbar. I can't seem to find a way to space the command buttons. Thanks for your help. Getting separators where you want them is tricky. I've found that I just have keep trying until I get what I want. Sometimes, once I add a separator, I'm able to move it to where I want it. (You can select it by choosing it in the property sheet.) Sometimes, I just end up deleting and trying again. Tamar ...Show All

• Matthew Wright Words Spell Checker not working

  I have a spell checker button in a form that uses microsoft word, here's my code: oWord=CREATEOBJECT("Word.Application") oWord.WindowState=2 _CLIPTEXT= bookstore.frmdesc oWord.Documents.Add.Content.Paste oWord.ActiveDocument.CheckSpelling() oWord.Visible=.F. =oWord.ActiveDocument.Select cText=oWord.Selection.Text cText=LEFT(cText,LEN(cText)-1) REPLACE bookstore.frmdesc WITH cText _CLIPTEXT="" oWord.Documents.Close(0) oWord.Quit(0) thisform.Refresh bookstore.frmdesc is a character field in a table, it's the text field in the form thats being spellchecked. my problem is that when the spell checker window pops up, it will highlight mispelt words but it won't show any of the suggestions. I've had other problems but they p ...Show All

• Douwe visual foxpro query

  Hai, i have a table with the following records. month,dealercode,branch,netqty can anybody kindly give me SQL Command which will sum netqty group by dlrcod and month but for each dealer monthqty should appear vertically. select dlrcod,branch,sum(netqty) from <table name> group by dlrcod,month with this query i get month totals horizontally but i want months to appear vertically. if any body can kindly give me a query, i would be greatful eg. mnth delaer code branch netqty january a0001 blr 1000 april a0001 blr 500 feb a0001 blr 300 may b0001 blr 400 june b0001 blr 300 january a0001 b ...Show All

• Vinodonly Source from internet

  Where can I find a source on the internet where will be wethear forcast for Slovakia and the other world... I want to include it in my program, to show the weather forcast, just temperature, humidity, air pressure, wheter it will rain, or snow, etc. Don't know wheather this kind of source exists... Thank for your advice This wasn't helpful... I am looking for I don't know maybe for a database or something from where I can extract infos(temp, pressure, etc.) for Slovakia and other world... But mainly for Slovakia and then the rest... There must be some kind of way. Please help me O.K. forget about what I wrote before... I will make it other way... I want to export ...Show All

• SaimaSalim VFP6 : How to display on more than 2 different character-string on textbox?

  Hi              .xdf_jn.value and .xdf_bl.value are controls in the form properties. There is a table (.dbf) to retrieve the datas.     local hblno            local array aJob[1]             select distinct jt_hblno, val(substr(jt_hblno,at(' ',jt_hblno))) ;               from tnfjob ;                           WHERE jt_jobno == ...Show All

• TheQuietShadow switching pages in pageframe

  I want to be able to detect when I am clicking on a page tab to switch pages, so I can control which portions of a lostfocus event on an object in the current active page will execute. I appears that I can't use mouseenter on the target page, like I do on command objects. Won't work, since the uienable fires when the page is deactivated, which is after the object.lostfocus is fired. I need to be able to find out before or while in the lostfocus, since that is where I put my validation code for the object. The perfect solution would be that mouseenter and mouseleave would work on the tab portion of a page, but that doesn't seem to be the case. Then I could tell if the object is losing focus because ...Show All

• zeljko62 Report: Counting / totaling groups.

  Is there any new fetures in VFP report designer which will allow me to easily count the group bands I have some reports which I need to show the number of items in one of the group bands (In other words the number of times a group band is printed). Thx. initialize a counter and incriment its value when ever a line has been printed and display the counter. Thanks Tamar; I thought maybe things are different in 9.0 Aleniko There's nothing new for this. You can do it the same old way, with a pair of report variables. One keeps count and the other tracks the current value of the grouping variable. Set it up like this: Name: nGroupCount Initial Val ...Show All

• GraemeP table question

  Hi, I don't know how to check if a fox table has a list of atributes or fields in a specfied order. For example, I have a table employee and I want to know if it has the fields id_employee, employee_name and employee_hiredate in this order. This verification will be included in a fox program. Does someone know how to solve this Thanks, DECLARE aFieldName[3] aFieldName[1] = " id_employee" aFieldName[2] = " employee_name" aFieldName[3] = " employee_hiredate" FOR i = 1 TO FCOUNT() IF UPPER( aFieldName[m.i]) # Field(m.i) =MESSAGEBOX(" Mismatch "+ aFieldName[m.i] + ","+Field(m.i) ) DO Error Handling ENDIF NEXT ...Show All