![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 6 of 6 total |
![]() |
Mon, Jun 2 2014 10:11 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | This one seems a bit of a harsh restriction to me. Its easy enough to work round so I'm not to concerned but I thought I'd mention it for the next time Tim takes a breather.
SELECT :Project , _fkContacts, _fkCompanies, _fkSites, _ID FROM Career WHERE _fkJobCodes = 'CEO' AND _fkCompanies IN (SELECT DISTINCT (_fkCompanies) FROM Calls WHERE _fkProjects = :Project) ElevateDB Error #700 An error was found in the statement at line 2 and column 1 (Invalid expression ? found, dynamic parameter references not allowed) Roy Lambert |
Mon, Jun 2 2014 10:14 AM | Permanent Link |
Matthew Jones | Roy Lambert wrote:
> SELECT > :Project , _fkContacts, _fkCompanies, _fkSites, _ID > FROM Career > WHERE > _fkJobCodes = 'CEO' > AND > _fkCompanies IN > (SELECT > DISTINCT (_fkCompanies) > FROM Calls > WHERE _fkProjects = :Project) You want to have a dynamic field in the results? That is used in the conditions too? Not sure how this would work as-is, the requirement must be interesting. -- Matthew Jones |
Mon, Jun 2 2014 11:36 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Matthew
The workround is to build the string yourself - ![]() This is my non sql centric view <vbg> Roy Lambert |
Mon, Jun 2 2014 12:04 PM | Permanent Link |
Matthew Jones | But you have the :Project in the list of fields. From your explanation,
you want a field named 226... > SELECT > :Project , _fkContacts, _fkCompanies, _fkSites, _ID -- Matthew Jones |
Mon, Jun 2 2014 1:12 PM | Permanent Link |
Roy Lambert NLH Associates ![]() | Matthew
"Matthew Jones" <matthew@mattNOSP-AMhew-jones.com> wrote on Mon, 2 Jun 2014 12:04:02 -0400 >But you have the :Project in the list of fields. From your explanation, >you want a field named 226... No I want a constant 226. I can do select 226 AS ProjectNumber from calls but I can't do select :Project AS ProjectNumber from calls Roy Lambert |
Tue, Jun 3 2014 4:03 AM | Permanent Link |
Matthew Jones | Roy Lambert wrote:
> No I want a constant 226. I can do > > select 226 AS ProjectNumber from calls Okay, you haven't gone mad then. 8-) -- Matthew Jones |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |