Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #2766 > unrolled thread

MySql refreshing.

Started byedgsun <edgsun@gmail.com>
First post2012-01-04 03:42 -0800
Last post2012-01-05 12:08 +0100
Articles 11 — 5 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  MySql refreshing. edgsun <edgsun@gmail.com> - 2012-01-04 03:42 -0800
    Re: MySql refreshing. edgsun <edgsun@gmail.com> - 2012-01-04 08:13 -0800
      Re: MySql refreshing. Szepi <szepligeti@gmail.com> - 2012-01-04 09:53 -0800
      Re: MySql refreshing. "Marc Verkade [Marti]" <marcatm@rti.nl> - 2012-01-04 19:37 +0100
        Re: MySql refreshing. edgsun <edgsun@gmail.com> - 2012-01-09 05:10 -0800
          Re: MySql refreshing. "Willie Moore" <williem@wmconsulting.com> - 2012-01-09 07:28 -0600
            Re: MySql refreshing. edgsun <edgsun@gmail.com> - 2012-01-09 06:06 -0800
          Re: MySql refreshing. "Marc Verkade [Marti]" <marcatm@rti.nl> - 2012-01-09 23:24 +0100
    Re: MySql refreshing. "Willie Moore" <williem@wmconsulting.com> - 2012-01-04 13:45 -0600
      Re: MySql refreshing. edgsun <edgsun@gmail.com> - 2012-01-04 18:56 -0800
    Re: MySql refreshing. "Danilo Giuliani" <softdevo@tiscali.it> - 2012-01-05 12:08 +0100

#2766 — MySql refreshing.

Fromedgsun <edgsun@gmail.com>
Date2012-01-04 03:42 -0800
SubjectMySql refreshing.
Message-ID<b31e6588-d98e-48aa-beaf-ccab23054483@k10g2000yqk.googlegroups.com>
Hello:

How do I propagate changes made to a MySQL database, to other open
sessions of CAVO?

It seems that Cavo read all of the tables and keep it in memory and
not refresh what has been done in other sessions.

For example, if you add a new record to a table, that row is not seen
in other sessions that are open.

Refresh does not work.We must close the session of CAVO and start
again, then is seen the new record.

TIA

[toc] | [next] | [standalone]


#2772

Fromedgsun <edgsun@gmail.com>
Date2012-01-04 08:13 -0800
Message-ID<ae21734b-441f-4018-adc0-66990abb6191@v14g2000yqh.googlegroups.com>
In reply to#2766
On Jan 4, 6:42 am, edgsun <edg...@gmail.com> wrote:
Hi:

I have found that closing the sqlconnection and opening a new one, the
pointer of the tables and changes made on other stations are
refreshed.

I think that this consumes too many resources because the connections
persist some time after closed, although it is a solution to a problem
that I consider to be serious.

An improvement to this solution would be to find a method to kill the
connection immediately.

If this is put into effect, it is not possible to return the results
of the searches as sqlselects objects but as dbase files.

Bye

ES
> Hello:
>
> How do I propagate changes made to a MySQL database, to other open
> sessions of CAVO?
>
> It seems that Cavo read all of the tables and keep it in memory and
> not refresh what has been done in other sessions.
>
> For example, if you add a new record to a table, that row is not seen
> in other sessions that are open.
>
> Refresh does not work.We must close the session of CAVO and start
> again, then is seen the new record.
>
> TIA

[toc] | [prev] | [next] | [standalone]


#2774

FromSzepi <szepligeti@gmail.com>
Date2012-01-04 09:53 -0800
Message-ID<74855e81-6a0c-4a2e-9fe2-3f8f5483d807@m20g2000vbf.googlegroups.com>
In reply to#2772
Hi,

The solution Vo2Ado.

Szepligeti

[toc] | [prev] | [next] | [standalone]


#2775

From"Marc Verkade [Marti]" <marcatm@rti.nl>
Date2012-01-04 19:37 +0100
Message-ID<4f049ce6$0$830$58c7af7e@news.kabelfoon.nl>
In reply to#2772
Are you sure you commit the changes?
Gr, Marc

"edgsun"  schreef in bericht 
news:ae21734b-441f-4018-adc0-66990abb6191@v14g2000yqh.googlegroups.com...

On Jan 4, 6:42 am, edgsun <edg...@gmail.com> wrote:
Hi:

I have found that closing the sqlconnection and opening a new one, the
pointer of the tables and changes made on other stations are
refreshed.

I think that this consumes too many resources because the connections
persist some time after closed, although it is a solution to a problem
that I consider to be serious.

An improvement to this solution would be to find a method to kill the
connection immediately.

If this is put into effect, it is not possible to return the results
of the searches as sqlselects objects but as dbase files.

Bye

ES
> Hello:
>
> How do I propagate changes made to a MySQL database, to other open
> sessions of CAVO?
>
> It seems that Cavo read all of the tables and keep it in memory and
> not refresh what has been done in other sessions.
>
> For example, if you add a new record to a table, that row is not seen
> in other sessions that are open.
>
> Refresh does not work.We must close the session of CAVO and start
> again, then is seen the new record.
>
> TIA 

[toc] | [prev] | [next] | [standalone]


#2790

Fromedgsun <edgsun@gmail.com>
Date2012-01-09 05:10 -0800
Message-ID<83beac78-ad5e-4e47-b43c-67d4b1be5504@y12g2000yqc.googlegroups.com>
In reply to#2775
On Jan 4, 1:37 pm, "Marc Verkade [Marti]" <marc...@rti.nl> wrote:
> Are you sure you commit the changes?
> Gr, Marc
>
Hi Marc:

