[VXCMD] Help with Text fields

[Ruslan Zasukhin]

On 6/18/05 5:00 PM, "Peter McConachie" <pmccon at bigpond.net.au> wrote:

>> BLOB is NOT Binary field
>> 
> 
> OK so far. What I don't understand is how you get data in & out of the
> memory buffer. Reading the VXCMD reference I need the following

Wait a moment.

But you need not pure BLOB, but TEXT field, write ?

Peter, I think that example from VXCMD 1 do have TEXT field.
You need use simply

    Field_PutString()    and Field_GetString()

To put/get strings into TEXT field

Exactly as with String and VarChar fields.

>     put "SELECT * FROM Table WHERE recID=1" into sSQL
>     put Valentina("DataBase_SQLSelect",dbRef,sSQL,"1","1","1") into cRef
>     put Valentina("Cursor_GetFieldRef",cRef,"cData") into fRef
>     put Valentina("BLOB_GetDataSize",fRef) into blobSize
>     put Valentina("MemBuffer_Allocate",blobSize) into bValRef    < Line 5
>     get Valentina("BLOB_ReadData",fRef,bValRef,blobSize)
> 
>> From what I can read, line 5 allocates memory buffer of blobSize bytes to
> receive data read from field "cData" of cursor. bValRef is an integer.
> 
> How do I get the data from this buffer into say a MetaCard field or other
> variable ? How do I put data into this buffer to prepare for a BLOB_Write
> Data operation ?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]