Subject | [IBO] Re: TIB_LookupCombo: no selection possible |
---|---|
Author | Svein Erling Tysvær |
Post date | 2001-11-14T11:30:43Z |
Hi Mirco,
specifying JoinLinks. Change to
SQL.Strings = (
'SELECT *'
'FROM ASSAY'
'JOIN TEST ON'
'ASSAY.ASSAYID=TEST.ASSAYID'
'LEFT OUTER JOIN SAMPLETYPE'
'ON SAMPLETYPE.SAMPLETYPEID=TEST.SAMPLETYPEID)'
Don't know if this has anything to do with your problem though...
Set
>SQL.Strings = (...
> 'SELECT *'
> 'FROM ASSAY, TEST LEFT OUTER JOIN SAMPLETYPE'
> 'ON SAMPLETYPE.SAMPLETYPEID=TEST.SAMPLETYPEID'
> 'WHERE ASSAY.ASSAYID=TEST.ASSAYID')
>Nothing unusual here as well.yes, there is! You're mixing SQL 89 and SQL 92 (I think), without
specifying JoinLinks. Change to
SQL.Strings = (
'SELECT *'
'FROM ASSAY'
'JOIN TEST ON'
'ASSAY.ASSAYID=TEST.ASSAYID'
'LEFT OUTER JOIN SAMPLETYPE'
'ON SAMPLETYPE.SAMPLETYPEID=TEST.SAMPLETYPEID)'
Don't know if this has anything to do with your problem though...
Set