New to this(urgency needed please) 1

[MrHelpMe]

I have a view as follows

create view as holderaccountbalance

select pp.lastname, pp.firstname, ca.balance, ca.creditlimit, ca.currency, tx.product,
cx.number, ce.value, max(tx.i013_trxn_date)
from caccounts ca, cardx cx, people pp, cextension ce, ctransactions tx
where
ca.serno=cx.caccserno and
ca.serno=tx.caccserno and
ca.serno=ce.rowserno and
ce.fieldno in (select fieldno from extensionfields where
category like 'Company Industry Cod%') and
cx.peopleserno=pp.serno
group by
pp.lastname, pp.firstname, ca.balance, ca.creditlimit, cx.number, ce.value, ca.currency, tx.product
order by ce.value

I keep getting this error message: Need to specify view column names in the view definition. Any idea what this means.

Also, is there any graphical user interface that I can use(free GUI) to create views, SP etc for Informix. Your urgent help is great. Thanks

 

[mynwo]

Hi there,
Regarding a query tool you can visit

http://www.indus-soft.com/SynametricsWebApp/WinSQL.jsp

Its free & a nice tool.
In the view specify a name to the max column.
eg. max_value max(tx.i013_trxn_date)
It should work.

Regards,

lloyd

 

[vpshriyan]

Hi,

Here are few more links for GUI tools which you may find useful. This list is not in any particular order.

Database Commander

http://www.crystal-soft.com

SIIS Sarasoft Integrated Imaging System

http://www.sarasoft.com

Database Design Studio Lite

http://chillisource.com/

DB Commander 2000 PRO

http://www.dbcommander.com/

Case Studio 2

http://www.casestudio.com/

Advanced Query Tool (ATQ)

http://www.querytool.com/

DTM SQL Editor

http://www.sqledit.com/

Regards,
Shriyan

"You can achieve the most when you don't care who gets the credit"