news.clarionlife.net

Life goes on!

I thought that they just drink beer but I was wrong. They want to show what they have been cooking over the last few months. Aussie Devcon 2009 soon

Tags: Aussie DevCon, Clarion 7 | No Comments »

“MS SQL Field Box 2.2″ released

I’ve just updated the MS SQL Field Box. Now it supports schemes and MS SQL 2008.
MSFB is a tool that allows to view a database structure and populates tables or column names in T-SQL editor. MS SQL managers 2000 and 2005 does not have built-in IntelliSense component. 3rdParty components like SQL Prompt or SQL Assistant cost a money. MSFB is free. Of course, MSFB is not so handy as IntelliSense. It is an alternative way.

Tags: MS SQL Field Box | No Comments »

CFC Library Documentation

I just started to translate the CFC documentation. I think that I will translate the template documentation only. After that I will release a new version. I think that it will be fast. The remaining large part of the documentation will be translated gradually. I have an idea to add the demo video to some templates.

Although in reality, how to work with templates almost always clear. Settings in the templates say for themselves. I rarely read the documentation for the templates, and all so clear.

Tags: CFC Library | No Comments »

CFC Library Documentation

Today, I have finished the documentation of library on russian language. It includes about 300 html-pages. Now I need to translate it to english

Tags: CFC Library | No Comments »

Clarion Folk

There are some Clarion-blogs that are not updated for a long time. It is not so easy to publish something. Comments are also very important. And you have your own personal life of course. That is why some of blogs are dead.

I think that if I was an English speaking person that I would write more often.

Tags: Blogs | No Comments »

MS SQL 2008: Indexed view

July, 1             July, 1
-------             -------
product_1           product_3 -> error!!!
product_2           product_4
product_3           product_5

CREATE VIEW dbo.vPriceChanges
WITH SCHEMABINDING
AS
SELECT
   PCD.GoodsID,
   PC.DateChangePrice
FROM
   dbo.PriceChangesDetail PCD
   JOIN dbo.PriceChanges PC ON PC.PriceChangeID = PCD.PriceChangeID

CREATE UNIQUE CLUSTERED INDEX
UQ_vPriceChanges ON dbo.vPriceChanges
(GoodsID, DateChangePrice)

I will write later if I’ll have a problem with this decision

Tags: MS SQL, T-SQL | No Comments »

Copying Data

I have a new task. I need to copy a data from remote office to main office. The data is the MS SQL database. What I need is just copy a database from one office to another.

And I can’t do it.

I can communicate between offices only by e-mail. This is the slow connection. I can download about 6 megabytes per one hour. The database have a 4 GB size. The full archived backup is about 500 MB. I need to receive the new data every day.

I know about a differential backup. But I need to restore a full backup before restoring a differential backup every time. That is why I think that the restoring will get all the server’s time after one month. There are 15 remote offices.

I thought that this is not so hard task. But now I don’t know how to solve it.

Tags: backup, MS SQL Server | 7 Comments »

Clarion blog works!

There are two new posts at Clarion blog. This is about tooltips and auto-save option. This is not so significant changes but it is better then silence.

Tags: Clarion 7 | No Comments »

The New Report Writer

I missed a few events when I had the vacation.
I can not watch a video at www.clarionlive.com. I see only the pictures from the blog. The main thing for me that: “Its worth mentioning that the new Report Writer will be shared by both Clarion 7 (win32) and Clarion.Net.”

I am ready to work

I returned from vacation. I am full of strength and ready for work:)

PS
I have received several letters during this time. I will try to answer them tomorrow.

Vacation

I will have a three weeks vacation. I have a plan to visit my parents who live about 7000 miles away from me. I think this trip will give me a new strength for a work. I will be back around August 16.

Tags: vacation | No Comments »

ClarionShop

I just had registered at clarionshop.com. You can see the CFC Library here.

Tags: CFC Library, ClarionShop | No Comments »

clarionshop.com

Today I have tried to add the CFC Library at clarionshop.com. I was not able to do so. I’m using Opera.
I have tried about 3 or 4 times. But nothing happened. My products list is still empty. IE did not want to open this site. I will try tomorrow again.

Motleysoft’s site looks ugly but it works as I expect.

Many features of clarionshop.com are not working for a long time, but people still enjoy this website. I don’t undertsand why.

Tags: ClarionShop, MotleySoft | No Comments »

CFC Library 2.6 released

This version includes the template for menu. You can set the style of menu such as MS Office XP and MS Office 2003. The documentation is missing. I think that it will be available in next version. I think that version 2.6 is the last version which is free for private use. The next versions will be available only by annual subscription.

The installation package contains a lot of examples which demonstrates the library possibilities. You can find all examples in Clarion “EXAMPLES/CFC Library”-folder after install.

Download the demo

Download the setup-file for C6

Download the setup-file for C7

Read more about CFC Library

Tags: CFC Library | No Comments »

CFC Menu Video

I have almost done with CFC Menu template. Today I present a demo video. I’ve made this video with a SnagIt. Video contains a minor disturbance, but I think that it is not important.
You can download a video here (2MB).

Tags: CFC Library | No Comments »