|
Complete Help File
First APL+Win Objects 6.0 now includes a complete HTML (.CHM) Help File including the detailed description of all APL+Win Objects, and of all their Properties and Methods.
This Help File can be called directly from APL+Win, using the Help function:
Help'??TExcel5'
Help'??Highlight'
|
This opens the Help File and directly displays help on the specified Object or Property/Method:
New TEditFile5 and TEditDir5 objects
The new TEditFile5 and TEditDir5 control objects may be used in APL+Winforms each time you need a control for entering a file name or directory name.
They both include an Edit (TEdit5) control and a Button (TButton5) control. The user may either directly enter a file or directory name or can click the button to select an existing file or directory name using standard dialog boxes.
Example:
'ff'Świ'*Create' 'TForm5'('*caption' 'TEditFile5 Demo')('*size'300 400)'DemoShow'
'ff'Świ'*.edf.Create' 'TEditFile5'('wherelc'Đ 60 Đ 190)('caption' 'File Name')('attach'1 2 3 2)
|
New TOWCSpread5 object
The new TOWCSpread5 object can be very useful as an alternative to the APL+Win Grid when you need to embed a grid with calculation capabilities (formulas) within a form in your application. TOWCSpread5 use the Microsoft OWC (Office Web Components) Spreadsheet object.
Example:
'ff'Świ'*Create' 'TForm5'('*caption' 'TOWCSpread5 Demo')('*size'300 400)
'ff'Świ'*.owc.Create' 'TOWCSpread5'('wherelc'0 0'>>' '>>')('attach'1 2 3 4)
'ff'Świ'.owc.Add'1(1 1)(10 10˝'APL'1 2 3 'is' 3.14158 'the' 'best' 'language'10)
'ff'Świ'.owc.range'1'B3:D8'
'ff'Świ'.owc.backcolor'(256 152 256)
'ff'Świ'.owc.border'1 3
'ff'Świ'.owc.bordercolor'255
'ff'Świ'.owc.Get'
'ff'Świ'.owc.GetNum'
'ff'Świ'.owc.range'1'B3:D8'
'ff'Świ'.owc.value'(2 2˝100 200 300 400)
'ff'Świ'.owc.range'1'C6:D7'
'ff'Świ'.owc.value'(2 2˝'APL.Net' 'is' 'coming' 'soon!')
'ff'Świ'.owc.backcolor'(255 112 112)
'ff'Świ'.owc.border'1 4
'ff'Świ'.owc.GetNum'1'B3:D8'
'ff'Świ'.owc.fontbold'1
'ff'Świ'.owc.fontitalic'1
'ff'Świ'.owc.fontname' 'Verdana'
'ff'Świ'.owc.fontsize'18
'ff'Świ'.owc.AutoFit'1
'ff'Świ'DemoShow'
'ff'Świ'*size'350 580
Śwself„'ff.owc'
|
New TTLI5 object
The TTLI5 object is extremely useful when you develop APL+Win applications for Microsoft Office, i.e. when you want to make use of Excel, Word, Outlook, Powerpoint or Access in your applications.
It is able to return a list of all the Microsoft Office ActiveX Constants ond of their decimal values.
'ttl'Świ'*Create' 'TTLI5'
'ttl'Świ'GetConstants' 'Office' 2003
MsoLineDashStyle
msoLineDashStyleMixed: Ż2
msoLineSolid: 1
msoLineSquareDot: 2
msoLineRoundDot: 3
msoLineDash: 4
msoLineDashDot: 5
msoLineDashDotDot: 6
msoLineLongDash: 7
msoLineLongDashDot: 8
MsoLineStyle
msoLineStyleMixed: Ż2
msoLineSingle: 1
msoLineThinThin: 2
msoLineThinThick: 3
msoLineThickThin: 4
msoLineThickBetweenThin: 5
MsoArrowheadStyle
msoArrowheadStyleMixed: Ż2
msoArrowheadNone: 1
msoArrowheadTriangle: 2
msoArrowheadOpen: 3
msoArrowheadStealth: 4
msoArrowheadDiamond: 5
msoArrowheadOval: 6
...
˝aaa„(aaa¬Śtcnl)›aaa„'ttl'Świ'GetConstants' 'Office' 2003
1561
|
New TFindReplace5 object
The TFindReplace5 object is useful each time you need a modeless dialog in one of your applications to search for or replace character strings.
It can work on a document displayed in an Edit (TEdit5) or RichEdit (TRichEdit5) control or work on all files contained in a given directory.
You can even for example use the TFindReplace5 object, disconnected from any application, to simply replace a character string by another in all files contained in a given directory.
Example:
'ff'Świ'*Create' 'TForm5'('*caption' 'Find & Replace Control Demo')('*size'400 500)
'ff'Świ'*.ed.Create' 'TRichEdit5'('ChStyle'4 8192)('wherelc'Đ Đ '>' '>')('attach'1 2 3 4)
'ff'Świ'*.ed.text'(('ff'Świ'ReadToEnd'(('ff'Świ'installdir'),'readme.txt'))~Śtclf)
'ff'Świ'*Set'('*.ed.limit'10000000)('*.ed.selection'0 Ż1)
'ff'Świ'*Set'('*.ed.selfont' 'Verdana' 11)('*.ed.selstyle'0 0)('*.ed.selection'0 0)
'ff'Świ'DemoShow'
|
New TGUID5 object
The TGUID5 object creates a unique GUID string under program control.
A Globally Unique Identifier or GUID is a pseudo-random number used in software applications. Each generated GUID is "statistically guaranteed" to be unique. This is based on the simple principle that the total number of unique keys ( or ) is so large that the possibility of the same number being generated twice is virtually zero.
GUIDs may be used for:
- generating keys that are guaranteed to be unique
- elements of information that can be passed when you connect to an Internet site, and it may be stored in cookies
etc.
Example:
'guid'Świ'*Create' 'TGUID5'
'guid'Świ'GUID'
{39DC96B3-F3DA-493C-AE43-448020A979F5}
|
Other new objects: TAPLDraw5, TMath5, TWebSiteNet5
TAPLDraw5 includes methods for batch converting files and creating Images for Imagelists. It also contains methods for displaying Metafiles in your applications.
The TMath5 object contains a few mathematical properties and methods.
TWebSiteNet5 is a VB.Net code generator. It can generate a complete ASPX page displaying a form to insert a new record in a given database table ot updating a givne record in a database table.
More than 100 new Properties and Methods
About 30 different objects have been enhanced in APL+Win Objects 6 with more than 100 new properties and methods.
The following only describes some of the most important new features added to APL+Win Objects 6.0.>
The TADO5 object now includes an Insert and an Update method to batch insert or update a matrix of records in any relational database. TADO5 is now capable of performing transactions due to its new BeginTrans, CommitTrans and RollbackTrans methods. The new PrimaryKeys TADO5 method can also now list all Primary Keys in a relational database.
TAbale5 has 2 new methods: ZipWithPassword and UnzipWithPassword, which allow you to zip/unzip a set of file, password protecting the zip file, under program control.
The TAboutBox5 object now has a new web property allowing to display an hyperlink to your Web Site with a hand cursor when the mouse hovers the link.
The TDates5 object has got 2 new methods: DateTimeExcelDConvert which translates Excel dates to YYYYMMDDHHMMSS format and Short2LongDate which converts a date in ddd d mmm yyyy format to dddd d mmmm yyyy format i.e.:
'dd'Świ'*Create' 'TDates5'
'dd'Świ'country'1
'dd'Świ'Short2LongDate' 'Tue 23 Jul 2004'
Tuesday 23 July 2004
'dd'Świ'country'33
'dd'Świ'Short2LongDate' 'Mar 23 Déc 2004'
Mardi 23 Décembre 2004
|
A lot of new features have been added to TExcel5:
- you can create Charts with the new AddChart method and set the charsource, charttype, chartshadow, charttitle, chartlabels, chartarea properties
- you can now add include pictures (like your company logo) in worksheet headers and/or footers with the new footerpicture and headerpicture properties
- you can draw shapes like circles and ovales with the DrawCircle method and circles with text inside with the DrawCircleWithText method
- you can calculate the size of a range in pixels with Range2Pixels
- you can protect/unprotect your worksheet with the ProtectSheet method
- you can hide rows with the new HideRows method
- you can add .BMP, .GIF or .JPG pictures to your woksheets with the new AddPicture method
- etc. TExcel5 includes a lot of other new properties and methods
Example:
Excel
'ee'Świ'Add'1(3 1)(4 2˝'APL+Win'30'APL+Dos'12'APL+Unx'19'APL+Vms'2)
'ee'Świ'AddChart' 'D2:J24'
'ee'Świ'chartsource' 'A3:B6'
'ee'Świ'chartrounded'1
'ee'Świ'chartshadow'1
'ee'Świ'chartlabels'2
'ee'Świ'charttitle' 'APL Sales'
'ee'Świ'charthaslegend'0
|
The TFileMenu5 object is now able to easily handle MRUs (Most Recently Used files) thanks to the mrus and maxmrus propertie, to the AddToMrus and ResetMrus methods and to the mMRU_onClick event.
The TGrid5 object now has a Print method to easily print the content of the entire grid
The THTML5 object which helps generate HTML code from APL, now includesthe following new methods:
- AddAPL which generates HTML to display sample APL code (as in this page)
- AddImage which generates HTML code to add an image
- AddList which generates HTML code to add a lit of items with bullets
- GroupLines which groups table lines by packs of N lines
- MakeSortedTable which, given HTML code for a table, sorts all the table lines according to a given column and generates the resulting HTML code
- etc.
With the TNetwork5 object, you can now find the first no yet mapped drive letter on your system with the FirstDrive method; you can programmatically map a new network drive with MapNetworkDrive, get a list of all used or mapped drives on your system with GetLogicalDrives and kwno which kind of drives they are with GetDriveTypes (1=not used, 2=removable, 3=fixed, 4=remote, 5=cdrom or6=ramdisk).
The TObject5 object has a large number of new properties and methods among which:
- cpuspeed, ipaddress, GetComputerName helps you get information about your computer
- CreateDir helps you create a directory and all its parent directories if they do not exist
- DLLInfo returns the version number, date, time and size of a given DLL
GetFileSize returns a file size without opening the file with APL
IsProcessRunning returns 1 if a process is currently running
- FixSystem attempts to automatically repair damaged workspaces which have wrong Reference Counts
- GridVersion and RegisterGrid help you know the exact version of the APL+Win Grid you are running and to register it under program control
GridFile returns the complete path name of the currently registered APL+Win Grid
- IsPrinterAvailable helps you kwno if there is a default printer currently connected an ready to accept printouts
- Mailto launches your default mail application and displays a new message with already filled fields
- NewObjects, NewProperties, NewMethods, NewFeatures and version which inform you about the latest APL+Win Objects enhancements in detail
- RecurseFiles and RecurseDirs which returns a directory and all of its files and/or sub directories ;
- Replace allows you to replace a string by another everywhere in a text with various options (case sensitiveness, syntaxic replacement or not, replace in text/tags/both)
- XProp and XMeth are very useful when dealing with ActiveX collections, returning the complete list of xProperties and xMethods a collection item
- etc.
There are also new methods and properties in TPowerpoint5: you can install hyperlinks in slides with the hyperlink property, load and run a Powerpoint Presentation from APL with the LoadAndRun method, remove bullets from list in slides with the RemoveBullets method.
The TRichEdit5 object has been enhanced with the syntaxcolor property and the SyntaxColor method to automatically syntax color HTML code: a new text property has been aded.
The TScheduler5 object has been extended with the following methods:
- CreateTask to schedule a new task
- DeleteTask to delete a scheduled task
- DeleteAllTasks to remove all scheduled tasks
- GetTasks to return all task id numbers
- Tasks to return a nested array of all currently registered tasks
TStatus5 has a new GetField method to retrieve the content of a status field.
TTipForm5 which is able to display multicolumn grid tooltips with shadow, has got properties to display images (image, imagefile and imagewidth) and a new ShowOffSet method to display the tooltip at a given distance of the current cursor position.
Example:
aaa„1 2˝'Function' 'TObject5'
aaa„aaa®'Nb. of lines'(•†˝Ścr'TObject5')
aaa„aaa®'Size'((,'CI8'Śfmt˝Śvr'TObject5'),' bytes')
'ff'Świ'*Create' 'TTipForm5'('gridcontent'aaa)('gridcolor'0(204 204 255))
'ff'Świ'*font' 'Arial'16 0'ansi'
'ff'Świ'shadeborder'0
'ff'Świ'shadecolor'128 128 128
'ff'Świ'shadedepth'3
'ff'Świ'gridcolor'(0 0 0)(255 255 255)
'ff'Świ'Show'
|
The TTree5 object has now got methods to help move nodes in the tree under program control (MoveUp, MoveDown, MoveLeft, MoveRight): these are used for example in CHM Builder v1.2 for interactively restructuring the Help File table of contents. Other new methods like NodeIds, NodeDepths and NodeIdDepths return information about the current tree nodes. The new Children method returns all children of a given node, recursively.
Rewritten objects
The TAccess5 (9 properties, 27 methods) and TWord5 (25 properties, 94 methods) objects have been entirely rewritten. They allow you to pilot Access and Word from your APL applications.
Bug fixes
APL+Win Objects 6 includes all bug fixes signaled by customers since version 5.
|