|
Progress ext database questions - newbie Windev |
Iniciado por h.f.blum, 08,ene. 2004 14:14 - No hay respuesta |
| |
| | | |
|
| |
Publicado el 08,enero 2004 - 14:14 |
I've bought WinDev for Native Access to Progress.
I've not yet setup the native access Progress but are familiarising myself with WinDev thru ODBC (read-only connection) first.
ODBC questions: Progress naming convention, Progress supports file and field names containing the special character - like file name lb-040 and fieldname Descr-35. Does WinDev support special characters used by external databases? Workaround? Will the natives access module do beter?
Analyse or Data model editor/files items. The editor or the inspector don't pick up the indexed fields. Access and VDbase do. You have to set the indexes manually. Is there a way to fix this? Will the antive access module perform beter?
Fields containg the special character cannot be set as keys. Error fieldname.
The progress database files contain several composite keys. These are not picked up by the analyse tool (Data model editor) Trying to set this manually will lead to a new field name in the model editor, but this doesn't correspond to the Progress database. Trying to set a 0,N-1,1 on two composite keys is not picked up by the link wizard. It will try to add a new key to the linked file. How can this be solved?
To work around this all without working with the tools and wizards, If I make a sql query in a text editor and use this. How? Furthermore will the data be available or will I run into problems as the tools and wizards do?
TIA,
Fred Blum |
| |
| |
| | | |
|
| | | | |
| | |
|