Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
Great explanation!
Thanks