asked on

Handling very long strings

Hello Experts:

I have seem to run into a problem that I don't know how to handle.

I am using Sql 7.0 for the database backend, and I store very long strings in a field defined as text. When I pull this data into a string variable, it only retrieves about 1300 characters of data. Im not sure if its the field definition or the variable definition that I'm having a problem with. As long as the data is smaller than 1300 characters, it works fine.

Any ideas?

Data is stored as such:

65000,65001,65002,65003,......

I pull this into a string variable then run a sql statement as such:

Select * from tablename where fieldname in (Variable).

ASKER CERTIFIED SOLUTION

bob_online

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bob_online

To continue, you can build the array like this

done = false
ArrayIndex = -1
While not done
redim preserve arrNames(arrNames.Ubound + 1)
ArrayIndex = ArrayIndex + 1
arrNames(ArrayIndex) = Left$(StringFromDatabase, 1275)
StringFromDatabase = Mid$(StringFromDatabase, 1276)
If Len(StringFromDatabase = 0 Then
Done = True
End If
Wend

trkcorp

ASSUMING ADO:
You probably need to use the GetChunk method for retrieving the data... This is well documented. Look up ADO/data types/managing long data types in your help files

bob_online

Finally, the 1275 value in my parsing routine won't work because it isn't allow for commas but you can easily calculate the corrrect value.

eosu

don't use getchunck - use ADO streams.

escheider

ASKER

Sorry its been awhile since I've checked on this, my wife is pregnant and haven't dedicated time to this site.

eosu, please give me an example on ADO streams..

escheider

ASKER

Decided to close this question. I used your example and it works just fine...thanks for your time and input