Visual FoxPro

Page 116




  • Topics
    Replies
    Last post
  • Microsoft is going open-source the core portions of the Visual FoxPro DBMS!
    by Fernando D. Bozzo
    12 Replies
    Last post by Fernando D. Bozzo
      • I want to be between the first ones to bring this news: http://www.eweek.com/article2/0,1759,2105307,00.asp !Can't believe that! Best regards, Fernando D. Bozzo
  • Field names from excel import
    by Mochalatte
    2 Replies
    Last post by Naomi Nosonovsky
      • I'm fairly new to VFP. I'm importing an excel file to use as a table. Two questions: Is there an easy way to change the field names from A,B,C,D to the actual names, perhaps in the import procedure Also, where is the table stored once it is imported
  • Expecting Advise on A Graphics Problem
    by Lord Arokh
    3 Replies
    Last post by Lord Arokh
      • Hi Everybody, I've project, that I have to use a custom worldmap and show some other drawing according their coordinates.Now I managed to draw the worldmap with FORM.LINE method. To zoom in/out I have to scale the worldmap. When I scaled 10x or much more times I can see the part that is on the form. And the other parts of the worldmap which is extended out of the form is lost. Because the LI
  • DotDotDot
    by Aleniko29139
    1 Replies
    Last post by AndyKr
      • I've noticed when I use reportbehavior 90, fields must have a certain size, otherwhise VFP shortens them and adds DotDotDot at the end. I've also noticed that there is some padding to the required size. In other words its not easy to put 2 fields very close together on a report form. For ecample, if I want to put a date range on a report with a dash in between... I'm sure I'm doing something dumb
  • ComboBox Control
    by Ahsan Amin
    14 Replies
    Last post by Naomi Nosonovsky
      • I have to to fill a combo box control with a table fiels with 'Please Select' at top.
  • vfp9 error reading file 1104 on server 2003
    by Caio Pordeus Junior
    5 Replies
    Last post by dni
      • I have a windows server 2003 R2 Enterprise edition service pack 2 with Sql server 2005 and vfp9, where users access the data via a mapped share. I use the server as a file share and run it from some other machine or terminal server or citrix ; sometimes i get a "error reading file" on this type of files: error reading file s:\xxxxx\xxxxx\nnn.fxp where nnn.fxp is a file that is include
  • How to send email by using default email client installed on user's machine
    by surinder singh
    5 Replies
    Last post by surinder singh
      • Hi All, I want to know if there is any way to send email in foxpro through default email client installed on user's machine. I am using MAPI currently to send emails. Thanks
  • adding carriage return and line feed through foxpro oledb provider
    by dsa1971
    4 Replies
    Last post by CetinBasoz
      • Using ado.net with the foxpro ole db provider I am trying to insert a record in the database that has a memo field. In the memo field I am trying to add some data seperated by a carriage return and line feed. Unfortunately, when I run it I keep getting a "Command contains unrecognized phrase/keyword" oledb exception. I have tried using string concatenation to add my parameter values to m
  • MS Access importing visual foxpro tables
    by Dave Mosby
    14 Replies
    Last post by Dave Mosby
      • Win XP Pro - Access 2003 - current ODBC driver for VFP Set up an ODBC connection via control panel/admin services using a free table directory - the target directory has many dbf files that are visible in the "browse" window - - I then try to use the Access link table "wizard" - choose ODBC connection - - select the ODBC link I created - - the "wizard&qu
  • How to create a VFP program whose name should not be shown during runtime in task bar, task list, systray ?
    by nrpanda
    4 Replies
    Last post by LeoLems
      • Hi, I need a VFP program whose name should not be shown in Windows Task Manager list, neither in Task Bar nor in System Tray during run-time. How can i achieve that Can it be done through VFP 6.0 Any example or idea plz With regds. nrpanda ----------------------------------------------------------- A VFP 6.0 Programmer
  • 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
  • Command Window in Vista
    by AlexBB
    14 Replies
    Last post by Tamar E. Granor
      • I hope Tamar Granor will read it. It seems she may be familiar with Vista. I have touched on this problem in my previous post. In VFP 9 Management Studio under Vista, the Command WIndow behaves like the mouse cursor/pointer when you set it up in slow motion and with traces. In addition it frequently bounces back to the place it started. It is unbelievably weird. It is very very, and I mean
  • Assigning an array to an Activex property
    by Mike@hcc
    8 Replies
    Last post by Mike@hcc
      • I am using VFP9, Sp1, and am trying to assign an array to an Activex property but I keep getting a "type mismatch" error. Using the same control and similar code works using VB6. Using the object browser shows the property to be of type variant and at runtime, using the debugger, shows it to be an array of type "Z", and the array I'm passing to be an array of type "A"
  • importing from excel
    by JonathanVickers
    11 Replies
    Last post by Naomi Nosonovsky
      • Hi, I'm struggling to import from an excel spreadsheet into foxpro. The problem is there's a "remarks" column in the xls which may contain more than 255 characters, so I want to import that column as a memo field. I've tried using APPEND FROM, but that's just putting nulls in the field. I've also tried IMPORT, but that just gives me a character field. I've tried setting up an ODBC connec
  • webbrowser newwindow event
    by Ivan Horvath
    3 Replies
    Last post by Warappa
      • Dear All, in our application (VFP7) we are using MS WebBrowser control. it is working well, except in one case. we don't allow the new window action. according to the documentation the NewWindow2 event is fired when the user tries to open an url in a new window (right click - selecting Open Link in New Window menu, shift+click, etc). i can catch this event, and returns as cancel=.T. everything
  • 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
  • Outlook 2003 won't open
    by Dan562562
    1 Replies
    Last post by CetinBasoz
      • My outlook 2003 seems to have froze. When I click to open outlook it won't open it seems like it's trying but then times out. I have recieved no error messages it just seems like theres an icon to open it but no program. This is a new occurance, I have never had any problems before. Please advise. Thanks Dan
  • How to fix grid headings?
    by Lightening
    5 Replies
    Last post by AndyKr
      • Can we do that It does not help if I set: AllowHeaderSing=.f.  
  • How to Copy 2 worksheet from one excel sheet to to 2 Worksheet of another Excel Sheet
    by aditya_050484
    3 Replies
    Last post by CetinBasoz
      • var xlApp, xlWB, xlSheet,f2,fso,oBook,oSheet,oBook1,oSheet1,idTmr; xlApp = new ActiveXObject("Excel.Application"); fso = new ActiveXObject("Scripting.FileSystemObject"); if(fso.FileExists("c:\\Example.XLS")) { f2=fso.GetFile("c:\\Example.XLS"); f2.Delete(); } xlApp.Visible = true; xlApp.DisplayAlerts=false xlWB = xlApp.Workbooks.Add(); xlWB.Sh
  • userprompt
    by Dhabu
    4 Replies
    Last post by Naomi Nosonovsky
      • How to promt user to enter the date in prg file. once it is entered i would like to save it to variable. I am using vfp6.0
  • Some more Excel automation questions
    by Aleniko
    7 Replies
    Last post by Aleniko
      • Hi all; - Is there a way to lock cells so the excel user can't modify them - I am trying to setup an excel sheet where each line in the sheet may neet to have multpiple 'child items' which the user needs to create. For example an order line item which the user may need to break into different production status lines. Is this something that can be done in excel Thank you all, AK.
  • Why won't this commit to the local FoxPro Table?
    by rpp
    1 Replies
    Last post by Naomi Nosonovsky
      • Each time I run this statement on the form I receive the following error: Alias "txtdescription" is not found. UPDATE adtype ; SET adtype.description = ALLTRIM(Thisform.txtDescription.Value), ; adtype.rate = ALLTRIM(Thisform.txtrate.Value), ; adtype.priority = ALLTRIM(Thisform.txtpriority.Value), ; adtype.headingnum = ALLTRIM(thisform.cbopageType.Value) ; WHERE adtype.
  • Historical FoxPro
    by Dumarest
    5 Replies
    Last post by Dan Freeman
      • This is really historical, back when FoxPro was independent. I just had a full system crash, and now want to get my one database with FoxPro back up. It will not run. Calls for a dll which is in fact on the system, but indicates that reinstalling the .exe file is desired. But ...... That is years ago, and any source material is on 5 1/4 inch diskettes if I still have them [generally these have lon
  • Validations on Textbox
    by Ahsan Amin
    14 Replies
    Last post by Phil Brammer
      • I am trying to implement validation on textboxes placed on a form using ISNull function. I placed the code in a procedure and calling it on the click event of a button but does not work. I want also want to check for numeric and character data. here is my code IF ISNULL(thisform.text2.Value) then MESSAGEBOX("Please enter customer name") ENDIF
  • File is in use by another
    by RavindraPatil
    2 Replies
    Last post by Lakshmi N
      • Hi all, One of my client is using my inventory program (developed in FoxPro 2.6 for windows) for last 4 years without any problem. Two days before client's computer operator reported to me the following situation; "I just turned on pc. First thing I did after that is I started your program and suddenly got an error message 'FILE IS IN USE BY ANOTHER' and stopped on the line 'INDEX ON