I have a product.dbf file. There is a field called "description" that is
Memo datatype. when I use odbc execute a sql like this:

String sqlStr="select * from products"+ " where
code="+"'"+product.ProductCode+"'";



Then I do:

if (myDataReader.Read())

{

product.Name=myDataReader.GetString(6).ToString();

product.Description =myDataReader.IsDBNull(11)?"":myDataReader.G-
etString(11).ToString(); }



Where the 11th field is the "description" field and has no data.



I got error:

Microsoft.Data.Odbc.OdbcException: NO_DATA - no error information
available

at Microsoft.Data.Odbc.OdbcConnection.HandleError(Int Ptr hHandle,
SQL_HANDLE hType, RETCODE retcode)

at Microsoft.Data.Odbc.OdbcDataReader.GetData(Int32 i, SQL_C
sqlctype, Int32 cb)

at Microsoft.Data.Odbc.OdbcDataReader.internalGetStri ng(Int32 i)

at Microsoft.Data.Odbc.OdbcDataReader.GetValue(Int32 i, TypeMap
typemap)

at Microsoft.Data.Odbc.OdbcDataReader.GetValue(Int32 i)

at Microsoft.Data.Odbc.OdbcDataReader.IsDBNull(Int32 i)

at Perissos.Rcs.DataAccess.MivaTableAccessor.LoadProd uct(Product&
product)



Could someone help me?


--
Posted via http://dbforums.com