|
Log in | ||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
I just needed the column list of the resulting query for a field picklist,
so I surrounded the original query AABB by SELECT * FROM (AABB) T WHERE FALSE But unfortunately this fails if the original query AABB was segmented... (multiple SQL statements like creating an index and then returning data using a select statement) So I decided to change all the SELECT keywords into SELECT TOP 0 and then returning the query result. But hey, this is strange: I get ALL records back? SELECT TOP 1 returns one record, SELECTR TOP 2 returns two records, but SELECT TOP 0 returns all records? Bug or WAD? Regards - hans |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Returning result sets using a stored procedure | Grant Brown | nexusdb.public.support.sql | 3 | 29th August 2006 04:28 PM |
| Deliberately return an EMPTY ResultSet from a Query | Dennis Landi | nexusdb.public.support.sql | 6 | 31st January 2006 07:19 AM |
| Result Fields are empty | Bernhard Roos | nexusdb.public.support.sql | 6 | 3rd December 2005 04:31 AM |
| 2.04 preview not returning data | Thomas Lohrum | nexusdb.public.support.sql | 1 | 20th October 2005 01:06 PM |
| Query not returning the correct dataset. | Rodrigo Gómez [NDX] | nexusdb.public.support.sql | 4 | 21st July 2005 02:19 AM |