Visual FoxPro

Page 199




  • Topics
    Replies
    Last post
  • Problem selecting a font in Visual Foxpro 9.0
    by Josseph
    12 Replies
    Last post by Bill Black
      • When I select the FontName property in the Property window, my default font Arial has disappeared from the selection list above. Arial is corrected installed in my system and I can select it in any other application, even with getfont() in the command window. Any idea Thanks. P.D.: My english is not so good. Sorry.
  • Installshield error (neophyte "programmer")
    by lowellnelson
    5 Replies
    Last post by AndyKr
      • I have developed a VFP prg file and built an exe file, both of which run without errors. I want to distribute the exe file to another location. I am attempting to use InstallShield for the first time. After building the installation program I attempted to test it. The installation program stops before completion, with an error dialog which states "Internal error 2602," then names the exe
  • ERROR FOXPRO
    by JAY MANNELLA
    6 Replies
    Last post by dni
      • WHY EVERTIME I REBOOT MY P.C GET BOX MESSAGE, CANNOT LOCATE M.S VISUAL FOXPRO SUPPORT LIBARY
  • CursorAdapters and UDF in FoxPro 9
    by IvanVC
    9 Replies
    Last post by IvanVC
      • Hi, I like to know if is possible to create a Cursoradapter (ADO) with a select CMD using a function. For example if I have a function concat(par1,par2) that returns par1+par2. I like to use as select command something like select concat(lastname,firstname) as name from personal Thanks Ivan
  • Determining if multiple EXCEL spreadsheet tabs exist before import
    by GR1206
    14 Replies
    Last post by Naomi Nosonovsky
      • Is there a way to determine if an EXCEL spreadsheet contains multiple tabs, and if so, bring back the name of each tab in order to select the one that you want to import data from I'm trying to import data into VFP from EXCEL, and normally use the IMPORT function and identify the spreadsheet tab by name. This time, I want to know 1) the total number of tabs in the spreadhsheet, and 2) the
  • ftp and vfp
    by jmom
    1 Replies
    Last post by CetinBasoz
      • I know very little about ftp's, so please bear with me. Can vfp dbf's or reports be transferred through ftp or does it do better being formatted into excel
  • Foxpro7 crashing with "fatal error exception code=c0000005 ..."
    by Endre E
    10 Replies
    Last post by AndyKr
      • Hi I have a tricky issue in my VFP7 application. At least tricky for me.  The application is crashing with fatal error C0000005. Sometimes I see a message like this one in the eventlog: "Faulting application <appname>.exe, version 1.4.82.0, faulting module ntdll.dll, version 5.1.2600.2180, fault address 0x00010f29.". Sometimes the application just hangs. I also see the Windows e
  • SQL query too long doesn´t work with SQLEXEC()
    by Everton81
    12 Replies
    Last post by Everton81
      • Hi fellows! I¡¯m doing a big sql query with 2 memory variables (cSQL and cWhere). Something like this: cSQL = "Select ....From.....Inner Join...." cWhere = "Where field1 like '%" + upper(textbox1.value) + "%'" + "Or field2 like '%" + lower(textbox2.value) + "%'" ...and so on until I can check out several possibilities of writing.
  • new to FoxPro...in search of answers
    by tm22
    7 Replies
    Last post by CetinBasoz
      • Let me start by saying I've never used FoxPro. A client is looking at converting a FoxPro db to SQL Server (or Oracle) and I need to do a cost analysis for it. Since I'm not familiar with FoxPro, I have no clue what it would take to convert. The client application has an interface to update the data. Is it possible to keep the same interface but change the backend db to SQL Server Also, what is t
  • Some questions about VFP
    by Ahsan Amin
    8 Replies
    Last post by Cindy Winegarden
      • 1) When i delete a record from VFPs table, it is marked as deleted but not deleted permanently. How to delete permanently 2) How to select select the records that are not marked in a table 3)iF i use 'Clear' method in a form, the control that are placed on form start vanishing, how to stop that
  • Creating a folder using VFP6
    by mrfitness
    9 Replies
    Last post by Naomi Nosonovsky
      • I have a query within a loop that will be creating many files. It is based on a (variable) 'where clause'. What I wanted to do was to grab the first 3 characters of the (numeric) variable 'where clause', and create a folder named with that variable, and place the results of the query in that folder. I think I can get the program to work if I figure out how to tell VFP to create a folder named as p
  • Retrieve Recno() of a newly inserted row into a table
    by Steve-0
    11 Replies
    Last post by CetinBasoz
      • You'll have to bear with me as I am not very well versed in databases in general, but even more so with Foxpro. I am using the latest Foxpro OleDB driver and need to find a way to retrieve the recno for a newly inserted row into a table. I have tried the following, assuming that the newly inserted row would be the last one in the table but this does not seem to work as I thought it w
  • MSCHRT20.ocx erro
    by Christina853
    7 Replies
    Last post by Dietervd
      • I have just restored a machine in which a program is loaded for testing. (I am not the programmer I was just hired). When I try to start the program i get the following error; mschrt20.ocx or one of its dependencies is not correctly registered. I did a full restore from backup to the new machine. The program will not start. Any Ideas I am not a seasoned programmer I am a network adminis
  • ActiveX control with FoxPro
    by Khalid Jayoussi2
    11 Replies
    Last post by dni
      • I have an MFC ActiveX control with support for SimpleFrame. I added OLEMISC_SIMPLEFRAME for MiscStatus and call EnableSimpleFrame in the constructor. I used this control in MFC and Vb and it works fine. but when I used it in FOXPro, I get a problem with scroll bars. but if I comment out EnableSimpleFrame the scroll will work fine with Fox Pro.
  • CONFIG in top-level application
    by Donquick
    8 Replies
    Last post by Naomi Nosonovsky
      • Hi, I am using VFP6.0. Acouple of questions about application creation. 1) I notice a config.fpw is created in the progs area by the application builder, which is presumable just for setting up config for this application. If i modify the fpw by putting a 'Command = XXX' line in it and generating the application then it doesn't seem to run the command when the app starts. Similarly u
  • unique
    by NILKAMAL
    5 Replies
    Last post by Alex Feldstein
      • hi! please help me out for this problem is it possible scan image from scanner for perticular size cos when i scan it scan blank space too and also in my table have like 10 field with id is primary key but i need one field no duplicate (e.g if driver Lic # i need unique no , no duplicate ) thanks
  • Problem selecting a font in Visual Foxpro 9.0
    by Josseph
    12 Replies
    Last post by Bill Black
      • When I select the FontName property in the Property window, my default font Arial has disappeared from the selection list above. Arial is corrected installed in my system and I can select it in any other application, even with getfont() in the command window. Any idea Thanks. P.D.: My english is not so good. Sorry.
  • InstallShield vaporized project? (neophyte user)
    by lowellnelson
    11 Replies
    Last post by Rick Borup
      • I generated a VFP prg and build an exe version which run without errors. I then attempted to use InstallShield to prepare for distribution to another site (I am completely inexperienced with InstallShield), but the test installation halted before completion and provided an error code. NOW I FIND THAT MY PROJECT, WITH ALL TABLES, FORMS, AND REPORTS NO LONGER EXISTS. Have I so offended the InstallSh
  • SQL Join question.
    by Aleniko
    3 Replies
    Last post by Naomi Nosonovsky
      • Hi; I have 2 tables. polgr.dbf and po.dbf. I want to query all the records from polgr and some matching info from PO. The problem is that in some cases there will be 2 records in PO with the same PO#. The following query produces duplicates if there are 2 records matching in PO. select polgr.qopen,po.acct from polgr left join po on polgr.pono = po.pono Is there a join condition or other way to avo
  • Fax Report Using VFP9
    by emery
    11 Replies
    Last post by emery
      • As resolved in "VFP Fax Integration" thread , I have been using Jaime's method to fax Reports with graphic/image and it works very well for VFP6. set printer to name "Fax" report form myReport to file "myfile.tif" noconsole Recently I compiled and ran my program using VFP9, I got the following Program Error: OLE IDispatch exception code 0 f
  • replace image with own name
    by NILKAMAL
    14 Replies
    Last post by NILKAMAL
      • hello! is any way replace my image with include reeno or any field data like i take image from my webcame and it store in one folder after that i use replace command so it save path in my field but when i replace that time image name want to change here is my code below DO [C:\Program Files\EZTwain\VFP\EZTwain.prg] TWAIN_SelectImageSource(0) * Get list of devices into memory TW
  • Linking Foxpro table to Access 2003
    by rkennebeck
    4 Replies
    Last post by rkennebeck
      • I am trying to link a foxpro table in Microsoft Access 2003 using ODBC. The package I'm linking to is in VFP 9 (I believe). When I do the link, and then try to open the table, it says: "The field is too small to accept the amount of data you attempted to add...." When I view the structure in Access, I notice that there are several binary fields. When I query the tabl
  • how to store encrypted passwords ..
    by ibbm
    9 Replies
    Last post by Mark OSVATH
      • is there some kind of algorithm in fox that can store and encrypted password so that if anyone got a hold of the data they couldn't read the password. Thanks in Advance
  • Copy File Error in Visual FoxPro 7?
    by Paul B Walker
    7 Replies
    Last post by Tamar E. Granor
      • When a COPY File Command is executed and a space is in either a folder name or a file name, the instruction is unable to handle it. I have tried a technique to put in " quote marks in the manner '"<path><filename>"' but then it gives me a syntax error. Is this a bug or am I entering the full path and filename wrongly If this is a known bug, is there a patch for it If not
  • SQL Select help.
    by Aleniko
    3 Replies
    Last post by Aleniko
      • Hi; I'm using this command: SELECT polgr.pono,po.podate as podate,polgr.design,polgr.qopen,IIF(isnull(poarrivals.design)," ","Y") ; FROM; krcbp!polgr ; LEFT JOIN krcbp!po ; ON polgr.pono = po.pono ; LEFT JOIN poarrivals ; ON polgr.pono = poarrivals.pono ; WHERE polgr.design = "SU-115" AND polgr.qopen <> 0; ORDER BY podate But I'm trying to get on