COMBOBOX with oDBF

[Ollie]

I want to store 'L', 'A' or 'O' in a (1 character) database field called MAIL_CAT (Mail category = Local, African, Overseas)

But I want to use a Combobox so the user can only make a valid choice, but I only want to store the first letter ie. L, A, or O in the database.

REDEFINE COMBOBOX oDBF:MAIL_CAT ITEMS {"Local", "African", "Overseas" } ID 4012 OF oDLG

... doesn't do it.

Is there a way the screen can show 'Overseas' when it sees 'O' in the database field? How?

[James Bott]

Use a DBCombo. See \samples\testdbc1.prg for an example.

[Ollie]

Thanks.

I have this code:

REDEFINE DBCOMBO oDBF:MAIL_CAT ID 4012 ;
items {"L","A","O"} ;
list {"Local","African","Overseas"} ;
of oFld:aDialogs[ 1 ] UPDATE

But the compiler gives a "parse error at 'DBCOMBO' what am I doing wrong?

[James Bott]

#include "dbcombo.ch"

[Ollie]

That did it. EXCELLENT !!! Thanks.