[V4REV] get png

[william humphrey]

Here is a LiveCode solution for getting images:

function GetSignature pSQL pCardNameAndPath pImageName

   put VDatabase_SqlSelect( DatabaseReference, pSQL ) into CursorRef

   put VCursor_Field( CursorRef, "fieldName" ) into fldPic

   get VBLOB_ReadData( fldPic, "dataPic" )

   set the text of image pImageName of pCardNameAndPath to dataPic

   put VCursor_Destructor(CursorRef) into CursorRef

end GetSignature

On Thu, Nov 28, 2013 at 6:07 PM, william humphrey
<bill at bluewatermaritime.com> wrote:
> If you double click field_pictures.rev using live code 6.5 you get
> crash immediately.
>
> On Thu, Nov 28, 2013 at 2:27 AM, Ruslan Zasukhin
> <ruslan_zasukhin at valentina-db.com> wrote:
>> On 11/27/13, 12:37 AM, "william humphrey" <bill at bluewatermaritime.com>
>> wrote:
>>
>>> Every time I look at the V4REV_Reference I remember how much I hate
>>> it. There is never one single complete example.
>>
>> Because this is Reference of methods.
>>
>> And believe me, YOU want one complete example,
>> But 10 other developers will want 10 totally other complete examples
>>
>>
>>> The order of fields in the cursor is the same as the order of fields
>>> in the SELECT statement of the query.
>>
>>> Example:
>>>
>>> put VTable_FieldValue( tblRef ) into value
>>>
>>> Example:
>>>
>>> get VTable_FieldValue( tblRef, 1, "Name" )
>>
>> William,
>>
>> So we are talking about cursors ??
>> Then why you watch into TABLES ?
>>
>>
>>> The above example hints that you can use a SQL query but it doesn't
>>> show you how.
>>
>> From above 2 lines I do not see any SQL mention.
>>
>> But again, you should learn Vcursor class, but not Vtable.
>>
>>
>>> Using the V4REV reference is like solving a crossword
>>> puzzle.  And you cannot use the example stacks that come with the
>>> V4REV install because those just crash LiveCode and they are written
>>> so it is very very difficult to copy pieces of code out from them and
>>> use them.
>>
>> * COPY CODE from example -- this is not good practice.
>>
>> * Our V4REV examples crash? You sure?
>>   May be it needs check gClient variable to see
>>     if it is in local mode or vserver.
>>   But we will double check then examples.
>>     Which exactly crashes for you?
>>
>>
>> --
>> 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]
>>
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>
>
>
> --
> http://www.bluewatermaritime.com



-- 
http://www.bluewatermaritime.com