Clarion - COM Wrapper

Author

COM Wrapper

mpollux_ork

2006-07-26, 6:55 pm

Hi, I have been working with clarion for about ten months, although at
work it's not the main developing language. I work at a Retail Sales
Company, and our POS was made in Clarion with tps's, so from time to
time we have to do little maintenance to some files. I am proficient
now with making little programs that will update a field on a row, or
the entire table, and so on. What I need to do now is to wrap that
functionality in a COM server, so I can use as a DAO recordset, for
instance. I don't need it to be generic, I'm only going to access one
file.

What I have in mind is a class with open(), close(), movefirst(),
movelast(), getrecord() methods, and maybe "eof", "bof",
"currentrecord", "record" properties. All of this for a specific TPS
file, and in this particular case, for read only access. What I need is
to get information for this table, and update an MS-Access file with
it, so I want to use a VB application, accessing the TPS via COM
SERVER.

I would really appreciate if you could give me any advice.

Thanks in advance.

Abe Jimenez

2006-07-26, 9:55 pm

Hi,

The only way I know to access TPS file data with other programming tools is
with the ODBC driver. If I were you, I would seriously consider converting
the Clarion application to a SQL server or even an MS-Access database.
Clarion and VB both work fine with those databases.

As far as doing an 'open(), close(), movefirst(), movelast(), getrecord()
methods, and maybe "eof", "bof", "currentrecord", "record" properties', your
simplest solution is to use the default Browse/Form generated Clarion
procedures. You can also use a form with VCR buttons and do something that
looks more like Access. It's not COM, but you can certainly achieve what
you want. Simply import your MS-Access table into the Clarion dictionary
and you can update it just like you update the TPS database.

--

Regards,
Abe Jimenez

"mpollux_ork" <mpollux@gmail.com> wrote in message
news:1153958412.551800.56850@s13g2000cwa.googlegroups.com...
> Hi, I have been working with clarion for about ten months, although at
> work it's not the main developing language. I work at a Retail Sales
> Company, and our POS was made in Clarion with tps's, so from time to
> time we have to do little maintenance to some files. I am proficient
> now with making little programs that will update a field on a row, or
> the entire table, and so on. What I need to do now is to wrap that
> functionality in a COM server, so I can use as a DAO recordset, for
> instance. I don't need it to be generic, I'm only going to access one
> file.
>
> What I have in mind is a class with open(), close(), movefirst(),
> movelast(), getrecord() methods, and maybe "eof", "bof",
> "currentrecord", "record" properties. All of this for a specific TPS
> file, and in this particular case, for read only access. What I need is
> to get information for this table, and update an MS-Access file with
> it, so I want to use a VB application, accessing the TPS via COM
> SERVER.
>
> I would really appreciate if you could give me any advice.
>
> Thanks in advance.
>

mpollux_ork

2006-07-28, 6:55 pm

Abe, thanks a lot for your response.

I have worked with the ODBC driver, but given the large amount of
records we are working with, it has proven not to work correctly.

We are migrating to a different POS system in about two months, this
time it is going to be clarion with dat's, and this time we expect to
have more control over the source code.

I liked your idea of doing the program in clarion, i honestly had not
thought of that approach, so I'm going to try it.

Regards,

Manuel Porras

Abe Jimenez ha escrito:
[color=darkred]
> Hi,
>
> The only way I know to access TPS file data with other programming tools is
> with the ODBC driver. If I were you, I would seriously consider converting
> the Clarion application to a SQL server or even an MS-Access database.
> Clarion and VB both work fine with those databases.
>
> As far as doing an 'open(), close(), movefirst(), movelast(), getrecord()
> methods, and maybe "eof", "bof", "currentrecord", "record" properties', your
> simplest solution is to use the default Browse/Form generated Clarion
> procedures. You can also use a form with VCR buttons and do something that
> looks more like Access. It's not COM, but you can certainly achieve what
> you want. Simply import your MS-Access table into the Clarion dictionary
> and you can update it just like you update the TPS database.
>
> --
>
> Regards,
> Abe Jimenez
>
>
> "mpollux_ork" <mpollux@gmail.com> wrote in message
> news:1153958412.551800.56850@s13g2000cwa.googlegroups.com...

Abe Jimenez

2006-07-31, 7:06 pm

Manuel,

If you have a choice of databases in your new POS software you may want to
consider the TPS driver over DAT. Especially if you are going to have a lot
of data.

--

Regards,
Abe Jimenez

"mpollux_ork" <mpollux@gmail.com> wrote in message
news:1154095632.478928.111560@m73g2000cwd.googlegroups.com...
> Abe, thanks a lot for your response.
>
> I have worked with the ODBC driver, but given the large amount of
> records we are working with, it has proven not to work correctly.
>
> We are migrating to a different POS system in about two months, this
> time it is going to be clarion with dat's, and this time we expect to
> have more control over the source code.
>
> I liked your idea of doing the program in clarion, i honestly had not
> thought of that approach, so I'm going to try it.
>
> Regards,
>
> Manuel Porras
>
>
> Abe Jimenez ha escrito:
>
>

Sponsored Links