Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Screwtape on August 27, 2014, 11:11:16 pm

Title: Too Few Parameters error with Custom SQL Fragment
Post by: Screwtape on August 27, 2014, 11:11:16 pm

Hi,

I've a really simple query and yet I'm getting this error message "Too Few Parameters - Expected 1" each time the fragment is called.

The SQL is

Code: [Select]

SELECT name FROM t_object
where stereotype = "StartEvent"
and t_object.parent_id = #OBJECTID#which seems so simple there couldn't be anything wrong with it, but I might just be blind.

Any help with this would be great! Thanks!

Screwtape

Title: Re: Too Few Parameters error with Custom SQL Fragm
Post by: qwerty on August 28, 2014, 12:50:08 am

Remove the underline in ParentID

q.

Title: Re: Too Few Parameters error with Custom SQL Fragm
Post by: Screwtape on August 28, 2014, 01:28:58 am

Thanks - it's always something simple.

By the way - it's listed as Parent_ID in section 2.4.1 of Inside Enterprise Architect, or at least on the online preview that I was looking at...

Title: Re: Too Few Parameters error with Custom SQL Fragm
Post by: qwerty on August 28, 2014, 01:43:48 am

 :-[ So you're the first one falling in that typo-trap. I'll make a correction immediately. Just download the pdf in a couple of hours.

<rant> One of those inconsistencies. Some names use underline, others don't.</rant>

q.