Answer Questions

• Narek 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

• Bill Howell How to change Default FONTS in Forms, Menus, status bar, title bar and so on...??

  Hi, Could somebody tell me, how to change default fonts of Menus, Status bar, titke bar and so on... Right now I can see everything in Arial but I need to use different font. Thanks If changing the Windows settings isn't an option, you have to spend a lot of time on replacing these parts. There basically two paths that I can see. 1) On the API route you can either create Windows yourself, or use BINDEVENTS() to hook into an existing VFP ...Show All

• krhyzsy optimize sql

  hi i am trying to optimize my aplication and for what i have seen in the net the SYS(3054) tells me if an sql statment is optimized or not. but when i do the foloing: SELECT acodigo, edescri, afamn1, afamn2, afamn3, &campo ; , agrupo1, agrupo2, agrupo3, agrupo4, agrupo5, agrupo6, ASTOCK AS stkt ; FROM thisform.ficheiros(1,1), thisform.ficheiros(2,1), ('tabart' + ano_chr2) ; WHERE acodigo = ecodart AND tacodart = ac ...Show All

• Yifan Lu Using SQL Pass Through to Access my Remote Data Source

  Here's the source code which I copy from QUE Book('The One Source for Comprehensive Solutions' by Menachem Bazian) //*using SQL PASS THROUGH TO ACCESS DATA SOURCE *// LOCAL lnHandle lnHandle = SQLConnect("My Remote text") IF lnHandle > -1    SQLExec(lnHandle, "SELECT customers.* FROM customers","Results")    SELECT Results    BROWS    SQLDisconnect(lnHandle) ENDIF I try that sample, and a ...Show All

• iamGary Very nice!

  Hello anyone, it's very nice to see Microsoft enhancing their community activities. Go for it! Providing a forum platform is one of the best aspects a company might offer. Thanks. I hope that this one doesn't compete the ones at Compuserve or UniversalThread. Sincerely, JoKi We still promote many of the great third-party sites dedicated to Visual FoxPro development such as the ones listed at  http://msdn.microsoft.com/vfoxpro/c ...Show All

• Thomas Cheah EOF() for a low level file function

  Hi there, I just ran into a problem with this code. What I want to do is to open a TEXT or binary data file and read it as a *binary* file byte by byte. What I found to my surprise was that the VFP EOF() function presumes that the file that's been opened is a TABLE! How do you go about reading bytes from a data file I am getting an error message that the alias is not found.. filename1 = "C:\Program Files\tcp_ip.txt" filehandle1 = FOPEN ( ...Show All

• slapztik coming back to foxpro

  used foxpro 2.5 and now have visual fp.  am having trouble lwith iff and if then syntax.  i want to have user enter a zip code and then the city and state are filled in.  thanks for any help   thanks for the reply.  my request is rather simple since I simply forgot some basic syntax but it will all com back.  i want to do something like when entering the zipcode field,  iff ...Show All

• Atul Nisar API call caused an exception

  The following is a program to convert HTML entities back into their original characters. Can anyone see why it would work on Windows 2000 and XP but not on ME & 98 I have gone through depends.exe to try and determine any dependencies that I have missed but everything seems ok. If the process is made to exit before the loop it doesn't crash VFP. I am running VFP6 SP5   #include <fstream.h> #include "PRO_EXT.H" #include <ctyp ...Show All

• nath Visual Foxpro Book Recommendations?

  All, Can anyone recommend a good book for learning VFP 6.0 from scratch   I've looked at SPECIAL ADDITION USING VISUAL FOXPRO 6 but it's not really helping me so far.  All I am trying to do is create a simple .exe that will read amd update some records from a .dbf and insert those records into a MS SQL table.  All the books on Amazon have gotten terrible reviews and MSDN has little to no info on doing thi ...Show All

• Ronald Ricardo Ramirez Moran Virtual vield code (lookup)

  I have two tables Dossier and Rolhand I'am trying to get the newest date from table rolhand into dossier. <-- Text in Red I'am using virutal field, but i can't get it to work. Table: Dossier * DOS_ID     Rol_id           Rol_date ------ -+--------------+------------ 1            05dak-91    &n ...Show All

• Riya Freezing issues

  We are currently in the process of switching to VFP 9 at work but we are having an issue that seems to be related to VFP and shelling out to DOS.  Occasionally when using command line PGP or using the "run" command to access Novel's nprint command we find that our system locks up and freezes (we are in a Winow 2000 environment.) We needed to place network paths in an ini file for retrievel instead of shelling out to use Novel's "Map" comman ...Show All

• c0d3-m0nk3y library location

  SET LIBRARY TO FFLUSH  DIR temp.txt  && size on disk is still 0 WAIT WINDOW "File Size = 0" = XFFLUSH() DIR temp.txt  && size on disk is 8196 WAIT WINDOW "File Size Does Not Equal 0" CLOSE ALL I'm trying to run this example code (fox9)- not finding this library - searched for fll's,dll's,vcx's - I look in  C:\PROGRAM FILES\MICROSOFT VISUAL FOXPRO 9\SAMPLES\API\  and find a table named examples - whi ...Show All

• shani241982 Input mask for a spinner

  I've defined an input mask for a spinner as $$99999.99 It displays the value $ 855.09 as $ 955.9 What am I doing wrong Thanks. I am sorry, there is no question. I just wanted to let you know that I PERHAPS < > discovered another usage for custom classes you haven't mentioned. It seems you did not mention this aspect so I wanted to let you know that they can be used this way. Of course, I could define all static ...Show All

• cmcauliffe Adding to a report.

  Ok, i have a report that is in foxpro that came with a software called DataTrac. I can open the report and using a table list add fields to the report. The fields are labeled like following. Existing Report Field names: loan_amt borr_phone New Report fields names: gen.loan_amt gen.borr.phone So when the gen.loan_amt fields are added to the reports that for some reason dont need the xxx. part they show the same figure of every reco ...Show All

• MarceloTallis editbox programmatic change

  I am looking for an easy way to determine if I've made interactive change in an editor box. The issue is that there are about 16 controls on a container, they are initialized from a table record thus their values at activate time generally are not trivial default. I have to save the changes with a SAVE button if I made any but I want this button's click method to quickly determine which control values have been changed. I do not want to do REPLA ...Show All