Visual FoxPro

Page 216




  • Topics
    Replies
    Last post
  • Display "Running query..." progress bar
    by hangover
    10 Replies
    Last post by Naomi Nosonovsky
      • How do I make the "Running query..." progress bar display when executing an SQL query within my VFP9 application I have tried both SET TALK ON and SET NOTIFY ON but it is still not displaying. Which other commands can affect whether it is displayed or not Thanks.
  • How to select a table while it is being used in a form?
    by Lightening
    9 Replies
    Last post by Naomi Nosonovsky
      • While we open multiple tables in a form, can we use it in another prg file The prg file is called by the menu. and it select some data from 2 tables and print out the result. When you run Select * from table1 ....... Select userid, name, fax from table2 ....... It seems OK for the first select but the 2nd one said "fax not found". When you set step o
  • DEFINE CLASS problem
    by Deni Atanasov
    4 Replies
    Last post by Deni Atanasov
      • I create my own class but when but i cant use function wich is included in this class. This syntax didnt work: SET DEFAULT TO "D:\working\class" CREATE CLASSLIB "hostupd" DEFINE CLASS CHostUpd as Custom FUNCTION Select CLOSE TABLES ALL SET DEFAULT TO "C:\customClass" SELECT * from merchants ENDFUNC ENDDEFINE Then i call for function wit
  • how to run as window service?
    by Joe Au
    1 Replies
    Last post by dni
      • How to write VFP code which is running as window service on Window Server 2003 Thanks.
  • Move pointer of a table to last record
    by Ahsan Amin
    12 Replies
    Last post by CetinBasoz
      • Is there any way to move the pointer of a table to last record apart of 'go bottom' func. Regards Ahsan
  • work-around for invalid path using set default to on windows server 2003 when directory tree is not browsable
    by MLovely
    4 Replies
    Last post by MLovely
      • Does anyone know a way to set the default directory when the application is running on windows server 2003 and the directory tree is not fully browseable by the user. A client switched from Novell to Windows Server recently. I am changing the default directory in several applications so users don't have to navigate the complex directory tree when they are selecting files. The parent
  • SQL Server Express & Foxpro-populating SS from Foxpro
    by drhoades32
    7 Replies
    Last post by AndyKr
      • I've placed more of the code at the bottom of this message. The problem is with the Insert command with SQLEXEC. If I use: lcStr = ["INSERT INTO SAUTHORS(firstname,lastname) values ('] + m.firstname + [','] + m.lastname + [')"] lnResult=SQLEXEC(m.lnConn, m.lcStr) The error I get says: Connectivity error:...Could not find stored procedure 'INSERT INTO SAUTHORS(firstname,lastn
  • Olecontrol parameters
    by andrew552717
    14 Replies
    Last post by dni
      • Hi! I need some help again. I have small ocx in vb and I want to use it in vfp6.0. It is working in vb this way: FK524ID1.SetIPAddress lpszIPAddress, CLng(txtPortNo.Text) where lpszIPAddress = "192.168.1.201" and txtPortNo.Text="5005" In VFP, when I dclick on "SetIpAddress" method in the Properties window, it is poping up new window with
  • GetFile
    by HowardW
    5 Replies
    Last post by HowardW
      • The statement lcFile = GETFILE([PDF],[Scanned doc],[Select document]) causes some machines to totally freeze up. Seems to affect Win2k machines and not XP or 2003. Statement is in a command button in a container in my vcx classlib. Used to work fine till I started building exe's on my 2003 server Any ideas
  • Problem with Buffering, Multilocks, Grids, Optimistic Record Locking for Multiple Users VFP 9.0
    by vfpu$3r
    4 Replies
    Last post by Naomi Nosonovsky
      • I would appreciate some help with this. Possibly someone else has dealt with this. I have a small app written in VFP 9.0 which does not seem to be acting correctly in a multi-user environment. Based on my research, I expect that two different users should be able to edit a field in two different records without a crash - but when user #1 begins to edit a field, if user #2 begins to edit a
  • Olecontrol parameters
    by andrew552717
    14 Replies
    Last post by dni
      • Hi! I need some help again. I have small ocx in vb and I want to use it in vfp6.0. It is working in vb this way: FK524ID1.SetIPAddress lpszIPAddress, CLng(txtPortNo.Text) where lpszIPAddress = "192.168.1.201" and txtPortNo.Text="5005" In VFP, when I dclick on "SetIpAddress" method in the Properties window, it is poping up new window with
  • build exe application
    by lowellnelson
    8 Replies
    Last post by lowellnelson
      • I am a neophyte FoxPro programmer, AND I am new to forums such as this, so please bear with me. I have been using a simple program utilizing a few free tables and some report forms, which I have been running within FoxPro. Now I want to generate an exe version for distribution to other computers in my area without installation of FoxPro at those locations. I have used the build command from the pr
  • Problem indexing views
    by Hans L
    14 Replies
    Last post by Hans L
      • I am trying to index a view. After having created the view in a prg file, created with Gendbc, I add (in the prg file): USE vwMysoft INDEX ON cname TAG Namn OF vwMysoft USE In other words, I use the same commands I would use for a table. Okay Then, when I open a form where I need the indexed view open, I do: USE vwMysoft SET ORDER TO Namn Error message: Variable Namn is not found. Either I am m
  • Split datetime()
    by Somebody2
    11 Replies
    Last post by Naomi Nosonovsky
      • I have a table with a bunch of rows and each row has a datetime when the transaction occurs. Is it possible to break the date off of the datetime I want to select some of the rows if they occur between one date and another date, is it possible
  • Problem indexing views
    by Hans L
    14 Replies
    Last post by Hans L
      • I am trying to index a view. After having created the view in a prg file, created with Gendbc, I add (in the prg file): USE vwMysoft INDEX ON cname TAG Namn OF vwMysoft USE In other words, I use the same commands I would use for a table. Okay Then, when I open a form where I need the indexed view open, I do: USE vwMysoft SET ORDER TO Namn Error message: Variable Namn is not found. Either I am m
  • RichText Control
    by Daniel CW Tan
    2 Replies
    Last post by Daniel CW Tan
      • Hi All, How do I print a report with a memo field that has richtext control in a form What I am trying to do is print the report with the same bold and italic fonts as the text in a memo field using richtext control in a form. Does anyone know if this can it be done Thanks in advance.
  • Information on FoxPro
    by bdewong
    8 Replies
    Last post by Naomi Nosonovsky
      • Hi, I am a little new to foxpro and my employer has an application that is written in foxpro 8; and I am looking for a little more information. For a little background information: This application resides on a network share as do the foxpro tables. Users access this application on the shared drive. The table files range in size from a few KB to almost a GB. I was wondering a few things: How does
  • Running MSDOS application from compiled Foxpro
    by Eddie N
    8 Replies
    Last post by Nugroho2
      • My compiled Foxpro project (EXE) runs OK at home. I ported it to a network, and everything goes well except one, i.e. it fails to run an MSDOS (console) application (EXE, Visual C++) called from a procedure. I open the MSDOS (command prompt) window and run the application directly from there, it runs OK, but could not be called from the Foxpro application. What could be the problem I have r
  • datatype casting
    by dvidal
    2 Replies
    Last post by Tamar E. Granor
      • Hi, I want to know how to convert or cast a string to an int. Thanks
  • 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
  • Full Screen Question
    by Yin Lai
    14 Replies
    Last post by Yin Lai
      • I am using visual foxpro 7.0. I need to set my program to full screen and limit the user option. That's mean, user just can use that computer to key data using the program and cannot do anything else (cannot open other program) except if they log out. Hope some expert can help me solve the problem. Thank you very much.
  • Fax Report Using VFP9
    by emery
    11 Replies
    Last post by emery
      • As resolved in "VFP Fax Integration" thread , I have been using Jaime's method to fax Reports with graphic/image and it works very well for VFP6. set printer to name "Fax" report form myReport to file "myfile.tif" noconsole Recently I compiled and ran my program using VFP9, I got the following Program Error: OLE IDispatch exception code 0 f
  • Change of Class Library ...
    by Markish
    6 Replies
    Last post by CetinBasoz
      • Hi, I have been using a base class library ( say X) for my application development. Now that I've created a new base class library (say Y). I want to change the class library for all the objects (in all forms in my project). I wrote a small program something like Code Snippet mscx_ct=Adir(mscx,'*.SCX') mct=1 do while mct<=mscx_ct mfnam=mscx(mct) use &mfnam repl all
  • New problem about imgscan.ocx
    by xuyca
    1 Replies
    Last post by AndyKr
      • I use imgscan.ocx to scan a picture in vfp form. The problem is that the picture in *.bmp I got from scaner can't be opened in VFP. But I can open it using paintbrush or imageedit. And the picture size is much different if using scanwise to scan (2MB using imgscan.ocx, 156kb using scanwise). I can open the picture that scan using scanwise by vfp. The vfp code in scan button of vfp form is: thisfor
  • Split datetime()
    by Somebody2
    11 Replies
    Last post by Naomi Nosonovsky
      • I have a table with a bunch of rows and each row has a datetime when the transaction occurs. Is it possible to break the date off of the datetime I want to select some of the rows if they occur between one date and another date, is it possible