thebigbradwolf
Posts: 10
|
Posted: 09/28/2007, 10:21 AM |
|
The program will work fine and return everything from the database except it won't return the values of a "Description" field, where it's a Text field, it autosets to "Memo" but I changed it to Text manually and I can't get it to work either way.
instead of the text actually stored there, I get things like this:
net.sourceforge.jtds.jdbc.ClobImpl@ffeba4
but the SEARCH returns the right rows in a grid like if you search for month in the desription, it returns the ones with "month" in them.
So, I think the problem is somewhere in the "Grid", but I don't see where.
|
|
|
wkempees
|
Posted: 09/28/2007, 3:18 PM |
|
What DB?
What field type has Description in the Database?
"thebigbradwolf" <thebigbradwolf@forum.codecharge> schreef in bericht
news:946fd3827efb22@news.codecharge.com...
> The program will work fine and return everything from the database except
> it
> won't return the values of a "Description" field, where it's a Text field,
> it
> autosets to "Memo" but I changed it to Text manually and I can't get it to
> work
> either way.
> instead of the text actually stored there, I get things like this:
>
> net.sourceforge.jtds.jdbc.ClobImpl@ffeba4
>
> but the SEARCH returns the right rows in a grid like if you search for
> month in
> the desription, it returns the ones with "month" in them.
>
> So, I think the problem is somewhere in the "Grid", but I don't see where.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
thebigbradwolf
Posts: 10
|
Posted: 10/01/2007, 5:56 AM |
|
The server is MS SQL server standard edition version 8.00.2039
In both the original table and the view I'm using, it is: Text (nulls allowed)
|
|
|
thebigbradwolf
Posts: 10
|
Posted: 10/03/2007, 8:20 AM |
|
Apparently, text isn't stored as "text" but as a pointer and it causes things to error, so you have to change one of the common files to be able to read it.
|
|
|
|