Clarion - I am back having fun and .... a problem

Author

I am back having fun and .... a problem

M.P. van Dobben de Bruijn

2005-07-26, 4:59 pm

Its a long time ago I looked at Windows programming
and <VBG> decided against it. Even with Clarion ... but
I have last w

picked up at the 6.2 version (after doing
a lot of my customers solutions in Clarion Professional for DOS).

Must say I am impressed by the progress and the ease
of use that has been made by SoftVelocity and partners
for programming business data-related solutions in Windows.

With the addition of Internet related solutions in
recent years I decided it was worth to give it a try.

Now .. the trial is going very well. But now I have a problem.

I have found a customer with an extensive FoxPro
based solution especially made form them in DOS of
course. And they may want to move on to Windows ver-
sions of that. But I have no time at the moment to take that
on also. So I convinced them that they could keep on using
their current DOS data-entry until I can help them. However, we
want to build some reporting procedures for those FoxPro files they
have in the mean time (to keep them coming to us). Well I intended
to copy the FoxPro data over to a seperate directory just to have a co-
py to do the rather static reporting from on a regular basis. However the-
re are problems to get the .NDX keys into the data-dictionary as Clarion is
complaining that the are illegal in structure (possibly "overed"). Ah that is .....

Now the problem. I can of course create my own keys (as this
is not live-data used in another application at the moment) and u-
se them to do the reporting with. However, these keys are not au-
tomatically rebuild at the first opening of the datafile instead there is
an error-message and a break down. I looked at import/export templa-
tes -and besides not wanting to spend extra money on add-ons on this
at the moment when we are not getting full revenues yet- I do not like the
idea that the customers users have to go through all kind of holahoops just
to get the new flashy reports from our solution. I want a batch file to copy o-
ver the data to the static reporting dbf-files only directory and then automatical-
ly fire up an Clarion application where the reports can be run from. It used to be
(in DOS) that keys could be auto-rebuild if they were out-of-sync. Can't find it in Win.

Anyone an idea how to solve this?

--
regards from Leeuwarden
Peter van Dobben de Bruijn
----
reply2usenet-2005 .at. The-Net-4U.com (.at. becomes @)
----

David Troxell - Encourager Software

2005-07-26, 10:00 pm

In article <Q3C8iT21jGKT-pn2-ddBWZtbHrMx4@localhost>, Reply2Usenet-2005@The-
Net-4U.com says...
>
>

Contact Mike McLoughlin of Sterling Data and ask for his expert opinion on
your situation. He is the maker of an excellent import-export tool, and I'm
sure could be of assistance in your situation.

http://www.sterlingdata.com/

mike AT sterlingdata DOT com

Product Description - IMPEX, MFG - Sterling Data
Internet Link - http://www.sterlingdata.com/impex.htm

David

> Its a long time ago I looked at Windows programming
> and <VBG> decided against it. Even with Clarion ... but
> I have last w

picked up at the 6.2 version (after doing
> a lot of my customers solutions in Clarion Professional for DOS).
>
> Must say I am impressed by the progress and the ease
> of use that has been made by SoftVelocity and partners
> for programming business data-related solutions in Windows.
>
> With the addition of Internet related solutions in
> recent years I decided it was worth to give it a try.
>
> Now .. the trial is going very well. But now I have a problem.
>
> I have found a customer with an extensive FoxPro
> based solution especially made form them in DOS of
> course. And they may want to move on to Windows ver-
> sions of that. But I have no time at the moment to take that
> on also. So I convinced them that they could keep on using
> their current DOS data-entry until I can help them. However, we
> want to build some reporting procedures for those FoxPro files they
> have in the mean time (to keep them coming to us). Well I intended
> to copy the FoxPro data over to a seperate directory just to have a co-
> py to do the rather static reporting from on a regular basis. However the-
> re are problems to get the .NDX keys into the data-dictionary as Clarion is
> complaining that the are illegal in structure (possibly "overed"). Ah that is .....
>
> Now the problem. I can of course create my own keys (as this
> is not live-data used in another application at the moment) and u-
> se them to do the reporting with. However, these keys are not au-
> tomatically rebuild at the first opening of the datafile instead there is
> an error-message and a break down. I looked at import/export templa-
> tes -and besides not wanting to spend extra money on add-ons on this
> at the moment when we are not getting full revenues yet- I do not like the
> idea that the customers users have to go through all kind of holahoops just
> to get the new flashy reports from our solution. I want a batch file to copy o-
> ver the data to the static reporting dbf-files only directory and then automatical-
> ly fire up an Clarion application where the reports can be run from. It used to be
> (in DOS) that keys could be auto-rebuild if they were out-of-sync. Can't find it in Win.
>
> Anyone an idea how to solve this?
>
>

