[V4MD] Question about the SQLExecute Command

[Carsten Ilwig]

> I have describe in prev letter that you need to use Cursors to add records
> with Director Members.
>
> SQL's INSERT cannot do this...
Ok. Thanks for your patience with me. ;-)

Best regards
Carsten Ilwig

----- Original Message -----
> >>> 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...
>