FoxPro

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi Experts

Could you point what is preventing vfpcompression.fll to be used in a VFP9 project running under Windows10?

Accordingly to:

img002
The same .fll perfectly runs under Windows 7

Any workaround?

Thanks in advance
0
Cloud Class® Course: Microsoft Exchange Server
LVL 12
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Need to send SMTP email from FoxPro app that includes CC and BCC on a windows machine WITHOUT installing any ocx's or dll's. Is this possible with standard windows api calls?

Server restrictions are high, so no regsvr statements are allowed, no registry changes. dll's or libraries residing in the same directory may be permitted.
0
Sometimes, when my FoxPro application does not close gracefully for whatever reason, I get an error message upon its restart: "Index does not match the table. Delete the index file and recreate the index". Can somebody provide me with a sample code to do it automatically? Also, I have a significant number of indexes, and some of their expressions are fairly complex. So, it would be nice to have all of them listed in a single text file for convenient copying and pasting into "INDEX ON". I am still using VFP6 (I know, I know...)

Thank you.
0
i need to convert my csv data to foxpro table...kindly help for example below:

"ALB-ME","44.6","G/L","ALP-ME","89.76","U/L","ALT/-ME","52.73","U/L"

With only three columns as shown "ALB-ME"-desc1,"44.6"-desc2,"G/L"-desc3 . All the data should be rows.

Kindly assist me
0
I have a Domain (Windows 2012 R2) with 10 Stations.

I have 1 station with some problems when accessing an application (Visual Foxpro 9).
when the application is active but idle for few minutes we get an error "Error reading file....".
We shutdown the application and restart it, it works fine for another few minutes... and again ,if the PC is idle for few minutes, it gives the same error.

I tried changing the NIC, removing the Power management from everywhere on the PC (NIC, HDD, etc... ) it did not change anything...

The weird thing is that If I have an excel file open from the same share folder, it doesn't give any error..

Any help ?
0
Hi All:
I have a program that reads a table using a DO..WHILE loop. For each record, there is code that copies a filename (of a BMP file) that is in a field to a temp file using a COPY FILE statment. The temp BMP file is then used on a report, and the report is run for each record. If I run the source code, the COPY FILE statements and the reports are correct but when the EXE is run, only one COPY FILE statement seems to happen and the same picture appears on every report. The client using the EXE discovered the problem. Everyone is using Windows 7.
Any ideas would be appreciated.
Thank you,
Cathie
NYC
0
I have an xBase++ app that creates a table that has memo fields. The
table is created by consolidating information from several source
tables.

When I run the app complied with Clipper 5.2 the resulting .FPT file
is about 220 MB.

When I run the same app compiled with xBase++ the resulting FPT file
is approximately 20 GB.

I have the driver set up as follows in the xBase app:

// Build DBE
DbeLoad( "FOXDBE", .T.)
DbeLoad( "CDXDBE",.T.)
DbeBuild( "FOXCDX", "FOXDBE", "CDXDBE" )
DbeSetDefault( "FOXCDX" )
 
// Set up for FOX 2.x and Comix compatability
DbeInfo(COMPONENT_DATA, FOXDBE_CREATE_2X, .T. )
DbeInfo(COMPONENT_DATA, FOXDBE_LOCKMODE, FOXDBE_LOCKMODE_CLIPPER)
DbeInfo( COMPONENT_ORDER, CDXDBE_MODE, CDXDBE_COMIX )

Any help is much appreciated.
0
Hi Experts

Could you point the better way to ensure a Wordpad content, by encryption or password ?

Also, what is the better way to do that?

By the way the file is opened by a VFP application

LOCAL oWSH

try
	oWSH = Createobject("wscript.shell")
	oWSH.Run(lcOutputFile, 2, .T.)

Catch To oErr
	oErr.UserValue = "Nested CATCH message: Unable to handle"
	=ALERT("PARE", "OK", 10, 10, "Wordpad não pode ser executado. Erro:"+oErr.Message )
Endtry

Open in new window


