Order By in 4GL Report
Posted in 1997
Bryan Tonnet — — source: Informix-list mailing list archive (1991-1998)
Anyone know of a decent (decent = not recopying the entire report block) way to include a dynamic "order by" in a 4GL report? That is, if my report driver is; LET sql_stmt_l = "SELECT a,b,c FROM z" IF something THEN LET sql_stmt_l = sql_stmt_l clipped, " ORDER BY a" ELSE LET sql_stmt_l = sql_stmt_l clipped, " ORDER BY b" END IF ; can the report be told of a variable "order by", or am I stuck with a different report block for each possibility? Thanks in advance Bryan Tonnet batonnet@zeta.org.au