🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: borland.public.cppbuilder.database.multi-tier
4 messages
4 total messages Started by Tsvetozar / Fast Fashion Thu, 23 Sep 1999 00:00
INTERBASE TABLES question
#1528
Author: Tsvetozar / Fast Fashion
Date: Thu, 23 Sep 1999 00:00
13 lines
1024 bytes
In an INTERBASE table I cannot have an autoincrement field so I have to
manualy maintain it in another table.
But if I do write

int myIndex = myTable->FieldByName( "INDEX_COUNTER" )->AsInteger ++;

is there a chance that both CGI applications after some user requests
access the table and read the same value.
I am wondering is it safe and the one CGI-app will wait till the other
has finished its table field update;
If there's a betetr way can you explain it  ???

tsvetozar
Re: INTERBASE TABLES question
#1529
Author: Ant�nio F�lix
Date: Thu, 23 Sep 1999 00:00
14 lines
776 bytes
Hi Tsvetozar

You couldn't have AutoInc Fields like Paradox, but you could use a Generator
to get the same
behaviour

please see Interbase.public.general newsgroup and the following posts

Re: How can i make a autoinc field in interbase

let me knowif you need more help

HTH
Antonio
Re: INTERBASE TABLES question
#1533
Author: Tsvetozar / Fast Fashion
Date: Fri, 24 Sep 1999 00:00
20 lines
1098 bytes
I've checked that messages...
is this what they write SQL ???
Can I use native C++Builder programming to make an autoinc field myself ???

"Ant�nio F�lix" wrote:

> Hi Tsvetozar
>
> You couldn't have AutoInc Fields like Paradox, but you could use a Generator
> to get the same
> behaviour
>
> please see Interbase.public.general newsgroup and the following posts
>
> Re: How can i make a autoinc field in interbase
>
> let me knowif you need more help
>
> HTH
> Antonio
Re: INTERBASE TABLES question
#1534
Author: Ant�nio F�lix
Date: Fri, 24 Sep 1999 00:00
39 lines
1531 bytes
Hi Tsvetozar

If you use a C/S environment you must take advantage of that.
The Generators are part of the Server capability and they should be used
instead of Client counterparts

Interbase don't have a AutoInc field Type, but provides the Generator to
achieve the same behaviour


The Sql commands that you saw on the referenced post belongs to the Database
Metafile

HTH
Antonio

Tsvetozar / Fast Fashion wrote in message <37EB1BF1.F12C5C8C@bia-bg.com>...
>I've checked that messages...
>is this what they write SQL ???
>Can I use native C++Builder programming to make an autoinc field myself ???
>
>"Ant�nio F�lix" wrote:
>
>> Hi Tsvetozar
>>
>> You couldn't have AutoInc Fields like Paradox, but you could use a
Generator
>> to get the same
>> behaviour
>>
>> please see Interbase.public.general newsgroup and the following posts
>>
>> Re: How can i make a autoinc field in interbase
>>
>> let me knowif you need more help
>>
>> HTH
>> Antonio
>
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads