Profound Logic Forums

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

Regards

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.

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!

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

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

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.