MySQL Forums
Forum List  »  Connector/ODBC

Select statement with empty Data
Posted by: Rene Sandmann
Date: February 15, 2007 02:32PM

Hello,

i have a SELECT statement that returns a value with no data.
This is the statement:
SELECT * from artikel WHERE artikelnumber = 10003

I send this to the Mysql server via the mysql 3.51 Odbc connector and using
Xbase 1.82.
When i use browse()
it reports one row but all values are empty.

When i change the Select statement to report two rows.
SELECT * from artikel WHERE artiklenumber = 10003 OR artiklenumber = 10004
all is correct even the Data from the first row is shown.

deos some have an idea?

thanks

Rene

Options: ReplyQuote


Subject
Written By
Posted
Select statement with empty Data
February 15, 2007 02:32PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.