Delphi DBGridEh picklist table to modify more questions-CodePudding

there are two tables: A table in the field id, name, bm, ks fields in table B seqks, seqks ksname, table B=table A ks
Column: A table
Id name bm ks
Zhang SAN network department 12 1
Table B
Seqks, ksname
12 WeChat group
13 promotion group
I use DBGridEh control link DataSource1 ADOQuery1 ADOConnection1, ADOQuery2 even table B
CX. CX. SQL: select id, name, CX. Bm, ITEM. Ksname from CX INNER table AS A JOIN table B AS ITEM ON CX. Ks=ITEM. Seqks where...

Then the
The select ksname, seqks from table B where... ,
DBGridEh1. Columns [4]. The PickList. Add (ADOQuery2. FieldByName (' ksname). AsString) are identical.//here to seqks
DBGridEh1. Columns [4]. The KeyList. Add (ADOQuery2. FieldByName (' ksname). AsString) are identical.//here to seqks
After the operation showed normal have a drop-down box is also Chinese
Id name bm ks
Zhang SAN network department WeChat group 1
Because the table A ks is digital, to display the name you will need to read table B corresponding seqks ksname
Now a drop-down box to choose modify WeChat to network group
Error: not in a position to update
If you like//to seqks here, is normal, but shows the Numbers, this is not what I want, what I want is to display Chinese
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Didn't, I'm a beginner, to hand over a friend, can you tell me how to make the great god choose a drop-down box promotion group make table 1 ks updates for 13

the main interface is shown in ChineseSearching said with a lookup, but will not use the
The trouble for a complete code, thank you!

CodePudding user response:

Sorry, I have to solve

CodePudding user response:

Thank moderator attention