Hello,
i try to use the RefreshQuick methode.
I Create a new TestTable with one TimeStamp Field and one uniqueidentifier Field.
Then i create a small TestProject with only Connection and MSTable1 componente.
I set the Tablename to my new created Table.
But if i call MSTable1.RefreshQuick(False) i get the error "Timestamp field required."
Or can you tell me step by step what to do to work correctly
(BDS2006 and SDAC 4.00.04)
This is my Table:
--------------------------------------------------------------------------------
CREATE TABLE [dbo].[Testtable] (
[test1] [char] (50) COLLATE Latin1_General_CI_AS NULL ,
[test2] [char] (50) COLLATE Latin1_General_CI_AS NULL ,
[test3] [char] (50) COLLATE Latin1_General_CI_AS NULL ,
[timestamp] [timestamp] NOT NULL ,
[uid] uniqueidentifier ROWGUIDCOL NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Testtable] WITH NOCHECK ADD
CONSTRAINT [PK_Testtable] PRIMARY KEY CLUSTERED
(
[uid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Testtable] ADD
CONSTRAINT [DF_Testtable_uid] DEFAULT (newid()) FOR [uid] GO
CREATE INDEX [IX_Testtable] ON [dbo].[Testtable]([timestamp]) ON [PRIMARY] GO
-------------------------------------------------------------------------------
As you can see there are all required fields.
Thanks for Help
Edgar Sperling