U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » PostgreSQL fieldname case bug

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

PostgreSQL fieldname case bug [message #9689]

Fri, 25 May 2007 00:16

zsolt is currently offline

zsolt
Messages: 698
Registered: December 2005
Location: Budapest, Hungary

Contributor

The problem is that postgresql returns field names in lower case.
In the original version of PostgreSQL classes, there was a ToUpper() on field names, allowing using expressions like sql[FIELD_NAME].
In current version, ToUpper() disappeared, so I'm unable to get fields by name from a result set.

Put back the original version please.

in bool PostgreSQLConnection::Execute() currently it is:

f.name = PQfname(result, i);

but should be

f.name = ToUpper(PQfname(result, i));

Report message to a moderator

Send a private message to this user

[Message index]

		PostgreSQL fieldname case bug By: zsolt on Fri, 25 May 2007 00:16
		Re: PostgreSQL fieldname case bug By: mirek on Fri, 25 May 2007 09:23
		Re: PostgreSQL fieldname case bug By: unodgs on Fri, 25 May 2007 09:24
		Re: PostgreSQL fieldname case bug By: zsolt on Fri, 25 May 2007 19:50
		Re: PostgreSQL fieldname case bug By: mirek on Mon, 18 June 2007 20:18

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Tue May 14 05:23:06 CEST 2024

Total time taken to generate the page: 0.01605 seconds