|
| [WD22] Postgresql - Analysis and subsequent sql generation |
| Iniciado por guest, 27,ene. 2018 12:19 - No hay respuesta |
| |
| | | |
|
| |
| Publicado el 27,enero 2018 - 12:19 |
Hello,
WD 22, Postgresql
I tried creating a new analysis to check the sql script generation facility.
File: accountname
companycode varchar(10)
accountguid varchar(32)
accountname varchar(60) key with duplicates
companycodeaccountguid compisitekey unique
When I tried to generate the sql script through Analysis - Analysis - Generation - Generate SQL scripts, I found the following things missing.
1. No way to define a primary key.
2. index is created on account name fields.
3. index is created on companycode+accountpk with NO unique key word, means duplicate values could enter.
Is this the way the 'GENERATE SCRIPT' gives us the code ? I feel it's incomplete.
What else is the way to maintain Analysis and its subsequent script generation in Windev ?
Happiness Always
BKR Sivaprakash |
| |
| |
| | | |
|
| | | | |
| | |
|