Clarion - access to clarion 2.1

Author

access to clarion 2.1

metall

2005-02-02, 8:55 pm

Hi everyone!

I have to access to clarion 2.1 base (dos, running on windowsXP) from .NET
application.

I have no problems with export datas from DAT files to another format
(MSSQL 2000), but I must update clarion dos database from my soft (one
time per day), because clarion is still in use and some people work with
this. I haven't DEF or APP files.

I cant replace orginal DAT file by file creating in another program (this
same columns - name, type and length) because clarion throw an error.
And I try others methods, but I haven't results and ... ideas.

Please, Help !

Thank you.

Edi

JMumf

2005-02-03, 3:55 am

If it was me I would write a program in Clarion for Windows that would
update the Clarion Dat file.

Clarion for Windows can read your MSSQL tables and write to you Clarion
DAT files.

Clarion for Window can also import you Clarion DAT files into it's
dictionary. The only problem could be that you may have an OLD version
of the DAT files and may have some problems because of that. I seem to
recall an older version of the DAT file format. Not sure how you can
tell.

JMumf

Leonid Chudakov

2005-02-03, 3:55 am

Hi,

If you can call Windows dlls from your .NET application then you can write a
dll in Clarion which will update DAT files.

--
--
Leonid Chudakov
chudakov@klarisoft.com
Cool tools and Clarion examples at
http://www.klarisoft.com
"metall" <edi_w@yahoo.com> wrote in message
news:c448373ef47ca4ca48a39ff5c1ebe11d@lo
calhost.talkaboutprogramming.com...
> Hi everyone!
>
> I have to access to clarion 2.1 base (dos, running on windowsXP) from .NET
> application.
>
> I have no problems with export datas from DAT files to another format
> (MSSQL 2000), but I must update clarion dos database from my soft (one
> time per day), because clarion is still in use and some people work with
> this. I haven't DEF or APP files.
>
> I cant replace orginal DAT file by file creating in another program (this
> same columns - name, type and length) because clarion throw an error.
> And I try others methods, but I haven't results and ... ideas.
>
> Please, Help !
>
> Thank you.
>
> Edi
>

metall

2005-02-03, 8:55 am

Thank you very much!

I was afraid about this. :) Soo, I have to learn Clarion for Windows. :)
Is any freeware version of Clarion Windows application?

Edi

metall

2005-02-03, 8:55 am

Thank you for your answer!

Is any freeware tool, apllication to create Clarion application for
Windows? If not, then which version of Clarion (5 or 6, maybe another) I
have to use, to create Windows DLL ?

best regards
edi

Nick Coe \(UK\)

2005-02-03, 8:55 am

Clarion 6.1. There's no freeware version AFAIK.

This site might be usefull though:

http://www.juliasoft.com/clarion.html

--
Nick Coe (UK)
AccHelp v1.01 Access Application Help File Builder
http://www.alphacos.co.uk/
Download Free Copy
----

In
news:cf656c10e5571bc910ae6173e12c4f5e@lo
calhost.talkaboutprogramming.com,
metall typed:
> Thank you for your answer!
>
> Is any freeware tool, apllication to create Clarion
> application for
> Windows? If not, then which version of Clarion (5 or 6,
> maybe
> another) I have to use, to create Windows DLL ?
>
> best regards
> edi

metall

2005-02-03, 8:55 am

X-Complaints-To: abuse@supernews.com
Lines: 9
Xref: newsfeed-west.nntpserver.com comp.lang.clarion:151991

Wow !!!

Yes, this is very usefull site!

Thank you!!

Best Regards
Edi

Leonid Chudakov

2005-02-03, 3:55 pm

Hi,

For your purposes you can use any Clarion for Windows version.
You can download C5 demo from ftp.clarion.ru/clarion/c5eval/ using clarion
as username/password

--
--
Leonid Chudakov
chudakov@klarisoft.com
Cool tools and Clarion examples at
http://www.klarisoft.com
"metall" <edi_w@yahoo.com> wrote in message
news:cf656c10e5571bc910ae6173e12c4f5e@lo
calhost.talkaboutprogramming.com...
> Thank you for your answer!
>
> Is any freeware tool, apllication to create Clarion application for
> Windows? If not, then which version of Clarion (5 or 6, maybe another) I
> have to use, to create Windows DLL ?
>
> best regards
> edi
>
>
>
>
>

