Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL Server 2000 Binary Field problem
When using SQLEXEC command to return a binary field from a SQL Server it comes back as a gen data type. Trying to save the field to a string, so I can use the STRTOFILE command but I get the error when using the following command.
SqlServer = SQLCONNECT("sqlServer", "userid", "Password")
rc = SQLEXEC( sqlServer, "SELECT binaryField From sqltable", "mycursor")
lcSting = myCursor.Binaryfield <-- Error
I think the problem is, the binary field is around 8000 char, and also has nulls in it.
Is there another way to retieve binary fields from SQL Server?
I need to be able to read/change the field and update the table on the SQL Server.
Thanks for the help
Rex A. Walters
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement