Welcome! Log In Create A New Profile

Advanced

refreshing table MSSQL Windev 21

Posted by Niek 
Niek
refreshing table MSSQL Windev 21
February 04, 2022 12:54PM
I have a tablecontrol linked to a MSSQL table.
After adding a new record i want to refresh the table.
Therefore I use:

TableDeleteAll(table)
ExecuteProcess(table,trtinit)

The problem is that the table is not refreshed ?

Another table is also related to a MSSQL table in the same way and refreshes well.

I compared the tables and there is no differences.

What can be the problem ?
Re: refreshing table MSSQL Windev 21
February 04, 2022 01:24PM
Hi,

I'd use TableDisplay(TableName, trtinit)

instead.

Kind regards,
Guenter Predl
office@windev.at
Niek
Re: refreshing table MSSQL Windev 21
February 04, 2022 04:41PM
Hi Guenter

TableDisplay(TableName, trtinit) is not working...
Re: refreshing table MSSQL Windev 21
February 04, 2022 05:11PM
Hi Niek,

just for the fun of it, start a new project YourProject_RAD and link the analysis to the original project's \YourProject.ana\YourProject.wda. Use RAD11 and let it do a "Full Application RAD", choose SQL or ODBC code for the windows, whatever applies to your connection to the database. Most windows of the project should run smoothly after generation by RAD11. You will get Form Windows and Windows with Tables where you can study the code of how Tables are refreshed and much, much more.

Kind regards,
Guenter Predl
office@windev.at
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: