Hi

At 07:40 pm 10/02/2004, you wrote:

>You do realise that
>the trigger fire at the server, so that the client will not be able to
>see the newly inserted record without requerying?

Now I do, thanks, but I have arguments for the same.

Hypothetical: If I am not mistaken as soon as I request a new record from
FB assuming the trigger is firing then an ID should be returned at least on
the server. Now for eg. I do not refresh nor do I ask for a new id and I
try to save my record in VFP and it raises an error and nothing
happens. Now when I open the generator and check it's value in Marathon I
expect the value to have incremented, which is not the case.

Factual: If I ask the server for a new record, the trigger fires but I have
not refreshed the data and I ask for a new id manually (as I do now) then
every time I call the generator manually I should be expecting interleaved
nos. (1 generated by the trigger, 2 manually, next record, 3 by the
trigger, 4 manually). Even this is not the case. I have just confirmed
that the trigger is not firing and only my manually retrieved ids are
actually being generated and thus they are sequential nos. 1, 2, 3...

>Another thing is
>that some tools (at least IBO, which is what I use) know that a
>primary key has to be filled out,

Marathon does not.

> and you have to specifically tell
>IBO that the field is not required if you ever want your trigger to
>fire.

I just got lost, sorry



Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
venussoftop@...
venussoftop@...
venussoftop@...
venussoftop@...
vso_ad1@...
___________________________________________


Please note: We reserve complete rights for policy changes in the future
and the same will be applicable immediately as and when made. Attachments
may get corrupted before reaching you, in such a situation please let us
know and we will resend you the same at the earliest. We do not take any
responsibility for data loss of any type and kind. Data safety remains the
sole the responsibility of the users of our softwares.
___________________________________________

Internet email confidentiality:

This message may contain information that may be privileged or
confidential. If you are not the addressee nor are you responsible for the
delivery of the message to the addressee indicated in this email, then you
may not copy or deliver this email to anyone and you should notify the
sender by reply email and then destroy this message.

Please reply email immediately to this message with REMOVE in the subject,
if you or your employer do not consent to email of this kind.

Opinions, conclusions and other information in this message that do not
relate to the official business of my firm shall be understood as neither
given nor endorsed by my company.


----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.581 / Virus Database: 368 - Release Date: 09/02/2004


[Non-text portions of this message have been removed]