Bonjour,
Je réactive cette question, car elle m'intéresse de nouveau.
SGBD H2 Database :
http://www.h2database.com
Spécifications complètes de la base que je souhaite créer ici :
http://www.amibroker.com/odbc.html
Je dois donc créer une table SQL ayant ces caractéristiques :
Citation:
Data plugin can connect to any database that has corresponding ODBC driver. In order to allow to access data, the table holding quotations needs to have the following columns:
* SYMBOL - holding ticker symbol (text - varchar)
* DATE - quotation date / time (DATETIME type - for Microsoft SQL Server, or TIMESTAMP type for mySQL (open source))
* OPEN - open (recommended FLOAT type)
* HIGH - high (recommended FLOAT type)
* LOW - low (recommended FLOAT type)
* CLOSE - close (recommended FLOAT type)
* VOLUME - volume (recommended FLOAT or INT type)
* OPENINT (optional) - open interest - (recommended FLOAT or INT type)
Types of fields are not that important as plugin has ability to auto-convert if types differ. Recommended types are just as a guideline for best performance.
Cette première approche vous semble-t-elle correcte ?
Merci de votre aide.Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14 DROP TABLE IF EXISTS quotes ; CREATE TABLE quotes ( symbol varchar(6) NOT NULL, qdate timestamp NOT NULL, qopen FLOAT NULL , high FLOAT NULL , low FLOAT NULL , close FLOAT NULL , volume FLOAT NULL , PRIMARY KEY (symbol) ) ;