Visual FoxPro

Page 173




  • Topics
    Replies
    Last post
  • TYPE
    by dni
    3 Replies
    Last post by Docpro777
      • I like to know what character will return function TYPE() from x, where x is: x=STR ( YEAR ( DATE ())) I think I have somthing wrong with my vfp 9 installation.
  • sending email from VFP through MS Outlook
    by glenna
    11 Replies
    Last post by Joe Au
      • We have the following code for sending email to Outlook. The email gets sent, but the font size is always 36 px or 36 pt (we tried both). None of the <cr><lf> show up. The email is one big paragraph. Can anyone help   Here is the code: LOCAL loApp, loEmailItem, cHex  lnsize = '"' + str(gaPointsize(Slcrm.nbodysize),2,0)+ '"'  cHex = ''  nDec = Slcrm.nColor  
  • 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
  • SELECT Statement
    by Somebody2
    2 Replies
    Last post by dni
      • I have a working select statement, but I want to select additional information from another database. Here is what I have so far - Code Snippet SELECT billing.parentid, billing.location, billing.timein, billing. timeout , billing.staff, children.age, children.first, children. last ; FROM billing, children; WHERE TTOD ( timeout ) between startdate AND enddate; A
  • Using VFoxPro 9 and SQL to create a table
    by Zaphod2003
    9 Replies
    Last post by Zaphod2003
      • Can someone tell me what's wrong with this code CREATE TABLE countries( ; id n(10,0) PRIMARY KEY , ; ccode c(2) UNIQUE , ; CHECK ( LEN ( ALLTRIM (ccode))=2) ; ERROR "Currency code must be 2 characters", ; currency n(10,0), ; CHECK ( currency >0), ; cname c(30) UNIQUE ; ) I have indentified the problem to be with the code CHECK (
  • Unable to open a table with 255 fields in VFP
    by S.G.K.Hari
    4 Replies
    Last post by MaxRalph
      • Hi all, I have a DBF with 255 fields. When i give the use command in VFP I am getting an error message as' Not a Table' The same can be opened in Excel. Help me how to open the same. Hari
  • How to use an updateable parameterized view.
    by Aleniko
    7 Replies
    Last post by Naomi Nosonovsky
      • Hi all; This is my first try with updateable views, so please go easy on me :-) I have a table with a primary autoincrementing key. I have created an updateable parameterized view. I'm using this view in a grid. I need to be able to add, delete and modify grid items. I am NOT setting any buffering at the load event of the form. I'm not sure if I should - isn't the view my buffer I'm experiencing
  • Check permissions of directory
    by teeth777
    8 Replies
    Last post by Christof Wollenhaupt
      • Hi all, I'm after a way to check the write access the user has to a particular directory. Pref. a way to do it that doesn't require non foxpro objects (ie wsh/fso). doing an fcreate to create a dummy file then deleting it isn't suitable. It's not really elegant and there are instances where the user might have create rights but no delete rights & there'd be a bunch of dummy files in the dir. a
  • Accessing VFP 8 through C# and ODBC
    by KevinInIndy
    12 Replies
    Last post by Craig Berntson
      • Our company has an online product ordering program that accesses our VFP 8 accounting package through an ODBC connection on our server. Occasionally, our system error log table will trap the following error: "ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]This file is incompatible with the current version of Visual FoxPro. Run 30UPDATE.PRG to update the file to the current version. ER
  • close all child forms
    by Victor BA
    8 Replies
    Last post by Radenko Zec
      • How can i close all the child forms shown in a MDI form at the same time
  • MSCHRT20.ocx erro
    by Christina853
    7 Replies
    Last post by Dietervd
      • I have just restored a machine in which a program is loaded for testing. (I am not the programmer I was just hired). When I try to start the program i get the following error; mschrt20.ocx or one of its dependencies is not correctly registered. I did a full restore from backup to the new machine. The program will not start. Any Ideas I am not a seasoned programmer I am a network adminis
  • RLOCK on a DBF file on a Windows Vista Shaded Folder
    by Stefano Alderotti
    13 Replies
    Last post by dni
      • Hi, I have problems on some functions [at first RLOCK()] when i try to access on a DBF file on a Vista Shared Folder from another Vista PC. If I try to access or execute Rlock() function, from XP on Vista or from Vista to XP, i have no problems. When i try to execute Rlock() on this file from Vista i have an "Error Reading File" only when another used already use this file.
  • 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
  • do form and wait
    by VFPNewbie
    6 Replies
    Last post by AndyKr
      • I have a program that scans through a table and when it hits a condition will call a form. The problem is that it runs the form and then continues scanning when I need it to wait for the user to complete the form before moving on. I'm calling it with the DO FORM method and can't find anything on it, please help.
  • 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
  • FOXFIX5.DLL and Windows 2003 Server
    by Stuman99
    9 Replies
    Last post by Stuman99
      • I seem to be having a problem using foxfix.dll on a windows 2003 server. The error message generated is cannot load 32-bit dll c:\foxfix\foxfix5.dll. Any ideas... seems to work ok when run from my windows xp workstation. Stuart
  • How to Call Web Page With POST Method in foxpro9
    by surinder singh
    1 Replies
    Last post by dni
      • Hi All I am here again with a new problem Problem: I need to show a web page to users that accepts 2 parameters say name & password through foxpro. But I need to call this web page by using POST method. i.e. if I call this web page by shellexecute function then it shows me the passed paramters in the url like this. web page: https://localhost/test/users/index.html https://localhost/test/users/
  • Textbox value does not seem to change
    by Hans L
    13 Replies
    Last post by Naomi Nosonovsky
      • I am in a form which shows, i.a., an address and a billing address (in textboxes; record A). I skip down a few records (to record F), and the "skip" buttons (Previous, Next) have ThisForm.Refresh in them. So I figured that the textbox Value property would be updated. And the address textbox surely shows the correct address from record F. But, when I click on a checkbox that moves the add
  • Calling a listbox from PRG
    by Eddie N
    4 Replies
    Last post by Eddie N
      • I put the following function in a PRG. It displays properly, but every time I call this function and click the list, it returns an arbitrary string, blank or otherwise. What should I do Code Snippet FUNCTION ASK_s i = 1 condition2 = ssoundex (my_word) frmShow.listbox1. clear do whil i < 6 .and. ssoundex (my_word) = condition2 frmSh
  • Private data Session for Prg Files?
    by Sammy Adems
    3 Replies
    Last post by AndyKr
      • Is it possible to set a prg file to a private data session For most of my reports I have an associated prg file to handle all the data processing, and then call the report to format the data the data out on viewing\printing. I am currently using a DataSession class (basically a form with a private datasession) that handles theses report calls. Since the prg is called from a D
  • Why _pageTotal always shows 1 ???
    by Lightening
    9 Replies
    Last post by Tamar E. Granor
      • in VFP9, I tried to use use my table report form test noconsole preview "Page " + TRANS(_PAGENO) + " of " + TRANS( _PAGETOTAL) But the _pagetotal value is always 1 although the report contains 4 pages. What is that
  • Server-Volume Name ... Simple Solution Found
    by Docpro777
    9 Replies
    Last post by Docpro777
      • Dearest Friends, FoxMasters, Geeks and/or venerable MVPs, Looking at Sys() commands, etc. I can't seem to be able to 'display' a name for the LAN Server(s). Sys(5) works for the "Drive" of course, but Sys(5) fails to be meaningful for a Server Name : ...eg. "DellDimension4300", "Martha", "Ivan", "MyLanServer", etc. I've searched help files
  • Detecting whether running as COM server
    by Darren Woodford
    2 Replies
    Last post by Darren Woodford
      • Is there a way for VFP to detect whether or not it is running as a COM Server I can't find a SYS function or anything that will tell me this. I am doing some testing and debugging within the VFP IDE and the COMRETURNERROR function keeps complaining that the feature isn't available so I would like to use an IF statement to raise errors differently when not running as a COM server. Man
  • OLE object error
    by gamease
    12 Replies
    Last post by Naomi Nosonovsky
      • Hi, I get the error : OLE error code 0x80040154. Class is not registered. OLE Object is being ignored . I get this error when i run a form which has a pdf document in VFP 6.0. If my computer has only installed the acrobat reader with version 6.0 or before, there will be no error occured. But when my computer has installed the acrobat reader with version 7.0 or later. The error will appear.
  • image resize
    by NILKAMAL
    7 Replies
    Last post by Naomi Nosonovsky
      • hello! i ceate simple form with image now i want to image resize in my imagecontrol can i do that also how do i do to change background color of my application thanks