AYE ....
Download Attachment: TEACHQA.zip15.14 KB
I DID BUILD A MINI FORM USEING A BASIC QUESTION AND ANSWER DATABASE.
I BUILT THIS IN VISUAL BASIC ..
ONE BUTTON SEARCHES THE DATABASE (sql query)
ONE BUTTON UPDATES THE DATABASE.
THE DATABASE IS A MSACCESS mdb FILE
NOW ITS ALL ABOUT THE DATABASE WE WANT TO CONNECT AND WHICH FEILDS WE WANT TO CONNECT TO. WITH VISUAL BASIC 6 SQL IS ALREADY AN INTEGRAL PART.
AFTER RESEARCHING ACCESS & DATABASES I HAVE JUGGLED WITH VARIOUS TEMPLATES FOR A BASIC TABLE ..
AFTER LOOKING AT THE OPEN MIND IN GREATER DEPTH (WHICH USES A MSACESS DATABASE
IT USES VARIOUS FEILDS ITEM,LINKFROM,LINKTO ETC.
IM NOT SURE NOW HOW WE WOULD STUCTURE A TRUE smart AI BRAIN...
I THOUGHT MAYBE noun/item, LINKING_FROM_VERB, LINKING_TO_VERB, POSITVE,NEGATIVE,NEATURAL,RESPONSE,ANIMATION_FILENAME(optional).
IE n(oun)CAT
LINKFROM > WHAT IS A
LINKTO > A (nOUN) IS A (RESPONSE), NEAUTRAL, RESPONSE
HMM ideas??
WITH VARIOUS TYPES OF SQL SEARCH WE CAN BUILD A TYPE OF FUZZY LOGIC, TO DETECT nOUNS IN THE USER INPUT AND LINKING_VERB. WHICH WOULD THE POINT TO IS LINKTO AND RESPONSE WITH ASOSCIATED NOUN. IF THERE ARE MANNY RECORDS THEN MAKE A RANDOM PICK . IF NO RESPONSE FOUND exeCute A like SEARCH(SIMULAR). IF NO RESPONSE IS STILL FOUND, THEN MAKE AN ENQUIRY TO THE USER BY PRESENTING THE USER WITH A teachme form ONSCREEN FOR A NEW ADDITION TO ITS DATABASE.
CURRENTLY I AM LOOKING FOR A WAY TO ACCESS MULTIPLE DATABASES WITHIN A VISUAL BASIC FORM???[?][?]
BUT IDEAS THOUGHT HELP ALWAYS WELCOME