Answer Questions

• carso MSComctlLib.TreeCtrl.2 Problem

  Working with the treeView Control I ran into an unexpected problem. It appears to be impossible to collapse a node branch programmatically. Collapse is an event, not a method and when I tried to use it as a method I could not get anywhere. I also tried to employ DblClick with the same negative result--the tree does not budge. Aside from Collapse I will need Expand as a method not event, although I am using it as even already. The expansion ...Show All

• Michelle Alexander - MS Set talk, set deleted in forms

  Hi; I am issuing SET TALK OFF and SET DELE ON in my application. Later on, when the user opens up a form, set TALK goes ON and in some cases SET DELE goes OFF. I have used the debugger, and I can't seem to find where exactly this happens, although its at the load event. There is nothing there to turn it on. So - what am I missing Aleniko Dave, Andy... One more obstacle cleared... T ...Show All

• Nofi Cursor help

  Hi    I am new to foxpro and have a question reguarding cursors. I am using VFP 9.0. I am working with a local VFP data base. As I understand it a cursor is a recordset created by a SQL statement that is stored in memory (or also on the hard drive if it is to big to fit into memory) on the client computer that the application is running on. I also understand if it uses the hard drive for temporary files that they will be deleted when t ...Show All

• nickicha Page count for report group

  Hi, I am in need of counting pages for groups in my report. When I try to count this in OnEntry / OnExit events, it does not work for me... Can you please suggest me a way to do this Thanks for any help... Solved with custom reportlistener class and its AfterBand() and Render() methods... ...Show All

• Vishal Chopra Export data to text- How I can bypass the default text delimitter?

  Dear all, I am exporting data from Visual FoxPro 6.0 to text file, so I use "Export..." in the menu, then choose file type "delimited text". I want the data export to text with field seperator is a bar character ( | ) and no text field delimiter. But FoxPro puts the double quote character ( " ) as default text field delimiter. How can I bypass this double quote character For example: Currently FoxPro exports ...Show All

• pehaada Coming from Excel to VFP9 and need help understanding math functions on cells

  I have set up a simple data tracking form that breaks out the associated costs of a vehicle going to Auction ( dealer costs, transportation fees and so on) for my employer. It works great, and I can enter data into the database successfully, and my Report will print it out nicely sorted by Store. I would now like to create cells on my data entry form that calculate and display various math procedures on the data being entered. For instance, ...Show All

• Chandrashekhar K i use ado access MS Access mdb,i need some help

  hello all I use mdb as my app's DB file, when my app(exe) run, a ".ldb" file the name as same as my DB file appears in my app current folder,when i exit the app the ldb file still stay there ,so I wrote the code  to del the .ldb file when my app exit. but i open the app(exe)  it appears again . below is what i want : Now i just want this ".ldb" stay in windows temp folder not in my app(exe) current folder. Is there any wa ...Show All

• DkRDbA MSGraph.Chart.8 control

  I need to make charts. I started with MSChart Control and so far I've accomplished almost all I wanted except for one thing which totally eludes me. I need a simple line chart, not columns or a pie. I need to display a row of data like DJIA or similar indices with no additional vertical bars or other embelishments. The curve comes out nice but a lot of space on the chart is wasted because the curve is being plotted too high on the chart in ve ...Show All

• SeanDL MySQL and VFP9.0

  Hi. I don't know how to make a connection to MySQL. I used Connector/ODBC 3.51.12 to connect to MySql with no responce. When I clicked on OK after I set up parameters a massage was displayed like User Cancled. Don't know what to do... Can anybody help me Has anybody experience with connectivity with MySQL I have an idea. Can you make a sample project with a database connected to a MySql database. I was told via Connector/ODBC 3.51.12 it'll ...Show All

• Rupesh Rao MSFT seek char+date

  dear all, i seek stockist code+invoice date but failed to seek. why what i had done... use invoice shared index on code+dtoc(inv_date) to invoice.idx set index to invoice.idx seek code+dtoc(thisform.txtInvdate.value) but failed to seek. thanks. What do you mean by "failed to seek" Did it error or simply couldn't find a match If you mean no match then probably you're switching "set date" ...Show All

• bobespn VFP8 on Win98

  Dear Experts It is possible to run VFP8 on Win98. If yes then How to install How to create EXE files How to distribute Exe files Please Help VFP8 runtimes will run on Windows 98. It is not recommended for the IDE for developing though. See: http://fox.wikis.com/wc.dll Wiki~VFP8Released >How to create EXE files Create a project. Add your main prg or form and build an APP to test first. When you build the project or an APp it shoul ...Show All

• Jeroen Landheer Index does not match the table. Delete the index file and re-create the index (Error 114)

  How do I recreate an index file for a table after the table has been recovered   Thanks! Thanks Craig!  I was able to do your second suggestion with success.  There are a couple of options.. REINDEX is the easiest, but if the key information stored in the CDX is corrupt, it will create corrupt indeces. The best way is to DELETE TAG <tag>, th ...Show All

• thelmapc empty field

  is there a better way of checking for empty fields than select *; from myTable; where field1 = " "; into cursor data1 i need to run a complete check on the database for empty records in every field. How would i check for a 'date' data field Mike It is a good point. How useful it for many eyes to view the same problem! I got used to using an intermediate memory variable but your idea is better. Thanks. thanks for the empty func ...Show All

• Mike Martin24365 Time format saved a character field

  Hi, Can somebody pls help me figure out how am i going to compute the time format such as this one "05:32:44" saved in a character field. The output should also be a time format not like this one when i'm summing up all the records "190:119:255". The time is in this format Hour:Minute:Second. I will appreciate very much if somebody can help me on this. Thank you in advance Hi, I'm sorry if ...Show All

• Marie 5 Can i do any control when i click the close button in the control bar of the form ?

  thank every one i got it,thank you very much Hi there. Clicking the close button triggers an event calling the QueryUnload method. Any code there will run when you click on the close button. Hope this helps! yag Group Manager VS Data Hi Jet Su, I'm not entirely sure what you mean - you can call other control's methods with code like *--Code in Close button ThisForm.cmdMyButton.Click()     jet su wrote: ...Show All