Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » PostgreSQL fieldname case bug
Re: PostgreSQL fieldname case bug [message #10063 is a reply to message #9694] Mon, 18 June 2007 20:18 Go to previous message
mirek is currently offline  mirek
Messages: 14265
Registered: November 2005
Ultimate Member
unodgs wrote on Fri, 25 May 2007 03:24

I'm sorry. I was experimenting with PostgreSql plugin and forgot to revert this change. It will be fixed.

PS:
As you can see in postgre plugin code I added GetInsertedId but I pass null in sequence variable:
Format("select currval('%s')", sequence);
As I discovered this is the only way to get the squence value. Unfortunatelly this way requires sequence name.



Hm, I am sorry I missed this one...

Actually, this makes PostgreSQL equivalent to Oracle - means you no longer need or use "autoincrement" and GetInsertedId, but rather sequences directly... You only need to add PostgreSQL ValueGen... See SqlSequence in Oracle/OraCommon.h.

Mirek
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: SqlFormat() bug with Date and Time types
Next Topic: How to access a firebird database ?
Goto Forum:
  


Current Time: Sun Jul 06 13:22:07 CEST 2025

Total time taken to generate the page: 0.03776 seconds