Getting Data Without Declaring a Table Variable

Its Possible to get data from the database without declaring a table variables.

Static void Job3(Args _args)
{
// No Variables
;

print (select CustTable).AccountNum;
Pause;
}

Note the parentheses around the select statement. This tells the compiler to create a temporary, anonymous buffer to hold the record. The select statement uses the exact table name and is immediately followed by a field name to get a value from a field.

If you use this there’s no Intellisense to help you look up the field name because the editor doesn’t know the type of the anonymous buffer.

This technique is often used in exist() methods on tables.