Answer Questions

• RajKat How to Read from 2 USB modems?

  Hi! I have 2 USB modems connected to my computer. What I want to do is to catch the caller ID numbers of incoming calls even if the 2 modems ring at the same time. Is this possible Also my even bigger problem is that is I do not not how can I actually access the modem through VFP 8 ! Any help on it (libraries, activex etc As free as possible PLEASE!!! ) Thanks Athan You may be able to find some he ...Show All

• Domingo Fugaban Jr MSChart

  I have to make line chart to print it in a report form. I'm using MsChart.Graph in VFP6, can someone tell me where can I find information on MsGraph as this is a special report I'll do I'd rather not having to buy a book. Thanks for your help in advance can someone tell me where can I find information on MsGraph You can go to my web site and download the session I gave on "Creating Graphs In VFP" The white paper and code samples i ...Show All

• gauer pack table in a grid

  <--- VFP 9 newbie We have a grid on the form that views a table opened exclusively on form init.  The table is called from the grid builder and we want to manipulate it.  Below the grid is a button that is 'suppose' to clear off all items in the table.  On button _click event we select the table, delete all, then pack.  Now the grid is void of the table and grid line.  Futhur reference to that table is now invalid. Ho ...Show All

• James Minns Date problem in VFP 6.0

  Hello! Huh, I currently have field named 'fine' in my DB. It's used to store fines. There two other fields, 'rent-date' and 'no_of_days'. The first one stores the date on which the rent of a book starts and the second one stores the number of days the book is going to stay with the borrower. Well, I would like to know how can I calculate the fine. To calculate it, I must find by how many days the due date has been "excessed" and ...Show All

• Sridhar VFP free tables in compressed folders

  Will Visual FoxPro free tables work fine on compressed drives or in compressed folders I am talking about the NTFS compression found under advanced attributes. I have several folders with hundreds of .dbf files used in out VFP app. I would like to compress these folders to save disk space. AndyKr wrote: : Will Visual FoxPro free tables work fine on compressed drives or in compressed folders I am talking a ...Show All

• SuebsakulP use the reccount

  hello all  I use "set filter to" and want to know how much record is match the filter condition. I use the "reccount()"  but it return the result is not I want. it is all the record count Hi, i think you will need to use COUNT command instead. RECCOUNT() is not affected by SET FILTER. Interesting! Additional questions: You mean we should use SELECT ALL .. FROM.. WHE ...Show All

• ServerGirl TXT Files

  Hi there!!! Does anyboady knows how can i print a TXT file in foxpro I don't know what can i do, I've never used VFP before and I need to do this Thanx a lot!!! There are several ways. The simplest one is probably the old TYPE Command: TYPE FileName1 [AUTO] [WRAP] [TO PRINTER [PROMPT] | TO FILE FileName2 ] [NUMBER] http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/7e83da43-86c1-4b0d-a00d-ea41238 ...Show All

• Richard Pavlicek table manipulation

  Two tables exist, call them tableA and tableB. They share some data. which was easy to get select a.work_id, a.sp_id, b.work_id, b.sp_id; from tableA a inner join table b on (a.work_id = b.work_id); order by work_id; into cursor hold1 there is still a matter of getting all the data from tableA and tableB that they don't share. i tried doing a left outer join, but i still get duplicates. Any ideas MP After further look at my data, i seem ...Show All

• Jyh-Cheng Chen RSA Public/Private Key Encryption in VFP 9.0

  Hi, I need to be able to decrypt data pulled from a MySQL table encrypted with RSA public/private key encryption within a FoxPro application.  I am currently using the FoxPro Foundation Class known as _cryptapi as a wrapper to the CryptoAPI interface.  The problem I'm having is that I can't seem to figure out how to decrypt a RSA encrypted string of data.  I know that the _cryptapi class provided by Microsoft uses the Microsoft B ...Show All

• Julie Clark older scatter gather, and VFP.

  Hi; I have a form which the user fills. The info the user enters need to be added as a record in a table. In the Foxpro2.6 world I used to do this by letting the user edit empty memory vars, and then append blank / gather from memvar. I am wondering if there is a better way to do this in VFP9 I know I can use buffering then tableupdate(), but that requires that I would append blank FIRST before I let the user edit the fields. ...Show All

• Jelle van der Beek show certain record in gridbox

  dear all, i dont want my form show ZZZZ product code that i make hardcode to my table. sele b SET ORDER TO 2 GO TOP thisform.grdSales.RecordSource = "b" thisform.grdSales.RecordSourceType = 1 thisform.grdSales.column1.Bound = .F. thisform.grdSales.column2.Bound = .F. thisform.grdSales.column3.Bound = .F. Thisform.grdSales.column1.text1.ControlSource = "P_name" Thisform.grdSales.column2.text1.controlsource ="P_c ...Show All

• Kutta Srinivasan Return values from SQL Serv

  Please let me know: 1. Can I receive a return value from SQL Server (Ex: when I update some data to SQL Server by using a SQL's stored procedure, the return of the stored procedure is whether the primary key exits or not) 2. How can I do that Thanks a lots. Chinh Nguyen Hi Dave M. I've followed the instruction what you've given me, but it still not working. This is my code 1. The stored p ...Show All

• Michael Nebel Total amount column of my grid

  I would like to interactively show the user that while the AMOUNT column is entered with data I would like to show it to the top the total amount when edited it will also change the total amount. Yes, that solves the prob. Thanks again Public oForm oForm = Createobject("myForm") oForm.Show Define Class myForm As Form   DataSession = 2   Top = 0   Left = 0   Height = 398   Width = 426   DoCreate = .T. &n ...Show All

• JJ Brychell string func failures? bugs?

  I found that when applied to THISFORM.Edit1.Text, VFP native EDIT control, the following functions always return 0: AT( ), ATC ( ), ATLINE( ), OCCURS ( ) They cannot be used for any purpose. The following functions work: LEN ( ), $, SUBSTR ( ) I did not bother checking RATLINE( ) , RAT( ) and RATC( ). I presume, they would fail also. Is it a bug Also I found oddly enough that command COPY FILE fileName1 to fileName2 fails i ...Show All

• limonada Using DirectX to resize raster images

  Hi. My employer told me that in order to preserve to quality of a raster image (Jpeg) I have to use DirectX. How do I use it in FoxPro (up to version 8 (i.e.6,7,8)) Thanks I don't work with images and I don't have experience or knowledge on DirectX, but you can easily manipulate images in VFP9 with GDI+ (also in VFP8 but with not as powerful a GDI+ implementation). HTH ...Show All