Gary,
thanks for your answer.
First I would like to make clear that the fact that the mentioned
FrontBase plugin author can't help me with my problems is NOT HIS FAULT;
just in case somebody misunderstood that. As you wrote, he's just not
working for the company any more.
Well, the problem that I have that in ceratin situations an
InsertRecord() will fail silently, ie. none of the error flags
(DB.Error, DB.ErrorNumber, DB.ErrorMessage) reports an error.
The actual situation:
- User "_System" created a table "Mitglieder" (which is assigned to
schema "_System" by default.
- User "Bitterlich" wants to add records via Database.InsertRecord().
Sufficient rights are assigned (I think <g>). The statement:
gDB.InsertRecord("""_System"".""Mitglieder""", myRecord)
- I did not forget gDB.Commit.
- No error reported; but no records added.
Second try:
- Using the server management utility, changed the default schema of
user "Bitterlich" to "_System"; so now I can use the simplified statment:
gDB.InsertRecord("""Mitglieder""", myRecord) or even
gDB.InsertRecord("Mitglieder", myRecord)
- Now that works.
BTW, using SQLSelect works just fine under both circumstances.
So I have two problems: The minor one - why can't I add records to a
table that belongs to another schema? The major one - why is no error reported?
I'm planning on using FrontBase for a mission critical application, and
I just can't have it failing silently on me, regardless how stupid the
error is I might have made myself.
Do you have any clues for me?
Cheers,
Frank+++
gary hayenga wrote:
...
> > It appears that the error reporting of the FrontBase plugin is
> > unreliable.
...
>
> The original Frontbase RB plugin author no longer works for Frontbase.
> We have been using it for quite some time in beta and have had a fair
> amount of success with it, with the exception that it does not yet
> support carbon builds for OS 9.x.
>
> What problems are you having?
>
> gary hayenga
--
Günter Schmidt & Co. oHG
Frank Bitterlich eMail: bitterlich at gsco dot de
Schlosserstr. 2-4 WWW: http://www.gsco.de/gsco
D-60322 Frankfurt Tel.: 069 / 156809-29
GERMANY Fax: 069 / 156809-28
|