Thanks Martijin. That worked.
I'm using a closure table to manage an organisation structure. The organisation
table is defined as:
CREATE TABLE ORGANISATION
(
ORGID DOM_INTLARGE NOT NULL,
ORG_NME DOM_VARCHARMEDIUM NOT NULL,
LEVEL_NUM DOM_INTSMALL NOT NULL,
INUSE DOM_BOOLN,
CONSTRAINT PK_ORGANISATION PRIMARY
What you'll need to do is to download the firebird embedded edition and unzip
it into a folder. If you are going to try to change the password from the
command prompt you'll need to copy the isql.exe file from your original
installation into the folder where you unzipped the embedded version.
I have the following tables in a relationship I’ve tried to draw below. The
OrgChart table is a closure table to display the hierarchy of the organisation.
The Organisation is 3 Levels deep.
|--|
|Guidance |
|_|
|
Thanks liviuslivius. You've taught me not to try to understand new code whilst
tired. :)
setysvar - Now that I'm refreshed I understand code and am very appreciative
Hi Set
Thanks for helping me with this. Your answer has been a great help. However
there is a problem with the result set. In the Assignment table I have the
following data: (of interest is assignid 9 which is projectid 19)
ASSIGNID ASSIGN_DATE MANAGER PROJECTID 1 03/03/2016 11 2
Sorry just to add that I want the query to return projectid, assign_date,
review_date and Progress_note
I have an assignment table (master table) and a review table (detail table).
The review table holds one or more records for each record in the assignment
table. I need a query to return the latest review for each record in the
assignment table. Could someone advise me on a query to do this.
I've tracked down the problem to the variable Vorgid inside the insert into
statement. This is a variable that I have declared at the beginning of the
procedure and I am using a select statement to set it's value. So the question
is what is the correct way to use this variable with the Insert
I am getting a "invalid request BLR at offset 667 bad parameter number" when I
try to define the stored procedure below. The procedure first checks that the
value supplied in IN_ORGID relates to a department and then finds the
organisational structure for the department (Ie: it's division and
Thanks Ed. Yes, Orgid is declared as a BigInt in the Assignment Table and
Vorgid is declared as a Bigint in the procedure.
I'm still building the procedure bit by bit so I haven't placed in what will
happen when LevelCheck is not 1. I want to get what I've done so far working
for valid
Thanks Martijn. Your suggestion worked perfectly
I have three tables Guidance, Assignment and Review. Assignment is a detail
table to Guidance and Review is a detail table to Assignment. When a new
record is entered into the Guidance table I want to an after insert trigger on
the Guidance table to insert default values into Assignment and
13 matches
Mail list logo