Visual FoxPro

Page 246




  • Topics
    Replies
    Last post
  • HIDE MENU exposes itself?
    by Docpro777
    2 Replies
    Last post by Docpro777
      • "HIDE MENU _msysmenu" and "DEACTIVATE MENU _msysmenu ... have been failing to keep _msysmenu hidden after certain simple myModal forms are called (via object 'click' methods) The deactivated (or hidden) _msysmenu seems to abruptly issue a "SHOW MENU" (or something) between 'queryunload' and 'destroy' events of those modal forms ... during their release. I've tried
  • why does Read Events release Main window
    by Hao Q.
    14 Replies
    Last post by Hao Q.
      • Sorry if this topic has been brought up before... I'm working project, which I set the main window as modeless. In order to prevent the form to be released at the time of initialization, I put THIS.SHOW and Read Events in Main.Init. However, after the form is initialized, the object main for main window is released from the memory (I view status of variables in the debugger window). If I'd like t
  • sms sample code
    by rollym
    2 Replies
    Last post by jeduards
      • Could someone please give me a sample code on how to send SMS through VFP 6 0r 7. I live in Australia and my mobile phone provider is OPTUS. My internet provider is optusnet.com.au Thank you and happy new year. Thank you for all who have unselfishly helped us VFP users for the past years. Rolly
  • Make thumb nails
    by Sammy Adems
    6 Replies
    Last post by Sammy Adems
      • What is the easiest way to auto create a thumbnail from a large image in FoxPro Thanx Sam.
  • Showing one form from another
    by Hans L
    11 Replies
    Last post by Hans L
      • Situation: I am in a form A, click on a cmd, and it opens another form B and hides the current form A. In form B, I click on a cmd and I would like to show form A and release form B. The release of form B works, of course, but not the showing of form A. I have never seen anything about whether it is possible to make changes in or affect one form from another. Is it (I guess it would work with a fo
  • Error Msg: Connection:xFoxComm is busy
    by Jooooto
    6 Replies
    Last post by Jooooto
      • the subjected message: Connection:xFoxComm is busy. when running the Foxpro Application in SQL Server with WinXP workstation. pls help
  • Using VFP to bold a row in excel
    by mrfitness
    14 Replies
    Last post by Alex Feldstein
      • I have a program that returns the value of a query and places it into excel. But I also entered a row of static text as headers. I want to bold the columns I want without doing a statement for each individual cell to be bolded. I cannot remember how to bold a selection of more than one cell in one command line. i.e. .sheets[esheet].cells(1,1).Value = "Contractno" &&COLUMN HEADER
  • intermittent failure to display jpegs on form
    by Marc Bachman
    7 Replies
    Last post by Naomi Nosonovsky
      • I have a form which displays two values from a record, one is a text file, and the other is a jpeg, the text file and the jpeg are in adjacent controls. I have gotten the text to display with some effort, but some of the jpegs just won't display. They have been adjusted to a pixel dimension convention so that they are optimally sized, and under 100kb. In and earlier thread, I was advised that sinc
  • RTF property
    by AlexBB
    8 Replies
    Last post by CetinBasoz
      • I set up a RichTextBox and show content of memo files from VFP DB tables. Over at VFP which refuses to comply with Vista I had a control that gave me a chance to manipulate fonts and set colors to parts of the text if I wanted. I am wondering how I shall do it in here Shall I use FontDialog for this Also, I've been thinking of using a speller in that VFP Form setup but never got arou
  • 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
  • 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
  • How to create a Word document?
    by Lightening
    10 Replies
    Last post by Lightening
      • I wish to convert a memo field into a Word format document. I searched around and found this: oWord=CreateObject("word.application") oWord.Documents.Open("c:\test.doc") oWord.ActiveDocument.Range.Start=0 oword.ActiveDocument.Range.End=0 oWord.ActiveDocument.Range.Text="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX" oWord.Documents.Save() It works if the
  • What is the recommended style in programming in VFP ?
    by Eddie N
    3 Replies
    Last post by Cindy Winegarden
      • I come from a dBase environment, hence I would prefer to start running my programs from PRG and occasionally call objects (Forms etc.) as needed. I am just wondering as to what style is recommended in VFP. Will it be better if I use FORMS and call the PRG from the forms or the other way round ...
  • Connection Problem
    by sashy
    1 Replies
    Last post by dni
      • Can anyone give me a sample codes on how to connect to visual FoxPro 6.0 free table using VB.Net Thanks.
  • Multiple Dataset in the same table object
    by Zoop
    18 Replies
    Last post by Zoop
      • Hi, I'm pretty new in ReportViewer. I would like to show fields from two differents db tables in the same table object. Example : I have an object inside my object datasource. Let's say, an "Employee" object (which is my datasource), containing a "Company" Object, and I want to access a property of the Company object. Automatically the datasetname is set to "Employee"
  • Filename and nullchars
    by DaCosta11
    6 Replies
    Last post by DaCosta11
      • I hope everyone had a good xmas and santa gives you a lot of presents :) Now, my question: try this code in VFP9: pParam1 is a parameters which contains a folder name. The folder must contains EMLs, but can be another file, just change the extension. cString =pParam1 + Chr(0) nEMLs =aDir(aEMLs, pParam1 + "\*.EML") For iEMLs =1 To nEMLs cString =cString + aEMLs[iEMLs, 1] + Chr(0) EndFor
  • 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)
  • Check permissions of directory
    by teeth777
    8 Replies
    Last post by Christof Wollenhaupt
      • Hi all, I'm after a way to check the write access the user has to a particular directory. Pref. a way to do it that doesn't require non foxpro objects (ie wsh/fso). doing an fcreate to create a dummy file then deleting it isn't suitable. It's not really elegant and there are instances where the user might have create rights but no delete rights & there'd be a bunch of dummy files in the dir. a
  • Validations
    by Ahsan Amin
    11 Replies
    Last post by CetinBasoz
      • I am trying to validate numeric and character type data, entered by user in textboxes placed on the form. Can any expert tell me which functions to use or you could tell me what should i type index button of VFPs help to find all type of data validation functions
  • Passing multiple variables from forms w/ VFP7SP1
    by KDKephart
    14 Replies
    Last post by Naomi Nosonovsky
      • I'm an old Clipper (S' 87) programmer that needs to figure out forms with VFP. The attached code generates a form containing a set of four optiongroups that set basic comm port parameters on the local host for serial communication with an instrument (usually an electronic balance). I'm trying to use the form to replace a series of cascading menus in the original program. My intent is for the form
  • File In Use
    by AlexBB
    14 Replies
    Last post by AlexBB
      • Trying to execute a delete command from .NET with OleDb driver I get an error: File in Use. It seems strange that a similar command appeared to have executed once before. That command is downstream of this one and that worked while the code around this one was not yet debugged and this ExecuteNonQuery was simply bypassed cmdm . CommandText = "execscript('USE crossRefTable in 0 EXCLUSI
  • Comparing cdx, idx, ndx
    by Bit
    5 Replies
    Last post by CetinBasoz
      • Hi, I found that there are serveral type of index format for a foxpro table ama.dbf Does it mean that if I use i> If I use cdx index, then the syntax would be index on height tag height. use ama order height. or use ama set order to height ii> If I use idx, then the syntax should be index on height to height use ama index height or use
  • REPLACE command help wanted
    by AlexBB
    14 Replies
    Last post by AlexBB
      • If not mastering counter intuitive VFP object manipulation was not hard enough in the past until I finally got a handle of it, now trying to do it from OleDb .NET code is like moving through heavy water--it is 10 times more difficult. I thought I reached the promised land when I finally made PACK work but my joy was premature. Now INSERT gives me the same trouble. I really prefer to
  • 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
  • Little Doubts with ListView....
    by Paramu
    5 Replies
    Last post by Markish
      • Hi There, Well. & Thanks in advance. Actually I added a table data's to Listview...But I want to locate my cursor in Listview ...according to my Textbox...value... for that any Command same like Locate for.... My Codings...For Data's added in ListView.. ---------------------------------------------------------------------------------------------------------------