This is the situation:
Open a session SqlYog on a station, a Cavo session at another station
and then opened a third session Cavo in another terminal.

We do insertions and changes in a table in the third season. SQLyog
has access to the modified records. The first session of Cavo (older)
does not have this access, unless you close your connection, and then
a new.

If you can achieve changes in the older session, I have configured my
system in a wrong way.

Refresh the query is not solution, because my querys are refreshed
each applied EDITCHANGE to the search string when looking out records.

My Cavo is 2.7b with the latest update.

My connection:

scrollconcurrency 4
AccessMode 0
IsolationOption 2
ODBCCursors 1
PositionOps.T.

Many Thanks.

ES

[toc] | [prev] | [next] | [standalone]


#2791

From"Willie Moore" <williem@wmconsulting.com>
Date2012-01-09 07:28 -0600
Message-ID<jeeq0s$sle$1@speranza.aioe.org>
In reply to#2790
Hey,

This is something that is not unique to VO. I see the same behavior that you 
are describing in php. I have a button that the user can click to re-issue 
the query immediately otherwise my screens refresh the data periodically.

Regards,
Willie
Vulcan VIP 

[toc] | [prev] | [next] | [standalone]


#2792

Fromedgsun <edgsun@gmail.com>
Date2012-01-09 06:06 -0800
Message-ID<a497f47b-4820-4169-8e34-cef822a13057@v14g2000yqh.googlegroups.com>
In reply to#2791
On Jan 9, 8:28 am, "Willie Moore" <will...@wmconsulting.com> wrote:
> Hey,
>
> This is something that is not unique to VO. I see the same behavior that you
> are describing in php. I have a button that the user can click to re-issue
> the query immediately otherwise my screens refresh the data periodically.

Thanks Willie:

What I understand is doing the work in this way:

For updates:

MyClassUpdateButton()
open connection
Begin transaction
updates, insertion, deletes
recover
Rollback()
end transaction
return bla bla

To search:

MySearchWindow:postinit(bla_,bla)
Openconection
Bla bla bla

MySearchWindow:EndWindow()
Put the result of the search in a dbase table or an array of variables
If you return the qwery result, you must keep connection opened.
Return (what I need)

Regardos from Edgardo :)

ES

[toc] | [prev] | [next] | [standalone]


#2793

From"Marc Verkade [Marti]" <marcatm@rti.nl>
Date2012-01-09 23:24 +0100
Message-ID<4f0b6948$0$817$58c7af7e@news.kabelfoon.nl>
In reply to#2790
OK, I understand.

SQLConnection:Reconnect() does a disconnect and connect so that wil not help 
you I guess.

Perhaps the following calls can help

SQLStatement:__Reset() or SQLSelect:__Reset()

Perhaps trigger a notification?
SQLSelect:Notify(NOTIFYFILECHANGE)`

Or..

SQLSelect:ResetCursor( SQL_SC_UPD_KEY )

If this all does not work, I guess trying VO2ADO is the way...
Sorry if I cannot be more specific!

Grtz, Marc



"edgsun"  schreef in bericht 
news:83beac78-ad5e-4e47-b43c-67d4b1be5504@y12g2000yqc.googlegroups.com...

On Jan 4, 1:37 pm, "Marc Verkade [Marti]" <marc...@rti.nl> wrote:
> Are you sure you commit the changes?
> Gr, Marc
>
Hi Marc:

This is the situation:
Open a session SqlYog on a station, a Cavo session at another station
and then opened a third session Cavo in another terminal.

We do insertions and changes in a table in the third season. SQLyog
has access to the modified records. The first session of Cavo (older)
does not have this access, unless you close your connection, and then
a new.

If you can achieve changes in the older session, I have configured my
system in a wrong way.

Refresh the query is not solution, because my querys are refreshed
each applied EDITCHANGE to the search string when looking out records.

My Cavo is 2.7b with the latest update.

My connection:

scrollconcurrency 4
AccessMode 0
IsolationOption 2
ODBCCursors 1
PositionOps.T.

Many Thanks.

ES 

[toc] | [prev] | [next] | [standalone]


#2776

From"Willie Moore" <williem@wmconsulting.com>
Date2012-01-04 13:45 -0600
Message-ID<je2a8n$jcp$1@speranza.aioe.org>
In reply to#2766
Hey,

How are you calling your mySQL tables? VO SQL classes, VO2ADO, another 3rd 
party lib? In general, with SQL you have to refresh your query. With VO2ADO 
you use the requery method.

Regards,
Willie
Vulcan VIP 

[toc] | [prev] | [next] | [standalone]


#2778

Fromedgsun <edgsun@gmail.com>
Date2012-01-04 18:56 -0800
Message-ID<af2fc3ec-4c3e-4e34-94c7-7a18b49e1269@p16g2000yqd.googlegroups.com>
In reply to#2776
Hi:

I do via VO SQL Classes

I tried several ways.

Only closing connection refresh pointers.

Thks Willie.

On Jan 4, 2:45 pm, "Willie Moore" <will...@wmconsulting.com> wrote:
> Hey,
>
> How are you calling your mySQL tables? VO SQL classes, VO2ADO, another 3rd
> party lib? In general, with SQL you have to refresh your query. With VO2ADO
> you use the requery method.
>
> Regards,
> Willie
> Vulcan VIP

[toc] | [prev] | [next] | [standalone]


#2779

From"Danilo Giuliani" <softdevo@tiscali.it>
Date2012-01-05 12:08 +0100
Message-ID<4f0584c1$0$16652$5fc30a8@news.tiscali.it>
In reply to#2766
simply re-run the query

Danilo


[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web