August 26, 2003 at 4:57 pm
Hi,
Can someone please enlighten me as to what the error message "Invalid Descriptor Index" means? I know that it has to do with a column in my table that has a data type of text and length of 16. I am trying to extract this column into my VB program. The values are being extracted correctly on the first pass, but in subsequent calls it always returns null. If I change the column to a varchar, I do not get this problem. Unfortunately though, I need the data type to be text.
Also, someone once taught me that columns with a data type of text should always be the last columns in your table. They should also be the last columns in any SQL queries. I have confirmed this as I was experiencing a problem whereby the values of some columns were dropping from sight after adding a column to a query. After I moved the column to before the text columns, all was well. Does anyone know why this is? What is up with this text data type?
August 31, 2003 at 3:11 am
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply