Visual FoxPro

Page 244




  • Topics
    Replies
    Last post
  • how to gather m. variables from a form into table where it's updated in a procedure outside the form
    by ibbm
    14 Replies
    Last post by dni
      • Hi, I have created a form to update/add info into a table depending on the actions. I use a prg file for the actual update as this routine is used in several other procedures outside this form. in the INIT() of the screen I either do a blank screen if an add or display the record if it exists. I do this with a scatter memvar command. The objects on the forms have controlsources of m
  • Help me ! How to add controls to Pageframe at runtime ?
    by Lego NXT
    4 Replies
    Last post by Don Higgins
      • Please tell how to add controls (ex : grid, command button, check box ...) to pageframe and coding event click of them at runtime Thanks
  • How to determine time elapsed between 2 DATETIME()'s
    by rpp
    6 Replies
    Last post by MarciaAkins
      • How does one use the DATETIME data. I need to figure how much time has elapsed between two date time stamps IN: 10/08/2007 08:52:47 AM OUT: 10/08/2007 12:11:33 PM Is there an easy formula to provide the exact hours and minutes Thanks in advance Richard
  • VFP9 with VB6
    by Doug Gerlach
    7 Replies
    Last post by Tamar E. Granor
      • i have an existing app written in vb6 that queries foxpro tables. it currently works in version lower than VFP 9 what i am running into is that when i am doing a database open and set the uses if i dont wait a second between uses calls, the first query i run give me an unknown alias. if i wait between the uses calls it works fine. my code is below is there anything i am missing Public
  • Search the subfolders from different folders
    by Karan CHAN CHAN CHAN
    9 Replies
    Last post by CetinBasoz
      • Hi all, I am preparing a small program, the main idea is to convert the txt file to .dbf. There is an "A" folder contains 405subfolders, i have to convert the file from the subfolder of "A" to subfolder of "B" ("B" folder also got 405 subfolers which have the same subfolder name with "A"). Now the problem is --> how do i se
  • passing variables to reports without declaring them as public.
    by ibbm
    3 Replies
    Last post by CetinBasoz
      • I have programs that set variables for certain fields to print on reports. How do I pass variables to these without making them public My program is something simple like this: declare variables as public set variables depending on the user selections select table.* from table INTO CURSOR Confirm CREATE REPORT rname.frx FROM Confirm WIDTH 640 COLUMN NOOVERWRITE REP
  • Convert to original source code
    by Bit
    2 Replies
    Last post by dni
      • Hi, Is there a way to convert an exe dbase IV program back to the original source code or .prg form to study Afterwards, it will be rewritten in foxpro format. Regards, BIT
  • Foxpro's Dirty Little Secret?
    by rHowe11
    8 Replies
    Last post by rHowe11
      • Arrgg! If I had a dime for every hour I've spent wrestling with Foxpro's error handling paradigm... Here's a new gotcha: Apparently, when an error occurs in a combo box valid event handler, and the error is handled by a try/catch block outside of the form, a reference to the combo object is stored in some mystery memory location, preventing the combo box (and thus the form) from being destro
  • "Cannot find the menu-generation program."
    by AlexBB
    14 Replies
    Last post by AlexBB
      • Hi there, I actually posted on this subject twice before and once got a satisfactory answer, the other time I simply figured out how to get this file myself. Now it seems to be different. When I make and attempt to build a project I get this message. So, I click Add, go to Program Files\Microsoft Visual FoxPro 9\ and find a file: genmenu.prg . Click on it and I get another error message:
  • Using VFP to bold a row in excel
    by mrfitness
    14 Replies
    Last post by Alex Feldstein
      • I have a program that returns the value of a query and places it into excel. But I also entered a row of static text as headers. I want to bold the columns I want without doing a statement for each individual cell to be bolded. I cannot remember how to bold a selection of more than one cell in one command line. i.e. .sheets[esheet].cells(1,1).Value = "Contractno" &&COLUMN HEADER
  • form help
    by NILKAMAL
    4 Replies
    Last post by NILKAMAL
      • hi! i am new in vfp now i am creating new proj and icreate form with theree grid i would like to auto increment id field (tab not to stop on this field) also when i click add buton it will refresh only parent form field ( not grid field) thanks lavesh
  • Display the content of a cursor
    by Bit
    4 Replies
    Last post by Lakshmi N
      • Hi, I use select temp_cursor browse but the program just display nothing and carry on the next step. What is wrong with it Regards, BIT
  • Form Variables
    by cdaviduik
    5 Replies
    Last post by MarciaAkins
      • I am passing two variables to a form, then using them to initialize values in the form using the init method. The first line of the init method is: PARAMETERS EFIELD, ETABLE I am able to access the variables EFIELD and ETABLE without a problem within the init method but I also want to access them when another method is called on the same form, say for instance a button press. Any ideas on how to d
  • Know of any graphics libraries for VFP 6?
    by TheLoon
    5 Replies
    Last post by CChalom
      • I know Foxpro has never been great at graphics. I've only seen it smack a bitmap on the window. Are there any (preferably free) .DLLs, code or libraries that enhance VFP 6 graphic capabilities
  • DCT FILE
    by dni
    14 Replies
    Last post by dni
      • I have a huge dbc data base. It is working perfect in vfp 7 sp1. When I am trying to use it in vfp 9 sp1, I receive a error in DCT file when I try to browse or use some tables (not at all, jus few tables).
  • About creating PDF Report using VFP 9.0
    by ashishvjoshi@hotma
    8 Replies
    Last post by ashishvjoshi@hotmail.com
      • How to create PDF report using vfp 9.0
  • sample class library
    by jmom
    6 Replies
    Last post by jmom
      • I have access to VFP6,8, &9 class libraries, but not everyone does. I tried copying a classes folder that has a datachecker from a samples.vcx from a local directory and copy it into a shared folder. When rebuilding project, it had a message saying could not find a MAINHWND and other Procedures. I tried searching for the names it provided, but no luck. Is there a datachecker sample in the V
  • Image in General Field VPF 6.0
    by Girish Kumar Sharma
    2 Replies
    Last post by Girish Kumar Sharma
      • Hello, 1. I scanned an image (candidate's photo) and saved it as BMP file. 2. Append General <myfieldname> from <filename with path> 3. When I see/print the image from Report; it also display and prints the bmp file's name and shrinks the image in a hazzy manner. Why it is so Please guide me how to remove the above problem. Thanks & Regards
  • 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
  • How to remove redundant phrase in field?
    by Littletommy
    14 Replies
    Last post by Littletommy
      • Hi all........ I have a table field that contains things such as..... V DISCONTINUED W/O REPLACEMENT; V DISCONTINUED W/O REPLACEMENT -I&S MASTER; 7 SUB 2610-139-3704; I&S MASTER; 7 SUB FOR 2610-139-3704 What I need to do is remove the duplicate phrases, leaving only one instance of each phrase in the field. The amount of phrases in the field varies...could be 2 as shown abo
  • how to store encrypted passwords ..
    by ibbm
    9 Replies
    Last post by Mark OSVATH
      • is there some kind of algorithm in fox that can store and encrypted password so that if anyone got a hold of the data they couldn't read the password. Thanks in Advance
  • Dbf Autoincrement with ADO
    by Walker Boh
    14 Replies
    Last post by dni
      • Hello everybody, I created a table with an autoincrement field( CREATE TABLE `Synch_LogFile` ( `ID` I Autoinc NOT NULL, `TableName` C (100) NOT NULL, ...) ) when I try To open it by ADO with VB (Select * From Synch_LogFile) I get this error message: [Microsoft][ODBC Visual FoxPro Driver]Not a table. What's I'm doing wrong Thanks,
  • Close button on Print Preview toolbar
    by sanj
    4 Replies
    Last post by MarciaAkins
      • Can you modify the Close button on Print Preview toolbar in Visual Foxpro 6.0. I need to remove the picture of Close button and put the text "CLOSE" on the button. can you do this in VFP 6.0 Please help. Thanks, Sanj.
  • 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
  • How to determine time elapsed between 2 DATETIME()'s
    by rpp
    6 Replies
    Last post by MarciaAkins
      • How does one use the DATETIME data. I need to figure how much time has elapsed between two date time stamps IN: 10/08/2007 08:52:47 AM OUT: 10/08/2007 12:11:33 PM Is there an easy formula to provide the exact hours and minutes Thanks in advance Richard