U++ framework
Do not panic. Ask here before giving up.
Home » U++ Library support » U++ SQL » Returning a null from select
Returning a null from select [message #11532] Sun, 16 September 2007 22:04 Go to next message
dmcgeoch is currently offline  dmcgeoch
Messages: 52
Registered: November 2006
Location: New Jersey
Member
Hopefully this is an easy question even though I've been pulling my hair out. Smile

I am executing a select statement ( SQL & Select data FROM table ) that may not find a match for the criteria. How do I test for no match. If I try to test the SQL[0] parameter, the program bombs. Is there a way to evaluate for no return value.

Thank you for any assistance,

Dave

Report message to a moderator

Re: Returning a null from select [message #11534 is a reply to message #11532] Sun, 16 September 2007 22:21 Go to previous messageGo to next message
zsolt is currently offline  zsolt
Messages: 702
Registered: December 2005
Location: Budapest, Hungary
Contributor
If your first Fetch() returns with false, you have an empty result set.

Report message to a moderator

Re: Returning a null from select [message #11540 is a reply to message #11534] Mon, 17 September 2007 02:05 Go to previous message
dmcgeoch is currently offline  dmcgeoch
Messages: 52
Registered: November 2006
Location: New Jersey
Member
That was it. Thanks

Report message to a moderator

Previous Topic: PostgreSQL issues
Next Topic: Handling multiple rows data in sqlite3
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Mon Apr 27 02:31:15 GMT+2 2026

Total time taken to generate the page: 0.00510 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.2.0.
Copyright ©2001-2025 FUDforum Bulletin Board Software