U++ framework: U++ SQL » Can not get a double from database

Home » U++ Library support » U++ SQL » Can not get a double from database

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

Re: Can not get a double from database [message #18030 is a reply to message #17889]

Sun, 07 September 2008 11:24

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

kbyte wrote on Mon, 01 September 2008 14:48

Hi,
I am trying to get a double (I think) from a sqlite3 database but I see a bad number. Ints and Strings no problem.
Here the code:

if(!SQL.Execute(Format("Select sum(ammount) from Pags where Num_Cli_Pag=%d",nNumCli)))
{
PromptOK("Error!");
}
if(!SQL.Fetch())
{
edDeb.SetData("0");
}
else
{
double d=(double)SQL[0];
strTemp=Format("%f",d);
edDeb.SetData(strTemp);
}

What am I doing wrong?

Thank you

Alex

Well, a couple of things (using SQL for select, probably using EditString to edit double...), but nothing related to the problem.

Small testcase would help.

Mirek

Report message to a moderator

[Message index]

		Can not get a double from database By: kbyte on Mon, 01 September 2008 20:48
		Re: Can not get a double from database By: mirek on Sun, 07 September 2008 11:24
		Re: Can not get a double from database By: captainc on Sun, 07 September 2008 14:16
		Re: Can not get a double from database By: mirek on Sun, 07 September 2008 20:44
		Re: Can not get a double from database By: kbyte on Tue, 09 September 2008 13:19

Previous Topic:	SQL statment in constructor make program crash
Next Topic:	MySql basic example

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Sep 09 22:57:11 GMT+2 2026

Total time taken to generate the page: 0.00838 seconds