TPgSQL does not recognize parameters in procedure calls, i.e:
call somefunction(:param) raises exception "there is no parameter $1".
In the PgDAC 5.3 it worked fine.
PostgreSQL 11.11, Delphi 7.
Search found 3 matches
- Tue 06 Apr 2021 15:04
- Forum: PostgreSQL Data Access Components
- Topic: PgDAC 6.4.2 procedure parameters issue
- Replies: 3
- Views: 17216
- Tue 30 Mar 2021 17:05
- Forum: PostgreSQL Data Access Components
- Topic: TPgConnection.Options.EnablePgTimeStamps bug for 2000-01-01
- Replies: 4
- Views: 17236
Re: TPgConnection.Options.EnablePgTimeStamps bug for 2000-01-01
Thanks, I'll wait for the new release.
Trying to migrate to 6.4.1 I have found another issue: query hangs up trying to run after any sql error.
Steps to reproduce:
1. Open and run PgDacDemo.
2. Connect to DB.
3. Go to the Query node.
4. Type any wrong query (for example,"select qqq"), click Open. Get SQL exception.
5. Click Open again. The app hangs up forever.
PostgreSQL 11.11, Delphi 7.
Trying to migrate to 6.4.1 I have found another issue: query hangs up trying to run after any sql error.
Steps to reproduce:
1. Open and run PgDacDemo.
2. Connect to DB.
3. Go to the Query node.
4. Type any wrong query (for example,"select qqq"), click Open. Get SQL exception.
5. Click Open again. The app hangs up forever.
PostgreSQL 11.11, Delphi 7.
- Thu 25 Mar 2021 05:18
- Forum: PostgreSQL Data Access Components
- Topic: TPgConnection.Options.EnablePgTimeStamps bug for 2000-01-01
- Replies: 4
- Views: 17236
TPgConnection.Options.EnablePgTimeStamps bug for 2000-01-01
Query field value for date 2000-01-01 returns null with TPgConnection.Options.EnablePgTimeStamps set to true .
I'm using PgDAC 6.1.
I'm using PgDAC 6.1.