Don't you love TERs?

[DBohner-(db)]

Don\'t you love TERs?

Ok... like I always start out... someone has to have dealt with this...
I have this Table. I check it out... I do not modify the TERs... I
highlight it and select build triggers. It appears to compile successfully
- no errors, no warnings.
I go into the TER and modify a comment... save, exit and build... no errors,
no warnings... appears successful.
I go back into the TERs and open a File.Insert command. I do not change
anything... save and exit the TERs... this time I select Build Triggers and
it dies before attempting to compile. It gives me a /* CER ERROR #3008 :
Invalid table or column */ error and references the table I just viewed in
the file.insert. NOTHING was modified...
The file to be inserted was checked out to the local workstation...
I had another one of our developers (a senior guy) look over it ~ "I have
never seen anything like that" was the response.
Ideas? Recommendations?
Daniel Bohner
[email protected]
www.existinglight.net
[email protected]
www.simplot.com

 

[kstern]

Re: Don\'t you love TERs?

If you are using the AS/400 as your server, you will need delete the SQL
packages from the environment your are using. You can do this by using the
display object description command specifying the object type of *SQLPKG.
Output this to an outfile and where the owner is equal to JDE or ONEWORLD delete
those packages.

Ken Stern
OneWorld Developer
Andrews Consulting Group

 

[DBohner-(db)]

RE: Don\'t you love TERs?

I did, finally, get around the issue... but I don't fully understand what
was wrong.

My work-around was to open the tablename.Insert and re-map all the fields...
exactly as they were...

When I recompiled - I go no errors... Logically speaking, something was
broken... There was a disconnect somewhere, but I don't know where. If
anyone knows where, please speculate.

Opinions, private or public, are welcome.

Daniel Bohner
[email protected]
www.existinglight.net

or

Daniel Bohner
Simplot Corporate Information Systems
Pioneer Building
Boise, ID
(208)332-0613 desk phone
(208)250-1917 personal cell
[email protected]

 

[Zoltan_Gyimesi]

Re: Don\'t you love TERs?

Daniel,
Just some silly idea:

1.) Print out the table spec of the effected table from table designer and compair it to the the opened Insert statement (field existance, field order, indices).
2.) Check your header file (Fxxyyy.h) of the effected table in your include subfolder.
3.) Re-generate the header file and try again.

Good luck,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[Zoltan_Gyimesi]

Re: RE: Don\'t you love TERs?

Daniel,

At first, I am glad to read that your issue have been resolved.
I have to scenarios about "your why or how":

A. Scenario:
============
The mentioned ER line was copied/pasted from somewhere else. There was a discussion about ER Copy/Paste in the near past on this List/Forum or on the other one where I have written:
"If I copy/paste a Table I/O statement then I always re-map all in it but generaly I avoid copy/paste Table I/O statement, my habit is to re-create this type of statements.".
This is based on my bad experiences.
If your statement were pasted, then your case is a good example.

B. Scenario:
============
The table was changed after the Insert statement have been created originaly.

Daniel, can you confirm one of the two scenario?

Zoltán
P.S.: please check Larry's "Cranky - Haven't had my coffee yet " post too.


B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)