tmssoftware.com
TMS Support Center
Example of IDBDatasetStatement
BIZ
TMS Aurelius
Dei_Flavio
(Dei Flavio)
April 18, 2018, 9:14am
1
Hello,
I have read about the possibility of using IDBStatement to execute queries or recall Store Procedures, I have seen that IDBDatasetStatement is available that reports a TDataset out but I can not find documentation about it.
Can you help about it?
Dei_Flavio
(Dei Flavio)
April 18, 2018, 9:26am
2
I explain my question better:
in one of my applications, I would need to display the result of complex SQL queries or the result of Stored Procedure show in grids.
These queries are used to create reports or visualizations, never insertions in the database.
For this I am looking for a method of Aurielius that allows me to write SQL queries directly and manage the result as TDataset.
What is the best method I can use to get my purpose?
Thk in advance.
wlandgraf
(Wagner Landgraf)
April 19, 2018, 11:44pm
3
Hi, sure, it's possible. Please refer to the following links:
https://www.tmssoftware.com/site/aurelius.asp?s=faq&show=793
https://www.tmssoftware.com/site/forum/forum_posts.asp?TID=8660
Related topics
Topic
Replies
Views
Activity
Direct SQL queries
TMS Aurelius
3
789
May 28, 2020
IDBResultset, TDataset, Connection
TMS XData
5
1139
May 10, 2018
Direct SQL access
TMS Aurelius
1
410
September 1, 2014
Aurelius, returning a non-Entity dataset
TMS Aurelius
5
137
May 16, 2024
Access both Aurelius and SQL data
TMS XData
2
851
June 13, 2019
© tmssoftware.com