Problem with RefreshQuick with 4.00.0.6

Sergio Bertolotti · Post by **Sergio Bertolotti** » Tue 24 Apr 2007 09:17

Dear Support,
this morning I update my SDAC 4.x prof to new recetly 4.00.0.6.
I use Borland Delphi 7 prof ver. 8.1 and MS SQL Server 2005 express edition with service pack 2 in italian.
I have a new question about RefreshQuick method.

I have a TMSQuery component, with relative TDataSource conneted to it and its name is setSelect, with only SQL property set.
Pratically a view in read only.

In detail :

SELECT
dbo.SPESE_PASTI1.CONT,
dbo.SPESE_PASTI1.DATA,
dbo.SPESE_PASTI1.SPESO,
dbo.SPESE_PASTI1.SYNCFIELD,
dbo.ANAGRAFICA_FORNITORI.RAGSOC
FROM
dbo.SPESE_PASTI1
INNER JOIN dbo.ANAGRAFICA_FORNITORI ON (dbo.SPESE_PASTI1.CODFOR = dbo.ANAGRAFICA_FORNITORI.CODFOR)
ORDER BY
dbo.SPESE_PASTI1.DATA

a simple join between SPESE_PASTI1 and ANAGRAFICA_FORNITORI tables.

In my TMSQuery I set IndexFieldNames to SPESE_PASTI1.DATA field.
SYNCFIELD is timestamp type.

I insert a new record in SPESE_PASTI1 and after this I call Post method of SPESE_PASTI1 table and then RefreshQuick(true) mehod of my setSelect - TMSQuery to refresh my view in DBGrid.

At this point I obtain an error message : TIMESTAMP FIELD REQUIRED.

In my TMSQuery I have a timestamp field.
And a timestamp field is also defined in SPESE_PATI1 table and ANAGRAFICA_FORNITORI table.
If I close and open my form or DBGrid I see correctly my new value inserted in SPESE_PASTI1.
If I call Refresh method instead RefreshQuick of setSelect all is OK, and I see this new record inserted without problems.

Can you tell me something about this new problem ?

Best regards.
Sergio Bertolotti

Jackson · Post by **Jackson** » Tue 24 Apr 2007 11:25

The RefreshQuick method doesn't support joins, so it won't work with such complex queries as you provided.

Sergio Bertolotti · Post by **Sergio Bertolotti** » Tue 24 Apr 2007 11:47

Dear EvgeniyM,

many thank's for your answer.

Do you plan to support joins in RefreshQuick method in future ?

My query isn't complex joins.

Best regards.

Sergio Bertolotti

Jackson · Post by **Jackson** » Wed 25 Apr 2007 07:46

We will investigate the possibility to add such functionality but not in the nearest time.

Sergio Bertolotti · Post by **Sergio Bertolotti** » Wed 25 Apr 2007 08:07

Dear EvgeniyM,

many thank's for your answer.

Best regards.

Sergio Bertolotti