U++ forum: Welcome to the forum

Search on this site

Search in forums

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

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

Can not get a double from database [message #17889]

Mon, 01 September 2008 20:48

kbyte
Messages: 87
Registered: July 2008

Member

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

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: Tue Jun 24 19:53:19 CEST 2025

Total time taken to generate the page: 0.06067 seconds