Search found 4 matches

by wilton_rad
Fri 10 Jul 2015 19:39
Forum: SQL Server Data Access Components
Topic: SDAC - Reportbuilder Plugin update
Replies: 5
Views: 1958

Re: SDAC - Reportbuilder Plugin update

I am also having the same problem, updated for the report builder 16:02
and even sdac version 7.1.3 the unit
... \ Demos \ ThirdParty \ ReportBuilder \ daSDAC.pas even makes reference to
TppComponentList

They said they had been updated and would be released however was not done yet.
this prevents using the report builder, and had to return to the version 6 sdac
by wilton_rad
Fri 10 Sep 2010 18:19
Forum: SQL Server Data Access Components
Topic: Can you add global settings to connections
Replies: 3
Views: 1278

change source

.....SOURCE\DBACCESS.PAS

constructor TDADataSetOptions.Create(Owner: TCustomDADataSet);
begin
inherited Create;

FOwner := Owner;

RequiredFields := True;
StrictUpdate := True; --->> change for False
TrimFixedChar := True;
LongStrings := True;
FlatBuffers := False;
RemoveOnRefresh := True;
FDetailDelay := 0;
UpdateBatchSize := 1;
end;
-------------------
public
constructor Create(Owner: TCustomDADataSet);

property SetFieldsReadOnly: boolean read FSetFieldsReadOnly write FSetFieldsReadOnly default False;
property RequiredFields: boolean read FRequiredFields write SetRequiredFields default True;
property StrictUpdate: boolean read FStrictUpdate write FStrictUpdate default True; -->>change for False
by wilton_rad
Fri 10 Sep 2010 18:13
Forum: SQL Server Data Access Components
Topic: How to know the EXACT SQL (with substituted parameters)?
Replies: 8
Views: 2490

solution

in TMSQuery.SQL type text select * from customers


sqlcustomer.close;
sqlcustomer.fieltersql :='customer=4';
sqlcustomer.open;
by wilton_rad
Fri 10 Sep 2010 14:46
Forum: SQL Server Data Access Components
Topic: Problem using ALLOW_SNAPSHOT_ISOLATION
Replies: 1
Views: 1658

Problem using ALLOW_SNAPSHOT_ISOLATION

Hi, i'm set property IsolationLevel in object msconection for ilSnapshot

apply command my database.


ALTER DATABASE mydatabase SET ALLOW_SNAPSHOT_ISOLATION ON

when conect in aplication return error:
http://www.radinfo.com.br/instaladores/erroisolationlevel.jpg

using SQL Server 2008 enterprise version 10.0.2531.0
using sdac version 4.80.0.58

if conect in server my aplication open correct.

thank you