Visual FoxPro

Page 220




  • Topics
    Replies
    Last post
  • Can I compile a stored procedure separately?
    by AlexBB
    10 Replies
    Last post by CetinBasoz
      • I am building a few stored procedures in VFP databases to run from my C# app. I hope I will be able to do it and if anyone has any experience with it I will appreciate comments. I have a question if the stored procedures could be compiled separately from all other code. Also, what are CLR stored procedures ow can they be related to the SP's stored in DB Is there any advantage
  • Can vFox9 printing using Excell worksheet layout!
    by johan2000
    6 Replies
    Last post by Naomi Nosonovsky
      • Dear sir,... One of the nice things about Excell is user can adjust font size, position, etc easily without the help of programmer!... (specially for printing TAX form, etc) If I have a record of data to be printed, and I wanted to print according the layout in the Excell worksheet, How can I do it Such that the vFox9 will print according to the layout/font size/style in the Excell form. Inside t
  • .
    by c y h
    7 Replies
    Last post by Markish
  • Problems Inserting fields into Table from cursor
    by Kadrin
    5 Replies
    Last post by Naomi Nosonovsky
      • I'm trying to add fields from 1 cursor table I linked from an SQL server (using SQLConnect()) and put them in another table. The 2 tables fields are the same in that they are meant to store the same information but the cursor table has a few NULL values, and the new 1 isn't allowed to have NULLS. I'm trying to check for NULLS and replace it with letters or numbers but can't find a way to so do. I
  • What is the recommended style in programming in VFP ?
    by Eddie N
    3 Replies
    Last post by Cindy Winegarden
      • I come from a dBase environment, hence I would prefer to start running my programs from PRG and occasionally call objects (Forms etc.) as needed. I am just wondering as to what style is recommended in VFP. Will it be better if I use FORMS and call the PRG from the forms or the other way round ...
  • Error : Not a table
    by RavindraPatil
    5 Replies
    Last post by Tamar E. Granor
      • my dear friends, I use vfp 6. I have a form with data environment containing some tables. The form worked perfctly for more than 2 months. Now tables have upto 500 records. When the program was started today, user unexpectedly got an error message like "not a table". I tried to open that table from command window with USE Command. the same error is displayed. Can I save those 50
  • problem with class
    by Fox Me Up
    3 Replies
    Last post by Budoi
      • i get the error ole error class is not registered...... what does this mean and how do i fix it i read the vfp help files on it but it was too confusing for me.
  • Selecting Cancel on a SaveAs dialog causes VFP to QUIT
    by Derek Dowle
    6 Replies
    Last post by Naomi Nosonovsky
      • I have a routine that exports data from a .dbf table in a vfp9 application to an Excel 2003 Workbook. By using the line of code 'COPY TO ( filename ) XL5' a system dialog box appears on the screen to enable the user to change the name of the file or the directory into which it is to be saved and then save the file. The dialog box is the same as the one that appears if the user
  • Ideas for accessing a remote table
    by Aleniko
    6 Replies
    Last post by navcool
      • Hi all; I am going to distribute an application to a few dozen customers. I would like to have a way for these sites to read/post info to a mysql table on the internet. Is there a way I can connect to a remote table but in such a way that the username and password for the connection would be hidden and secure I would also like to have the means of changing the password to the Mysql database and ha
  • cannot quit visual foxpro
    by HowardW
    14 Replies
    Last post by dni
      • Subject message appears altogether too often - during my development, user sessions, etc. Similar messages imply this could be caused by the task pane. I do not knowingly use the task pane and have the auto startup turned off. Sure enough it happened again - tried clear all; release all, clear events, sqldisconnect(0), etc. - all the things I could think of and tried before. No luck. Then I turned
  • Showing one form from another
    by Hans L
    11 Replies
    Last post by Hans L
      • Situation: I am in a form A, click on a cmd, and it opens another form B and hides the current form A. In form B, I click on a cmd and I would like to show form A and release form B. The release of form B works, of course, but not the showing of form A. I have never seen anything about whether it is possible to make changes in or affect one form from another. Is it (I guess it would work with a fo
  • (HELP) how to write a program for keyword search in memo field
    by fonn
    3 Replies
    Last post by CetinBasoz
      • I would like to seek help in writing a program in FoxPro 7.0 to open the memo field "expr" in many different reports, in which specific keywords "DUPLEX=1" or "DUPLEX=2" is stored in the memo field "expr". P.S. The keyword "DUPLEX=1" or "DUPLEX=2" is not the only things stored in the memo field. The keyword appears in different lin
  • visual foxpro to excel
    by Lakshmi N
    5 Replies
    Last post by PB_UK
      • Sir, I have 2 excel sheets. one sheet contains sapcode,sapname,grpcod,prdcod,amt another sheet contains sapcode,so many other fields and amt both sheet contains multiple sapcodes now my job is to 1. read first sheet into a dbf (sum(amt) group by sapcode because multiple sapcodes) 2. read second sheet into a dbf (sum(amt) group by sapcode because mul
  • Native Financial Functions in VFP
    by Lawr3nc3
    5 Replies
    Last post by Lawr3nc3
      • Anyone know how to simulate the financial functions in excel or vb.net
  • Can vFox9 printing using Excell worksheet layout!
    by johan2000
    6 Replies
    Last post by Naomi Nosonovsky
      • Dear sir,... One of the nice things about Excell is user can adjust font size, position, etc easily without the help of programmer!... (specially for printing TAX form, etc) If I have a record of data to be printed, and I wanted to print according the layout in the Excell worksheet, How can I do it Such that the vFox9 will print according to the layout/font size/style in the Excell form. Inside t
  • VFP and Word Merge
    by Stuman99
    3 Replies
    Last post by Stuman99
      • I am adding word automation to our VFP application. I like the ease of use of Bookmarks and have no problems navigating thru a document that has existing bookmarks. My problem is that users will need to create new documents and add bookmarks into the appropriate places of the new documentation. How do I provide the user with a pick list that will allow them to insert the available bookmarks. Is th
  • fox $
    by Fox Me Up
    4 Replies
    Last post by LeoLems
      • what do most companys charge per hour if a client wanted a custom applications writtin in foxpro
  • Do while/if difficulties
    by Anomaly
    3 Replies
    Last post by Don Higgins
      • Hi, I am working on a program and in part of it I am using the SEEK command. After it I need to know if it was found in order to continue, if !FOUND I need to repeat what came before the SEEK, is there a way to jump up a few lines in a DO WHILE
  • Outlook contact details
    by hangover
    14 Replies
    Last post by CraigBoyd
      • This might not be the right forum for this question given that it mainly concerns Outlook (although I am accessing it from VFP), but I am hoping that one of you smart and helpful people may know the answer ... I am trying to obtain to populate a VFP table with the details that I can see in my Outlook 2002 address book. I have had some success at obtaining details such as Name, Email
  • Please Select on ComboBox
    by Ahsan Amin
    10 Replies
    Last post by CetinBasoz
      • How to add 'Please Select' on top of the ComboBox that lists a table field. It's ContorlSource is set on form's Init event and other properties in property window.
  • Arrange the "character string" numbers in order
    by MillBear
    6 Replies
    Last post by CetinBasoz
      • I use the character string for number input. What Syntax should I use to sort out the ˇ°character-stringˇ± numbers as below For example: To sort out according to the number 1 1 12A 3 3 4 4 5 443546
  • initialising parameter for view
    by RavindraPatil
    2 Replies
    Last post by MarciaAkins
      • hi friends, I have used a parameterized view in my form. Parameter is m_no. Which event to use to initialise this parameter to avoid manual input each time the form is run. I used form load, form init and cursor init event. but each tinme input box appears. pl. help
  • Feature Difference between Academic and Non-Academic Version of Microsoft Visual Foxpro 9.0
    by nrpanda
    1 Replies
    Last post by hangover
      • Hi, Currently I am using VFP 6.0. I want to upgrade it. So I want to purchase Microsoft Visual Foxpro 9.0 (not the upgraded version, but the complete version). My vendor has both Academic and Non-Acedemic version. As he is a non-technical person, he does not know much except price and version. So I want to know the Technical Feature difference between Academic and Non-Academic version
  • dot matrix printers
    by jmom
    3 Replies
    Last post by Madix_t
      • Once again, I am asking about printing through terminal services. (Sorry!) At least one user has a dot matrix printer, he/she can print something out. The problem is the output is messed up on his paper. They described it like it was printing over and over on the same line.
  • FoxPro SQL help for Date Formats.
    by Robeen_S
    11 Replies
    Last post by CetinBasoz
      • Hi, I'm using this SQL in FoxPro: Select field1, field2, field3, substr(DTOC(datetimefield_1),1,10), substr(DTOC(datetimefield_2),1,10) from mytable.dbf where field1 = "searchvalue" It works. But I would like to specify that I want the datefields to be displayed in mm/dd/yy format rather than use the substr() function to truncate the datetime at the end of the yyyy. It seems