Re: [SQL] DLookup('field', 'table', ['condition'])

2001-02-27 Thread Josh Berkus
Mr. Ambos, > Is this supposed to give effectively the same result as the subquery > (select student.id where name='Bill Gates' limit 1)? I don't think > that subquery is supported in 7.0, but will be in 7.1 along with > EXECUTE for plpgsql which should let you build a query out of the > parts yo

Re: [SQL] DLookup('field', 'table', ['condition'])

2001-02-26 Thread Stephan Szabo
On Tue, 27 Feb 2001, Herbert Ambos wrote: > I'm trying to create Domain Aggregate function that mimic Access' Dlookup > function, but without any luck, after digging (i think) all the docs > don't have the solution yet. > > Syntax: > > DLookup ('field', 'table|view', ['condition']) > >

[SQL] DLookup('field', 'table', ['condition'])

2001-02-26 Thread Herbert Ambos
Hi, I'm trying to create Domain Aggregate function that mimic Access' Dlookup function, but without any luck, after digging (i think) all the docs don't have the solution yet. Syntax: DLookup ('field', 'table|view', ['condition']) where: field -- column n