In order for this site to work correctly, and for us to improve the site, we need to store a small file (called a cookie) on your computer.
By continuing to use this website, you agree to our cookies and privacy policy.
  
Home page Home page Home page Home page
Pixel
Pixel Header R1 C1 Pixel
Pixel Header R2 C1 Pixel
Pixel Header R3 C1 Pixel
Pixel

QTIPS - List/SQL Statements

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)
Pixel
Pixel Footer R1 C1 Pixel
Pixel
Pixel
Pixel