Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #2766 > unrolled thread
| Started by | edgsun <edgsun@gmail.com> |
|---|---|
| First post | 2012-01-04 03:42 -0800 |
| Last post | 2012-01-05 12:08 +0100 |
| Articles | 11 — 5 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | edgsun <edgsun@gmail.com> |
|---|---|
| Date | 2012-01-04 03:42 -0800 |
| Subject | MySql 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]
| From | edgsun <edgsun@gmail.com> |
|---|---|
| Date | 2012-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]
| From | Szepi <szepligeti@gmail.com> |
|---|---|
| Date | 2012-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]
| From | "Marc Verkade [Marti]" <marcatm@rti.nl> |
|---|---|
| Date | 2012-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]
| From | edgsun <edgsun@gmail.com> |
|---|---|
| Date | 2012-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]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2012-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]
| From | edgsun <edgsun@gmail.com> |
|---|---|
| Date | 2012-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]
| From | "Marc Verkade [Marti]" <marcatm@rti.nl> |
|---|---|
| Date | 2012-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]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2012-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]
| From | edgsun <edgsun@gmail.com> |
|---|---|
| Date | 2012-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]
| From | "Danilo Giuliani" <softdevo@tiscali.it> |
|---|---|
| Date | 2012-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