Subject | RE: [IBO] Problem with SQL syntax |
---|---|
Author | Tobias Giesen |
Post date | 2002-02-15T19:52:42Z |
> SELECT * FROM COSTCATEGORYDEFINITIONSWhat is this supposed to do in a trigger? Looks like Delphi would say
> WHERE COSTCATEGORYNO = NEW.COSTCATEGORYNO;
"This code has no effect" - so probably Interbase considers it illegal?
What you could use is a FOR SELECT stament, or an UPDATE statement etc.,
but I can't see what a simple SELECT could be supposed to do.
Cheers,
Tobias