PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Progress ext database questions - newbie Windev
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