|
Débuté par Steahlty, 20 sep. 2013 10:01 - 6 réponses |
| |
| | | |
|
| |
Membre enregistré 12 messages |
|
Posté le 20 septembre 2013 - 10:01 |
Hi Community,
we are using Webdev 18 and are having a little problem:
In our applications we have the problem, when we are changing a record, the changes are made in the SQL database of our server but the implemented query in our site does not show them. We have to wait about 5 to 10 minutes or sometimes logoff from the site to see the changes.
Now my question: Are the any possibilities to configure the Webdev Application Server to use an cache or better to turn it off?
This is our configuration:
Client Browser: IE 9
Client OS: Windows 7
Webdev Application Server Version 18 Build 63c
Webdev Application Server: Server OS Windows Server 2008 R2
Database: MS SQL Server 2008
Thanks for your replies.
GreetzMessage modifié, 20 septembre 2013 - 10:02 |
| |
| |
| | | |
|
| | |
| |
Posté le 20 septembre 2013 - 15:40 |
Hi Andreas
I have never seen such a behavior, and I'm pretty sure it has nothing to do with webdev OR the DB... If you write a reocrd in the DB, then it's there and usable as soon as written...
So either you are NOT refreshing the data in your query when you think you are doing it, or whatever SQL DB you are using is getting ready to explode on you
Best regards
-- Fabrice Harari International WinDev, WebDev and WinDev mobile Consulting
More information on http://www.fabriceharari.com
On 9/20/2013 2:01 AM, Steahlty wrote:
Hi Community,
we are using Webdev 18 and are having a little problem:
In our applications we have the problem, when we are changing a record, the changes are made in the SQL database of our server but the implemented query in our site does not show them. We have to wait about 5 to 10 minutes or sometimes logoff from the site to see the changes.
Now my question: Are the any possibilities to configure the Webdev Application Server to use an cache or better to turn it off?
This is our configuration:
Client Browser: IE 9
Client OS: Windows 7
Webdev Application Server Version 18 Build 63c
Webdev Application Server: Server OS Windows Server 2008 R2
Database: MS SQL Server 2008
Thanks for your replies.
Greetz |
| |
| |
| | | |
|
| | |
| |
Membre enregistré 12 messages |
|
Posté le 01 octobre 2013 - 13:40 |
So do you have a tip for me, how the data in a query is usually refreshed?
I did not find anything in the Webdev-Help. |
| |
| |
| | | |
|
| | |
| |
Posté le 01 octobre 2013 - 16:50 |
Hi Andreas
the data in a query is refreshed only when you REexecute it. So generally, what you do (if you eed to) is to checkl the file to see if something has changed (hversion, in HF database), and if yes, you do hexecutequery again and redisplay (it is of course possible that the change in the FILE is not part of the query dataset)
Best regards
-- Fabrice Harari International WinDev, WebDev and WinDev mobile Consulting
More information on http://www.fabriceharari.com
On 10/1/2013 5:40 AM, Steahlty wrote:
So do you have a tip for me, how the data in a query is usually refreshed?
I did not find anything in the Webdev-Help. |
| |
| |
| | | |
|
| | |
| |
Membre enregistré 12 messages |
|
Posté le 07 octobre 2013 - 13:24 |
Hi Fabrice,
thanks for your replies. But i have some more questions:
- is hversion working on a ms sql database too? You wrote only about hf databases. - i thought, that a query is automatically reexecuted, when i do a pagedisplay and fill an included table not by programming but with the data from a query. -i also thought the same way, when i do a pageinitialize() so that all controlls are reloaded.
And how do i reexecute a query, that fills the content of a table and i did not fill the table by programming. |
| |
| |
| | | |
|
| | |
| |
Posté le 07 octobre 2013 - 15:14 |
Hi
- is hversion working on a ms sql database too? You wrote only about hf databases.
The answer to that question is in the help file, on the first line on the left... You have a line of icons telling you for what environement a function is available... In this case, HF, nativeAccess and OLEDB are supported.
- i thought, that a query is automatically reexecuted, when i do a pagedisplay and fill an included table not by programming but with the data from a query.
When you do a pagedispllay the query linked to a table of the page will be executed, not RE-executed (the page is displayed, not RE-displayed)
If you want to refresh the page, you should do a tabledisplay with hreexecutequery constant
Best regards
-- Fabrice Harari International WinDev, WebDev and WinDev mobile Consulting
More information on http://www.fabriceharari.com
-i also thought the same way, when i do a pageinitialize() so that all controlls are reloaded.
And how do i reexecute a query, that fills the content of a table and i did not fill the table by programming. |
| |
| |
| | | |
|
| | |
| |
Membre enregistré 12 messages |
|
Posté le 07 octobre 2013 - 16:21 |
Fabrice Harari wrote:
> Hi
> - is hversion working on a ms sql database too? You wrote only about hf
databases.
>
> The answer to that question is in the help file, on the first line on
the left... You have a line of icons telling you for what environement a
> function is available... In this case, HF, nativeAccess and OLEDB are
supported.
But in the line, where the syntax is explained, there are to icons, telling that for OleDB and native access the version number is always equal to 0.
So the only possibility i think i have, is to do a tabledisplay with the reexecution-option when i initialize the page. |
| |
| |
| | | |
|
| | | | |
| | |
|