Visual FoxPro

Page 14




  • Topics
    Replies
    Last post
  • Copying from one sheet to another within the same book
    by Sleepgone
    3 Replies
    Last post by CetinBasoz
      • I am creating a workbook for a local company using excel. I've got most of the book worked out except that when information is input into the "main" sheet I need the same information - the entire row - copied over to another sheet within the same book depending on certain criteria. In other words, if the value in a column is 2 then copy the entire row to sheet 2, if it's 3 then copy to s
  • system messages (sendmessage api)
    by fvp4ever
    6 Replies
    Last post by fvp4ever
      • I'm going to get system messages sent to my forms for example wm_devicechange which sent by os but I do't know how to do that. any idea thanks
  • 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
  • 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
  • Indexed field problem
    by Ravindra Patil
    3 Replies
    Last post by Ravindra Patil
      • hi generous friends, i m using vfp 6. I have a form with data environment having a table that is indexed on 3 fields with tagname reg_no, name, surname. my form has four record navigation commandbuttons viz. top, prev., next and last. When any navigation button is clicked I want to move the record pointer in sequence of the first tag i.e. reg_no. So i have given command "Set Order to re
  • Not Enough Memory o Complete the Operation.
    by AlexBB
    14 Replies
    Last post by AlexBB
      • There is a chance that this is not the forum where I will ultimately get an answer since I do not know where the root of the problem is but still I am asking for everyone's attempt to brainstorm. It is actually a continuation of the previous notorious PACK <tableName> thread. Since I felt that I ran into a stonewall I devised a DEVIOUS (!) plan to crack the problem. It appears to ha
  • Modify Structu Ctrl Arrow-Up and Arrow-Down
    by rwsgy
    3 Replies
    Last post by Craig McGuff
      • Using VFP6 and 8, I remember when modi stru a table, I was able to use the Ctrl-Arrow down and up to move fields up and down. But now it doesn¡¯t work. Any idea how to make it work TIA (thanks in advance)
  • DBF to CSV conversion
    by ram_mv
    13 Replies
    Last post by dni
      • Hi, I am converting a dbf file into csv file using C#. My program is working fine for file having fewer columns in dbf file. If the dbf file has more than 255 columns, I am getting the error "FILENAME" is not a table. I am using Visual foxpro OLEDB friver. I downloaded drivers from http://www.microsoft.com/downloads/detai ls.aspx fa milyid=e1a 87d8f-2d58 -491f-a0fa -95a3289c5 fd4&
  • create a key in registry
    by le tan duc
    7 Replies
    Last post by le tan duc
      • Please help me to create a key (Keyname='key name') in it: String name: (defalut) Type: REG_SZ Data: "Agribank" Thanks.
  • Code in VFP9 runtime application scrolls on screen.
    by Derek Dowle
    3 Replies
    Last post by Naomi Nosonovsky
      • I have a routine in an application to export data to an Excel Workbook that runs as designed in the development environment but not in the runtime environment. When exporting data there are two particular errors that need to be trapped. The first is when the name of the file already exists. In this case VFP appears to be able to resolve the problem automatically, without the n
  • Errors running FoxPro Stored procedures in .NET windows app
    by TechMate
    10 Replies
    Last post by TechMate
      • Hi I want to run a stored procedure in user selected database which basically creates two new tables to be persisted in the same database. I am able to call this stored procedure but I keep getting the same error "One or more errors occurred during processing of command." There are no details of what the error is specifically about. I am able to run the same stored procedure using Mic
  • Sterling Pound Sign...
    by Pablo Jord
    2 Replies
    Last post by dni
      • Hi All, I am printing some dividend cheques at the moment for a customer of ours. I am using PCL codes through FoxPro for Dos. For some reason when I try to print the ¡ê sign to denote the conversion to sterling the pound symbol will not print. I can print the symbol on my laster printer but it will not print on our printronix printers. Has anyone had this problem Thanks for your help.
  • odbc driver
    by vhockz
    2 Replies
    Last post by Alex Feldstein
      • im using visual foxpro 7, and need to add odbc driver, but there was an error that i need to install current version of odbc driver. The problem is i didn't know rhe specific file that i need to download. tnks
  • 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
  • Printing Query Results
    by Dohko
    9 Replies
    Last post by Naomi Nosonovsky
      • Hi I have a table that has one column with numbers 1 to 51. I would like to know how can I write a statement that will let me Count the frequencies of each number and store it in another column in the table. I would also like to access this data with a variable for example n=1 for n=1 to 51 numbers frequencies endfor Thanks
  • do I have to close tables in DE?
    by Lightening
    9 Replies
    Last post by Naomi Nosonovsky
      • I have several tables in the DE of a form. When I close the form, do I have to Select myTable Use ..... to close these tables in the Destroy or Release event Or do they automatically close by themselves when the form is released
  • textbox length
    by Ahsan Amin
    10 Replies
    Last post by PB_UK
      • when i enter something in the text box the cursor automatically moves to next record ater entering 30 characters. I have not set it's lenth. so what's the reason
  • 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
  • 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
  • Why my VFP exe file cannot be launched?
    by Lightening
    9 Replies
    Last post by Lightening
      • I complied my program under VFP6 into an exe file in the program folder. But it cannot be launched. I believe there is nothing wrong with the code, because I just made a minor change. The funny thing is that if I copied the file to other folders on the same drive, it works! And even more wear is that some old version VFP exe files could not be launched from within that program folder, either. I
  • How to avoid "Saveas" dialog box while using IE ExecWb(4,2)
    by Tang Jian
    8 Replies
    Last post by Claude Fox
      • Dear all, I want to save all contents of a web page to local harddisk automatically, pictures included if any. But while I use the following code, the dialog box shows. Any one have good ideas *****mycode in vfp9, Windows XP, ie6******** ee=CREATEOBJECT("internetexplorer.application") ee.Visible =.t. ee.Navigate(" http://www.baidu.com/ ") wait window "wait for a
  • serious problem using VFOX9! INCREDIBLE! HELP! HELP!
    by Zava Matteo
    4 Replies
    Last post by CetinBasoz
      • Please contact me: matteo.zavattari@elmec.it (the alert don't work) Hi all, we¡¯re facing a serious problem using VFOX9. This problem is not contained in the previous versions of VFP (8,7,6). This occurs when two or more different users share the same table using the optimistic buffering (5). This happens on a network or simply using two different instances of VFOX9 on the same PC. Sharing tab
  • 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.
  • Not a table message...
    by Pablo Jord
    4 Replies
    Last post by Pablo Jord
      • Hi All, I have a Visual FoxPro table which I use as a backup table. I have a lot of records in it at the moment. When I was trying to open it yesterday I got the following error: Not a table. I can't seem to open the table at all. The table must have got corrupted etc. Is there any way I can retrieve the contents of this table without having to do a restore from a previous backup. Pablo.
  • Separators in toolbars.
    by Aleniko
    5 Replies
    Last post by Naomi Nosonovsky
      • Hi; Is there a way to add a seperator visualy into a toolbar between existing command buttons... WITHOUT GOING INSANE :-) Thanks, Alen.