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 » Huge error of Postgresql! Double fields by transmission to the program lose a fractional part!

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

Return to the default flat view

Create a new topic

Submit Reply

Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! [message #47491]

Mon, 23 January 2017 02:28

sergeynikitin is currently offline

sergeynikitin
Messages: 748
Registered: January 2008
Location: Moscow, Russia

Contributor

sergeynikitin@jabber.ru

Huge error of Postgresql!
Double fields by transmission to the program from sql table lose a fractional part!

The decision is extremely simple. To scan a string not as int (atoi), but as Double (ScanDouble).
The request to correct quickly as soon as it is possible!

Place to correct:
file PostgreSQL.cpp
Fucntion: void PostgreSQLConnection::GetColumn(int i, Ref f) const
Line: 644
Now:

	switch(info[i].type)
	{
		case INT64_V:
			f.SetValue(ScanInt64(s));
			break;
		case INT_V:
			f.SetValue(atoi(s));
			break;
		case DOUBLE_V:
			f.SetValue(atoi(s));         //<========THIS LINE NEED TO CORRECT
			break;
		case BOOL_V:
			f.SetValue(*s == 't' ? "1" : "0");
			break;
		case DATE_V:
			f.SetValue(sDate(s));
			break;
		case TIME_V: {
				Time t = ToTime(sDate(s));
				t.hour = atoi(s + 11);
				t.minute = atoi(s + 14);
				t.second = atoi(s + 17);
				f.SetValue(t);
			}
			break;
		default: {

   . . . . .

Must be:

	switch(info[i].type)
	{
		case INT64_V:
			f.SetValue(ScanInt64(s));
			break;
		case INT_V:
			f.SetValue(atoi(s));
			break;
		case DOUBLE_V:
			f.SetValue(ScanDouble(s));
			break;
		case BOOL_V:
			f.SetValue(*s == 't' ? "1" : "0");
			break;
		case DATE_V:
			f.SetValue(sDate(s));
			break;
		case TIME_V: {
				Time t = ToTime(sDate(s));
				t.hour = atoi(s + 11);
				t.minute = atoi(s + 14);
				t.second = atoi(s + 17);
				f.SetValue(t);
			}
			break;
		default: {

   . . . . .

Thanks!

SergeyNikitin<U++>( linux, wine )
{
under( Ubuntu || Debian || Raspbian );
}

Report message to a moderator

Send a private message to this user

[Message index]

		Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Mon, 23 January 2017 02:28
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: unodgs on Mon, 23 January 2017 07:34
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Mon, 23 January 2017 08:38
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: Klugier on Mon, 23 January 2017 09:38
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Mon, 23 January 2017 09:46
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: mirek on Wed, 25 January 2017 11:30
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Wed, 25 January 2017 18:18
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Wed, 25 January 2017 18:35
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Wed, 25 January 2017 18:37
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: Klugier on Wed, 25 January 2017 18:42
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Wed, 25 January 2017 18:54
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: mirek on Wed, 25 January 2017 19:02
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Wed, 25 January 2017 19:31
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: mirek on Wed, 25 January 2017 19:49
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Wed, 25 January 2017 20:31
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: mirek on Wed, 25 January 2017 20:40
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 01:00
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 01:25
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 01:33
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 01:43
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 01:45
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 01:57
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 02:04
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 02:23
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: mirek on Thu, 26 January 2017 14:10
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: mirek on Thu, 26 January 2017 15:01
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: sergeynikitin on Thu, 26 January 2017 15:25
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: mirek on Thu, 26 January 2017 09:09
		Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! By: Klugier on Wed, 25 January 2017 19:03

Previous Topic:	I propose to Add Postgresql to topic header
Next Topic:	How can .sch express a many-to-many relationship ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sun Apr 28 12:14:07 CEST 2024

Total time taken to generate the page: 0.04675 seconds