| Author |
OTC Mediator - SQL client
|
|
|
|
Hi!
I know it will sound weird, but have anyone one heard about SQL client that
connects to
SQL server using OTC Mediator? I need to have a ability to add new rows to a
SQL table, but those rows must be visible by Mediator. If I add a row with
MSSQL client (MSSQL server is used) the row is not visible buy the Mediator.
regards,
hs
| |
| Marek Horodyski 2004-06-28, 3:55 pm |
|
Użytkownik "hs" <nospam@dev.null> napisał w wiadomości
news:cbp7u9$8o3$1@news.onet.pl...
>
> Hi!
>
> I know it will sound weird, but have anyone one heard about SQL client
that
> connects to
> SQL server using OTC Mediator? I need to have a ability to add new rows to
a
> SQL table, but those rows must be visible by Mediator. If I add a row with
> MSSQL client (MSSQL server is used) the row is not visible buy the
Mediator.
>
I use this on Oracle (example) :
MedExecSql( "delete from mytable where is_deleted='Y'")
MyTable->( MedRfsRecc( Select()))
try function MedRfsRecc() after change. I use not continuous recno number.
Regards,
Marek Horodyski
| |
|
|
"Marek Horodyski" <m.horodyski@pzuzycie.com.pl> wrote in message
news:cbp9d8$m6a$1@atlantis.news.tpi.pl...
>
> I use this on Oracle (example) :
> MedExecSql( "delete from mytable where is_deleted='Y'")
> MyTable->( MedRfsRecc( Select()))
>
> try function MedRfsRecc() after change. I use not continuous recno number.
the problem is that I don't have the source code of my DOS application. I
need the abbility to add new rows to a SQL table that the program is
operating on. I don't get how Mediator controls adding new rows. Are the
rows numbers stored on a local file? I think It should be possible to
operate on the same table from many Mediator servers, but then Mediator
can't store rows numbers in a local file.
regards,
hs
| |
| Ross McKenzie 2004-06-29, 3:55 am |
| On Tue, 29 Jun 2004 08:58:48 +0200, "hs" <nospam@dev.null> wrote:
>
>"Marek Horodyski" <m.horodyski@pzuzycie.com.pl> wrote in message
>news:cbp9d8$m6a$1@atlantis.news.tpi.pl...
>the problem is that I don't have the source code of my DOS application. I
>need the abbility to add new rows to a SQL table that the program is
>operating on. I don't get how Mediator controls adding new rows. Are the
>rows numbers stored on a local file? I think It should be possible to
>operate on the same table from many Mediator servers, but then Mediator
>can't store rows numbers in a local file.
>
>regards,
>hs
>
>
If you have lost your source code and want it recovered, you might
like to send me an email to discuss your options.
Regards,
Ross McKenzie
ValuSoft
Melbourne Australia
valusoft AT optushome DOT com DOT au
| |
| Marek Horodyski 2004-06-29, 3:55 am |
|
Użytkownik "hs" <nospam@dev.null> napisał w wiadomości
news:cbr3np$7ua$1@news.onet.pl...
>
> "Marek Horodyski" <m.horodyski@pzuzycie.com.pl> wrote in message
> news:cbp9d8$m6a$1@atlantis.news.tpi.pl...
number.[color=darkred]
> the problem is that I don't have the source code of my DOS application. I
It is problem.
> need the abbility to add new rows to a SQL table that the program is
> operating on. I don't get how Mediator controls adding new rows. Are the
> rows numbers stored on a local file? I think It should be possible to
Row nubers is stored in special column "recno". But when you add record
under (below) mediator, it can't see this change.
> operate on the same table from many Mediator servers, but then Mediator
> can't store rows numbers in a local file.
Mediator can work on many serwers. Try ask more on www.otc.pl
Regards,
Marek Horodyski
| |
|
|
"Ross McKenzie" <NoJunk_valusoft@optushome.com.au> wrote in message
news:40e11aed.682093@news...
> If you have lost your source code and want it recovered, you might
> like to send me an email to discuss your options.
thanks, I don't want to recover the source code, I just want to know, how to
add rows to a table outside the program.
| |
|
|
Użytkownik "hs" <nospam@dev.null> napisał w wiadomości
news:cbr3np$7ua$1@news.onet.pl...
>
> the problem is that I don't have the source code of my DOS application. I
> need the abbility to add new rows to a SQL table that the program is
> operating on. I don't get how Mediator controls adding new rows. Are the
> rows numbers stored on a local file? I think It should be possible to
> operate on the same table from many Mediator servers, but then Mediator
> can't store rows numbers in a local file.
Without the source code of your app you are in trouble.
In Mediator record numbers are stored in special column called Recno and the
MaxRecno value is cached in Mediator server for better performance.
As already mentioned by Marek, to refresh internal Mediator cache related
to given table you can call MedRfsRecc() function or to permanently turn off
MaxRecno caching for a given table you may call MedExRecc(.T.).
The above two options require source code, however.
If no source code is available, you still have two other options:
1. Add records through Mediator xbAPI interface. At this
moment Delphi interface is supported.
2. Add records using Mediator OLE DB interface.
In both cases all records travel through Mediator server and will
be visible immediately after appending.
Regards,
Jacek Potempa
OTC S.A.
www.otc.pl
| |
|
|
"Jacek" <Jacek.Potempa@otc.pl> wrote in message
news:cbrbod$a80$1@news.onet.pl...
> The above two options require source code, however.
> If no source code is available, you still have two other options:
> 1. Add records through Mediator xbAPI interface. At this
> moment Delphi interface is supported.
> 2. Add records using Mediator OLE DB interface.
thanks a lot, this is what I am going to do.
regards,
hs
| |
|
|
"Jacek" <Jacek.Potempa@otc.pl> wrote in message
news:cbrbod$a80$1@news.onet.pl...
> 1. Add records through Mediator xbAPI interface. At this
> moment Delphi interface is supported.
> 2. Add records using Mediator OLE DB interface.
which of these methods is compatible with Mediator server 3.0.7.1 ?
| |
|
| > > 2. Add records using Mediator OLE DB interface.
> which of these methods is compatible with Mediator server 3.0.7.1 ?
Mediator OLE DB interface.
If you don't have proper libraries, send me private e-mail
and I'll forward them to you.
Jacek
|
|
|
|