Visual FoxPro

Page 46




  • Topics
    Replies
    Last post
  • Report to HTML output problems.
    by Aleniko
    7 Replies
    Last post by Aleniko
      • Hi; I'm wondering if some of you experienced problems with how HTML reports are generated in VFP... I was experiencing small problems like information in the title band not showing etc, but yesterday I got this problem: An html output is generated perfectly on my XP pro machine. But when I deploy the program on a win2003 server, the result of a generated html are all messy and ugly. This happens w
  • 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.
  • Microsoft: No Visual FoxPro 10
    by CDFAUX
    14 Replies
    Last post by dni
      • An official announcement of MICROSOFT: http://redmondmag.com/news/article.asp editorialsID=8320 Although all the signals pointed in this sense, obviously the official confirmation is a bad news. I believe that still lack clarity in the communication of Microsoft. I understand that SEDNA tries to leave liberated to the community the future development of VFP, but if the intention of Microsoft
  • Query result on textbox
    by Victor BA
    5 Replies
    Last post by CetinBasoz
      • I'm trying to return a value from a query and show it in a textbox, like this: use table1 private x; select count(*); from table1; into x; thisform.textbox.text=Str(x) && I also tried ..... x=select count(*) from table1; but doesn't work, what am i doing wrong thanks
  • Buttons Disappear
    by mrpaully
    10 Replies
    Last post by dni
      • I have a form that submits an odbc query. Once the data is returned to a listbox, a number of the command buttons dissapear if you put the mouse cursor over them. Why is this and does anyone know the fix
  • Problem with Buffering, Multilocks, Grids, Optimistic Record Locking for Multiple Users VFP 9.0
    by vfpu$3r
    4 Replies
    Last post by Naomi Nosonovsky
      • I would appreciate some help with this. Possibly someone else has dealt with this. I have a small app written in VFP 9.0 which does not seem to be acting correctly in a multi-user environment. Based on my research, I expect that two different users should be able to edit a field in two different records without a crash - but when user #1 begins to edit a field, if user #2 begins to edit a
  • GETPRINTER() causes access violation in VFP6R.DLL
    by JazzyKat
    7 Replies
    Last post by Naomi Nosonovsky
      • Hello, We have a Visual Foxpro 6 application used on several computers. On one machine, and only this one, one of the report often crashes with the error "access violation in VFP6R.DLL" The computer configuration is: Windows XP sp 2 Visual Foxpro 6 executable Other computers using the same report have no problem. I`ve read on this forum and on other newsgroups that it may be caused by me
  • The VFP9 WebBrowser class (_webview.vcx) managing *.hta vs. *.html?
    by Docpro777
    2 Replies
    Last post by dni
      • I'm hoping to make the VFP9 WebBrowser class browse *.hta file(s) ... i.e., to prevent windows html security messages in a LAN. This WebBrowser class ( _webview.vcx) works well for *.html files (and I trust *.htm files). I've failed to make the class browse *.hta files and thought I'd ask if any of you (peradventure) think *.hta files can/cannot be used in this WebBrowser class.
  • Export from Visual Foxpro application to excel 2007?
    by Yong Ling
    3 Replies
    Last post by CetinBasoz
      • Hi, I'm trying to export huge amount of data from visual foxpro application to excel. Since the old version of excel can only handles up to 65536 rows, so I upgraded to excel 2007. But after I exported to excel 2007, it still show me 65536 rows only instead of 1M rows. Why it's still using the xls instead of xlsx Thanks in advance. Best regards, Yong Ling
  • Deleting records
    by dvidal
    3 Replies
    Last post by dni
      • Hi, I need to delete some records from a table that has the same values for some attributes. Some attributes are part of the primary key while others not. Thanks,
  • Copying from one sheet to another within the same book
    by Sleepgone
    3 Replies
    Last post by CetinBasoz
      • I am creating a workbook for a local company using excel. I've got most of the book worked out except that when information is input into the "main" sheet I need the same information - the entire row - copied over to another sheet within the same book depending on certain criteria. In other words, if the value in a column is 2 then copy the entire row to sheet 2, if it's 3 then copy to s
  • 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
  • SMS through visual foxpro
    by Ravi Awasthi
    5 Replies
    Last post by SharathMum
      • Dear Sir, Please send me source code for SMS through visual foxpro, or favour me with some clues. Thanks & regards, - Ravi Awasthi
  • Foxhelp index and search pane is empty and not working
    by Sándor T&
    4 Replies
    Last post by Sandor Torok
      • Hello, I have VFP6 and VFP8 in my notebook under Windows XP SP2. There was an error opening any html help: "Cannot Open the File: Mk:@MSITStore:<any>.chm" I found in one of the forum the next commands to do in the CMD window: regsvr32 %systemroot%\system32\hhctrl.ocx <press enter> regsvr32 %systemroot%\system32\itss.dll <press enter> After them the foxhelp a
  • Grid sorting
    by Aleniko29139
    7 Replies
    Last post by MarciaAkins
      • Hi; I have a grid which is populated with the results of a SQL query. I need to sort the grid depending on which column header the user clicks on. I have not done this ever and I was wondering which is the correct approach: - After I run the SQL query, run a series of 'index on' commands so I can use the indexes. - Run a secondary query on the results of the query to produce the
  • Urgent help needed in deploying project
    by Hemangi
    2 Replies
    Last post by Bruno Yu - MSFT
      • Hi All I have created one exe which runs fine but after i do setup of it using install shield it gives error of "unrecognized command/phrase" i really got tired of find the cause pls suggest me some remedy Thanks Hemangi
  • How to show properties window to a file in foxpro
    by surinder singh
    14 Replies
    Last post by surinder singh
      • Hi I want to show the properties window to the file selected by user on right click -> properties option. (as this is shown with any file when we right click on that file and click on properties option in widows explorer) If anybody knows about it , please tell me how to do this If any one knows to do this in Visual Foxpro then it will be good for me.
  • 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
  • HUGE problem with the Container Control (?)
    by graFFiti
    7 Replies
    Last post by AndyKr
      • In VFP9: I have a Form, that has a Container, that holds a Listbox The Listbox has some items in it. Now, if you try to click on an Item, hold the mouse clicked and drag it up and down, the selected item does not change, it just blocks there. When you release the mouse and click on another item, you now have TWO selected items in the Listbox. That is not normal. A Listbox outside a container works
  • HDD Serial No.
    by RavindraPatil
    6 Replies
    Last post by CetinBasoz
      • hello generous persons, Does anybody know how to obtain HDD Serial No. through foxpro Or I have that code in VB. Can we store the value returned by that code to foxpro variable thuogh I do't know much about vb, the code is as follows ; Imports System Imports System.Collections Imports System.Management Public Class Form1 Dim WindowsApplication1 As System.STAThreadAttribute()
  • How To Link Combobox Columns to Grid Columns¡­.?
    by Paramu
    4 Replies
    Last post by Paramu
      • Hi There, First if anything got bore, please forgive me and let us clear our doubts¡­. The coding will show the details of Combobox to Grid Control thisform.grid1.AllowAddNew = .T. thisform.grid1.RecordSource ='wkassign_1' thisform.grid1.ColumnCount =9 thisform.grid1.RowHeight =25 thisform.grid1.Column1.controlsource='srl_num' thisform.grid1.Column2.controlsource='emp_id_1' t
  • data envoirnment
    by Ahsan Amin
    3 Replies
    Last post by Vladimir Zografski
      • I have to fill a combobox control with a table field. The combobox is placed on the form and for has data envoirnment inwhich two table are related with each other.
  • reading a directory for a existing files
    by Novelle
    14 Replies
    Last post by Novelle
      • hi there! im new to vfp and i want to make a programm that reads a certain directory and which gives me back the number of the files in that directory and the filenames. can someone tell me how it works in vfp it will really be great... thanks in advanced! novelle
  • Miniprinter tickets
    by LALO572976
    2 Replies
    Last post by LALO
      • How can I print tickets with a miniprinter in Visual Fox
  • Little Doubts with Reports - Tables Area...........
    by Paramu
    6 Replies
    Last post by Orkutian
      • Hi there, I have a problem with my reports preview. Actually I used a free Table and its used in area12 [Select 12] in a form. And the Report - Preview is through a command button of a Form¡­ In Command- Window the report is working good [ie. . Do form ¡°abcd1.scx¡±]. At the same time after compiling EXE, if I click the button its¡¯ saying error something like¡­ ¡­¡­¡­.. ¡°File Does not exist¡± But i