U++ forum: Welcome to the forum

Re: SqlVal to int (Typecast) [message #45175 is a reply to message #45174]

Wed, 23 September 2015 06:58

dolik.rce
Messages: 1789
Registered: August 2008
Location: Czech Republic

Ultimate Contributor

Hi ayana,

ayana wrote on Wed, 23 September 2015 06:25

SqlVal ro;
Sql UserQuerySql;
UserQuerySql.Clear();
UserQuerySql * Select (Count(MBVARINDEX)).From ( PARAMETER );
while ( UserQuerySql.Fetch() )
{
ro=Count(MBVARINDEX);
}

In the above query whatever the count value I am getting is of type 'SqlVal',I want that to typecast into 'Int', Let me know how to do typecasting for it.

This SqlVal is actually only representation of sql column used when constructing the query. What you need is the result, which is accesible via the Sql object after calling Fetch:

int ro;
Sql UserQuerySql;
UserQuerySql.Clear();
UserQuerySql * Select (Count(MBVARINDEX)).From ( PARAMETER );
while ( UserQuerySql.Fetch() )
{
  ro=sql[0];
}

See the Sql tutorial, it demonstrates this and many other useful and important thing about sql in U++.

Best regards,
Honza

Report message to a moderator