Problem with SQL Driver

Problem with SQL Driver

Hello, I've got a problem. I'm using SQL Server to change value of variable in zenon. I created 2 tables zRECEIVE and zSEND, configured sql driver and add the same variables name in driver and in my project. After I insert data in zRECEIVE table zenon read them and delete row, but the Value on variable in Runtime doesn't change. I have no idea why? To create table i used that example: CREATE TABLE [dbo].[zRECEIVE]( [ID] [bigint] IDENTITY(1,1) NOT NULL, [NAME] [nvarchar](max) NOT NULL, [DATUMZEIT] [datetime] NOT NULL, [ZEIT_MS] [int] NOT NULL, [WERT] [nvarchar](max) NOT NULL, [STATUS] [int] NOT NULL, Should the columns DATUMZEIT, ZEIT_MS and STATUS have special format or values? I didnt found information about that. Thanks in advance

This is a migrated post! Originally posted on 11.06.2014 by user zenek92. Please be aware that information can be outdated.