Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieving FileStream from SQL Server
Message
From
12/07/2011 14:20:35
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01517970
Message ID:
01517996
Views:
38
>>>>>>Maybe so, but I couldn't find the UPDATE syntax in your links. I already had the INSERT syntax, but couldn't convert it to an UPDATE.
>>>>>
>>>>>Why?
>>>>
>>>>Because I am dumb? :)
>>>
>>>LOL :-)
>>>I doubt about it :-)
>>
>>Thanks :)
>>
>>Seriously, I got confused by the whole BULK and OPENROWSET stuff having never seen nor used them before.
>
>But why you need OPENROWSET?
>From VFP you could use CA with BLOB field or SPT with CREATEBINARY(FILTOSTR())

I still don't know what OPENROWSET is/does, but it works. If I get the time I'll try the CREATEBINARY instead, but as I'm using the FILESTREAM functionality I'm not sure if I need the OPENROWSET or not.
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Reply
Map
View

Click here to load this message in the networking platform