milllkp.blogg.se

You can test other functions like Update and Delete with the same method.Use this license if you are an individual or small web hosting company with fewer than 250 customers and you want to show your own personal branding. + If you double click dynamic tag and write ID, name and major and then click “Insert”, you can see the new database is inserted in Access 2010 as below picture. + If you double click dynamic tag and write ID and click “Select”, you can see the its

+ Save the page and run CimonX with DS license key lock. +Make 4 texts and rectangle objects : Insert, Update, Delete and Select + Make 1 dynamic tag : IDSEARCH (yellow box) + Make 3 dynamic tags : ID, name and major (red box) In order to test ODBC, make a page as below: + Click  and make 4 scripts as following: + Write “Delete From Table1 Where im_ID=’’” at SQL and then click “OKĪfter ODBC setting, create Script to run Select, Insert, Update and Delete function. + Click and register a Field Name and following: + Write “Update Table1 Set im_name=’’, im_major=’’, Where im_ID=’’” at SQL and + Write “Insert Into Table1(im_ID, im_name, im_major) Values(‘’, ‘’, ‘’)” and then click “OK” + If you click “OK”, you can see the “SelectQ” at + Click and register 3 Field Name and following: How to Run Query : Run By Command Function + Click icon and write ‘myDB’ at and click ‘OK Open CimonD and register tags and set up ODBC + If you see the first picture, there is Directories C:＼ Users＼ Marketing＼ Documents＼ + Click and find out the Directories you saved myDB.mdb. + Since Database is made by Access 2010, select Microsoft Access Driver(*.mdb) and then click

+ Click and then click to register Database you made. Since you already made Database with Access 2010, it is time to set up ODBC at Windows. + Double click ‘Table1’ and then write the ID, name and major as below picture. + Field Properties of im_name and im_major are default (You do not need to change them) + Change the Field Properties only with im_ID as following: + Then write the Field Name and Data Type as below picture.

+ Click  and write ‘Table1’ at Table Name. In order to use ODBC function, click  as following.

A: Insert, Search, Update and Delete are available with CIMON-SCADA ODBC function through Microsoft Access.