tips:revmedia:v2i8a3

QTIPS - List/SQL Statements

Published ByDateVersionKnowledge LevelKeywords
Sprezzatura Ltd01 JAN 19912.021+EXPERTLIST, SQL, CURRENCY

Ms Jenny Spankie of the Inland Revenue warns that whilst it is permissible to use the dollar sign in field names, other currency symbols aren't so reliable. Although it is possible to paint windows and create dictionary items containing the œ sign, any attempt to create a list statement using the field will fall over with a "Compilation aborted" message. Further, with 2.01, it is not possible to use the SQL ALIAS syntax. This is a particular problem where derived columns are being created, since they have no heading and would benefit from the use of an aliased column name.

(Volume 2, Issue 8, Page 4)

  • tips/revmedia/v2i8a3.txt
  • Last modified: 2024/06/19 20:20
  • by 127.0.0.1