| Afin.Query | AfinScript © AFIN 2016 | ||||||||
| Start: [F5] or [Ctrl+Q] | |||||||||
| <<< Parameters | Info: 5 columns (A:E = 'COCPI..T') from the #11 row are reserved for the AfinScript's program. | ||||||||
| e.g. Path = | C:\AnyPath | ||||||||
| e.g. Database = | |||||||||
| e.g. Period = | |||||||||
| (…) | |||||||||
| Class (Vendor) | Object | Command | Parameters | Info | The rest: Comments, calculations, row parameters | ||||
| Afin.Query comm | . | ||||||||
| . | . | ||||||||
| Afin.Query | Info | OK, but it stops the program. | |||||||
| Afin.Query | ODBC;DSN=Excel files; DBQ=C:\AnyPath\Testy\Sprzedaz2015_testy.xlsx | SELECT COUNT(*) AS [MyCount]
FROM [Faktura$] |
PasteTo=Query[; Name=MyQuery ; RowNumbers=1] | . | Defaults: Name=Query; RowNumbers=1; Clear={See 'clear' specification (Afin.VBA)} |
||||
| Afin.Query | C:\AnyPath\Testy\Sprzedaz2015_testy.xlsx | SELECT COUNT(*) AS [MyCount]
FROM [Faktura$] |
PasteTo=Query; Name=MyQuery | . | If standard MS Query prefix like 'ODBC;DSN=Excel files; DBQ=' is omitted, it is filled in automatically (for popular file databases only) | ||||
| . | . | ||||||||
| Afin.Query | URL;http://nbp.pl | PasteTo=WebQuery; Name=NBP | , | Defaults: Name=Query; RowNumbers=1; Clear={See 'clear' specification (Afin.VBA)} |
|||||
| Afin.Query | URL;http://carbon.brighterplanet.com/flights.txt | PasteTo=MySheet1!K1; Name=NBP; PostText=origin_airport=WAW&destination_airport=JFK | , | PostText - See POST command (reading HTML) | |||||
| . | . | ||||||||
| Afin.Query | OLEDB;Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=C:\AnyPath\Sprzedaz2015.xlsx; Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1" |
SELECT * FROM [region$] |
PasteTo=_DaneOLEDB; Clear=3 | , | Clear={See 'clear' specification (Afin.VBA)} | ||||
| Afin.Query | OLEDB;Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=C:\AnyPath\Sprzedaz2015.accdb |
region | PasteTo=_DaneOLEDB; Name=_OLEDB; Unlist=1 | , | Defaults: Name=Query; RowNumbers=1; Unlist=0 |
||||