Trouble with writing a SQL template fragment

[John Arnold]

Hi folks I'm trying to write a template fragment based on a SQL query.

My query (very basic at the moment) is

select Object_Name as PortName from t_object where Object_Type = "Node" and Package_ID = #PACKAGEID#

But I'm getting the error message

DAO.Database [3061]
Too few parameters.  Expected 1.

any ideas?

[Geert Bellekens]

try

Code: [Select]

select o.Name as PortName from t_object o
where o.Object_Type = 'Node'
and o.Package_ID = #PACKAGEID#
Geert

[John Arnold]

Many thanks for the suggestion Geert, but I still get the same error.
John

try

Code: [Select]

select o.Name as PortName from t_object o
where o.Object_Type = 'Node'
and o.Package_ID = #PACKAGEID#
Geert

[qwerty]

Your first query used Object_Name which does not exist. Hence the too few parameters. Geert's SQL is correct. So what kind of error do you get?

q.

[Geert Bellekens]

Many thanks for the suggestion Geert, but I still get the same error.
John

try

Code: [Select]

select o.Name as PortName from t_object o
where o.Object_Type = 'Node'
and o.Package_ID = #PACKAGEID#
Geert

You also had the #Package# macro wrong. This actually works.

Code: [Select]

select o.Name as PortName from t_object o
where o.Object_Type = 'Node'
and o.Package_ID = #Package#
You do know that you can't just make up anything when writing SQL don't you?
Columns and macros actually have to exists in order to use them.

Geert

[John Arnold]

Geer, I have been researching this a bit but I still can't make it work.

the #package# macro is used in searches, but #packageid# is used in template fragments.

I do know I can't write just anything, but I can't find a proper description of the object model Sparx is using so it's difficult to know what the correct fields are.

You also had the #Package# macro wrong. This actually works.

Code: [Select]

select o.Name as PortName from t_object o
where o.Object_Type = 'Node'
and o.Package_ID = #Package#
You do know that you can't just make up anything when writing SQL don't you?
Columns and macros actually have to exists in order to use them.

Geert
[/quote]

[Geert Bellekens]

I do know I can't write just anything, but I can't find a proper description of the object model Sparx is using so it's difficult to know what the correct fields are.

You can either open your .eap file with ms-access (or another generic sql client) or reverse engineer the .eap file (or dmbs repository) into EA.

Geert

[qwerty]

Or you can refer to my Inside book.

q.