Change log

August 2008

Implemented STORE

Implemented RESTORE FROM

June 2008

Implemented DELETE and DELETED()

Implemented GridLineColor property.

Implemented Load event

Implemented Grid, Column, Header and Spinner controls. The grid controls currently only work on the PDA.

Implemented SYSMETRIC()

Added SYS(8006)

May 2008

Implemented EOF(), the Refresh method and the DisplayValue property.

Implemented TIME() and the Activate event for pages.

Implemented ListIndex

Implemented the WordWrap property for buttons and GETPEM()

Implemented ListCount and ActivePage properties.

Implemented DTOC(), CTOD().

Enhanced MESSAGEBOX().

Added several enhancements in index handling and data type support

April 2008

Added support for Visual WebGUI

March 2008

Implemented AERROR()

New function SYS(2005) to control the Microsoft SQL Server Compact Engine. Support for version 3.5 has been added.

February 2008

The error handler now displays a dialog with error details.

December 2007

Error handling improved

Various field types including VARCHAR and VARBINARY have been implemented or enhanced.

November 2007

Implemented SET BELL. ?? and ? now respect the current setting.

Implemented ERASE, COPY FILE

Added FontName, FontSize, FontBold, FontItalic, FontUnderline and FontStrikeThru. Please note that Guineu ses GDI+ and therefore might print text slightly different than Microsoft Visual FoxPro.

Added various output formats for GuineuIDE.

This change log gives a brief overview of what changed. You can find a more detailed list in the Guineu release blog (http://guineu-blog.blogspot.com)

October 2007

Implemented RUN

Added new GuineuIDE.EXE for the Visual FoxPro development IDE. GuineuIDE allows to compile a project into an EXE. Forms and class libraries are converted to PRGs.

Added new Vocabulary sample. This sample runs on the desktop and a PDA. It can be used to learn languages, etc.

Implemented SET COVERAGE TO, ZAP

Implemented SEEK(), SELECT(), CLOSE DATABASES [ALL]

Implemented LOCATE, CONTINUE

Implemented FOUND(), USED(), SET STEP ON, SYS(2015)

Implemented Valid and When.

Implemented Picture property on forms.

Implemented LostFocus, GotFocus and SetFocus

September 2007

Implemented Editbox

Implemented GETENV()

Implemented SET FILTER TO

August 2007

Implemented SCAN FOR and USE...ORDER

Implemented read access to currency, date, boolean and integer fields.

Implemented FCOUNT(), FIELD()

Implemented SKIP

Implemented GOTO, GO TOP and GO BOTTOM.

Implemented FONTMETRIC().

SET ORDER TO implemented for DBF files.

SEEK implemented for DBF files.

July 2007

REPLACE and APPEND now work with DBF files. REPLACE is currently limited to character fields that are not indexed.

Implemented VERSION(), ALEN()

Added a new option to APRINTERS().

Implemented operators AND and OR.

Implemented DO CASE...CASE...OTHERWISE...ENDCASE

Implemented ERROR command.

Implemented RAT(), ROUND(), MINUTE(), IIF(), SYS(2), SEC(), PAYMENT(), ISALPHA(), SOUNDEX(), RATC(), LOG(), ICASE(), MAX(), STUFF(), SYS(0), VAL(), ISLOWER(), SQRT(), SYS(3), INLIST(), DRIVETYPE(), RAND(), ISDIGIT(), SIGN(), APRINTERS(), FV(), HOUR(), LOG10(), PV(), ISUPPER(), PADC(), PADL(), PADR(), OCCURS(), SYS(1), EXP()

June 2007

Implemented VARTYPE(), ISNULL(). JUSTDRIVE(), TAN(), GETWORDCOUNT(), GETWORDNUM(), NVL(), BITAND(), JUSTEXT(), RTOD(), DAY(), JUSTSTEM(), FORCEEXT(), BITOR(), JUSTFNAME(), FORCEEXT(), BITOR(), JUSTFNAME(), YEAR(), GOMONTH(), FORCEPATH(), FLOOR(), DISPLAYPATH(), QUARTER(), COS(), BITCLEAR(), MONTH(), BITLSHIFT(), BITRSHIFT(), BITNOT(), BITXOR(), DTOR(), PI(), CEILING(), BITTEST(), SIN(), BITSET(), DIRECTORY(), DEFAULTEXT()

Page and Pageframe implemented.

BackColor and ForeColor implemented

Implemented Enabled and Visible

ControlSource in read only mode available

Implemented READ EVENTS, CLEAR EVENTS, CLEAR

Implemented STRTRAN(), CHRTRAN() and EMPTY().

Implemented Picture and DownPicture for CommandButton on the desktop

Added Listbox and Combobox control with Additem, RemoveItem, Clear and InteractiveChange event.

Implemented ALINES().

Implemented EVALUATE() for variable and field names.

Implemented APPEND, REPLACE

Implemented SELECT().

Added Release method to forms.

Implemented ADIR()

Implemented RECNO()

Added Image control.

EXE prompts for FXP if no file has been passed and default FXP doesn't exist.

Implemented SYS(8004) to switch between SPT engines. Guineu supports two engines in the desktop version: ODBC and Microsoft SQL Server 2005 Compact.

Implemented SQLSTRINGCONNECT(), SQLDISCONNECT() and SQLEXEC() for the PDA with Microsoft SQL Server Mobile.

Implemented SET EXACT

New function SYS(8003) to enable .NET Debugging support. Added delegate based support for .NET debugger.

Implemented SYS(2000), DIMENSION

May 2007

Implemented DTOS(), RGB()

Implemented Container class

Implemented DATE(), DATETIME()

Implemented RECCOUNT()

New function SYS(8002) to handle unknown tokens.

DO supports the IN clause now.

FOR supports STEP and non-integer loop counter.

Implemented FOPEN(), FCLOSE(), FREAD(), FWRITE(), FERROR(), FCREATE(), FSEEK(), FGETS(), FFLUSH(), FPUTS(), FEOF(), FCHSIZE(), FDATE(), FTIME()

Implemented USE.

Implemented LEFT(), REPLICATE(), CREATE CURSOR

Implemented SYS(16), ADDBS()

Implemented STREXTRACT(), PROGRAM(), JUSTPATH().

FULLPATH() implemented.

New function SYS(8001) to handle path casing.

SET DELETED, SET MEMOWIDTH, SET SAFETY, SET STATUS, SET STATUS BAR, SET TALK implemented

NEWOBJECT() implemented

SET PATH TO, SET EXLUSIVE and SET SYSFORMATS implemented.

External PRGs can now be called.

Implemented a basic cursor engine.

ALIAS() implemented.

SCAN...ENDSCAN implemented.

SQL pass-though is now available on desktops. Implemented are SQLSTRINGCONNECT(), SQLDISCONNECT() and SQLEXEC() . Because the Compact Framework has no ODBC support, these functions are not available on mobile devices.

LOWER() implemented.

$ operator working.

Added the WinForm sample to show the interaction between .NET and Guineu.

UPPER() is now implemented.

Added support for arrays. LOCAL can create arrays.