Posted May 5th, 2009 by Andrew Popoff
Today I started work on a template for the menu. I usually make it quickly. But now I have decided that I will spend considerable time for writing a template. I think that I will slightly rewrite the template for the context menu and the toolbar, so that all these templates were able to work together.
In product xXPFrame I redraws the standard menu. In CFC-menu I decided that I will build menu again. This means that you have to create all the menus again. And I understand that this is a bad thing. Therefore, I decided to start work on the template with the possibility of implementing the import of existing menus.
The template contains only one button, which allows you to import an existing menu to the template. I am importing the structure of the menu, the names of items and icons. I do not know the way to import actions that are performed by pressing the menu item.
Read the rest of this entry »
Tags: CFC Library, template | No Comments »
Posted April 29th, 2009 by Andrew Popoff
You can download the MS SQL Field Box source here.
You must also install the CFC Library 2.5 and register the templates that are included in the library (cfc_templates.tpl, DEBUG.TPL, dp_class.tpl).
I think that the class for working with ADO is that it’s worth a look.
Tags: CFC Library, Clarion 7, MS SQL Field Box | 1 Comment »
Posted April 29th, 2009 by Andrew Popoff
I have added two classes. One for incremental search and one for system global hotkeys. The documentations is still missing.
I have a plans to develop a template for menu. And after that I will write documentation for the product.
CFC Library page
Tags: CFC Library | No Comments »
Posted April 28th, 2009 by Andrew Popoff
I’ve uploaded the MS SQL Field Box 2.0.
It is a small tool which allow you view MS SQL Server database structure and paste table or field names in your favorite editor with mouse left double click or keyboard hotkeys.
I wrote this program using the Clarion 7, CFC Library, ADO and hand-coding.
ps
I will upload the source code of the utility soon.
Tags: MS SQL Field Box | No Comments »
Posted April 27th, 2009 by Andrew Popoff
Today I finished work on “MS SQL Field Box“. I need only add the “About” or a little documentation. Of course I used the CFC Library. I have added to the library class to work with global hot keys. So I need to do build the library version 2.5. I think that I will do it tomorrow.
Resize the window was a big problem for me. I used “Anchor”-strategy in recent times. But this strategy is wrong, in the absence of restrictions on the minimum size of the window. I had to make a change in the size of the window manually. I think that I will write a class to change the size of the windows controls in the future. It is an old problem and it requires a solution.
I have an idea to find the overlapping controls and hide them, when I struggled with resizing. I have not used it now.
To determine the overlap of two rectangular areas, you can use the WinAPI functions.
There are two functions: CreateRectRgn and RectInRegion. The first function creates a region with a given size. The second function determines the location of the rectangle in the region. I checked it works:)
Tags: CFC Library, Clarion 7, MS SQL Field Box | No Comments »
Posted April 21st, 2009 by Andrew Popoff
Today I continued working on the “MS SQL Field Box”. Yesterday, I was not able to compile the application with a dictionary. Today, I exported it in txa-format. And I made a new application using txa-file. Compilation worked successfully!
I have not encountered major problems today. Some things annoy. Sometimes Clarion crashed. But today I feel better and faster then yesterday.
“MS SQL Field Box” uses ADO. I am using hand-coding inside the app. It is a small class to work with ADO. I will publish the code of the product when I finish.
Tags: Clarion 7, MS SQL Field Box | No Comments »
Posted April 20th, 2009 by Andrew Popoff
People are different. Programs are different.
If you hate the CapsLock key like I do, you have come to the right place. This site is the home to CapsLockBeGone, the blessed little utility that will rid you of your CapsLock key forever.
Tags: ihatethecapslockkey.com | No Comments »
Posted April 20th, 2009 by Andrew Popoff
I have the utility MSSQLFieldBox. It allows you to add columns of tables in the editor of SQL. I use it almost every day. This is certainly not autocompletion input, but still easier than typing the name in the fields by memory. I accustomed to this method during the years of programming at the Clarion.
On Friday I decided that it was necessary to rewrite the program. It is not too large. The entire program consists of three scripts 
-- list of databases
USE master SELECT sysdb.name FROM sysdatabases sysdb
-- list of tables
USE shop31
select
obj.name,
obj.id,
p.value
from
sysobjects obj
LEFT JOIN sysproperties p ON p.id = obj.id and p.smallid = 0
where
objectproperty(obj.id, 'IsUserTable') = 1
OR objectproperty(obj.id, 'IsView') = 1
-- list of columns
SELECT
p.value,
t.name,
c.name,
c.length,
c.prec,
c.scale,
c.iscomputed,
c.isnullable,
c.colorder,
c.colid,
c.id
FROM
syscolumns c
LEFT JOIN sysproperties p ON p.id = c.id and p.smallid = c.colid
LEFT JOIN systypes t ON t.xtype = c.xtype
WHERE
c.id = 1977058079
I decided to remove all third-party templates and leave only the pure Clarion code. Today I realized that the easiest way to rewrite the program again. I decided that I would write the program in Clarion 7. Today I took these. I cried and laughed. I was not able to work in the new IDE.
Now, Clarion may be called SAD (Slow Application Development).
I was not able to compile the application with a dictionary. It was too many mistakes. Tomorrow is a new day.
ps
Good news: Bob Z replied today in a clarionbeta thread that:
C6 build 9059 AND a NEW C7 release fixing all major bugs WILL be released to ALL expired CSP holders so as to let them decide if they want to renew…
Tags: ADO, Clarion 7, MSSQLFieldBox, SQL | No Comments »
Posted April 19th, 2009 by Andrew Popoff
Today we celebrate Easter. Easter is the most important annual religious feast in the Christian liturgical year. According to Christian belief, Jesus was resurrected from the dead three days after his crucifixion. Christians celebrate this resurrection on Easter Day or Easter Sunday.
Happy easter!
Tags: Easter | No Comments »
Posted April 18th, 2009 by Andrew Popoff
SV continues to work on the Clarion 7. As I understand now they want to receive money each year for $800.
Ingasoftplus company sells MAV. I know the MAV developer. He is russian. I know how to hard to support the product like this. Actually I want to develop my own library to access the data.
Some days ago I decided to see how ADO works in C7. The ADO paradigm is more closer to me than ODBC. C7 crashed all the time when I try to use ADO templates.
And…I’m so sad that I don’t know the spanish language
Tags: Clarion 7, Ingasoft, MAV | No Comments »
Posted April 16th, 2009 by Andrew Popoff
In this version I introduce the WinAPI customizable toolbar. There are classes and template. The documentation is still missing. Numerous examples are presented.
You can download the installation files here.
There are two files. One for install in C6 and one for C7.
Comments are welcome!
ps
There will be more information in coming days.
Tags: CFC Library | No Comments »
Posted April 15th, 2009 by Andrew Popoff
It is too early to talk about the history of CFC Library. But it exists
I started with the creation of WinAPI Rebar control.
The Rebar has toolbars usually. And I started to work on the toolbars.
Toolbars buttons has a tooltips. And I started to work on the tooltips.
Toolbars buttons can have a drop-down menu. And I started to work on the menus.
Menus and toolbars has a global alert keys. And I made the appropriate class.
Now I have almost finished work on a template for the customizable toolbar.
Tags: CFC Library | No Comments »
Posted April 14th, 2009 by Andrew Popoff
Clarion 7 Gold has been released. Hurray!
Tags: Clarion 7 | 4 Comments »
Posted April 13th, 2009 by Andrew Popoff
It always happens. I lose interest in the product, when the class is already written. I prefer to use the classes as templates. Templates certainly simplify life. But the classes are given more control over everything.
In any case, I am now working on a template for the toolbar. This will be a simple template. If you need anything more, you’ll need to use hand-coding. Although the template is usually enough:)
Tags: CFC Library | No Comments »
Posted April 13th, 2009 by Andrew Popoff
Today is April 13. It is morning now. I am waiting for news. I do not believe that this will happen today. It seems to me that Clarion 7 release will be delayed for a few days. In fact, I’m not ready to work in the Clarion 7. I think it will be another year before I write my first application. But I very much look forward to this event.
Tags: Clarion 7 | No Comments »
