Hi all,
I'm new to dbExpress driver for PostgreSQL but have used dbExpress for years with FireBird.
In a test-app I have a TSQLConnection with a acompaning TSQLDataSet.
At startup I make a connection to my db with the following code:
SQLConnection1.Params.Values['HostName'] := 'localhost';
SQLConnection1.Params.Values['Database'] := 'minilc';
SQLConnection1.Params.Values['User_Name'] := 'postgres'; SQLConnection1.Params.Values['Password'] := 'mypwd';
SQLConnection1.Connected := true;
and connection succeedes.
Clicking a button in my test-app I reach the following code:
procedure TfrmMiniDb.btnOpenClick(Sender: TObject);
begin
if SQLDataSet1.Active then
SQLDataSet1.Close;
SQLDataSet1.CommandText :=
'Select * from CustomerInfo ' +
'where ' +
'name like ' + Chr(39) + '%Kalle%' + Chr(39);
SQLDataSet1.Open;
end;
At "SQLDataSet1.Open" I get the following error:
Operation not allowed on a unidirectional dataset
Copying the sql-request into pgAdmin III it works allright and
I think I should be allowed to do this.
Can anyone help me out please?
Regard
stab
Unable to make a SQL-request with dbExpress driver
Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for PostgreSQL in Delphi and C++Builder
Return to “dbExpress driver for PostgreSQL”
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