Visual FoxPro

Page 33




  • Topics
    Replies
    Last post
  • 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
  • How to create a dBase III Table with a CDX index
    by Sergio Aguilar
    7 Replies
    Last post by dni
      • Hello, I'm trying to create a table of dbase with a cdx index, but when I create the index, the type of it is MDX, so I want to know if there is a way to create the dbase file with a cdx index in vb.net, tnx for your help
  • Positioning Dbf file in form/List Box
    by Gary Demi
    4 Replies
    Last post by Gary Demi
      • I have a form with a listbox, setting listbox.rowtype=6 (fields) and listbox.rowsource=seqlc.anum,customer,date,type,picture,pictfile,pictdir (fields) from a single dbf The DBF has an index on anum. (SET ORDER TO TAG anum) anum is unique, but not consecutive. When I use the up & down arrows & page up/dn within the the list box it works fine. The list is displayed correctly ordered by anum.
  • 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&
  • Need help adding a new auto increment integer field to a table
    by Rob2001
    5 Replies
    Last post by Aleniko
      • Hi     I have a table that I want to add a auto increment integer field. I go into the database designer, Right click on the table I want to add the field to then select modify. Then I insert a field and give it the name client_id set the type to Integer (autoinc) it defaults to a width of 4. Then I tell it to index it accending.    This works but on all the existing
  • Drop MS Outlook emails on a foxpro control and save it to a .msg ??
    by LeoLems
    3 Replies
    Last post by dni
      • Hi everyone, I am hoping someone can help me with this one... I am looking for a way to save a dropped MS Outlook email message to a .msg file The drop will be on a visual foxpro control (doesn't matter wich one) I just want the .msg file and nothing else.. But I want it in a drag & drop kind of style. It is similair to a drop of a email message on the desktop (
  • w 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
  • replace image with own name
    by NILKAMAL
    14 Replies
    Last post by NILKAMAL
      • hello! is any way replace my image with include reeno or any field data like i take image from my webcame and it store in one folder after that i use replace command so it save path in my field but when i replace that time image name want to change here is my code below DO [C:\Program Files\EZTwain\VFP\EZTwain.prg] TWAIN_SelectImageSource(0) * Get list of devices into memory TW
  • 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.
  • 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.
  • Error Installing VFP VS_SETUP.MSI
    by 12l
    14 Replies
    Last post by Anonym_123
      • ReInstalling VFP9 en mi W2k3 Standard SP1 the error message: "The windows installer: z:\vs_setup.msi could not be opened. Setup will not continue. This is a default response to an error. If you see this please save log files and RAID a bug." What happend Thanks
  • Thumbnail -Images
    by MM ROy
    10 Replies
    Last post by MM ROy
      • Sir, I am using Visual FoxPro 6.0 version. I want to view (like thumbnail) all the images of a folder (.jpg, .gif, etc.) using with visual foxpro form. The number of images may be varying. I have no idea....Please help... Roy MM
  • Farewell
    by AndyKr
    10 Replies
    Last post by Joe Morel - MSFT
      • Recent events, and postings, in this and other forums have convinced me that I am no longer able to act as a moderator in this forum and have asked that my moderator's privileges be withdrawn. I shall no longer participate in this forum and hope that whoever takes on the task will do a better job than I. Later: I have been asked to say where I can be found outside this fourm so yo
  • 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
  • Request to Refrain from Linking to UT Threads
    by AndyKr
    14 Replies
    Last post by AndyKr
      • I have removed the posts on this topic, and combined them, into a single, separate thread to avoid cluttering up a genuine quesion: Naomi Since you have withheld your E-Mail address I must post this caution publicly. Please do NOT refer to "for-profit" sites - like the Universal Thread - in replies on this forum. The reason is that the Universal Thread is not
  • My exe does not running other PC
    by mezofi
    14 Replies
    Last post by mezofi
      • Hi! I built a project and I have a big problem. It is run only my PC, and if I put it on a pendrive (exe). But if I put it on an other PC , this program show only main page. Then when I click someone button, the program show an error message: Command contains unrecognized phrase/keyword (Error 36) It is very strange, because if it is on my pendrive the program good have not got any error. Mez fi f
  • Unknown Classes Loaded in Memory
    by Terry Montgomery
    2 Replies
    Last post by AndyKr
      • I just realized a problem that we have been having and now I finally found out why. Now I need a solution to address it. The gist of the problem is that we have a Public class based on another user defined class. When we compile the project, the class definition gets left in memory. As a result we cannot delete the files (clean the build folder) without closing out of the foxpro session. If I j
  • Setting a date in VP 6
    by ibbm
    4 Replies
    Last post by ibbm
      • I want to set a date field to zeros I use to use "replace datefield" with {"00/00/00"} but vp 6 doesn't like it. Any help would be appreciated. Thanks
  • 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
  • SQL Select using variables
    by cdaviduik
    5 Replies
    Last post by cdaviduik
      • I would like to create a SQL SELECT statement in VFP9 but instead of specifying the table explicitly I would like it to be read from a variable. For example: TABLE_NAME = "table_to_select" SELECT * FROM TABLE_NAME; INTO CURSOR tbl_cur and when I execute the above I would actually like this to happen: SELECT * FROM table_to_select INTO CURSOR tbl_cur Any ideas on how to do this I have not
  • Passing values to a form
    by jan_sc
    3 Replies
    Last post by MarciaAkins
      • hi all, how can i pass values from textboxes lets say in form2 to form1 and then close form1 once i thisform.release form2, the values resetted. thanks in advance. regards.
  • Problem when updating!!!! Help!!!
    by pamtru
    10 Replies
    Last post by Naomi Nosonovsky
      • Hi i have a problem when running this query in shared mode or set exclu off. update table set field=5 It is very slow in a network or mapped drive. The crazy thing is that if the mapped drive is to a directory in the local computer it is very slow too. Example use c:\table shared update table set field=5 this go allright but now let suppose that i shared the fold
  • help needed on troubleshooting label printer problem
    by jimcjr
    9 Replies
    Last post by Naomi Nosonovsky
      • I've inherited a Visual Fox Pro application (originally written in Foxpro for Windows, but more recently compiled with VFP 7 and then VFP 9). It creates several different types of labels using the standard .LBX and .LBT files that the Foxpro label designer creates. (All of the users are running the application on Win XP SP2 machines.) The labels were designed using a Smart Label Printer Pro
  • Form Display Problems
    by MiamiFoxpro
    2 Replies
    Last post by MiamiFoxpro
      • I am having some problems that are similiar to the VIsta Aero problem where a border style is causing parts of a form to be transparent. I have a form with a pageframe on it but the pageframe does not go to the top of the form. There are some buttons between the the top of the pageframe and the form. When the application is started the form background above the pageframe is transparent. It is not
  • dates in vfp
    by jmom
    6 Replies
    Last post by CetinBasoz
      • Hello, my question is this: Is there a function to turn a datetime character into just a date character If not, I can figure out a way to work with using the DTOT() to convert my date expression into datetime format. Thanks for any future help.