U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » fetch not reading into struct

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

fetch not reading into struct [message #32661]

Wed, 01 June 2011 02:11

jjacksonRIAB
Messages: 227
Registered: June 2011

Experienced Member

I have a session created with MSSQL and am reading from a view in SQL server. My .sch file looks like this:

TABLE_ (PUNCH_VIEW)
	STRING_ (EMPLOYEE_ID, 6)
	STRING_ (FIRST_NAME, 15)
	STRING_ (LAST_NAME, 16)
END_TABLE

Now, when I create a session, I'm running over VPN so I have to impersonate first, then I create my connection and try to run a select:

S_PUNCH_VIEW view;

Sql sql(dbSession);
sql * Select(view).From(PUNCH_VIEW);

while(sql.Fetch(view))
{
    if(view.FIRST_NAME == "John")
    {
        // add this text to a GridCtrl
    }

    // Add data to GridCtrl
    grid.Add(sql);
}

For some reason the fetch is not filling S_PUNCH_VIEW "view" with any data. It's just empty through each cycle in the loop, but grid.Add(sql) actually works and displays the data.

Additionally if I try sql[FIRST_NAME] instead, I get an exception: "Assertion failed in Sql.cpp line 287 0". Any hints as to what I'm doing wrong?

Report message to a moderator

Re: fetch not reading into struct [message #32664 is a reply to message #32661]

Wed, 01 June 2011 08:34

tojocky
Messages: 607
Registered: April 2008
Location: UK

Contributor

jjacksonRIAB wrote on Wed, 01 June 2011 03:11

I have a session created with MSSQL and am reading from a view in SQL server. My .sch file looks like this:

TABLE_ (PUNCH_VIEW)
	STRING_ (EMPLOYEE_ID, 6)
	STRING_ (FIRST_NAME, 15)
	STRING_ (LAST_NAME, 16)
END_TABLE

Now, when I create a session, I'm running over VPN so I have to impersonate first, then I create my connection and try to run a select:

S_PUNCH_VIEW view;

Sql sql(dbSession);
sql * Select(view).From(PUNCH_VIEW);

while(sql.Fetch(view))
{
    if(view.FIRST_NAME == "John")
    {
        // add this text to a GridCtrl
    }

    // Add data to GridCtrl
    grid.Add(sql);
}

Maybe you should try:

[code]
Sql sql(dbSession);
sql * Select(EMPLOYEE_ID, FIRST_NAME, LAST_NAME).From(PUNCH_VIEW);

while(sql.Fetch(view))
{
    if(view[FIRST_NAME] == "John")
    {
        // add this text to a GridCtrl
    }

    // Add data to GridCtrl
    grid.Add(sql);
}
[/code]

Report message to a moderator

Re: fetch not reading into struct [message #32666 is a reply to message #32664]

Wed, 01 June 2011 08:51

jjacksonRIAB
Messages: 227
Registered: June 2011

Experienced Member

When I do that I get a compiler error (MSVC 2010):

error C2676: binary '[' : 'S_PUNCH_VIEW' does not define this operator or a conversion to a type acceptable to the predefined operator

If I switch it to sql[FIRST_NAME], I get "Assertion failed in e:\upp\uppsrc\Sql\Sql.cpp, line 287 0" at:

Value Sql::operator[](SqlId id) const {
	String s = ~id;
	for(int i = 0; i < cn->info.GetCount(); i++)
		if(cn->info[i].name == s)
			return operator[](i);
	NEVER(); // <-- here
	return Value();
}

Report message to a moderator

Re: fetch not reading into struct [message #32670 is a reply to message #32666]

Wed, 01 June 2011 10:31

tojocky
Messages: 607
Registered: April 2008
Location: UK

Contributor

try use upper case SQL, and use SQL instead view:

SQL = dbSession
SQL * Select(EMPLOYEE_ID, FIRST_NAME, LAST_NAME).From(PUNCH_VIEW);

while(SQL.Fetch(view))
{
    if(SQL[FIRST_NAME] == "John")
    {
        // add this text to a GridCtrl
    }

}

A better example look in HomeBuget package.

[Updated on: Wed, 01 June 2011 10:41]

Report message to a moderator

Re: fetch not reading into struct [message #32673 is a reply to message #32670]

Wed, 01 June 2011 11:54

jjacksonRIAB
Messages: 227
Registered: June 2011

Experienced Member

I see what I did. When I was writing my .sch file I was going off of column alias names instead of the actual column names behind them. My mistake.

Thanks for your help!

Report message to a moderator

Previous Topic:	Creating a TIMESTAMP column in MySQL
Next Topic:	Sqlite with U++

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri May 09 12:01:39 CEST 2025

Total time taken to generate the page: 0.00997 seconds