tadodataset

"either bof or eof is true or the current record has been deleted.." error on applyupdates that contains a delete operation.

Hello, I am getting this error while resolving delete operation from ClientDatset to TAdoDataset (which bound to access table). I am using Delphi 2010. My DatasetProvider between TClientDataset and TAdoDataset : object dspTarifeler: TDataSetProvider DataSet = DM.qryTarifeler ResolveToDataSet = True Options = [poPropogateChan...

How to achieve independant cloned TADODataSet ?

Hi guys. The scenerios is like this: We have some SQL table. We are perfroming an SQL query on this table and we have results in TADOQuery object. var qryOryginal, qryClone: TADOQuery; begin //setup all the things here qryOryginal.Active := True; qryClone.Clone(qryOryginal, ltBatchOptimistic); qryOryginal.Delete; //delete i...

Delphi XE Unicode dealing with nchar(1) fields

Hello I'm using a dbGo TADODataset in Delphi XE to read data from a SQL Server 2008 table. All the string fields are nvarchar or nchar. The nvarchar fields map to TWideStringField with no problems. The problem is with an nchar(1) field, this maps to a TStringField fine but not to a TWideStringField - when I configure the field to be T...