Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
FILETOSTR too large
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01355252
Message ID:
01355253
Vues:
43
>l_ImagePath is a file 79,550 KB and when the command is executed we get error:
>
>Alias 'TEMPIMAGEFL' is not found
>
>Is there a way to send the file name to sql and convert the file to an image?
>
>
>Example:
>
>lcImage= FILETOSTR( l_ImagePath )
>
>lcSqlCmd = [exec dbo.IMS_sy_SaveImage '] + ;
> l_Source + [',] + ;
> ALLTRIM(STR(UserFL.UserFLID)) + [,] + ;
> ALLTRIM(STR(TermFL.TermFLID)) + [,'] + ;
> lcName + [','] + ;
> lcType + [', ?lcImage ]
>
>If this.SqlExecWrapper( lcSqlCmd, 'tempImageFL')

What IMS_sy_SaveImage do?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform