Visual FoxPro

Page 180




  • Topics
    Replies
    Last post
  • 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
  • check for filetype
    by ScottCamp
    10 Replies
    Last post by ScottCamp
      • Ok...I'm Back...LOL I'm trying to modify and old custom program someone made for us years ago. Simply to move files from one place to another. Everything works great. I'm trying to check if a file type exists in a directory (since the names will always be changing but the file type will always be a .jpg). If it does, then copy everything in that folder over. if a .jpg doesn't, then give a me
  • 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
  • Importing a Query to Visual Foxpro into an excel sheet
    by 970935726
    5 Replies
    Last post by Cindy Winegarden
      • Ok people. This is probably is very simple or maybe very complex. I need help and I am far from an expert. I have a Visual FoxPro database (9.0) in my C: drive. I want, from Excel, to query this database and throw the results into the current workwheet (or any worksheet for that matter). Eventually I would like to throw the results into the worksheet starting at a specific row. Is th
  • SQL Server Express & Foxpro-populating SS from Foxpro
    by drhoades32
    7 Replies
    Last post by AndyKr
      • I've placed more of the code at the bottom of this message. The problem is with the Insert command with SQLEXEC. If I use: lcStr = ["INSERT INTO SAUTHORS(firstname,lastname) values ('] + m.firstname + [','] + m.lastname + [')"] lnResult=SQLEXEC(m.lnConn, m.lcStr) The error I get says: Connectivity error:...Could not find stored procedure 'INSERT INTO SAUTHORS(firstname,lastn
  • CREATE TABLE, but where is it saved on the drive?!
    by Barts007
    11 Replies
    Last post by CetinBasoz
      • I¡¯m trying to create a new free table, which is a dbf file in FoxPro, but I do not understand where is it saved on the drive. Plus, I¡¯m getting a n error: ¡°Invalid path or file name.¡± I¡¯m using VB.NET,: SetConnectionString = "Provider=vfpoledb.1;Data Source=C:\VFP\myFile.dbf" ¡­. ExecuteNonQuery("CREATE TABLE 'C:\VFP\myFile.dbf' FREE (yr INT)") What'
  • 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.
  • Trouble getting dates in Report
    by Anomaly
    7 Replies
    Last post by Naomi Nosonovsky
      • Hi, Im creating a report and I need it to print out the from and to dates that the user has selected to search by. Do I simply put it in as the report variables Or is it more complicated then that
  • Email attachments when client is unknown
    by Aleniko29139
    1 Replies
    Last post by Alex Feldstein
      • Hi all; I know there are several different ways of sending Emails using VFP. I have an installation with different users who are using different Email clients including outlook, outlook Express and even AOL. What is the best way to use VFP to send an Email with an attachment, but using the proper client I'm not even sure that the mail client used is the 'default' one. Thx.
  • Importing data from Excel into a FoxPro Memo field
    by MartinnitraM
    4 Replies
    Last post by Naomi Nosonovsky
      • Hi I'm trying to import data from an Excel spreadsheet into a Foxpro v8 memo field using the APPEND FROM command something like this, but the field is blank after I run the append. CREATE TABLE "C:\Blah\TESTMEMO.DBF" NAME "TESTMEMO" (TESTMEMO M NOT NULL) APPEND FROM "C:\Blah\TESTMEMO.xls" TYPE XL8 SHEET "SHEET1" Any ideas how I can do this Th
  • Foxpro Code crashing windows 2003 server
    by Mitchman10
    4 Replies
    Last post by AndyKr
      • We have a non-programmer... a statistician in our office. He has written a data munching program in foxpro. The data resides on a file server. I have never seen this, but his program causes CPU Utilization to go over 70% on this server. It dose lots of scans, calculating, and then lots of ole automation to populate word docs, excel docs, and create pdf. Any thoughts on tips or tricks
  • Visual FoxPro9 Report Designer BUG
    by MariusR@R
    10 Replies
    Last post by VSCG
      • This issue is somehow related to CTRL+V (Paste) action of an object in report designer and TAG Memo field in .frx file. This is actually terrible thing because you can loose all your code in INIT procedure in Report. Steps to Reproduce: Just try to do the following actions: 1. CREATE REPORT 2. Add a Field box with some text 3. Open INIT procedure in data environment 4. Add some text
  • Import Excel 2007 files
    by Steve - Wise Software
    6 Replies
    Last post by CetinBasoz
      • Hi Sorry if this has been posted on here already but i'm unable to find an answer to my question. When trying to import files created in excel 2007 but fox is telling us that it doesn¡¯t recognise the format. I could understand the new file format not working as VFP has been out a considerable time but even if you save the file in "compatibility mode" as the old file f
  • 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
  • Grid Navigation
    by Dwntrdr
    3 Replies
    Last post by Dwntrdr
      • Hi All; VFP7 I am wanting to use special keys (CTRL-PGUP / CTRL-PGDN / CTRL-HOME / CTRL_END ) to navigate ( GOTO TOP / GOTO BOTT / First Col / Last Col ) within a grid. Has anybody done this I have been playing around with a forms's KeyPress() event and a grid (custom) keypress() event (called by the form keyPress() ). It's the CTRL-HOME / CTRL-END that's having problems. The current control se
  • date question
    by dvidal
    5 Replies
    Last post by dni
      • Hi, I have two questions about managing dates. First, anyone has a code example of how to work with date controls. Second, I don't know how to make jump a cursor in a text control. For example, the date must be entered in the format: dd/mm/yyyy and I want that when the user types dd, the cursor will be in the position mm (in other words, I want that the user don't type '/' character). T
  • Uploading data with multiple child tables
    by honey1016
    5 Replies
    Last post by Lakshmi N
      • What can i do in my uploading i was created it from forms i have a combobox that have 8 list of values, the one is the parent table and the rest are child tables I select it one by one to upload the data because for consolidation. I want is to transfer in program and I want is one transaction in uploading. I mean if I click the program or (do program) I will upload the 8 tables. But the parent tab
  • Any way to print multiple copies of a report from within the reportlistener
    by ControlNode
    5 Replies
    Last post by Naomi Nosonovsky
      • I have a table that the reportlistener uses for determining the printer that a report is sent to and that is working fine, but now the requirement has been added to adjust the number of copies of a report to print, or to disable a report all together. The settings screen and table have been updated to support "Print Count". The disabled part seams easy, if the Print Count = 0 have loadre
  • vFox9 vs PHP+SQL...
    by johan2000
    4 Replies
    Last post by Claude Fox
      • Can anyone tell me for Accounting program (such as General Ledger)... Is it better to use VFOX9 or PHP+SQL What kind of applications are much suitable for using VFOX9, and what situation will be preferable for using PHP&SQL Is there any document in comparing vFox9 and PHP+SQL or Where should I post this kind of question (a link would be appriciated) thanks you help!.
  • Need help with report expression
    by JCrum
    8 Replies
    Last post by JCrum
      • I want to evaluate two fields before I include it in my report. I'm not sure if what I have is correct, can someone help me with the syntax: IIF(EMPTY(grntradd) OR ISNULL(grntradd) OR PROPER(grntradd)=PROPER(mailaddr),"Not Available",PROPER(grntradd))) Thanks, Jennifer
  • VFP 9 SP2 and Reports
    by Paul Grenier
    3 Replies
    Last post by Naomi Nosonovsky
      • This code does not work with the files reportoutput.app and reportpreview.app (files both dated 2007) supplied with the beta VFP 9 sp2. SET REPORTBEHAVIOR 90 _reportoutput = "reportoutput.app" REPORT FORM BORPT PREVIEW It only works when the older version (2004) reportoutput.app and reportpreview.app files are copied and overwrite the 2007 files. Any ide
  • buffering and locking issues
    by jmom
    9 Replies
    Last post by CetinBasoz
      • In my project my form has a pessimistic row buffering. I did that so when many people are doing data entry at the same time, they do not collide and be on the record at the same time. Before CursorSetProperty("Buffering",2,"alias") when we hit the textbutton "add" it would act like we were on the same record in the table. We wanted to avoid this. I believe this wou
  • 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
  • Cursor adapters, ADO and Native VFP Data
    by CChalom
    14 Replies
    Last post by CetinBasoz
      • Hi, I've been using Remote Views to access native VFP DBC's.through ODBC. As I want to use some of the new functionalities of VFP data, AutoInc, Varchars, Blob fields, I was recommended to try using ADODB with Cursor Adapters. But I've found no samples using VFP native data... Can someone recommend be some kind of literature for that I was told that accessing data using AD
  • Include DB in .exe
    by hangover
    9 Replies
    Last post by hangover
      • Hi. If I include a database in my compiled application via the Project Manager, how do I then reference it and its tables Do I still need to open the database and tables or are they automatically opened Thanks.