Hello
Please correct me if I am wrong, it seems that Params in Scripts does not work.
suppose following scripts:
//-----------------------
create table table1 as
select * from old_table1;
create table table2 as
select
*
from
old_table2
where
period_start_time >= :start_date
and period_start_time SQL->Clear();
OraScript->SQL->Add(....); // add sql scripts
SetParams(); // now I set all params
OraScript->Execute();
//-------------------
Then I found that
1. Before calling Execute(); the OraScript->Params is empty (Params->Count is 0), and I can not access to the desired params.
2. If I catch BeforeExecute event, both OraScript->Params and OraScript->DataSet->Params are also empty. Still not be able to access to the desired params.
So this makes me impossible to have a script run with parameters.
Please kindly check it.
Suggested solution:
1. In the event of "BeforeExecute", the DataSet already have its Params constructed.
2. Or we can add an "BeforeExecute" event to TCustomDADataSet, where to catch the params.
Param does not work for OraScript
Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Return to “Oracle Data Access Components”
Jump to
- General Forums
- ↳ Announcements
- Database Tools
- ↳ dbForge for MySQL
- ↳ dbForge for Oracle
- ↳ dbForge for PostgreSQL
- ↳ dbForge for SQL Server
- ADO.NET Data Providers
- ↳ Entity Framework support
- ↳ LinqConnect (LINQ to SQL support)
- ↳ dotConnect for Oracle
- ↳ dotConnect for MySQL
- ↳ dotConnect for PostgreSQL
- ↳ dotConnect for SQLite
- ↳ dotConnect for DB2
- ↳ dotConnect for SQL Server
- ↳ dotConnect for Cloud Applications
- ↳ dotConnect Universal
- ↳ Entity Developer
- Delphi Data Access Components
- ↳ EntityDAC
- ↳ Universal Data Access Components
- ↳ Oracle Data Access Components
- ↳ SQL Server Data Access Components
- ↳ MySQL Data Access Components
- ↳ InterBase Data Access Components
- ↳ PostgreSQL Data Access Components
- ↳ SQLite Data Access Components
- ↳ VirtualDAC
- dbExpress Drivers
- ↳ dbExpress driver for Oracle
- ↳ dbExpress driver for SQL Server
- ↳ dbExpress driver for MySQL
- ↳ dbExpress driver for InterBase & Firebird
- ↳ dbExpress driver for PostgreSQL
- ↳ dbExpress driver for SQLite
- ODBC Drivers
- ↳ ODBC Drivers
- Network Security
- ↳ SecureBridge
- Developer Tools
- ↳ Code Compare
- ↳ Review Assistant
- ↳ LINQ Insight
- ↳ SSIS Data Flow Components
- ↳ Excel Add-ins