Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 10 of 15 total |
bookmark doubts |
Wed, Nov 15 2006 12:02 PM | Permanent Link |
"Lucian" | 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 |
Wed, Nov 15 2006 12:03 PM | Permanent Link |
"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; |
Wed, Nov 15 2006 4:30 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Nov 16 2006 2:07 PM | Permanent Link |
"Lucian" | > 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 |
Thu, Nov 16 2006 3:19 PM | Permanent Link |
"Robert" | "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 |
Thu, Nov 16 2006 3:37 PM | Permanent Link |
"Lucian" | > 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 |
Thu, Nov 16 2006 3:49 PM | Permanent Link |
"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 |
Thu, Nov 16 2006 4:03 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Nov 16 2006 4:31 PM | Permanent Link |
"Lucian" | > 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 |
Thu, Nov 16 2006 5:59 PM | Permanent Link |
"Robert" | "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 |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |