PB expert advice!!
[Users questions | Browse:74 | Favorites]
Users questions: I Zikao computer network, there is a database technology course, have to be on the test machine we used PB programming, I never learned PB, 11 月 10 号 being tested, and worried to death about me, I borrowed from the library PB book to chew on, how can such a short time to learn will be, ah, can not only please the nice people online help Me! The following is exploring truth, I did by following a click, but can not run, do not know the following statement is not written all of the, if not all, please help me which write all, or is better to do good program sent to my mailbox zkd.dd @ 163.com,, I am grateful!! ~ ~ 1. To establish a database newdb (newdb.db database file must be saved in C: * temp directory). (Auto connect to the database, ODBC data source name for newdb). 2. Newdb in the database to create three tables: s (sno, sname, a ge, sex) c (cno, cname, teacher) sc (sno, cno, grade) the property, age and grade as smallint, and the others were char type. S in the table, the master code is sno; in table c, the main code is cno; sc in the table, the master code is a (sno, cno), the outer code has two: sno and cno. Were three tables, please enter the following records: s table c table table s1wen18fc1pascalshis1c195s2bao25fc2basicl sc ous1c290s3li20mc3cmas1c380s4he23mc4c + + mens1c485s2c4753. Construction work space (C: * temp * student.pbw) build target (C: * temp * student . Pbt) built application (C: * temp * student.pbl) 4. To create three data in the application window object d_s, d_sc, d_c, respectively, show three tables s, sc, c data. 5. In the application to create the main window w_main, the main window should be included : ?Three data window controls (dw_1, dw_2, dw_3): display table, respectively s, Table sc, table c data. ?seven command button control. ?a static text control: put "input data" words. ?1 A single-line editor control (sle_1): used to input data for search and modify. 6. In the application of the object to write the script, so that the application has the following features: ① applications running at the beginning, there w_main window, three of which control the contents of the data window is blank. ② Click "B ROWSE "button to display the contents of the table s, and can browse. ③ Click the table s, display table and table c sc content, and can browse. ④ Click the table c (right side of a table), you can buy three tables blank. ⑤ Click the "INSERT_SC" button to insert a table in sc record Please custom content; then click "OK" button to put the record into the database. ⑥ Click "DELETE_SC" button to delete a table in sc current record; then click "OK" button to put the record from the database. ⑦ In the single-line editor to enter a whole number (for example, 5), click on "UPDATE_SC" button, the table can be sc increase the value of the current record of achievement in this integer value (5); then click "OK" button, you can modify this record to write the database. ⑧ In the single-line editor to enter a student number (for example, s1), click on the "QUERY _SNO "Button in the s table and sc table shows the situation of the students and their school curriculum situation. ⑨ Click" EXIT "button to return (exit the application). 7. Running application student. 3) Reference answers (script) 1. student.pbl in the application of the ope n the event of writing the script: SQLCA.DBMS = "ODBC" ** database vendor name SQLCA.AutoCommit = False ** defined procedures manual submission services SQLCA.DBParm = "ConnectString = 'D SN = newdb '"** DBMS additional information required for the 3 ** Department from its copy, paste over ** connect; ** connection data source newdb! Open (w_main) ** open the main window w_main2. In the main window w_main
- vb in the iif
- Ask association, the best example of a code
- vb.net check the screen changes the control value method
- Database. .
- expert c programming language
- c language program to solve
- In order to better our lives
- perl simple loop ask for advice
- Why is my diary can not see into the code
- Sql software testing will need to do it? Jiji Ji i!
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.