Dr.Ruud

2005-02-03, 3:55 pm

Toen ik Leonid Chudakov kietelde, kwam er dit uit:

> You can download C5 demo from ftp.clarion.ru/clarion/c5eval/ using
> clarion as username/password

ftp://clarion:clarion@ftp.clarion.ru/clarion/c5eval/

--
Affijn, Ruud ` - ?
+ ` ? *
? ` Jvr qvg yrrfg,
? = ` fgresg wbatre.

Dr.Ruud

2005-02-03, 3:55 pm

Toen ik metall kietelde, kwam er dit uit:

> I have to access to clarion 2.1 base (dos, running on windowsXP) from
> .NET application.
>
> I have no problems with export datas from DAT files to another format
> (MSSQL 2000), but I must update clarion dos database from my soft (one
> time per day), because clarion is still in use and some people work
> with this. I haven't DEF or APP files.

Can't you create (with Clarion 2.1) a special daily synchronize-
application? Your .NET application can create textual tab-separated
datafiles, to be processed by that sync-app.

--
Affijn, Ruud ` - ?
+ ` ? *
? ` Jvr qvg yrrfg,
? = ` fgresg wbatre.

metall

2005-02-03, 3:55 pm

thank you for this :)

regards
edi

metall

2005-02-03, 3:55 pm

The problem is in driver to clarion 1.2 DAT files. Because i haven't any
clarion development software. But a few hours ago I found a file with
description about DAT structures. And i try to create file driver.

edi

metall

2005-02-03, 3:55 pm

thanks!

edi

Dr.Ruud

2005-02-03, 3:55 pm

Toen ik metall kietelde, kwam er dit uit:

> The problem is in driver to clarion 1.2 DAT files. Because i haven't
> any clarion development software. But a few hours ago I found a file
> with description about DAT structures. And i try to create file
> driver.

Clarion 2.1 comes with CCVT.EXE. It is feasible to dump the current
data into a textual datafile (or even a DBF), then use that datafile
to do the updates, and recreate from the datafile the updated DAT &
K## files.

--
Affijn, Ruud ` - ?
+ ` ? *
? ` Jvr qvg yrrfg,
? = ` fgresg wbatre.

metall

2005-02-04, 3:55 pm

Yes, but when I use this tool and export data to dbf and editing with MS
Access then I cannot run programm based on clarion 2.1, because it throw
famous error 47 :) Another problem is with CCTV.EXE, because I cannot run
this tool from cmd line without interaction with user. I want use CCTV
like this: "CCTV.EXE File.DAT File.DBF" and after "CCTV File.DBF
File.DAT". But CCTV doesn't support this. Exist any free tool to remove 47
ERROR?

best regards
edi

Odd Johannesen

2005-02-04, 3:55 pm

Hi edi

My example with the Converter utility:

CCVT.EXE t=clarion i=elkem o=dbaseIII f=elkem /v
This should convert the file ELKEM.DAT to ELKEM.DBF without showing screen
picture.
! Check the name of your EXE-file

Regards

Odd Johannesen
Granli 23
NO- 4550 FARSUND
Norway

odd@toalango.com

> Yes, but when I use this tool and export data to dbf and editing with MS
> Access then I cannot run programm based on clarion 2.1, because it throw
> famous error 47 :) Another problem is with CCTV.EXE, because I cannot run
> this tool from cmd line without interaction with user. I want use CCTV
> like this: "CCTV.EXE File.DAT File.DBF" and after "CCTV File.DBF
> File.DAT". But CCTV doesn't support this. Exist any free tool to remove 47
> ERROR?
>
> best regards
> edi

Jason Berkan

2005-02-04, 3:55 pm

On Fri, 04 Feb 2005 03:46:26 -0500, "metall" <edi_w@yahoo.com> wrote:
>Yes, but when I use this tool and export data to dbf and editing with MS
>Access then I cannot run programm based on clarion 2.1, because it throw
>famous error 47 :) Another problem is with CCTV.EXE, because I cannot run
>this tool from cmd line without interaction with user. I want use CCTV
>like this: "CCTV.EXE File.DAT File.DBF" and after "CCTV File.DBF
>File.DAT". But CCTV doesn't support this.

