Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FILETOSTR too large
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
FILETOSTR too large
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01355252
Message ID:
01355252
Views:
101
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')
Next
Reply
Map
View

Click here to load this message in the networking platform