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 »
Posted April 12th, 2009 by Andrew Popoff
On 12 April 1961, Gagarin became the first human to travel into space, launching to orbit aboard the Vostok 1.
Tags: Gagarin, Space Day | No Comments »
Posted April 9th, 2009 by Andrew Popoff
I have translated the article which was written for Russian community in 2006. I did the package and sent it to ClarionMagazine. I am not sure of the translation. Maybe Dave will reject my article.
In any case, the class code, written for the article will be included in the CFC Library.
Tags: author, CFC Library, Clarion Magazine | No Comments »
Posted April 9th, 2009 by Andrew Popoff
Programming a struggle with himself. You have a some ways usually. You can choose the easy or hard way. And if you agree with easy way then you can have a problems in the future maybe. You must choose everytime. Today I choose the easy way. I work on the rebar control. I decided to implement only a small portion of functionality. I loose this fight becouse I’m tired to struggle with a windows controls.
Anyway now the toolbar looks more pretty
Download demo
Tags: CFC Library, demo, Rebar, ToolbarWindow32 | No Comments »
Posted April 9th, 2009 by Andrew Popoff
Another one.
No Comments »
Posted April 7th, 2009 by Andrew Popoff
I think that no one knows exactly how many people in Russia programs at Clarion. We have a mailing list. This is the main means of communication. It has approximately 300 users per year.
The main site is clarionlife.net. This is a private site, which is not profitable. Sometimes I publish news from the world of Clarion on it. The site contains a large collection of examples, classes and templates. Some peoples upload the files. This happens not so often. Site has the forum. It has about 400 registered users. But still, people love to talk in the mailing list.
Also we have the official site clarion.ru. I visited it twice a year
There are still some “old” sites that have not been updated long time ago. I think you know the reasons.
We also have several 3rdParty developers, but they all focus on the sale is not for Russia.
We have a lack of information about Clarion in our native language. Few people know about the Clarion in the world of programmers.
Tags: Russian Community | No Comments »
Posted April 7th, 2009 by Andrew Popoff
Dave Harms wrote:
Clarion Magazine is looking for writers! If you have written some code of interest to Clarion developers, or have experience or expertise in a Clarion-related area, consider writing an article. You don’t need prior writing experience, just a willingness to learn and share your knowledge with others.
You can read more here.
ps
I have a some articles that I wrote for the Russian community. Do I have power to translate them?
Tags: Clarion Magazine | 1 Comment »
Posted April 6th, 2009 by Andrew Popoff
Working on the toolbars, I have decided that it was necessary to make the toolbar with custom draw, as well as I did it with the menu. I spent about two days to learn how to do it. And I realized that now I can not do it correctly. There are too many nuances, which I still do not know. So I decided not to make a stylized toolbar. Perhaps this will be done in the future, but not now.
Tags: API, CFC Library, owner draw, ToolbarWindow32 | No Comments »
