#1  
Old 21st October 2003, 02:15 AM
Holger Franke
 
Posts: n/a
Default "table stream" access control?

I use "table streams" with TnxDataset.WriteStream and TnxDataset.ReadStream
to store some global settings.

I read and write these streams from different clients. For this I want to
know if the table stream I want to write is busy or not.

Any suggestions?

Holger






  #2  
Old 21st October 2003, 03:55 AM
David Marcus
 
Posts: n/a
Default Re: "table stream" access control?

Holger Franke wrote:
> I use "table streams" with TnxDataset.WriteStream and TnxDataset.ReadStream
> to store some global settings.
>
> I read and write these streams from different clients. For this I want to
> know if the table stream I want to write is busy or not.


Why don't you store the global settings in a table?

--
David Marcus
  #3  
Old 21st October 2003, 09:13 AM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: "table stream" access control?

> I read and write these streams from different clients. For this I want to
> know if the table stream I want to write is busy or not.
>
> Any suggestions?

Us a explicit transaction while reading/writing the stream.

--
Thorsten Engler [NexusDB Architect]


  #4  
Old 21st October 2003, 05:49 PM
Holger Franke
 
Posts: n/a
Default Re: "table stream" access control?

It is a part of our licencing-concept to hold data and
registration-informations together in a file.

Holger


  #5  
Old 21st October 2003, 05:55 PM
Holger Franke
 
Posts: n/a
Default Re: "table stream" access control?

Ok, Thank you.
Is it necessary to do this, beacause each stream holds only 1..2 KByte?

Holger


  #6  
Old 21st October 2003, 06:48 PM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: "table stream" access control?

> Ok, Thank you.
> Is it necessary to do this, because each stream holds only 1..2 KByte?

Maybe I misunderstood your question, but you wanted a solution to prevent 2
clients from reading a stream, changing it, and writing it again at the same
time, thereby overwriting each others changes, right?

An explicit transaction will do exactly that.

--
Thorsten Engler [NexusDB Architect]




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to access field with an unfortunate name "12-dele" Steen Angelo nexusdb.public.support.sql 2 18th December 2007 08:49 PM
Why ? The table "folder" cannot be dropped. It is referred to from the table "mail" Ad Franse nexusdb.public.support.sql 4 11th May 2007 06:02 AM
2.0.599r3: Query that should work returns Unable to resolve the identifier"#t1"."ContratoId" =?ISO-8859-1?Q?=22Rodrigo_G=F3mez_=5BNDX=5D=22?= nexusdb.public.support.sql 2 4th November 2006 10:03 AM
SQL query to search on a field that is "similar to a set" or "mask"? J Tabor nexusdb.public.support.sql 2 10th May 2006 02:20 PM
Announcment! "The Keep" ver 2.0.0.1 and "Po Boy Application LifeCycle Management Utility" ver 1.0.0.l are now both available for free download! Robert Meek nexusdb.public.support.thirdparty 1 11th July 2004 10:23 AM


All times are GMT +11. The time now is 10:40 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.