How to count number of unique records of a field in progress openedge 4gl? -

-

i have customer table field age . how can count how many distinct ages there ?

you can in abl using for-loop , break , counter. there built in aggregate functions (accum) in abl seen in wild...

define variable integer     no-undo.  each record no-lock break record.age:     if last-of(record.age) do:         = + 1.     end. end. message "there " " unique ages" view-as alert-box.

or crippled built in sql:

select count(distinct age) record.

Comments

Post a Comment

Popular posts from this blog

c++ - list<myClass<int> * > sort -

-
i cannot sort list contains pointers objects of template class. template class node{ public: node(void){} node(t choice, vector<t> & data); node(t choice, vector<t> & data, player p, int level, int pos, node<t> *pred, side); void addnodes(void); static list<node<t> * > nodes; friend class mybinomialtree<node<t>, t>; bool sorter(const node<t> * lhs, const node<t> * rhs);// * &lhs doesn't work private: node<t> * left; node<t> * right; t chosen_; vector<t> data_; bool isleaf; //... }; outside class: template<class t> bool node<t>::sorter(const node<t> * lhs, const node<t> * rhs){ if((*lhs).level_==(*rhs).level_){ return (*lhs).pos_<(*rhs).pos_; }else{ return (*lhs).level_<(*rhs).level_; } } and want sort before print, have template<class t> void node<t>::print(void){ ...
Read more

sql server - database first change primary key from int to uniqueidentifier -

-
i trying change primary key in 1 of tables int uniqueidentifier. pointed out in title, taking database first approach using entity framework. the process took remove primary key table in sql designer , renamed column "itemid" "item". i created column named "itemid" , set uniqueidentifier type default newsequentialid(). then deleted column renamed "item" , set "itemid" primary key. i moved visual studio , did update model database gave me error error 1 error 2019: member mapping specified not valid. type 'edm.int32[nullable=false,defaultvalue=]' of member 'itemid' in type 'shoppingmodel.dbfruits' not compatible 'sqlserver.uniqueidentifier[nullable=false,defaultvalue=,storegeneratedpattern=identity]' of member 'itemid' in type 'shoppingmodel.store.dbfruits'. and here model under .tt directory public partial class dbfruits { public dbfruits() { thi...
Read more

mysql - SQL, Recursive Query -

-
Image
can please me query working selecting data's tables wanted display fields connected other fields using recursive query. my table i have self query does'nt output connected , connected fibers query select closure_id, fiber_id , @pv:=fiber_id 'fiber_id2' (select * tbl_map_closure_fiber order closure_id) join (select @pv:=1)tmp closure_id=@pv just askin how can manage ouput both connected closure_id , connected fiber. please 1 . you need join table pair related rows. select t1.fiber_id, t2.fiber_id fiber_id2 tbl_map_closure_fiber t1 join tbl_map_closure_fiber t2 on t1.fiber_id = t2.closure_id http://sqlfiddle.com/#!9/3f83ee/2
Read more