|
|
Home » U++ Library support » U++ SQL » Huge error of Postgresql! Double fields by transmission to the program lose a fractional part!
Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part! [message #47535 is a reply to message #47534] |
Thu, 26 January 2017 01:25 |
|
Modified code (while lang settings SetLanguage(LNGFromText("RU-RU"));:
char *s = PQgetvalue(result, fetched_row, i);
switch(info[i].type)
{
case INT64_V:
f.SetValue(ScanInt64(s));
break;
case INT_V:
f.SetValue(atoi(s));
break;
case DOUBLE_V:
RLOG("===start analysis===");
RDUMP(s);
double da,dS;
da = atof(s);
dS = ScanDouble(s);
RDUMP(da);
RDUMP(dS);
static String test_format_and_lang_settings;
test_format_and_lang_settings = Format("%f",dS);
RDUMP(test_format_and_lang_settings);
RLOG("====end analysis====");
RLOG(" ");
f.SetValue(ScanDouble(s));
break;
case BOOL_V:
f.SetValue(*s == 't' ? "1" : "0");
break;
case DATE_V:
Log:
26.01.2017 03:22:15 ===start analysis===
26.01.2017 03:22:15 s = 90
26.01.2017 03:22:15 da = 90
26.01.2017 03:22:15 dS = 90
26.01.2017 03:22:15 test_format_and_lang_settings = 90,000000
26.01.2017 03:22:15 ====end analysis====
26.01.2017 03:22:15
26.01.2017 03:22:15 ===start analysis===
26.01.2017 03:22:15 s = 40
26.01.2017 03:22:15 da = 40
26.01.2017 03:22:15 dS = 40
26.01.2017 03:22:15 test_format_and_lang_settings = 40,000000
26.01.2017 03:22:15 ====end analysis====
26.01.2017 03:22:15
26.01.2017 03:22:15 ===start analysis===
26.01.2017 03:22:15 s = 269.96336996337
26.01.2017 03:22:15 da = 269
26.01.2017 03:22:15 dS = 269.96336996337
26.01.2017 03:22:15 test_format_and_lang_settings = 269,963370
26.01.2017 03:22:15 ====end analysis====
26.01.2017 03:22:15
26.01.2017 03:22:15 ===start analysis===
26.01.2017 03:22:15 s = 381.556455240666
26.01.2017 03:22:15 da = 381
26.01.2017 03:22:15 dS = 381.556455240666
26.01.2017 03:22:15 test_format_and_lang_settings = 381,556455
26.01.2017 03:22:15 ====end analysis====
26.01.2017 03:22:15
26.01.2017 03:22:15 ===start analysis===
26.01.2017 03:22:15 s = 282.083413662361
26.01.2017 03:22:15 da = 282
26.01.2017 03:22:15 dS = 282.083413662361
26.01.2017 03:22:15 test_format_and_lang_settings = 282,083414
26.01.2017 03:22:15 ====end analysis====
SergeyNikitin<U++>( linux, wine )
{
under( Ubuntu || Debian || Raspbian );
}
[Updated on: Thu, 26 January 2017 01:28] Report message to a moderator
|
|
|
|
|
Huge error of Postgresql! Double fields by transmission to the program lose a fractional part!
|
|
|
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!
|
|
|
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!
|
|
|
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!
|
|
|
Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part!
|
|
|
Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part!
|
|
|
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!
|
|
|
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!
|
|
|
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!
|
|
|
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!
|
|
|
Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part!
|
|
|
Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part!
|
|
|
Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part!
|
|
|
Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part!
|
|
|
Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part!
|
|
|
Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part!
|
|
|
Re: Huge error of Postgresql! Double fields by transmission to the program lose a fractional part!
|
|
|
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!
|
|
|
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
|
Goto Forum:
Current Time: Thu May 23 16:10:41 CEST 2024
Total time taken to generate the page: 0.02040 seconds
|
|
|