Pragma 6 Updates

 

 

Latest Version 1.01  Build 16
January 25, 2009

 

Version 1.01

Build 1

October 21, 2005

Pragma 6 has been compiled using the Microsoft Visual C++ .NET 2003.

All compiler references to P4 are being eliminated.

This build has no security but will expire (crash) at the end of 2005.

The new compiler generated the following errors:
The scope of the function HTMLHelp() had to be narrowed by changing to ::HTMLHelp().
The function ReadHuge() had to be changed to Read().
In the function execute.cpp in the initialization int(*vbptr)() had to be changed to int(*vbptr)(...).
CTrace was globally renamed to CPragmaTrace since CTrace is already defined in ATL MFC.
Changed the location of Winmm.lib.
In sec.cpp line 781 was commented out.
The location of the file afxhelp.hm was updated in P5.HPJ.
In FILEMNGR.CPP in the function CFilemanager::OpenFile (Line 1903) a wait loop of 50 milliseconds was introduced.  This is a test.

In print.cpp line 2223 local variable "height" changed to "printheight", while printing last line of a grid.

Due to stricter compiler rules many variables that were not initialized caused a crash.  The following initializations were added:

Recapdlg.cpp line 523, BOOL status = true
XLR  (Frans)
Backup Vocab (vocab does not get closed, assert with debug version)
p4dsverb.cpp line 537, int attrib = 0
ppgvoc.cpp line 3309,  int i  = 0
ugsidehd.cpp line 140, long row = 0;

A beta version of the chart program has been added! 
A beta version of the report program has been added! 

 

Build 2

November 21, 2005

This build has no security but will expire (crash) at the end of January 2006.

Be aware that PostgreSQL is accessed using the c++ code for ODBC, which is slow.  We are working on direct access and will let you know when it has been implemented.

The SELECT queries from PostgreSQL are limited to 25 rows.  This is of course provisional.

The name of the start sound has been changed to p6 start.wav.

A bug has been eliminated in the Report Dlg.cpp that prevented the parameter ReportHeadingColor to work.

Two new standard verbs, DISPLAY CHART and DISPLAY REPORT have been added.
The new standard verb,  LIST CONTROL ADD SQL TABLE has been added.
Two new standard verbs, SQL CONNECT and SQL SET have been added.
A new standard verb, SQL GET PARAMETERS has been added.
A new standard verb, SQL GET FIELD has been added.  It works, but has not yet been optimized.  Look how it works in the tutorial vocab with todays date at the FORM ADDRESSES DS1 and you will be surprised how easy and fast it is to use PostgreSQL and Pragma 6.

The manual pages for the standard nouns XE and FST have been modified for SQL.

Beware that these verbs may change functionality or number of parameters during testing!

In the View menu the option View SQL and Export PFM to SQL have been added.

You need the new PRMSG.PFM and PRSTD.PFM files, dated November 21.
You need the P6.EXE dated November 21.
You need the tutorial vocab dated November 21.

 

Build 3

Do not use build 3.  Due to a mixup there are two (or more) versions, neither of which is stable.  
Please use build 4.

 

Build 4

December 30, 2005

This build has no security but will expire (crash) at the end of February 2006.

You need the P6.EXE dated December 30.
You need the new PRMSG.PFM and PRSTD.PFM files, dated not earlier than November 16.
You need the tutorial files dated December 30.

The utility Export PFM to SQL has been moved to the Utilities menu.

A button 'New Connect' button has been added to the SQL Connect dialog to facilitate connecting to adifferent database.   

The list utility List Elements in now non modal and can be kept open while editing.   Also P6 remembers its last position.  To facilitate leaving it open while programming the dialog box has been made a bit narrower,  

The verb SQL GET has been implemented.   

The verb LIST_CONTROL_ADD_SQL_TABLE has been redeseigned in is now fully operational.  The documentation is uptodate.  Please read it since there are various ways to use the verb.

All accesses to PostgreSQL are now through the function SQLverbs.

The chart program can now display up to 4 lines at the same time.

 

Build 5

January 6, 2005

To circumvent a bug in the ODBC driver there is the option to use the old ODBC code for a multirow fetch.  Please read the Technical paper "SQL Bug" for more information.

 

Build 6

January 18, 2005

You need the new PRMSG.PFM dated not earlier than January 17 2006.
You need the tutorial files dated January 17.

All SQL errors are now copied to a File Status of 0 (OK), 1(record not found) or 99 (specific message, either from Pragma or SQL).  Hopefully all message boxes have been eliminated.

In Tools, Options, File Manager you can now set the maximum number of rows that you can fetch with one query. The default is 100 rows. The maximum cannot be greater than 1000.  If you want to get more than 1000 rows (are you looking up the complete yellow pages?) you must do multiple queries (look at the reference of SELECT in PostgreSQL on how to do this).

Two new data types can now be displayed by the verb LIST BOX ADD DATA:  Pragma filenames and the nouns of a Pragma file.  Read the reference for LIST BOX ADD DATA for details.

The verb SQL CONNECT has been modified and now has 3 parameters, which let you choose whether to connect or disconnect, display or not the dialog box and enter the connect script.  Please note that the functionality may change in the near future after feedback.  Read the reference for SQL CONNECT for details.

The utility Export File to SQL now adds quotes instead of eliminating spaces with underlines.

 

Build 7

This build has no security but will expire (crash) at the end of March 2006.

The following initialization has been added:
status = FALSE in RecapPrintForm.

Hopefully the last message box error in SQL SET has been eliminated.

In the verb CONVERT DATA the algorithms to calculate the Julian date from the Gregorian date, Gregorian date from the Julian date and day of the week have been changed.  The documentation reflects these changes.  Be aware that the numbering of the days of the week in the day of the week program have changed!

The maximum number of rows that you can fetch with one query has been eliminated, that is you can enter any number you wish, at your own peril.  You have been warned.

A bug has been squashed in the verb LIST BOX ADD DATA, type 4 that did not show upper ASCII characters.

 

Build 8

This build has no security but will expire (crash) at the end of May 2006.

 

Build 9

This build has no security but will expire (crash) at the end of May 2006.
This build was for internal use only.

 

Build 10

This build has no security but will expire (crash) at the end of July 2006.

A problem with the pie charts, when displaying a 0 slice, was solved.

The color parametr for the color of the pie slices, is called ChartBrushColor 1 to ChartBrushColor20.  The error in the documentation has been corrected.

 

Build 11

This build has no security but will expire (crash) at the end of March 2007.

A problem has been encountered with the Euro sign (alt 0128) when converting to and from Ansi to Oem with the standard functions.  To solve the problem two new functions have been written in TOOLS that convert all the characters except the Euro sign.
These two functions have been used in the functions SET_ELEMENT_PROPERTY,  GET_ELEMENT_PROPERTY and in GRID WRITE DATA, GRID WRITE DATA MULTILINE,  GRID_WRITE_DATA_ELLIPSIS, GRID_READ_DATA

 

Build 12 - 14

These were builds to extend the free time.

 

Build 15

This build has the standard Pragma 5 security.

Build 16

January 25, 2009

Pragma 6 has been compiled using Microsoft Visual C++ 2008.
Before running the new version you must run the file vcredist_x86.exe that will install the necessary Microsoft DLL's.

The dongel security has been eliminated.  Use password security instead.

 

 

 

2009-01-25
logo.gif, lip_upd.gif, stop.gif, exclam.gif
p6 updates.htm