LOAD v SQL SELECT

[mazacini]

Up to now, I have been mainly dealing with table files.

So I use the LOAD command, then specify the individual fields I want to load.

I can also append calculated fields, and change the formatting of fields in the script following LOAD.

Now, I want to connect to a MS Access file.

Using the wizard, firstly I connect via ODBC to the Access file; then I click on the Select button.

It enters the script

SQL SELECT *
FROM Table

The problem is that I don;t know how to do the things I do with the LOAD command, such as selecting indivdual fields rather than all (*), or changing the format of individual fields, or appending fields during load.

Can anyone help?

Ta

Joe 

[swuehl · Accepted solution]

I think you can actually do some of the things you want to also with a SQL SELECT, like specifying the individual fields (this should also be possible via the wizard, but just replace the wildcard with your field list).

Then, you could do a preceding LOAD using all the QV functions to transform / manipulate the fields.

Like

LOAD *,

'Test' as Newfield;

SQL SELECT Field FROM Table;

[mazacini]

Great explanation!

Thanks