Answer Questions

• Stephen Clegg III Importing Data from ms excel format.

  Hi! I'd like to ask help to all the gurus, i have this application which will let you import data from an ms excel format. Say, I had a list of inventory items (summing up to 2,000+) instead of inputting those items again to my application, i will just provide an option to browse the excel file and do the importing of the data. How will i go about this What commands to be used Any help would be greatly appreciated. Thank you! Alfred N. ...Show All

• Jason Whatever How using barcode in VFP?

  Hi! Help me use barcode in VFP use ActiveX controls Where download it Thanks! Hi, This is true, but most of us don't like the tedious task of hitting the 'enter' key. Is there a way to scan a product and have it come up without further user input required Steve   Hi, The barcode scanner returns a series of integers following an enterkey. So, you can do t ...Show All

• Jack T Timer Control not kicking in

  Hi All, We have a small VFP 8.0 synchonization utility that picks data from a VFP 8.0 database , converts it into XML  and sends it over the net to an Oracle database . It has a timer control on it which makes sure that this utility sends the data from VFP 8.0 to Oracle every 45 mins. It has always worked on all the setups till now, except one. We have not been able to figure why it does not work on that one. Any hints or directions to thi ...Show All

• Ashraf Hameeda T Urgent : Using SQLLdr with vfp 5.0 and Direct = True

  i am using the Vfp 5.0 for my application and using the sqlldr to load the records as bulk to the db tables. Inputs from the notepad are correctly fetched and stored my my db table(tempcontract). But when i use the Direct = true option, then the details are not stored properly.infact not at all stored. I studied from net that when the "Direct = True" option is used then the insertion into the db table woul be faster. so i ...Show All

• michielonline Problems with Command REN ???

  Hello!!! I usually use the following command in VFP6 (in Win98): !Ren Folder1 Folder2 to rename the name of Folder Folder1 to name Folder2. It is OK. But I can't use this command in WinXP (SP2). I don't know why Can any one help me Thanhs a lot. Have you tried the VFP command: RENAME FileName1 TO FileName2 You have to give more information. What OS are you using What version of Windows Scrip ...Show All

• Rod_Kane I really confused

  Hi, I really confused..what is the different between Visual FoxPro and Visual Basic and Visual Studio.. ..which one better.. ..what features for each programs.. ..when to choose each program.. Please help me.. Thanks, Jennifer Is Visual Basic the good source to start a programming language please.. ....Because, really I confused...which is different between Visual Basic 6 and VFP.. ...They ar ...Show All

• Sameer C T 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

• Greg05 how do i get a result in 4 tables in SELECT- SQL command?

  good day to the experts... My transaction has 4 tables, 1 for recording the amount of loan, 1 for check payment, & 1 for cash payment, and the vendor table. Below is the tables and its corresponding fields *// vendor table 1 (FIELDS=acct_no, acct_name,address, totalamount) * // loan table table 2 (FIELDS=or_number,acct_no, loanamount, or_date) *//cash payment table ltable 3 (FIELDS=child_numb, or_number,acct_no, amountpaid, ...Show All

• Kevin Lawrence VFP9.0 Data Access from .NET

  Hi all I am trying to acces VFP 9.0 Data from a asp.net web site and here is the problem In the visual web developer express when I hit "View in browser" The web page comes up correctly then I copy it to \\localhost\vfptest and open it in the browser and get an error indicating that vfpoledb cannot find/open the specified file. So then I go back to VWD and set the project to the IIS directory directly and hit "view in browse ...Show All

• pexxx Working with field General!

  Hi, all! Help me to update field type General: append object, edit, open,... in VFP from program control with bottom command. (use line command MODIFY GENERAL <field gen> don't open object) Thank! If you 'have to' store in table then use memo (foxpro 1.0 and up, VFP9 BLOB). I'll add my $.02: DON'T USE GENERAL FIELDS .   ...Show All

• Ken Courts 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

• jmota Property is invalid for table cursors

  Hi All, I am receiving the error "Property is invalid for table cursors" when I try to update a cursor created from an array. Please, see the code below as example: OPEN DATABASE   dbname1  && Open DBC using SQL connection USE tablename1  SCATTER MEMVAR    && _count1 = AFIELDS ( _array1 )   && Copy structure of tablename1 Table in _array1 CREATE CURSOR   cursorname1 & ...Show All

• soumya30680 Additional fields in table exported to txt

  Hello, I need to output from a VFP 6 table to a text file. When I use "copy to mytext.txt delimited with ," I get an additional field before and after each of the original fields from the table. This means that in my new text file, fields 1,3,4,6,7,9,10,12,13 etc are empty fields that were not present in the table and fields 2,5,8,11,14 etc are the fields with data. Can anyone tell me how to avoid these "extra" field ...Show All

• Artur Reaboi Help?

  I have a file with a first_name field I am trying to break it into first/middle/last fields. In foxpro. Any help would be great. Brian ALINES(ANAME, STRTRAN(first_name," ",CHR(13))) aname[1] aname[2] aname[3] Dave ...Show All

• JuKu Obtaining a web page's title

  I'd like to get the titles of web pages, and would prefer not to do this by loading all the web pages into a webbrowser, because that seems a bit heavy handed. In VB6 I used some APIs to achieve this, but I'm not having any luck in getting it to work in .net. Here's the code I'm trying: Module Module2 Private Const INTERNET_FLAG_RELOAD = &H80000000 Private Declare Auto Function InternetOpenUrl Lib "wininet" Alia ...Show All