--
From David Troxell - Product Scope 32 PRO - Encourager Software
Email - mailto:C3P_Remove_@_Me_encouragersoftwar
e.com
Clarion Third Party Profile Exchange Online
http://encouragersoftware.com/profile/clarlinks.html
http://www.encouragersoftware.com/

Leonid Chudakov

2005-07-26, 10:00 pm

Hi,

What about using BUILD command.
--
Leonid Chudakov
chudakov@klarisoft.com
Cool tools and Clarion examples at
http://www.klarisoft.com

"M.P. van Dobben de Bruijn" <Reply2Usenet-2005@The-Net-4U.com> wrote in
message news:Q3C8iT21jGKT-pn2-ddBWZtbHrMx4@localhost...
>
>
> Its a long time ago I looked at Windows programming
> and <VBG> decided against it. Even with Clarion ... but
> I have last w

picked up at the 6.2 version (after doing
> a lot of my customers solutions in Clarion Professional for DOS).
>
> Must say I am impressed by the progress and the ease
> of use that has been made by SoftVelocity and partners
> for programming business data-related solutions in Windows.
>
> With the addition of Internet related solutions in
> recent years I decided it was worth to give it a try.
>
> Now .. the trial is going very well. But now I have a problem.
>
> I have found a customer with an extensive FoxPro
> based solution especially made form them in DOS of
> course. And they may want to move on to Windows ver-
> sions of that. But I have no time at the moment to take that
> on also. So I convinced them that they could keep on using
> their current DOS data-entry until I can help them. However, we
> want to build some reporting procedures for those FoxPro files they
> have in the mean time (to keep them coming to us). Well I intended
> to copy the FoxPro data over to a seperate directory just to have a co-
> py to do the rather static reporting from on a regular basis. However the-
> re are problems to get the .NDX keys into the data-dictionary as Clarion
> is
> complaining that the are illegal in structure (possibly "overed"). Ah that
> is .....
>
> Now the problem. I can of course create my own keys (as this
> is not live-data used in another application at the moment) and u-
> se them to do the reporting with. However, these keys are not au-
> tomatically rebuild at the first opening of the datafile instead there is
> an error-message and a break down. I looked at import/export templa-
> tes -and besides not wanting to spend extra money on add-ons on this
> at the moment when we are not getting full revenues yet- I do not like the
> idea that the customers users have to go through all kind of holahoops
> just
> to get the new flashy reports from our solution. I want a batch file to
> copy o-
> ver the data to the static reporting dbf-files only directory and then
> automatical-
> ly fire up an Clarion application where the reports can be run from. It
> used to be
> (in DOS) that keys could be auto-rebuild if they were out-of-sync. Can't
> find it in Win.
>
> Anyone an idea how to solve this?
>
> --
> regards from Leeuwarden
> Peter van Dobben de Bruijn
> ----
> reply2usenet-2005 .at. The-Net-4U.com (.at. becomes @)
> ----

M.P. van Dobben de Bruijn

2005-07-27, 8:59 am

