Use DDMs in visual designer

[amanso]

Is it possible to use DDMs in visual designer to fill the choices in a textbox?

Regards

[Scott Klement]

When you use the "database-driven autocomplete" properties, it builds an SQL statement like this:

"SELECT <your fields> from <your file>" with optional WHERE and ORDER BY if you specify the appropriate properties.

Will that work for your DDM file? I have never used DDM files, so I'm not sure what is needed to use them.

[Wendy]

Is there any new news about using DDM's in visual designer to fill the choices database file for a select box or textbox? It would be fantastic if Profound was able to do this!

[Scott Klement]

I never got a reply, above. That was the last I heard of this.

[Wendy]

Scott,
Currently while I'm trying to use a DDM file definition I get the following msg when I click on 'choice options field':

Unable to retrieve field listing:
File XYZ not allowed with SYSTEM(*LCL)

This makes me assume we can't use a DDM. Maybe I'm assuming wrong. But if not, is this something you feel we could put in a request for enhancement?

Thank you,
Wendy

[Scott Klement]

Is it because the above listed SQL statement doesn't work on DDMs? If so, can you suggest what would need to be done differently to query a DDM via SQL? I'm not familiar with DDMs.

You can certainly put in a feature request for it if you want to, that's up to you.