Another notification problem
Posted: Wed 02 Mar 2016 16:28
Hello,
in this never-ending-story I do have a new problem with notifications I do not understand.
On form1 I use notifications with some Tables, on Form2 I do not.
Recently I have added a small table on Form1 to use notifications.
This table can be modified on Form2, changes should be notified to all users with opened form1.
This works unless I do not insert or delete a row from the table.
So here is the log,
the table being in notification on form1 is TbKonLP,
TbKonGR2 is not in notification but in master-detail to TbKonLP
do you see anything problematic?
best regards
Hans
in this never-ending-story I do have a new problem with notifications I do not understand.
On form1 I use notifications with some Tables, on Form2 I do not.
Recently I have added a small table on Form1 to use notifications.
This table can be modified on Form2, changes should be notified to all users with opened form1.
This works unless I do not insert or delete a row from the table.
So here is the log,
the table being in notification on form1 is TbKonLP,
TbKonGR2 is not in notification but in master-detail to TbKonLP
- 17:16:23 624: Flag: tfQExecute, Object: MSAccess/TMSTable: TMSTable
Name: TBStmLie
OWNER: Form2
SELECT * FROM MoStmLie
-----------------------------------------------------------------------------------------------------------
17:16:23 659: Flag: tfQExecute, Object: MSAccess/TMSTable: TMSTable
Name: TbKonLP
OWNER: Form2
SELECT * FROM MoKonLP
WHERE Lieferantennummer = :Lieferantennummer
:Lieferantennummer(Integer,IN)=103
-----------------------------------------------------------------------------------------------------------
17:16:26 085: Flag: tfQExecute, Object: MSAccess/TMSTable: TMSTable
Name: TbKonLP
OWNER: Form2
DELETE FROM MoKonLP
WHERE
Lieferantennummer = ? AND Raster = ?
:Old_Lieferantennummer(Integer,IN)=103
:Old_Raster(WideString[5],IN)='1: 44'
-----------------------------------------------------------------------------------------------------------
17:16:26 087: Flag: tfQExecute, Object: MSAccess/TMSTable: TMSTable
Name: TbKonGR2
OWNER: Form2
SELECT * FROM MoKonGR
WHERE Bezeichnung = :Raster
:Raster(WideString[0],IN)=<NULL>
-----------------------------------------------------------------------------------------------------------
17:16:26 088: Flag: tfQExecute, Object: MSAccess/TMSQuery: TMSQuery
Name:
WAITFOR (RECEIVE message_body, status, queuing_order, conversation_group_id, conversation_handle, message_sequence_number, service_contract_name, service_contract_id, message_type_name, message_type_id, validation FROM SDAC_NS_90_QUEUE), TIMEOUT 2147483647
-----------------------------------------------------------------------------------------------------------
17:16:26 177: Flag: tfQExecute, Object: MSAccess/TMSTable: TMSTable
Name: TbKonLP
OWNER: Form1
select Lieferantennummer,Raster,Gr01,Gr02,Gr03,Gr04,Gr05,Gr06,Gr07,Gr08,Gr09,Gr10,Gr11,Gr12,Gr13,Gr14,Gr15,Gr16 from dbo.MoKonLP
-----------------------------------------------------------------------------------------------------------
17:16:26: Exception:
Statement does not support notifications
EDatabaseError
EDatabaseError
-----------------------------------------------------------------------------------------------------------
17:16:27 691: Flag: tfQExecute, Object: MSAccess/TMSQuery: TMSQuery
Name:
WAITFOR (RECEIVE message_body, status, queuing_order, conversation_group_id, conversation_handle, message_sequence_number, service_contract_name, service_contract_id, message_type_name, message_type_id, validation FROM SDAC_NS_90_QUEUE), TIMEOUT 2147483647
-----------------------------------------------------------------------------------------------------------
do you see anything problematic?
best regards
Hans