On Tue, 26 Jul 2005 22:53:37 UTC, David Troxell - Encourager Software <ESw_Remove_@_Me_encouragersoftware.com> wrote:
> Contact Mike McLoughlin of Sterling Data and ask for his expert opinion on
> your situation. He is the maker of an excellent import-export tool, and I'm
> sure could be of assistance in your situation.
>
> http://www.sterlingdata.com/
>
> mike AT sterlingdata DOT com
>
> Product Description - IMPEX, MFG - Sterling Data
> Internet Link - http://www.sterlingdata.com/impex.htm
>
> David

Thanks David,

The real problem is that I do not want to do import
(at the time) I want to leave their current data entry
and building structure of the FoxPro databases intact.

I do not have the time to do that now and
they can live with the "teaser" the flashy reporting.

So I copy their DBF and Memo files over to
a seperate directory to make sure everything
continues to work there on data-entry as it did.

However, the .NDX-files (the keys) I cannot
use as Clarion has a structure problem with them
(possibly "overed"). So I need (and want anyway,
because their old package has some real quirks I
need to deal with anyway if they go over totally any-
how) to resturcture the key-structure for those datafiles.

Problem is that for some reason I cannot simply
open Clarion for Window (DOS did an auto rebuild
of the keys on opening the application as far as I re-
member) and have the key-structure I build into the dic-
tionary used to create perfect working keys on the fly. It
complains about them being non-existent/corrupt then breaks.

[color=darkred]

I am looking for a solution so transparant that
they do not even notice it (auto-copy, auto-rebuild
of the keys etc.) as to enhance the user-experience.

It is easy to lose the future contract by making
them go through all kinds of hola hoops at this time
just for them to be able to make the new flashy reports.

I may want ImpEx or an alternative (or all of them) at a
later point in time when I have to do more re-structuring
(for them) but now it is far to complex for this small problem.

--
regards from Leeuwarden
Peter van Dobben de Bruijn
----
reply2usenet-2005 .at. The-Net-4U.com (.at. becomes @)
----

M.P. van Dobben de Bruijn

2005-07-27, 8:59 am

On Wed, 27 Jul 2005 01:30:06 UTC, "Leonid Chudakov" <chudakov@klarisoft.com> wrote:

> Hi,
>
> What about using BUILD command.

Exactly, but in the DOS version the templates
had an auto-feature for that when at first opening
it was discovered that the keys had got lost/corrupted.

Now I see a warning/remark and then it breaks.

So I will need to enter the BUILD some-
where but where do I put it? In the dictio-
nary in the filestructures and where or in an
embed (and which one) for the main window?

BTW nice tools on the KlariSoft site.

Looks I have missed out on a lot of
Windows programming "fun" / possibi-
lities because I did not want 2go Win only.

--
regards from Leeuwarden
Peter van Dobben de Bruijn
----
reply2usenet-2005 .at. The-Net-4U.com (.at. becomes @)
----

M.P. van Dobben de Bruijn

2005-07-27, 8:59 am

On Wed, 27 Jul 2005 11:23:38 UTC, "M.P. van Dobben de Bruijn" <Reply2Usenet-2005@The-Net-4U.com> wrote:

> On Wed, 27 Jul 2005 01:30:06 UTC, "Leonid Chudakov" <chudakov@klarisoft.com> wrote:
>
>
> Exactly, but in the DOS version the templates
> had an auto-feature for that when at first opening
> it was discovered that the keys had got lost/corrupted.
>
> Now I see a warning/remark and then it breaks.
>
> So I will need to enter the BUILD some-
> where but where do I put it? In the dictio-
> nary in the filestructures and where or in an
> embed (and which one) for the main window?

Bad form to answer ones own post,
but before anyone puts in a lot of work <g>:

Found a coding example in the Programming
Language Reference manual (in my version 6.2
on page 66) for Key's, static and dynanmic Indexes

