Foxpro

VFP

=-=-=-=-=-=-=-=-=-=-=-

encryption and zip

https://www.sweetpotatosoftware.com/blog/index.php/2009/08/09/major-vfp-encryption-update/

https://www.sweetpotatosoftware.com/blog/index.php/2005/09/01/visual-foxpro-encrypt-and-decrypt-files/

vfpencryption71.fll if you prefer. This uses the same runtimes that VFP 9 uses.

https://www.foxite.com/articles/read.aspx?id=81&document=extending-craig-boyds-vfpcompressionfll

http://doughennig.com/papers/

http://doughennig.com/papers/Pub/201103dhen.pdf

http://doughennig.com/papers/Pub/201101dhen.pdf

=-=-=-

7zip

https://www.foxite.com/archives/using-7zip-with-foxpro-0000389594.htm

https://sevenzip.osdn.jp/chm/cmdline/switches/

Compression method: LZMA2 is the default in this example is Zzip2
7za u -mx1 -mhe -m0=BZip2 -pPASSWORD Backup.7z ./FILES/*

-mx1 is the fastest compression

-mx9 is the most compression

-aot auto rename existing file (for example, name.txt will be renamed to name_1.txt).

Dictionary size: is -md4m for 4MB and -md128m was the maximum I got without error

Word size: -mfb273 is the max and worked

Solid Block size: -ms64g   worked for 64GB

Number of CPU threads: -mmt4

Encryption method: is AES-256 by default
 

7z a -mx9 -md128m -mfb273 -ms64g -mmt4 -pAmirsToughPassword C:\amirarchive.7z c:\amirfiles\*.*

https://axelstudios.github.io/7z/#!/

https://archive.codeplex.com/?p=DotNetZip

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Foxpro web application:

Yousfi very advanced programs: http://yousfi.over-blog.com/tag/javascript/

https://www.foxite.com/archives/run-javascript-from-vfp-0000242619.htm

SqlExec()

SPT: http://fox.wikis.com/wc.dll?Wiki~SQLPass-Through

http://www.yaldex.com/fox_pro_tutorial/html/8dd6491b-da44-401f-b972-0d51f12f1a07.htm#codeExampleToggle

=-=-=-=-=-=-=-=-=-=-=-

HTTP download system using ULRMON.DLL for years with no problem, but no security:

DECLARE LONG URLDownloadToFile IN URLMON.DLL ;
LONG, STRING, STRING, LONG, LONG
nGetResults = URLDownloadToFile(0, cHttp_file, cDownload_file, 0, 0)

=-=-=-=-=-=-=-=-=–=

POSTing a CSV from FoxPro to an url

The URLMON library contains this function, URLDownloadToFile, which is a way
to download files without user prompts. The ExecWB( _SAVEAS ) function always
prompts the user, even if _DONTPROMPTUSER parameter is specified, for “internet
security reasons”. This function gets around those reasons.
pCaller”>Pointer to caller object (AX).</param>
szURL”>String of the URL.</param>
szFileName”>String of the destination filename/path.</param>
dwReserved”>[reserved].</param>
lpfnCB”>A callback function to monitor progress or abort.</param>

DECLARE INTEGER URLDownloadToFile ;
     IN URLMON.DLL ; 
INTEGER pCaller, ;
 STRING szURL, ;
 STRING szFileName, ; 
INTEGER dwReserved, ;
INTEGER lpfnCB

webPage = some_url
txtFile = some_result_text_file

urlCall = URLDownloadToFile( 0, webPage, txtFile, 0, 0 )
USE MyData
COPY TO MyData.csv TYPE delimited
USE
LOCAL lcMyData
lcMyData = FILETOSTR("MyData.csv")

LOCAL xhr
xhr = CREATEOBJECT("Microsoft.XMLHTTP")
xhr.Open("POST", "http://www.mydomain.com/posthandler.asp", .f.)
xhr.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded')
xhr.send("data=" + lcMyData)

LOCAL lcResultText
lcResultText = xhr.responseText;

? lcResultText
xhr = null

 

 

 

 

Posting an XML file to a web service  

LOCAL WS AS MSXML2.ServerXMLHTTP60

* the object to handle the communication to the server
m.WS = CREATEOBJECT("MSXML2.ServerXMLHTTP.6.0")

LOCAL URL AS String

* the location of the service that receives the data
m.URL = "http://www.example.com"

LOCAL XMLFilename AS String

* your XML data
m.XMLFilename = GETFILE("xml")

* post the file contents
m.WS.Open("Post", m.URL, .F.)
m.WS.Setrequestheader("Content-type", "text/xml")
m.WS.Send(FILETOSTR(m.XMLFilename))

* get the http status code
? m.WS.Status, m.WS.Statustext 

-=-=-=-=-=-=-=-=-=-

loGatewayService = CREATEOBJECT("MSSOAP.SoapClient30")
loGatewayService.MsSoapInit("http://....SomeWebService....

like it is suggested in this thread :
http://www.tek-tips.com/viewthread.cfm?qid=1399175&amp;page=1

and I added this before calling the web service :

loDOM = Createobject("MSXML.DomDocument")
loDOM.LoadXML(lcXML)

-=-=-=-=-=–=

URL encoding/decoding:

http://fox.wikis.com/wc.dll?Wiki~Encode/DecodeURL/URI/URIcomponentclass

http://fox.wikis.com/wc.dll?Wiki~ListCategories

=-=-=-=-=-=-=-=-=-=-=-=-

CA connect to other databases

lodo = CreateObject("CursorAdapter")
lodo.DataSourceType="ODBC"
lodo.DataSource=SQLStringConnect("DRIVER=SQL Server;Network=DBMSSOCN;SERVER=w2kas;database=(local);uid=sa;pwd=")
lodo.SelectCmd="select * from foo"
lodo.CursorFill()
Browse

=-=-=-=-=-=-=-=-=-

http://www.foxtools.com/vfp/foxpro-tools

Visual Foxpro Tools

 

Miscellaneous
CodeBlock Stonefield Systems Group Inc
Focus.fll August Technologies (Makers of jKey.fll)
MoleBox(Application Packager) FoxRunner (Automated Application Testing)
VMWare (Multiple Virtual Machines) InstaFox (Installation software written in FoxPro)
Beyond Compare (File comparison utility) Inno Setup(Installation Software)
Tame (16bit apps on NT\2000) Cryptor (Data encryption software)
The Armadillo (Software protection system) VFPSkins
FoxWeb Full-Text Search Engine  
FoxUnit (FoxPro Testing Software)  Client Server
VFP Compiler SunLINE SDK
   
ActiveX Controls Report Printing\Writers
LeadTools (Imaging) DBi Technologies Amyuni Technologies Virtual Print Engine
Classy Components Inc. Data Dynamics XFRX UserQ
Animated Gif’s GridEX WinPrint PDF Solutions
bbControls TX Text Control Win2PDF pdfFactory
Sub Systems     iSEDQuickPDF
MarshallSoft – Email, FTP, Serial Communication Mind’s Eye Report Engine CutePDF
PC Guard – Copy Protection Frx2Any List & Label
  Foxfire! R&R Report Writer
Quick Books Integration Visual Report Engine Pro(VisualRep) Crystal Reports
iBiz Integrator for QuickBooks DataBlox Stonefield Query Report Manager
 CoreObjX    FoxyPreviewer  FoxBarcode
       
       
      Here is a comparison chart on the Wiki
   
Quick Books Articles File Synchronization
ITA – Importing into QB Intuit Developer Site vuBrief
QB SDK Example    
   
Help Files Remote Application Maintenance
Help&Manual Help to RTF pcAnywhere GoToAssist
HTML Help Builder   GoToMyPc  
    Virtual Network Computing (VCN)
.  
   
Screen Cature\AVI Files File Conversion
HyperCam TechSmith SE Tools  
HardCopy ScreenCam  
   
 
Telephony Data Recovery\Fix
ExceleTel Recover FoxFix
  Stonefield Database Toolkit DBF Doctor
  DBF Recovery  
   
Data Compression Credit Card Processing
ZLIB(Free) DynaZip Medasyst XCharge
   

 

   
Codebook and Related Links
Edward Leafe Consulting Wiki-CodeBook

 

 

https://www.lianja.com/overview/lianja-app-builder