Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CA and Vartype(), Type() and BLOB
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
CA and Vartype(), Type() and BLOB
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01060413
Message ID:
01060413
Views:
52
I have SQL DB table with field types:

- varbinary
- nvarchar
- binary
- text
- image

In VFP I use CA and cursor Schema for this table.
The CA builder offer for this fields in schema always type M
But I wish for data type 'image' IN SQL DB, use BLOB field in CA cusor schema.

I don't find something in VFP Help for this.
At last I find something. I can use
blobfield W (12) &&& in CSchema
In addition for blob field in VFP:
? TYPE('blobField')     &&& return W
? VARTYPE(blobField)    &&& return Q
Any ideas ?
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Next
Reply
Map
View

Click here to load this message in the networking platform