| Subject | Re: [firebird-support] select first fails with view | 
|---|---|
| Author | sugi | 
| Post date | 2004-08-04T15:14:09Z | 
> Select first 1 * from sometable works.This is an old IBO 4.2.x bug, not a firebird bug. If you can access
> Select first 1 * from v_someview fails:
> STATEMENT:
> TIBOInternalDataset:
> "<TIB_Session>.<TIBOQuery>.<TIBOInternalDataset>."
> The view is based on the table, and works fine if I don't have 'FIRST
> 1'.
yahoogroups' IBObjects message archive, search for the "[IBO] Parser
messes up SQL containing FIRST" thread from october 2003.
If i remember correctly, this error showed up with normal tables too,
not just views. The quick-and-dirty solution was to turn off the
KeyLinksAutoDefine property.
Salam,
sugi.