Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server - Can it store contents of VFP General Field
Message
From
17/01/2001 14:08:21
 
 
To
17/01/2001 11:58:13
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00464744
Message ID:
00464819
Views:
13
Hi!

The best way to store binary data on SQL Server is to use image field on SQL Server. You're asking right question about general field - it is quite messy to handle it. There are workaround to use Memo field in VFP to store binary data and than map it to image field on SQL server. See following
FAQ#7995713 in Frequently Asked Questions section -> Client/server -> "How to work with Image field type on SQL Server?"


>We are hoping to scan all incoming post using a VFP Frontend.
>
>We want the results of these scans to be stored in a SQL Server backend and accessed over our WAN (Kilostream so pretty slow)
>
>1. Does SQL Server support the General Fields neccesary to store our scans.
>
>2. Is our WAN too slow.
>
>3. Is this a good idea or is their a better way we dont know about.
>
>Many Thanks
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform