Visual FoxPro

Page 124




  • Topics
    Replies
    Last post
  • Locate Command
    by Ahsan Amin
    7 Replies
    Last post by hangover
      • I have to locate the CourseID field from a table. I have a combo box that list the CourseName field. CourseID CourseName ------------- ------------------- 1 SE 2 VFP 3 ASP Now if use select VFP from the Combo i want the courseid 2. I am using the follwoing code LOCATE FOR a_Courses.CourseName = thisform.cb
  • calculating the difference between two dates
    by zahj
    5 Replies
    Last post by Lakshmi N
      • hi! does anyone know how i can compute the difference between two dates example: Date1 = 03.15.2007 Date2 = 03.16.2008 output should be : 0 Months 1 Day(s) 1 Year(s) tnx...
  • 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
  • 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
  • Ambiguous Date/Datetime constant
    by Brad Corbett
    4 Replies
    Last post by CetinBasoz
      • Bare with me, I'm not a Foxpro guru. I'm writing a console app in VB.net. I am trying to write data to a Dbf file. In VB I was getting a "Data Mismatch" error, so I took the insert string and executed it in Foxpro. After figuring out that you have to Put curly brackets around the date values I started getting the following error: Ambiguous Date/Datetime constant. Use format: {^yyyy-mm
  • Locate Command
    by Ahsan Amin
    5 Replies
    Last post by Fox Me Up
      • I am trying to compate a textbox value with field value and using found() function to check if found or not. I am entering the same value as it is in a table field but found() function returns false. I am using the following code: LOCATE FOR ALLTRIM(SubName) == 'thisform.txtSubName.Value' IF FOUND() MESSAGEBOX("This subject already exists") RETURN ENDIF
  • Request to Refrain from Linking to UT Threads
    by AndyKr
    14 Replies
    Last post by AndyKr
      • I have removed the posts on this topic, and combined them, into a single, separate thread to avoid cluttering up a genuine quesion: Naomi Since you have withheld your E-Mail address I must post this caution publicly. Please do NOT refer to "for-profit" sites - like the Universal Thread - in replies on this forum. The reason is that the Universal Thread is not
  • Performance of Foxpro OLEDB
    by cajin
    13 Replies
    Last post by CetinBasoz
      • I am working on a project which accesses foxpro 9.0sp1 database through OLEDB. The datbase has about 1million records. My code simple and straighforward just like below, conn.Open(); OleDbCommand cmd = conn.CreateCommand(); cmd.CommandText = "DELETE FROM mytable" cmd.ExecuteNonQuery() conn.Close(); But it will take a very long time to mark all records as deleted
  • VFP PopUp Menu In Vista
    by PeterSvi
    6 Replies
    Last post by Vladimir Zografski
      • I have a FoxPro 9 SP2 application and works just fine in WinXP machine. However in Vista (Windows Theme Vista), the submenu is always poping up at the left side of the bar even if it's running out of space. The result is that always something got cut off because part of the submenu is outside the range of the screen. I see other people posting the same question on the web but I was never able to f
  • VFP6 to VFP9 broke Dataenvironment.OpenTables
    by GeofS
    12 Replies
    Last post by Tamar E. Granor
      • The <form>.Load() code below, which used to work fine with VFP6, now generates a syntax error (Error #10) after compiling with VFP9. The error occurs on the OpenTables() line. It occurs with multiple forms, all of which have their AutoOpen and AutoClose properties set to FALSE. What has changed to break this simple code local lReturn with this if type('.dataenvironment') = 'O' * m
  • Putting string into OleRtf control
    by Eddie N
    2 Replies
    Last post by Eddie N
      • I am programming using VPF 9 and RTF control (oleRtf) to display a text string (after appending RTF header and footer). I use the selRTF method to display the string in the oleRtf. Code Snippet ** my_sentence is the string DO FORM showstr_edit NAME frmShow frmShow.oleRTF.selRTF = my_sentence All seems to be okay. But everytime I refresh the form and put another string to display, it
  • "Multiple-step operation generated errors. Check each status value."
    by Steve-0
    14 Replies
    Last post by Steve-0
      • I am getting the following error when trying to update an existing Foxpro database using the VFPOLEDB.1 provider and ADO: "Multiple-step operation generated errors. Check each status value." I have tried about every combination of cursor types and locations but cannot get it to work. Here is my code: Dim ADODBConnection As New ADODB.Connection() ADODBConnection.Con
  • Trying to make a simple "Hello World" type program..
    by TheLoon
    2 Replies
    Last post by Alex Feldstein
      • This is the ultimate Foxpro n00b question. Please ignore it if it annoys you. Trying to get back into Visual Foxpro 6. I figure the best way is to attempt a "Hello World" type program with just a form and a button with no code. I create the project and then create the form. I then added a button with no code. It compiles just fine but when run stand-alone the form appears for a brief second and ex
  • 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
  • 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
  • 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
  • query on report designer
    by RavindraPatil
    2 Replies
    Last post by MarciaAkins
      • Hi all, I use vfp 6. I have a report's data environment connsisting 2 tables say, a and b. and table a is related to table b. I want to display all the records in table A. but when I run the report , the record pointer in A does not move forward. Instead of that record pointer in B moves. How to solve this problem
  • Viewing pdf
    by gamease
    6 Replies
    Last post by Naomi Nosonovsky
      • Can someone show me how to view pdf file in a form (.sct)
  • 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
  • Possible Bug in Foxpro 9
    by Anonymous584079
    3 Replies
    Last post by Carl Warner
      • Foxpro 9 on my laptop seems to loose conection to tables. I will open a database and a table located on my laptop. I browse the the table. I leave my laptop for a few minutes and try to browse again and I get an "Open" table dialogue box. This happens every time on my laptop but never on any other computer. Any Ideas
  • wait windows
    by jmom
    4 Replies
    Last post by Naomi Nosonovsky
      • Is there a way to change colors on wait windows so they stand out more
  • COM Interop
    by rHowe11
    2 Replies
    Last post by rHowe11
      • Hi, I have a large Foxpro business application that needs COM interop with a NET application I wrote for providing online help. I was able to integrate the two in a manner similar to that described in Rick Strahl¡¯s "Accessing .NET Objects Through COM" ( http://www.west-ind.com/presentations/VFPDOTNETiNTEROP/VFPDOTNETINTEROP.HTM ). After compiling the .NET proj
  • Change default printer works only once
    by CFutino
    6 Replies
    Last post by DaCosta11
      • This one is weird... I use the followin function to change my default printer: FUNCTION SetaImpDefa(imp,muda) Declare long WriteProfileString in "kernel32" ; string lpszSection, string lpszKeyName, string lpszString Declare long SendMessage in "user32" ; long hwnd, long wMSg, long wParam, String lParam if muda HWND_BROADCAST = -1 WM_WININICHANGE = 26 endif printer_name = imp printer_buff
  • Connecting VB6 for FoxPro 9.0 tables using DAO ?
    by AnonymousKnee
    2 Replies
    Last post by Cindy Winegarden
      • Hi, Does anyone know if it is possible to connect VB6 to FoxPro 9.0 tables using DAO (i.e. Set db = OpenDatabase(dbDir, False, False, "Foxpro 2.6;") I know I can connect in another way, but I have an old bespoke program that uses this connection and recordset type for a 2.6 database but they are upgrading their database so I'd like to make minimal changes to the code. thanks !
  • How to import data from csv file
    by surinder singh
    7 Replies
    Last post by CetinBasoz
      • Hi all How to import data from csv file. Csv file : name,add,description ( delimited with ,) Table fields: name c(20), add c(20), description M I am using append from command but "description" field getting nothing. Thanks