Yes it does. Check the docs, but I believe you have to use I= for the
input file and O= for the output file.

>Exist any free tool to remove 47
>ERROR?

CFIL and your source code that contains the file declaration. After
converting from DBF to DAT you get a generic DAT file that does not
match the file definition your program expects. If you run CFIL on
it, it will convert it and your program will run perfectly.

Jason

metall

2005-02-04, 8:55 pm

Yes, you have right. But I have a problem with CFIL.EXE program. When I use
CCVT.EXE file for conversion DBF to DAT it produce a .TMP file with
definition of DAT file. When I try to use CFIL I have a big problem. Field
Source File want a .CLA file and I don't know what I have to type into
filed Label.

regards
edi

metall

2005-02-04, 8:55 pm

Jason Berkan

2005-02-04, 8:55 pm

On Fri, 04 Feb 2005 15:46:33 -0500, "metall" <edi_w@yahoo.com> wrote:
>Yes, you have right. But I have a problem with CFIL.EXE program. When I use
>CCVT.EXE file for conversion DBF to DAT it produce a .TMP file with
>definition of DAT file. When I try to use CFIL I have a big problem. Field
>Source File want a .CLA file and I don't know what I have to type into
>filed Label.

Do you have the source code for the program?

Jason

metall

2005-02-05, 8:55 am

No, I haven't s source code and probably this is the big problem. CCVT and
CFIL I downloaded from www.
I tried to resolve my problem by creating application in Clarion 5, but
I'm not a Clarion developer and I don't know Clarion Language and IDE (for
me this is like control of space shuttle).
For me the best solution is a tool, that can be read and write into
Clarion .DAT file and not be a Clarion Application (EXE or DLL). I read
many websites and I cannot find any useful tool.
Maybe I have to create my own driver by reading binary file, extracting
header and rows and compose that again into DAT file. But this is very
riskly. Have you any other idea?

best regards
edi

JMumf

2005-02-05, 8:55 pm

As far as I know no utilities exist. What you are looking for is
something like an ODBC for Clarion .DAT files, again I do not know of
one that exists. Your simplest solution is to write a Process
application in Clarion for Windows.
It would be much harder to write a utility that would do what you want.

If you want I could write something for you, but I would need to charge
you for it (that how I make my living).
It would be possible to write something that handles a couple of tables
and you could finish the rest. The code does not need to be that fancy
a lot of it would be done by the Templates. It would basiclly be a few
Process Procedures with some embeded code. When the program is run in
AutoMode it would just run, process and end. I do this all the time.

JMumf

David S. Beggs

2005-02-06, 3:55 am

if it's only once a day, you might be able to use ccvt.exe to convert the
entire database to dbase, make your changes, then use ccvt.exe to convert it
back to clarion dat files.

"metall" <edi_w@yahoo.com> wrote in message
news:c448373ef47ca4ca48a39ff5c1ebe11d@lo
calhost.talkaboutprogramming.com...
> Hi everyone!
>
> I have to access to clarion 2.1 base (dos, running on windowsXP) from .NET
> application.
>
> I have no problems with export datas from DAT files to another format
> (MSSQL 2000), but I must update clarion dos database from my soft (one
> time per day), because clarion is still in use and some people work with
> this. I haven't DEF or APP files.
>
> I cant replace orginal DAT file by file creating in another program (this
> same columns - name, type and length) because clarion throw an error.
> And I try others methods, but I haven't results and ... ideas.
>
> Please, Help !
>
> Thank you.
>
> Edi
>

metall

2005-02-10, 3:55 am

Thank you very much!

I was afraid about this. :) Soo, I have to learn Clarion for Windows. :)
Is any freeware version of Clarion Windows application?

Edi

metall

2005-02-10, 3:55 am

Nick Coe \(UK\)

2005-02-10, 3:55 am

Leonid Chudakov

2005-02-10, 3:55 am

Sponsored Links