Visual FoxPro

Page 22




  • Topics
    Replies
    Last post
  • Should we leave Microsoft altogether?
    by Dave M.
    12 Replies
    Last post by Carl Warner
      • VB6 Dead, Foxpro Dead. J# Dead ¡­ Dot Net 1.0/1 Dead.. Now there are rumors of a freeze of WinForms Development to for a focus on WPF. WPF is not yet suited for data centric app (no grid control). No decent IDE out yet. There are even rumors of that the next version of windows won¡¯t support ANY 16 Bit App, and that the version after that won¡¯t support any 32 Bit app. What is
  • VB6 Time comparision - Needs help
    by Helloworld2482
    1 Replies
    Last post by CetinBasoz
      • I am comparing date then time to search the record in my transaction table, that table is having more then 50,000 records but some time is comparing and some time it does not can any body help me to solve immediate Dim cm_time as string cm_time="23:04:15" Set RS = New ADODB.Recordset RS.Open SQL2, FoxConn, adOpenForwardOnly, adLockReadOnly While Not RS.EOF If chk = False And SQL
  • Page setup settings in VFP9
    by Naomi Nosonovsky
    4 Replies
    Last post by Naomi Nosonovsky
      • Hi everybody, I found that if you open a report, go to File\Page Setup\Printer Setup\Properties and then change Print Quality (say, to economode or 300 dpi instead of default 600 dpi, this setting is preserved while the report is opened in design-mode, but when I save the report and re-check these properties, they are back to default. Note, that the rest of the properties such as tra
  • Printing Issue within REPORT FORM (rptfole) PREVIEW Command
    by emery
    2 Replies
    Last post by emery
      • When REPORT FORM (rptfole) PREVIEW is used to view report, the Print Preview toolbox shows up. If I click the Printer icon, instead of sending the report to default prinetr (e.g. HP laserJet), VFP9 program always invokes the Send Fax Wizard. Does anyone know how to resolve the problem Thanks for help. Emery
  • how to rectify updtbrn problem
    by ram2004
    2 Replies
    Last post by Bruno Yu - MSFT
      • how to rectify updtbrn problem in foxpro 2.5
  • Using SQL to create a multi-periods sum result.
    by Aleniko29139
    5 Replies
    Last post by AndyKr
      • Hi; I need to create a cursor with multiple columns listing sums of sales. For example: Product# 2006 Sales 2005 Sales 2004 sales 2003 sales 2002 sales Lets assume the table structure is simply ProductId, SoldDate and SoldAmount. This table obviously lists individual sales. Before I start xbasing my way into this, can I do this using a SQL select command Thanks
  • VBA to VFP code conversion
    by larz
    9 Replies
    Last post by larz
      • Can anyone help with converting the following from VBA code generated in Excel to VFP code: Sheets("Notes").Copy Before:=Workbooks("AB0KF3FK.XLS").Sheets(1) Thank you
  • How to resolve Invalid *.ftp file error
    by Lightening
    4 Replies
    Last post by Lightening
      • While trying to pack a table, got the error: Memo file xyz.fpt if missing or is not valid. The file is there and there is data in the memo field for some records.
  • OLEDragDrop errors
    by hangover
    5 Replies
    Last post by Naomi Nosonovsky
      • I have written a database application for logging requests, and I am trying to create additional functionality such that the user can drag and drop an Outlook email onto the application and it will automatically create a new record populated with the relevant details (e.g. request date, requestee, etc). I have got the 'difficult' stuff working fine - i.e. when an Outlook email is dragged an
  • NOT A TABLE
    by NGUYEN XUAN KHANH
    4 Replies
    Last post by Vladimir Zografski
      • RECENTLY I HAVE A TERRIBLE PROBLEM ABOUT DATABASE IN VISUAL FOXPRO 8. THERE ARE 400 DBF FILE IN MY DBC. 2 DAYS AGO, AFTER INPUTED DATA, I EXITED THE APPLICATION. THE NEXT MORNING I RAN THE APPLICATION, IT MESSAGE TO ME THAT "NOT A TABLE". I CHECKED AND FOUND THAT 300 DBF FILES GOT ERROR "NOT A TABLE". ALTHOUGHT MOST OF THEM WEREN'T INPUTED DATA AND POWER AND HARDWARE WERE IN GO
  • foxpro 2.6
    by mrsamankhan
    4 Replies
    Last post by DemoQa
      • Hi I have an client who is still using a FPD 2.6 app. I need to make some changes to it so he can use it for another year or so. I am using FPD 2.6 in Windows XP Professional SP 2. It works fine, but it runs in a small DOS emulation( (I suppose) screen. Is there a way to get it to run in a traditional DOS screen, eg where FP takes up the whole screen Or at least run it in a lasger window
  • Opening VFP tables with Fox2.6 (Dos)
    by Foxmonkey
    9 Replies
    Last post by CetinBasoz
      • Hello. I am a novice user of Foxpro, occaisionally using Foxpro 2.6 for Dos for data manipulation. I am wondering if there is an easy and free way to convert DBF files produced with Visual Foxpro with 2.6D. We get batches of files that are produced by some later version (it signs a "30" in byte zero of the header, while our tables have the "03"). I get a message stating it is
  • Array of chars to a character field
    by Spirtik
    2 Replies
    Last post by CetinBasoz
      • Hi, might be a noob question, i'm just starting to learn VFP, but here's it: I have an array (dimension 30), which i fill with letters (from A to F), after reading and validating them i try to copy (gather) the array to a field that is character (30) also, but it copies only one, first symbol. I've also tried to do it in a "do while" statement by _tmp=_tmp+A(i) , but it doesn't wor
  • vfpoledb.dll access violation
    by abhinaw
    14 Replies
    Last post by CetinBasoz
      • We are using a COM+ VB component to access data. It uses Fox Pro DLL ( vfpoledb.dll dated april 2002 ). we are getting intermittent access violation errors in our application. I am posting event logs at the end. The interesting line is the last line ( vfpoledb!DllCanUnloadNow + 0x2144e ) . It shows that vfpoledb.dll thows error while trying to destroy a resource ( DllCanUnloadNow). It looks l
  • search form
    by NILKAMAL
    14 Replies
    Last post by NILKAMAL
      • hi! can some one help me for this i want to creat search form as below 1) option button - fielda 2) option button- fieldb 3) option button - field c here is i place one textbox for user can put value and search button to search and if record found then go to my my form with this value thanks
  • arabic
    by bijansaba
    7 Replies
    Last post by Dina Lasheen - MSFT
      • hi i want write arabic in the textbox (right to left) what must ido
  • Referential Integrity problem
    by CChalom
    6 Replies
    Last post by CChalom
      • In one of my apps that I'm using the native DBC, suddenly a strange RI problem is occurring. Here's the error message: File '__ri_update_entr_itens.prg' does not exist . The problem occurs when i do an APPEND BLANK to the table "entr_itens". Then I checked my DBC, and found no entries for RI and this table ! Nothing on Delete, Insert or Update. Then I already PACKED DATABASE, VALID
  • Field validation rule.
    by AlexBB
    13 Replies
    Last post by CetinBasoz
      • With my new approach to VFP DBs trying to retrieve data into .NET via OleDb I am facing a few issues I previously ignored. I need to set validation rules for some character fields. The only reqirement is that there should be no blank fields. I used the VFP Management studio Table Designer. I tried a few clauses I thought would make sense but they all failed. MSDN does not give any examples
  • Data environment with MDI
    by Victor BA
    5 Replies
    Last post by AndyKr
      • I have an MDI form with a child form, in the MDI i have 1 textbox and 1 button, and i want to search for a record in a table (which is connected with the child form), but the results must be in the controls on the child form...i would think of this like...manipulate the data in another form, how can i do this Thanks
  • Write to Foxpro window from DLL
    by Eddie N
    3 Replies
    Last post by Eddie N
      • I am a beginner in C++. I develop a win32 DLL and call one of the functions from Foxpro. I try to write to the Foxpro window using putchar and _putch but it fails. What should I do Code Snippet DECLDIR void test (char*start) { char *start2; start2 = start; while (*start2) { putchar ((int)*start2 ++); } }
  • Page Breaks in Excel
    by tjreuter
    3 Replies
    Last post by CetinBasoz
      • How do I insert a Page Break in Excel using Office Automation in VFP
  • 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
  • DBCs and Citrix/ Terminal Server
    by Hitman99
    6 Replies
    Last post by MarciaAkins
      • Can any of you Foxpro experts help me I am involved in deploying network systems, and am often called on to publish Visual Foxpro apps through Citrix/TS to many users. To do this I am told that I must give each user an individual copy of the DBC file, which is a major pain since it then has to be copied to every user and consequently updated individually. Forgive me if this is a stupid ques
  • Pls...give me a command To Blink A Particular record in Listbox [VIsual Foxpro 9.0]
    by Paramu
    9 Replies
    Last post by Tamar E. Granor
      • Pls...give me a command To Blink A Particular record in Listbox [VIsual Foxpro 9.0] Actually I added few records in listbox...But I want to blink a particular record in listbox....pls...give me command... list box coding is thisform.list1.clear use abcd go top do while .not. eof() thisform.list1.additem("example") skip endd
  • Code in VFP9 runtime application scrolls on screen.
    by Derek Dowle
    3 Replies
    Last post by Naomi Nosonovsky
      • I have a routine in an application to export data to an Excel Workbook that runs as designed in the development environment but not in the runtime environment. When exporting data there are two particular errors that need to be trapped. The first is when the name of the file already exists. In this case VFP appears to be able to resolve the problem automatically, without the n