Answer Questions

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

• Atroa OWC11.PivotTable

  I've tried to play with MSGraph for some time and after not getting very far yet (although I got some graphs) I downloaded MS Office Pro 2003 enterprise Edition and found out that there seem to be richer controls out there. In particular I am trying to work with OWC11.ChartSpace , OWC11.PivotTable and OWC11.SprreadSheet . I have resigned to the fact that I would have to use MS Excel Spreadsheet as an interim container between my tables and the g ...Show All

• Brent Rockwood 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

• Rahul.Net what is the maximum field VFP9 can handle

  Good day to everybody... just a little problem with my update at VFP interface with my back-end database I dont have this problem updating my employees table in SQL2000 with 35 columns at my VFP interface, but recently I add another 3 columns at my table, that's where I encounter this problem. Inserting a new record or deleting there's no problem, but when i edit a particular record then saved the changes,the update is OK.. but after I clo ...Show All

• spyders how to send control codes via "???" to receipt printer

  Hi All, I am writing a POS system and using a receipt printer (Epson TM-U220D). Unfortunately the printer drivers from Epson didn't work & hence I resorted to using the Windows Generic/Text printer. I am using a series of to output to the printer, which works fine. My problem is that I need to do some form of simple formatting on the receipt, e.g. make company name bold, etc. My question is, how do I send the control codes to achieve t ...Show All

• Code_Explorer Inserting and Updating images file from VFP9 to SQL Server 2005

  i am developing a form where i am collecting personal information such as name, address and signature of the person as a bmp file........ i am saving the data in the SQL Server 2005 . My front end is VFP 9 forms. i am building a SQL query to insert the record....... the prob that i m facing is that  i cannot concatenate the image type with the SQL string that i m building the insert works fine if i dont try to insert the image the imag ...Show All

• BobExpress cannot generate an exec file

  I just finished a large project and tried to generate an .exe file from it. I encountered the following problems. BUILD EXE FROM ..... issued from the Command Window gives me a series of errors. The first one is entirely unexpected. It claims that a file "inpARR" could not be found. When I click on "locate' it offers me a file dialog box to find it. I definitely do not have any reference to a file by this name anywhere in my pr ...Show All

• O.Tacke Accessing VFP9.0 Stored procedures with .NET

  I've been fighting an almost epic battle these last few days with Foxpro, to try to access its Stored Procedures with ADO.NET. Here is my code: Dim conn As String = "Data Source=Q:\network\Gestion\stage.dbc;Provider='VFPOLEDB.1';password='';user id=''" Dim OleDbConnection2 As OleDbConnection = New OleDbConnection(conn) Dim cmmSelect As OleDbCommand = New OleDbCommand("ProcGrillePosteA", OleDbConnection2) cmmSelect. ...Show All

• Gad Rosenthal I have a corrupted table. Is there a simple, FREE way of repairing or recovering the data?

  I have a corrupted table. Is there a simple, FREE way of repairing or recovering the data Thanks, Jim Is this apply to VFP 7.0 too Thanks in advance. HEY, that worked great. Thanks Jim, (Make sure you have adequate backups before you proceed!) What version of VFP If you know what you are doing and it's just a mismatch between the number of records in t ...Show All

• Rolan Select Statement

  Basically i want to create a view that calculate the stock end balance using moving average. On entry invoice the prg would create txn on a table item_txns that store all txns that affects the balance. The problem is the sale txns only store the qty but does not store the cost of good sold. This would be calculated on the fly when users query and want to see the cost of good sold . I want to do this using SELECT statement, The fields ar ...Show All

• Ahmed Fawzy Abd Eldayem Copying a file to EXCEL from FoxPro.

  PLEASE HELP! I'm using Visual FoxPro 6.0 and EXCEL 2003.  I created a query with FoxPro 6.0 and copied the data to EXCEL 2003.  The Table size is 33827 records and it only copied 16384 records.  It only copied half the code.  Why is this Here is the code. close data all set talk on set dele on SELECT 0 USE "c:\documents and settings\bartech\my documents\fmpdata\software code\fmp reports\fmptables\line02.dbf" shared se ...Show All

• whatwhatkit FoxPro v9 vs Visual dBASE Plus 2.01 BDE 5.2.02

  Hi there. I just installed a Visual FoxPro 9.0 and started "playing" with it. Tried to create a table - it is straightforward and then a form. It seems to be a rich platform. Something puzzles me though. I do have extensive experience with Visual dBASE PLUS and previous versions in terms of OO language and form/table designer. Thus I am trying to compare. I am attempting to migrate to MS software/platforms wholesale since the dBASE is offering l ...Show All

• Jack Vaughan deployment, building exe problem

  OK, this is the third round. I still cannot run an exec file. I cannot build it properly. When I issue (in the Command Window) BUILD EXE the intellisense prompt appears with my app name. So, I accept the rest of the clause as default. Until today I could generate .exe with no problem but had problem getting it started. Today finally for reason I cannot explain an error appeared during BUILD: Unable to find Unknown ARR . Jus ...Show All

• rn_dba ODBC & text to columns

  I have created a Remote View that pulls from an ODBC connection in my DB. I have a field that is within the ODBC named employee_name where the name appears like so- SMITH;JOE L or SMITH JR;JOE L .  I want to execute a similar function that is used in Excel- text to columns where the data can be "split" into different columns depending on the delimeters (; or a space etc...) Is there a function similiar to this in VFP 9.0   I would hate ...Show All

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