Hi Dmitry,
W (blob) is equal to M NOCPTRANS
MartinaJ
>>>Hi,
>>>
>>>I would like to experiment with binary data. I read in the VFP help that for binary data you have to use Blob type field.
>>>I created a test cursor with B type field. But, the following produces error:
>>>
>>>CREATE CURSOR binerytest (testfld b)
>>>INSERT INTO binerytest (testfld) VALUES ("123")
>>>
>>>
>>>How do you store a string in this field?
>>Hi Dmitry,
>>
>>CREATE CURSOR binerytest (testfld W)
>>INSERT INTO binerytest (testfld) VALUES (0h313233)
>>INSERT INTO binerytest (testfld) VALUES (CAST("123" AS VARBINARY(3)))
>>
>>
>>MartinaJ
>
>Hi Martina,
>First, thank you for your help.
>I am looking at the Help page of VFP and can't seem to figure out what type is "W" or "Q". Could you please explain?
>
>Update: Just found in help that Q stands for Varbinary but nothing about W.
>
>Update 2:. Do I understand that the number parameter in the VARBINARY(N) should be equal to the number of characters in the string? This is why you wrote (above) VARBINARY(3)?