Visual FoxPro

Page 98




  • Topics
    Replies
    Last post
  • When do we use DE in report?
    by Lightening
    9 Replies
    Last post by Lightening
      • If we have a customer table and a orders table, a typical one to many relationship, do we use Data Environment or a temp table or cursor in a report Our data is usually dynamically changing, e.g. we wish to use the same report to display all orders of a particular customer or a group of customer in a region. If not using Data Environment, when do we use DE and what's the advantage of
  • Dot matrix printers with Visual Foxpro
    by Farhat Fakih
    14 Replies
    Last post by Lakshmi N
      • Hello all, We are in the process of converting an old Foxpro 2.6 (DOS) software into VFP, the problem that we face is that the printing is very slow on dot-matrix printers We cannot shift to laser printer as the stationery is pre-printed and has to be multi-part. Can anybody offer the solution Thanks in advance
  • Printing from com dll
    by foxman_
    4 Replies
    Last post by Claude Fox
      • I'm trying to print a report from a Com dll file. I keep getting the OLE IDispatch exception code 2031: User-interface operation not allowed at this time. Is there any way to make this work without building to an .exe file I'm using VFP 9 thanks in advance -m
  • Running MSDOS application from compiled Foxpro
    by Eddie N
    8 Replies
    Last post by Nugroho2
      • My compiled Foxpro project (EXE) runs OK at home. I ported it to a network, and everything goes well except one, i.e. it fails to run an MSDOS (console) application (EXE, Visual C++) called from a procedure. I open the MSDOS (command prompt) window and run the application directly from there, it runs OK, but could not be called from the Foxpro application. What could be the problem I have r
  • 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
  • Foxpro, left join, group by
    by nick800
    2 Replies
    Last post by CetinBasoz
      • Ok, I'm at a brick wall here. I'm working on a project that uses Foxpro as the database for a .NET based website. Basically, for this table I have 4 tables People ( about 45000 records ) Addresses ( about 45000 records ) Signings ( about 36000 records after where ) Representatives ( about 500 records ) the people id is indexed in addresses and signings the representatives district is indexed in ad
  • Get external IP adress
    by miltoncwb
    7 Replies
    Last post by Naomi Nosonovsky
      • Dear Experts, How can I get the external IP from a vfp program just like I visit www.checkip.org Thanks you in advance. Milton
  • VFP9 application in same network with email server & VOIPs
    by Daniel CW Tan
    10 Replies
    Last post by Daniel CW Tan
      • Hello All. I am currently having a VFP9 application shared in a network that also include VOIP telephony & email servers. Up to 30 users in all. The VFP9 "exe" file is only 3Mb and the database files totalling 5Mb. It seems that the VFP9 application runs awfully slow at times while the others runs fine. Could the VFP9 application the main reason why the slowness . Ho
  • How to let user choose a data path?
    by Lightening
    5 Replies
    Last post by Lightening
      • I wish to let the user choose a folder to dump data. How can I achieve that    To be user friendly, I whish to give them an interface like putfile() or getfile() screen. Not a text box to manualy enter the path.  Thanks.
  • Foxplus database program files
    by Tony Garrison
    8 Replies
    Last post by Tony Garrison
      • All: I am an old foxplus dbase guy. I have many .prg files that I would like to upgrade to Foxpro for windows. Can someone offer me some direction on how to get started. I enjoy writing rountines and want to get back into programming again. -Thank you.
  • file question
    by dvidal
    1 Replies
    Last post by CetinBasoz
      • Hi, I want to to know if there is a function or command to create a directory in visual fox pro 7. For example, I want a new directory called: 'c:\users\test' . Thanks,
  • 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
  • sql query
    by Ahsan Amin
    8 Replies
    Last post by Naomi Nosonovsky
      • I have a combobox placed on a form that is bind wih a column of a table. I using distinct keyword for this but when i run the programe it opens the table instead of form. Here is my code SET DELETED ON &&SELECT a_Courses SELECT DISTINCT a_Courses.CourseName FROM a_Courses thisform.cboCourses.ControlSource = "a_Courses.CourseName"
  • Combobox problem
    by Yuniel Lorenzo
    4 Replies
    Last post by MarciaAkins
      • Hi out there Ok I have this code to fill a combobox: thisform .comMagent. RowSourceType = 6 thisform .comMagent. RowSource = "cmmage.masteragen" and doesn't work and is supouse to work, the only way that it can work is usinglike this: USE cmmage thisform .comMagent. RowSourceType = 2 thisform .comMagent. RowSource = "cmmage.masteragen"
  • Adding the _msm_windo to my menu.
    by Aleniko
    9 Replies
    Last post by Naomi Nosonovsky
      • Hi all; I'm trying to add the functionality of the 'window' menu bar into my own menu. I need to let users switch between windows open. I've tried adding pad name "_msm_windo" to my menu using foxpro's menu generator. I've also tried sys(1500,"_msm_menu","_sysmenu") Both didn't work. I've used menu pads under Foxpro2.6 with no problems but this is the first time I'm t
  • Retrieving tables
    by Josemaloco
    3 Replies
    Last post by Markish
      • Just a newbie question that I didnt found anywhere. How can I retrieve all the tables with a SELECT command I mean, whats the name of the table holding all that info
  • 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.
  • to read text file thru foxpro
    by polachan
    4 Replies
    Last post by Rick Borup
      • Dear all, Please help me by providing a sample program tips in foxpro to read a tab seperated text file into a DBF file example the text file as follows Code Name Joindate Salry 01 Alex 12/12/2006 2000.00 02 John 13/02/206 100.50 Regards P
  • field valid method
    by NILKAMAL
    7 Replies
    Last post by CetinBasoz
      • pl.help what i am doing wrong cos when i add new dl_no( my field name) it same message coming " already exists" i want to seek dl_no in checkcust table and if found get the message and focus on same field and if not the go to next field SELECT CHECKCUST SET ORDER TO DL_NO && DL_NO SEEK dl_no IF FOUND() =messagebox("ALREADY EXISTS") return .F. ELSE END
  • Rerunning the query for a grid
    by mathmo
    4 Replies
    Last post by dni
      • I've got a grid on one of my forms (created simply by dragging and dropping a query from the data environment onto it). I'd like the data in the grid to be be updated depending on what the user has selected from a combobox (i.e. have the query be run again based on the new user selection from the combobox). Refreshing the grid isn't enough, I haven't been able to get the grid to show anything else
  • Problem when using "call some_func()" with SQLEXEC-Connectivity error: [Oracle][ODBC][Ora]ORA-00907: missing right parenthes
    by RDarius
    9 Replies
    Last post by RDarius
      • Hi, I have problem when using "call some_func()" with SQLEXEC. Is this ODBC problem or FOXPRPO 9.0SP2 nHandle=SQLSTRINGCONNECT("DSN=pcv;DBQ=192.168.0.123;UID=pcv;PWD=pcv;BTD=F;NUM=NLS;FWC=T") id_doc=61 doc_nr='TEST0000001' SQLEXEC(nHandle,"call pcv.mp.test_call( id_doc, doc_nr)") =1 commited SQLEXEC(nHandle,"update pcv.b50_headeriai set b50_op_numeris= doc_nr wh
  • About using imestatus()
    by xuyca
    4 Replies
    Last post by xuyca
      • Hi, I am using imestatus() to change input method between English and Chinese. It worked good in windows 2000. But it doesn't work in window xp. imestatus(0) always change to Chinese input and imestatuss(1) doesn't work. code is as follow: =imestatus(1) && using Chinese input =imestatus(0) && using English input Anybuddy know why
  • invisible form
    by RavindraPatil
    5 Replies
    Last post by RavindraPatil
      • Dear friends, I use vfp 6. I have a form with 10 fields and a grid. When I run the form. The form is not displayed at all. But it is there. Because after each tab the cursor moves to the next field. I can see only blinking cursor and neither form nor the fields. please help
  • 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
  • how do i stop the automatic rounding of a number
    by Madix_t
    5 Replies
    Last post by Madix_t
      • good day to the experts... what setting do i have to make to stop the numeric value to automatically rounded of the numeric data here is my problem Total_amount N(7,2) lcComputation=747*2.260*1.027 lcOutput=lcComputation - .655 Total_amount=1733.14694 my text field will hold only maximum of 8 character (9,999.99). Now, when i save my work, supposedly the number shown on it will be 1,733.14. But i