Hi,

Is this code correct, I mean, does it ensure I end up in the place I
started?

 OldFilter := Table.Filter;
 B := Table.GetBookmark;
 try
   // filtering and deleting some records from "Table" happens here
   // ............

   Filter := Table.OldFilter;
   Table.GotoBookmark(B);
 finally
   Table.FreeBookmark(B);
 end;


What happens when I call GotoBookmark, if the record bookmarked was
deleted?


tia,

Lucian

>   OldFilter := Table.Filter;
>   B := Table.GetBookmark;
>   try
>     // filtering and deleting some records from "Table" happens here
>     // ............
>
>     Table.Filter := OldFilter;
>     Table.GotoBookmark(B);
>   finally
>     Table.FreeBookmark(B);
>   end;

Lucian,

<< Is this code correct, I mean, does it ensure I end up in the place I
started? >>

Not guaranteed, no.  However, you'll be at the closest position possible if
the bookmarked record has been deleted or modified in a way that moves it in
the active index.  You can verify a bookmark by calling the BookmarkValid
method.

--
Tim Young
Elevate Software
www.elevatesoft.com

> Not guaranteed, no.


Ooops, it seems I was lucky so far! Thanks.
I have another one, possibly feature request:

I want to copy a BLOB from a record to another record, however, is it
possible to do this without actually transfering the BLOB over the
network/internet? If it's not possible, is it feasible to have such
feature?


regards,

Lucian

"Lucian" <thanks@no.spam> wrote in message
news:D13FF54A-B114-432B-8785-8A55B8CE71EC@news.elevatesoft.com...
>> Not guaranteed, no.
>
>
> Ooops, it seems I was lucky so far! Thanks.
> I have another one, possibly feature request:
>
> I want to copy a BLOB from a record to another record, however, is it
> possible to do this without actually transfering the BLOB over the
> network/internet? If it's not possible, is it feasible to have such
> feature?
>

I assume you're talking about C/S, in that case just do it with SQL.

Robert

> I assume you're talking about C/S, in that case just do it with SQL.

Yes C/S .. Errr, I never accessed BLOB's via SQL, can you share one
or two such sql statements, plz

TIA,

Lucian

> I assume you're talking about C/S, in that case just do it with SQL.

will it work if the copy is in the same table?

Luci

Lucian,

<< I want to copy a BLOB from a record to another record, however, is it
possible to do this without actually transfering the BLOB over the
network/internet? If it's not possible, is it feasible to have such
feature? >>

Are you referring to copying a BLOB from one record to another in the same
table ?  You can do so via inserts by using the CopyOnAppend property:

http://www.elevatesoft.com/dbisam4d5_tdbisamdataset_copyonappend.htm

--
Tim Young
Elevate Software
www.elevatesoft.com

> http://www.elevatesoft.com/dbisam4d5_tdbisamdataset_copyonappend.htm

aha, ok. so something like this (no error checks, just some pseudocode):

 mytable.FindKey...
 mytable.CopyOnAppend := true;
 mytable.insert;
 // set the fields - actually this overrides some copied stuff
 // but I'll skip updating the blob alltogether
 mytable.post;
 mytable.CopyOnAppend := false;

This way I endup with a new record, having the BLOB I need copied from
the record found with FindKey and the content of the blob never left
the server?

cool thanks

Lucian

"Lucian" <thanks@no.spam> wrote in message
news:A3894EE0-B41D-4D37-A19A-07D75C82FD74@news.elevatesoft.com...
>> I assume you're talking about C/S, in that case just do it with SQL.
>
> Yes C/S .. Errr, I never accessed BLOB's via SQL, can you share one
> or two such sql statements, plz


Let DBISAM worry about it it is just another field as far as SQL is
concerned. Say you have a table with an ID integer and a blob B and you want
to create a new record with an ID of 2 copying the blob from 1 into the new
record

Insert into mytable (id, b)
select 2, b from mytable where id = 1

Robert