Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
karan@talash.net
Starting Member
12 Posts |
 Posted - 2002-07-01 : 02:46:59
|
| Hi,I am facing a strange problem.I am executing a stored procedure and storing the result in a recordset.I am then printing the value of one field in a table,but the records are not displayed.I had verified that the procedure is returning records.The datatype of the field was text and when i changed the datatype to varchar the records are displayed.I am unable to understand the reason behind this.RegardsKaran |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-07-01 : 02:55:30
|
| What are you calling the Stored Procedure with ? ADO ?Damian |
 |
|
|
karan@talash.net
Starting Member
12 Posts |
Posted - 2002-07-01 : 03:07:14
|
| Hi Merkin,Yeah i am accessing the stored procedure through ADO.I also want to let u know that when i am accessing another field of same datatype i am able to print the results. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-07-01 : 03:13:08
|
| When using text fields with ADO, they have to be the last fields in your select lists or ADO gets confusedDamian |
|
|
|
karan@talash.net
Starting Member
12 Posts |
Posted - 2002-07-01 : 03:21:24
|
| HI Merkin,If the case is that ADO gets confused then why it is printing another field of same datatype where the second field is also not the last field.RegardsKaran |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-07-01 : 03:29:48
|
| I would have to see your code to give you more info... but basically, put text fields last, or you are likely to get unpredicatble results when using ADO.Damian |
|
|
|
|
|
|
Strange Problem