I've had some problems with dbExpress vs. SQL Server in D2005 too.



I have a TSQLStoredProc, a DataSetProvider, a ClientDataSet and a DataSource.



The Proc takes a TSQLTimeStamp input parameter.



I've always written code like this in D7 when I need to refresh my data in response to a parameter change:



procOrdersSinceDate.ParamByName('@date').AsSQLTimeStamp := DateTimeToSQLTimeStamp(DateTimePicker1.Date);



cdsOrdersSinceDate.Refresh;



This works just fine in D7, but in D2005 it only works the first time (every other refresh after this returns exactly the same data even though the DateTimePicker changes).



The reason is that it seems that every Refresh of the ClientDataSet repopulates the Params of the TSQLStoredProc with its own values overwriting the new value I just set. If I write this code instead it works as expected:



if cdsOrdersSinceDate.Active then

begin

cdsOrdersSinceDate.Params.ParamByName('@date').AsSQLTimeStamp :=

DateTimeToSQLTimeStamp(DateTimePicker1.Date);



cdsOrdersSinceDate.Refresh;

end

else

begin

procOrdersSinceDate.ParamByName('@date').AsSQLTimeStamp :=

DateTimeToSQLTimeStamp(DateTimePicker1.Date);



cdsOrdersSinceDate.Open;

end;



(Sorry about the formatting, the comments editing window on this blog was *really* small in FireFox).



I hope this gets fixed in a patch or something soon as I'm not very interested in changing all my code because of this new behavior.