Any suggestion on decrypyt before it's opened and then after it's saved, is it a good approach?


Thanks in advance
0
Hi Experts

Could you point how to manage a VFP Multi-threaded COM Server dll to make it works out?

I obtained this example

I guess  DTS  Explorer must be opened to make it works out, isn't it?

img002
Is it a matter of install the .dll on DTS ?
If so, how to do that?

The VFP code to calls  the .dll
** This is a simple example DLL for use
** with the BASICSAMPLE.PRG file.

** Example Usage:
** loDLL = CREATEOBJECT("sample.EasyMTServer")
** loDLL.SomeLengthyProcess(_VFP)

** Note: You could also use the following
** in the event the DLL is not registered
** (assuming sample.dll exists in your path)
** loDLL = NEWOBJECT("EasyMTServer","sample.dll")

DEFINE CLASS EasyMTServer As Session OLEPUBLIC
	PROCEDURE SomeLengthyProcess (toCallback)
		
		** We'll declare the Windows API Sleep
		** function, so we can ensure the 
		** process runs for 20 seconds.
		DECLARE Sleep IN WIN32API Long

		** Create a variable for
		** our FOR/ENDFOR loop.
		LOCAL lnCount As Integer

		** Print a string to the main VFP window.
		FOR lnCount = 1 TO 20
			** Create a SYS(2015) value, and
			** print it back to the VFP window.
			toCallback.DoCmd("? + ALLTRIM(SYS(2015))")

			** Let's sleep for 1 second
			Sleep(1000)
		ENDFOR
		
		** Write out a Done!
		toCallback.DoCmd("? + 'Done!'")
		
		CLEAR DLLS "Sleep"
	ENDPROC
ENDDEFINE			

Open in new window


Thanks in advance!
0
I have 50 visual foxpro files in my computer. I want to transform that contents to excel is that possible??
If it's possible means how to that?
0
Cloud Class® Course: SQL Server Core 2016
LVL 12
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Hi Experts

Could you point a way to start MTS Explorer from Win 7?

Thanks in advance.
0
Hi Experts

Could you point a workaround to this problem when registering a .DLL by using  West Wind Web Service Proxy Generator  .NET Web Service Proxy Generator for Visual FoxPro?

When generating by using the tool:
img001
So, when code runs:
img002
Inside the box means:
Failed to load file or assembly 'filec: \ wwwproxy \ hello_serviceproxy.dll'
or one of its dependencies. The system can not find the file
specified



Thanks in advance!
0
I need to be able to encrypt PDF documents in VFP programatically and then create a zip file with the encrypted PDF to email

Please assist.

Thanks
0
Hi,

I need to be able to synchronize files from RDP to my local computer without using FTPs.
This process should be automated.

Thanks
0
Hi Experts

Could you clear what is and what is causing this VFP  XML Web Service, correctly registered when running?

 img003
if the line
leResult = loHello_Port.sayHello('xxx')

Open in new window

is ommited - no problems arises

if the line is changed to:
leResult = loHello_Port.sayHello()

Open in new window

this error arises

img004
The XML
<definitions name = "HelloService"
   targetNamespace = "http://www.xxxxx.com.br/soap/HelloService.wsdl"
   xmlns = "http://schemas.xmlsoap.org/wsdl/"
   xmlns:soap = "http://schemas.xmlsoap.org/wsdl/soap/"
   xmlns:tns = "http://www.xxxx.com.br/wsdl/HelloService.wsdl"
   xmlns:xsd = "http://www.w3.org/2001/XMLSchema">
 
   <message name = "SayHelloRequest">
      <part name = "firstName" type = "xsd:string"/>
   </message>
	
   <message name = "SayHelloResponse">
      <part name = "greeting" type = "xsd:string"/>
   </message>

   <portType name = "Hello_PortType">
      <operation name = "sayHello">
         <input message = "tns:SayHelloRequest"/>
         <output message = "tns:SayHelloResponse"/>
      </operation>
   </portType>

   <binding name = "Hello_Binding" type = "tns:Hello_PortType">
      <soap:binding style = "rpc"
         transport = "http://schemas.xmlsoap.org/soap/http"/>
      <operation name = "sayHello">
         <soap:operation soapAction = "sayHello"/>
         <input>
            <soap:body
               encodingStyle = "http://schemas.xmlsoap.org/soap/encoding/"
  

