Stack Overflow
Stack Overflow

Questions tagged [tadodataset]

25 questions
7
votes
1 answer

How to create a TDataSet Lookup Field at runtime?

I'm using TADODataSet (D7). I do not create persistent fields in design-mode with my DataSet. dsItems.CommandText := 'select ID, ItemName, UserIDCreate from Items'; dsUsers.CommandText := 'select ID, LoginName from Users'; // lookup dataset If I…
Vlad
  • 1,383
  • 14
  • 29
7
votes
3 answers

ADO components CommandTimeout

I have a problem with settings of the query execution timeout with TADOQuery, TADOCommand or TADODataSet (I've tried it with each one). I have a tiny application, which connects to the database and periodically executes stored procedures, which…
user532231
6
votes
2 answers

ADODataSet deleting from joined table

I have a Delphi app where I display a list of games that have been played from a query like this: select g.*, gt.id, gt.descr from GAMES g inner join game_types gt on gt.id = g.game_type order by game_date DESC When I click the delete button in…
Frank Luke
  • 1,342
  • 3
  • 18
  • 33
4
votes
4 answers

How to achieve independent cloned TADODataSet?

The scenarios is like this: We have some SQL table. We are performing 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; …
Wodzu
  • 6,932
  • 10
  • 65
  • 105
4
votes
1 answer

Retrieving autogenerated data in insert on ADODataset

I actually try to do an insert on a ADODataset linked on a table with an auto-generated GUID. When I try to get the new ID of my record I get some zero for GUID.
Franck Charlier
  • 414
  • 4
  • 17
3
votes
1 answer

Duplicate TADODataSet component with streaming fields?

I have a very similar code to this to duplicate a TADODataSet component and it's events. So, If I have an ADODataSet1 I want to create a new instance ADODataSet2 as exact duplicate component of the former component. Everything works fine, But still…
ZigiZ
  • 2,480
  • 4
  • 25
  • 41
3
votes
1 answer

Building HTTP Server Application

I have a project which does financial reports and I want to let user to be able to get this reports through the internet I tried using TIdHTTPServer which is an Indy component to make my application to work as an HTTP Server and to let it to be able…
user1512094
  • 611
  • 2
  • 10
  • 23
2
votes
1 answer

Delphi XE Unicode dealing with nchar(1) fields

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…
Mattl
  • 1,588
  • 3
  • 24
  • 49
2
votes
1 answer

unwanted SET NO_BROWSETABLE ON generated by tadodataset

i have a problem in my delphi application with tadodataset the simple question after switching from delphi xe2 to xe9 and sql2014 i see in profiler that all of my queries started with SET NO_BROWSETABLE ON this cause recompile stored procedures and…
dawood karimy
  • 179
  • 2
  • 13
2
votes
1 answer

How to use a RecordSet.Find with TADOQuery?

In this question: Delphi ADO : Locate with dataset filter on bug an ADO bug was described where the Filter string is ignored during .Locates. This is causing problems for us migrating from the BDE because we have a lot of code that changes the…
Tom
  • 565
  • 1
  • 5
  • 21
2
votes
1 answer

How to modify calculated field with TADODataSet?

I have a TADODataset executed with (only for example): SELECT id, name, lastname, name + ' ' + lastname as fullname FROM persons ORDER BY lastname After I open the dataset, I can modify "name" and "lastname" fields, but can't modify"fullname",…
a.vakhrushev
  • 37
  • 3
2
votes
1 answer

What would cause "Cursor Operation Conflict" error in ADO with SQL Server on Windows 8 and Delphi XE3?

I'm using Embarcadero Delphi XE3 on Windows 8 and I'm trying to connect with SQL Server 2000. My program used to work correctly when I was using Delphi 2007 on Windows 7, but now whenever I do transaction (Update, Insert, Delete) it gives me an…
user1512094
  • 611
  • 2
  • 10
  • 23
2
votes
1 answer

How to detect any modification that happens in SQL Server database?

I have an application using TADODataSet and TADOConnection to connect with SQL Server database. I would like to detect any modification that happens in the database. modifications = Insert, Update, Delete I want to know which TADODataset or which…
user1512094
  • 611
  • 2
  • 10
  • 23
2
votes
1 answer

Delphi - ADODataSet Subset

I am building a form in Delphi that has a dropdown of Services and a grid of Add-Ons for the select service. The data I am getting comes from an API and I am storing the data for the Services in an ADODataSet as follows: ID (integer) Name…
BrianKE
  • 4,035
  • 13
  • 65
  • 115
1
vote
1 answer

ADODataset: how to load XML (saved beforehand in DB in ADO schema) data without temporary files?

Warning: total rewrite. Scenario: I loaded some data from database on a TCustomADODataset descendant. After that, I saved this data on XML temp file (using TCustomADODataset.SaveToFile) to allow getting the XML data as a string and store it on a…
Fabricio Araujo
  • 3,810
  • 3
  • 28
  • 43
1
2