Use VC to add a field in the database table for reading, and then display and save

1. Save:

 

When using ADO to access the database, one of the reasons for the idispatch Error #3092 error is that the reserved keywords are used in SQL statements.

Key is a keyword.

Strsql = strsql + "', key_kek ='" + key_kek;

 

M_key.getwindowtext (key_kek );

 

M_key is the variable associated with Edit. In this statement, the caption value of m_key is copied to the variable key_kek.

 

2. Read and display:

 

Str_key = m_precordset-> getcollect ("key_kek"). bstrval;

M_key.setwindowtext (str_key );

 

110410 WCG