Open in new window

0
How to Data add/ edit into table by form design by visual FoxPro.
Pl. Guide me. I have no idea for form design.
Sir, i have made input screen @ raw, column say command but I want to develop this screen by form design. But I don't know how  data  add/edit into table.
Suppose iname var. Content replace in name field. How form design add
If form design add / edit simple tutorial aavine pl. Send me
Thanks
0
Hi Experts

Could you point the correspondent object to use Wordpad instead of Word from VFP?

This code opens Word:

oWSH = Createobject("wscript.shell")

Open in new window


What is the correspondent to open WordPad ?

Thanks in advance
0
Hi Experts

Could you point a way to programatically change a DBF field type from Character to Character binary?

Or optionally how to programatically create a Character (Binary) column by using CREATE TABLE(...

Thanks in advance.
0
Hi Experts


I'm using  vfpencryption71.fll that perfectly runs and correctly saves on a not indexed  DBF file.

But if I use an indexed DBF file (I don't know if it's really the cause, this occurs:

*-- The string that must be saved
OµÆp%D½×°W“˜Âá?ËR•(óÏSqϧux¹

*-- The string saved
Oü-+p%D+×°W"˜Âá?ËR•(óISqI§ux1  

Open in new window


The DBF index configuration Collate is Machine.
 
The codepage of the not indexed table and the indexed table is the same 1252.

The problem arises on CDX not in IDX.

Thanks in advance.
0
Cloud Class® Course: MCSA MCSE Windows Server 2012
LVL 12
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Hi Experts

Could you point a way to solve this OLE Error when trying to include it on a form?

img002
img001
The .OCX was successfuly registered
c:\Windows\SysWoW64\Regsvr32 richtx32.ocx

Open in new window


The dependency walker I had:
img003

Thanks in advance
0
Hi Experts


To run FoxinCloud it is necessary to contract a "special" internet provider that runs FAS (FoxinCloud Application Server) isn't it?

(f.e. my actual plan allows only to develop under Apache - I'm using PHP, since FAS it's not a very common server I guess it's not so easy to find)

Do you know who offer this and the conditions?

More: Have you ever used this technology, do you think is it really a good alternative?

Thanks in advance
0
Hi Experts

How reliable is a VFP's  FPT (memo) ?

Any check/ repair routine is advisible to run from time to time  to prevent corruption?

Thanks in advance
0
Hi Experts

Could you point how to correctly copy a file to a subfolder by using COPY FILE ?

Accordingly with this code:
	*-- Runs OK
		Copy File &LCZIPFILE To &LCDRIVE

		*-- Doesn't runs

		m.driver_final = LCDRIVE + "Espiriplug\"
		Copy File &LCZIPFILE To &driver_final
*-- OR
		Copy FILE(LCZIPFILE) to (driver_final)

Open in new window


The error produced

img001
Any workaround to this situation?

Thanks in advance
0
Hi Experts

Could you point how to deal with this mscomdlg.commondialog error when running VFP?

img001
I guess it's a matter of an .OCX install

I had installed comdlg32.ocx and mscomm32.ocx


And configured as:

img002
Any other is necessary?

Thanks in advance!
0
Hi Experts

Could you point what is causing this .FLL error under certain conditions?
I guess it's due any VFP7memory issues, could it be?

	Set Library To vfpcompression.fll Additive

Open in new window


img001
The same code perfectly runs at my PC but not always runs at an user's  PC.
The .FLL had been renewed with a perfectly one. So a .FLL corruption like the messages suggests is remotely true.

Thanks in advance.
0

FoxPro

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.

Top Experts In
FoxPro
<
Monthly
>