use the RefreshQuick methode

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
edgar.sperling@online.de
Posts: 6
Joined: Sun 11 Dec 2005 10:21

use the RefreshQuick methode

Post by edgar.sperling@online.de » Fri 30 Mar 2007 08:41

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

Jackson
Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Fri 30 Mar 2007 14:34

Thank you for information.
We have reproduced the problem and fixed it.
This fix will be included in the nect build of SDAC 5.

Post Reply