Look this:
with ClientDataSet1 do
begin
Close;
if Params.Count = 0 then FetchParams;
Params.ParamByName('IDGESTION').AsFloat:= 3;
Params.ParamByName('IDSERVICE').AsFloat:= 8;
Params.ParamByName('OBJSCODES').AsString:= '''TFIMMPATH'',''TFIMMMOTIVECONTRACTSTATE''';
//...
I have a SQL with:
where FieldName in (:FILEDSVALUES)
in my Delphi program i use
Params.ParamByName('FILEDSVALUES').AsString:= '''Value1'',''Value2''';
but the SQL don't work.
Trynig the SQL directly from SQLEditor it work correctly.
What's appen?
Fabio.
Hi,
I set some Provider flags in a ClientDataSet like pfInUpDate= False but when the TOracleDataSet create the query for UpDate include the field.
For a correctly work i must fetch all fields in the TOracleDataSet and then set the Provider flags directly in the TOracleDataSet.
This is normaly or...
I try to use the 3Tier DOA demo to set a master/details relationchip whit ClientDataSets components.
If the tables are empty all work fine but when u have one master record with details u can't add records. I try it with 2 simples tables with KeyFieldName "ID" and all FK correctly configured in...
Yes, the ResolveToDataSet is set to false.
Rember that all work fine if the tables are empty. The first time you run the application u can append all records you want but in the second run of the application (without change any components properties) the ID of the master table is not included in...