Visual FoxPro

Page 37




  • Topics
    Replies
    Last post
  • Need help on get mother board serial number
    by hs ong
    7 Replies
    Last post by hs ong
      • I need help!!! I using wmi to get my motherboard serial number. It's work in my notebook, but when i test it on several personal computer, the serial number is blank. Why it become blank Is it some computer will not store mother board serial number Please help: I put my code here: LOCAL lcComputerName, loWMIService, loItems, loItem, lcMID lcComputerName = "."
  • Retrieve current date data
    by espirit
    9 Replies
    Last post by Naomi Nosonovsky
      • Hi, Im having a problem to retrieve data based on today date. I'm using Visual Fox Pro 6. My table structure is as below: name type width updated_on DateTime 8 I need to retrieve only data that is updated today or current date. For eg my table datetime is 28/06/2007 12:00:00 PM, and I need to retrieve only data for today which is 28
  • Record No. in Not Deleted Records
    by Ahsan Amin
    4 Replies
    Last post by Tamar E. Granor
      • Is there any command/function that returns highest row no. from not deleted records Like if i have a table that contains 10 records from which 4 are deleted. Now i want it to return 6.
  • adding a jpeg file address to a field
    by nebraskajanice
    8 Replies
    Last post by skipdcm
      • First, let me apologize as I am real old user of FoxPro 2.0 and have just gotten back to FoxPro via version 9.0 so I am extremely "dumb" but willing to educate myself. My application is: I have a table that contains a number of inventory items. I want to add a field that contain an address for a jpeg file of that item for serveral different reports. Can it be done Thank you in
  • 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
  • Try ... Catch
    by Mayuresh554114
    2 Replies
    Last post by Mayuresh
      • Hello All , We are a software company having a product developed for Fincancial Systems in Visual Foxpro. The product is well settled and is running successfully for past 10-12 years. Now we are trying to trap our system errors by using Try... Catch ... and Finally instead of onerror .... But unfortunately we found that Try... and Catch can be used with in the method or procedure , it canno
  • Foxpro Code crashing windows 2003 server
    by Mitchman10
    4 Replies
    Last post by AndyKr
      • We have a non-programmer... a statistician in our office. He has written a data munching program in foxpro. The data resides on a file server. I have never seen this, but his program causes CPU Utilization to go over 70% on this server. It dose lots of scans, calculating, and then lots of ole automation to populate word docs, excel docs, and create pdf. Any thoughts on tips or tricks
  • Upgrading V6 app to V9 gives strange Windows Phenomena
    by Bronxgodzilla
    3 Replies
    Last post by Markish
      • Hi there... I'm just trying to solve this little annoying Gotcha & would appreciate help from experienced problem solvers. Old V6 code creating my data input windows, now blanks when I bring my mouse across it, then have to "hunt in the dark" for event buttons (Add, Goto, Exit, etc) which then appear when mouse is over them. Then only about half the window appears. Truly weird. Reall
  • Outlook contact details
    by hangover
    14 Replies
    Last post by CraigBoyd
      • This might not be the right forum for this question given that it mainly concerns Outlook (although I am accessing it from VFP), but I am hoping that one of you smart and helpful people may know the answer ... I am trying to obtain to populate a VFP table with the details that I can see in my Outlook 2002 address book. I have had some success at obtaining details such as Name, Email
  • Using VFoxPro 9 and SQL to create a table
    by Zaphod2003
    9 Replies
    Last post by Zaphod2003
      • Can someone tell me what's wrong with this code CREATE TABLE countries( ; id n(10,0) PRIMARY KEY , ; ccode c(2) UNIQUE , ; CHECK ( LEN ( ALLTRIM (ccode))=2) ; ERROR "Currency code must be 2 characters", ; currency n(10,0), ; CHECK ( currency >0), ; cname c(30) UNIQUE ; ) I have indentified the problem to be with the code CHECK (
  • Record count of a table
    by Ahsan Amin
    3 Replies
    Last post by Alex Feldstein
      • i am trying to make a program that will 1. pop up a file open dialog box using a mouse click on a button on form 2. user will select a dbf file and it will be stored in variable 3. i want to count no. of records in table using this variable I am trying to write the following code but does not work: private gcTableName as Character CLOSE DATABASES CLOSE TABLES OPEN DATABAS
  • How to Pass parameter between forms ?
    by Hemangi
    8 Replies
    Last post by MarciaAkins
      • Hi, How do i pass one variable value from one form to other , once it pass on to other form previous form should get release or disable so that next form only can be viewed. i have tried using "do form with varbname " but previous form doesnt get disable when i write thisform.release in unload event of this form, and if dont want to use formset. regards Hemangi
  • FoxPro Ver 8 problem with Ver 7 form doc
    by Old Foxpro Dood
    14 Replies
    Last post by AndyKr
      • I work for government and unfortunately we are a little behind on versions, but I do have a problem which my dbase,sco foxbase, microsoftfox brain can't handle. A project was created in Ver 7 with no compilation or execution errors prevelant. When proj is opened in Ver 8 and a particular form is opened the error displayed says "SYNTAX ERROR 10" .... my old feeble brain has tried debugger
  • How to remove redundant phrase in field?
    by Littletommy
    14 Replies
    Last post by Littletommy
      • Hi all........ I have a table field that contains things such as..... V DISCONTINUED W/O REPLACEMENT; V DISCONTINUED W/O REPLACEMENT -I&S MASTER; 7 SUB 2610-139-3704; I&S MASTER; 7 SUB FOR 2610-139-3704 What I need to do is remove the duplicate phrases, leaving only one instance of each phrase in the field. The amount of phrases in the field varies...could be 2 as shown abo
  • odbc driver
    by vhockz
    2 Replies
    Last post by Alex Feldstein
      • im using visual foxpro 7, and need to add odbc driver, but there was an error that i need to install current version of odbc driver. The problem is i didn't know rhe specific file that i need to download. tnks
  • Cannot save Chinese character
    by Joe Au
    3 Replies
    Last post by Tamar E. Granor
      • I install VFP 8.0 English version into a Windows Server 2003 Chinese version with SQL Server 2005 English version. Within the SQL Server, I can save Chinese character into a column as it is defined as nchar. When I run a VFP application, I cannot save Chinese character and it becomes as . The VFP application connects the SQL Server through ODBC data source. I have tried both enable an
  • Windows Services spying
    by hs ong
    8 Replies
    Last post by hs ong
      • Is there any code in visual foxpro that can do this I sent a trigger in dll / exe file to one PC, I spy into this PC windows services, I triggered this PC to return back its Hardware ID like Harddisk S/number etc.. Visual Foxpro can do this (windows services-control panel->setting->admin.tools->services)
  • problem of SET NAMES
    by Darren5559
    1 Replies
    Last post by CetinBasoz
      • hi, i am using VFP9 with mysql and odbc 3.51 connector. i have a table called 'user', and the structure is as follow :- user_id varchar(10) password varchar(10) because i have to develop a system which can support chinese character, so i define a command "SET NAMES BIG5" in the mysql connector, this changes make the size of columns becomes double during View or SPT, instead of varchar(
  • Application cannot run after compile
    by Sixon
    14 Replies
    Last post by Sixon
      • I have a visual foxpro project and compile it in Win32 system application, with Build in the project. But after compilation, the program cannot run. When complie it, I've including the VFP9.DLL and VFP9RENU.DLL files in the project directory.......Please help me...thank's....
  • Displaying a VFP report in a window without the main VFP screen.
    by Andrew Mozley
    2 Replies
    Last post by CetinBasoz
      • I am developing a free standing application which should just display a VFP report using VFP reporter. However I notice that when I run it I get the VFP application window and within that the report preview window complete with buttons and scroll bar (which I am happy to have). Is it possible to get the report preview window to fill the screen (except, perhaps for the title bar), so the user ca
  • What specific code needs to be placed in a forms BeforeOpenTables...
    by rpp
    7 Replies
    Last post by Naomi Nosonovsky
      • I have multiple customers with identical datasets (ie, dbc, tables, fields etc..) the content of each customers tables is very different of course. I have been using the Load statement after establishing the DEFAULT PATH, however, I would like to use the DataEnviornment to make use of the added features. My problem has been how to dynamically load the DataEnviornement accurately with
  • Olecontrol parameters
    by andrew552717
    14 Replies
    Last post by dni
      • Hi! I need some help again. I have small ocx in vb and I want to use it in vfp6.0. It is working in vb this way: FK524ID1.SetIPAddress lpszIPAddress, CLng(txtPortNo.Text) where lpszIPAddress = "192.168.1.201" and txtPortNo.Text="5005" In VFP, when I dclick on "SetIpAddress" method in the Properties window, it is poping up new window with
  • Need help on get mother board serial number
    by hs ong
    7 Replies
    Last post by hs ong
      • I need help!!! I using wmi to get my motherboard serial number. It's work in my notebook, but when i test it on several personal computer, the serial number is blank. Why it become blank Is it some computer will not store mother board serial number Please help: I put my code here: LOCAL lcComputerName, loWMIService, loItems, loItem, lcMID lcComputerName = "."
  • image resize
    by NILKAMAL
    7 Replies
    Last post by Naomi Nosonovsky
      • hello! i ceate simple form with image now i want to image resize in my imagecontrol can i do that also how do i do to change background color of my application thanks
  • Detect hard diskk serial number.
    by Jarron
    9 Replies
    Last post by Ali Budiyono
      • Dear Expert, Can I know how to detect the hard disk serial number or code using foxpro Thanks a lots.