Çë½ÌÒ»¸öACCESSµÄ²éѯÓï¾ä£¡
Òª×éºÏ4ÕűíµÄ²éѯ£¬·Ö±ðÊÇA±í£¬B±í£¬C±í£¬D±í£»
A±í
Game_id Game_Name
1 abc
B±í
Category_ID Category_Name Game_id
1 A 1
2 B 1
C±í
area_id area_name game_id
1 AB 1
2 CD 1
D±í
server_id server_name area_id
1 AAA 1
2 BBB 1
3 CCC 2
4 DDD 2
ͨ¹ý²éѯÔõôÏÔʾÏÂÃæµÄ½á¹û£º
Game_Name Category_Name area_name server_name
1 A AB AAA
1 A AB BBB
1 &n
Ïà¹ØÎÊ´ð£º
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
int ret = 0;
_RecordsetPtr pset;
CString sql;
& ......
ÈçÌâÔÚÎÒ´ò¿ªaccessÐ޸ĵÄʱºò±¨´í
ÎÒ×°µÄGhost µÄXP°æ sp3µÄ²¹¶¡
´íÎóÇ©Ãû
AppName: msaccess.exe AppVer: 11.0.8166.0 AppStamp:46437912
ModName: pintlgnt.ime&n ......
access¿ÉÒÔÖÆ×÷ÄÇÖÖÏÂÀ²Ëµ¥Â𣿾ÍÏñFile£¬È»ºóÏÂÃæÓÐOpen£¬Save,Save asµÈÑ¡Ïî¡£µ«ÊÇ£¬Ó¦¸Ã½«Êó±ê·ÅÉÏÈ¥¾ÍÖ±½Ó¿ÉÒÔ´ò¿ª°É£¬²»ÊÇcombo box¡£Õâ¸öÓÃʲôÀ´×ö£¿
×Ô¶¨Ò幤¾ßÀ¸
´°ÌåÉè¼ÆÄ£Ê½
²Ëµ¥--ÊÓͼ--¹¤¾ ......
ÎÒÓÐÒ»¸ö±í,
´óÖ½ṹʽÕâ¸öÑù×ÓµÄ
id itname fenlei1id fenlei2id num
1 ÎïÆ·1 1 &n ......