Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memofields and SQL-Server 7.0
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Memofields and SQL-Server 7.0
Miscellaneous
Thread ID:
00480858
Message ID:
00480858
Views:
57
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.
Next
Reply
Map
View

Click here to load this message in the networking platform