Hi,
i want to transfer data from a Memo-Field to a SQL-Server table.
On the Sql-Server i create a field from type image.
create cursor foo (MemoFeld M)
APPEND BLANK
StringToInsert = "Hello Memofiled. Here i am!!!"
replace MemoFeld with StringToInsert
sqlcon = sqlconnect ( "TEST", "SA", "")
= SQLEXEC(Sqlcon,"INSERT INTO TestTab(MemoFeld) VALUES (?foo.MemoFeld)")
Ok, that works. A select with ISQLW returns a long Hex-Stig. Thats right.
But if i try to get the field wiht Fox-Pro it is returned as a field as type Objekt(General) Field and not as Memo-Field.
= SQLEXEC(Sqlcon,"SELECT MemoFeld from testtab into cursor foo")
How can i get a nomal Memo-Field or how can i convert the General-Field to a String?
CU,
Sven
If you post a reply, kindly refrain from emailing it, too.