CODE
OPEN(Sample,42h)
LOCK(Sample)
BUILD(Sam;Field2) (they forgot the closing bracket in the manual <G> )
UNLOCK(Sample)
BUILD(Sam:DynNdx,'-Sam:Field1,+Sam:Field2")

I'll have to look into that ,42h in the open statement, I guess.

Then transform it for the Keys and Indexes on the Files
I intend to use in the reporting application and then put
it (excluding the CODE) in a .CLW sourcefile and "embed"
that somewhere in the Main Window for the Reporting App.

My reasoning OK? Which embed-point do I best use?

--
regards from Leeuwarden
Peter van Dobben de Bruijn
----
reply2usenet-2005 .at. The-Net-4U.com (.at. becomes @)
----

Leonid Chudakov

2005-07-27, 8:59 am

42h gives you exclusive access to file.
Looks like this code must be placed somewhere before opening the files.
HTH

--
--
Leonid Chudakov
chudakov@klarisoft.com
Cool tools and Clarion examples at
http://www.klarisoft.com

"M.P. van Dobben de Bruijn" <Reply2Usenet-2005@The-Net-4U.com> wrote in
message news:Q3C8iT21jGKT-pn2-Svo8Wf73bbCd@localhost...
> On Wed, 27 Jul 2005 11:23:38 UTC, "M.P. van Dobben de Bruijn"
> <Reply2Usenet-2005@The-Net-4U.com> wrote:
>
>
> Bad form to answer ones own post,
> but before anyone puts in a lot of work <g>:
>
> Found a coding example in the Programming
> Language Reference manual (in my version 6.2
> on page 66) for Key's, static and dynanmic Indexes
>
> CODE
> OPEN(Sample,42h)
> LOCK(Sample)
> BUILD(Sam;Field2) (they forgot the closing bracket in the manual <G> )
> UNLOCK(Sample)
> BUILD(Sam:DynNdx,'-Sam:Field1,+Sam:Field2")
>
>
> I'll have to look into that ,42h in the open statement, I guess.
>
> Then transform it for the Keys and Indexes on the Files
> I intend to use in the reporting application and then put
> it (excluding the CODE) in a .CLW sourcefile and "embed"
> that somewhere in the Main Window for the Reporting App.
>
> My reasoning OK? Which embed-point do I best use?
>
> --
> regards from Leeuwarden
> Peter van Dobben de Bruijn
> ----
> reply2usenet-2005 .at. The-Net-4U.com (.at. becomes @)
> ----

M.P. van Dobben de Bruijn

2005-07-27, 5:01 pm

On Wed, 27 Jul 2005 13:02:49 UTC, "Leonid Chudakov" <chudakov@klarisoft.com> wrote:

> 42h gives you exclusive access to file.

From the commenting in the example code
in the manual I understood it is supposed to
be Red/Write Deny None and hence the LOCK
statement on the next line (commented for Exclusive
access). Are you sure that 42h is also locking it to me?

> Looks like this code must be placed somewhere before opening the files.

I embedded it in the Main (not Window but Frame of course)
Procedure of the application. In the Open Window and then it
goes before the generated code. If I look at the source it is then
in the main LOOP handling all events and on OF EVENT:OpenWindow.

But ...... I stil had problems. Until I looked thoroughly
(or perhaps after having some extra coffee a little bit mo-
re thoroughly) at the directory with the .DBF-files. Then dis-
covered that the first key was generated KeyName.IDX and
the second one did not get that far KeyName.$$$. So I looked
in the dictionary, the Primary Key was using an unique number of
one of the fields, the second key used that same field but had ano-
ther non-unique fields prefacing that one. I nevertheless wanted to ha-
ve the componented whole key to be unique. Perhaps something wrong
with that. Sure enough ... when I dropped the unique requirement for the
second key from the dictionary it worked without a hitch. The problem imme-
diately returns of course (even GPF-ing) if I put that unique requirement in again.

So there must be something wrong with that secondary key of two components.

Could it be that if the data is contaminated with non-unique combo values
this translates to this kind of behavior instead of graciously dropping to an er-
ror message (with full details) and then out of the key-generation and/or programm?

--
regards from Leeuwarden
Peter van Dobben de Bruijn
----
reply2usenet-2005 .at. The-Net-4U.com (.at. becomes @)
----

Sponsored Links