[V4MD] Question about the SQLExecute Command

[Ruslan Zasukhin]

on 3/14/03 11:17 AM, Carsten Ilwig at Carsten.Ilwig at portal-rind.de wrote:

>>> Is it possible to store an Director Member via SQLExecute command into an
> BLOB
>>> Field?
>>> With the SetMedia command in Director-Lingo ther isn't any problem to do
> this
>>> but if I try this with the INSERT INTO command I get als the error 618
>>> (expected ',') back.
>> Mmmm, I afraid this not works...
>> Command SetMedia is special for this.
> That's correct, when I do this with the SetMedia-command, than it work's
> fine.
> But I have tried to insert a hole Director Member with the SQL-Command
> "insert into" via SQLExecute-command.
> But this do not seem to function.
> 
> for example:
>   insert into myTable (TextMember) VALUE ('(member 71 of castLib 9)').
> 
> I get now error back, but in the field "TextMember" there are no data saved
> and the field is also not NULL.
> 
> Is it not to be possibly to write Directormember (or generally data for
> BLOB-fields) with the SQL commands Insert/update in a database?

No Carsten,

I have describe in prev letter that you need to use Cursors to add records
with Director Members.

SQL's INSERT cannot do this...


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------