Excel VBA

lovely_idiot · May 24th, 2010, 01:52 AM

Hi everyone,

Iâm having a problem with TEXT Data Type in Sybase. (TEXT is used to store âREMARKSâ which may be very long)

I have this TEST1 table for testing:

Code:

create table TEST1 (
	DATE	datetime,
	REMARKS 	text
)

(1) I am able to insert some string into the âREMARKSâ field but not retrieve it using "select"(Please refer to attached).
The button only attempt to display the âREMARKSâ and âDATEâ in âTEST1â which already has some records.
? Runtime error at the following line: ODBC--Call failed!

Code:

MsgBox "Test record: " & rstRtn("REMARKS") & " - " & rstRtn("DATE"), vbInformation + vbOKOnly, "Testing"

Any ideas how to overcome this?

(2) I am able to insert each profile name into a single line into the âREMARKSâ filed.
However, retrieving the profile names line by line (to write to different rows in Excel spreadsheet) is going to be tough (Only after (1), is answered and I am able to get rstRtn("REMARKS"), of course :D).
Any ideas?

Thanks for any help :)

Shasur · May 24th, 2010, 08:49 AM

Hi

Not sure why the error comes from this code.

Can you check in immediate window the content of RecordSet 'rstRtn' , this might provide you with some hint.

If not can you post some more code for us to understand

Cheers
Shasur