Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memofields and SQL-Server 7.0
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Memofields and SQL-Server 7.0
Divers
Thread ID:
00480858
Message ID:
00480858
Vues:
58
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform