Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Dynamic references not allowed |
Wed, Jun 18 2008 3:38 AM | Permanent Link |
"Tomas" | 1. SELECT r.*, t.RTypeName FROM ROOM r, RType t
WHERE r.RTypeID = t.RTypeID AND NOT r.RoomID IN (Select RoomID FROM SALES WHERE SalesDate <= ? AND NOT DEAD) 2. CREATE TEMPORARY TABLE "sample" AS SELECT r.*, t.RTypeName FROM ROOM r, RType t WHERE r.RTypeID = t.RTypeID AND NOT r.RoomID IN (Select RoomID FROM SALES WHERE SalesDate <= ? AND NOT DEAD) 1st quesy works but 2nd sql in SP does not work. Is this a bug or limitation? |
Wed, Jun 18 2008 4:15 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tomas
Its a limitation presently. I also had the problem and I think Tim said it'll be something that's going to be sorted. For now you'll need to DECLARE a VARCHAR build the string and then execute it. Roy Lambert [Team Elevate] |
Wed, Jun 18 2008 6:33 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Tomas,
<< Is this a bug or limitation? >> It's a known limitation in that CREATE TABLE doesn't allow parameters. It's on the list for fixing in one of the first few 2.0 minor releases. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |