>Table: LogAL100
>Field Name Type Len
>
>cart_num C 8
>coperator C 5
>dtime T 8
>cmachine C 5
>clopnr C 6
>copnr C 3
>cstatus C 1
>corsak C 2
>cprgrupp C 3
>------------------------
>Total record size: 42
>
>SQL-view:
>
>
>SELECT *, SUBSTR(LogAL100.cart_num,1,5) AS artsort FROM reportit!logal100 ;
>WHERE Logal100.cart_num = ?vp_Artnum ;
>AND Logal100.coperator = ?vp_Operator;
>AND Logal100.cmachine = ?vp_Machine ;
>AND Logal100.cprgrupp = ?vp_Prgrupp ;
>AND Logal100.clopnr = ?vp_Lopnr ;
>AND Logal100.dtime BETWEEN ?vp_FromTime AND ?vp_ToTime ;
>ORDER BY 10, Logal100.copnr, Logal100.clopnr
>
>
>
>
>