home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a085 / 1.ddi / EXP15_3.PRG < prev    next >
Encoding:
Text File  |  1994-01-10  |  1.0 KB  |  34 lines
  1. *⌐░⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐┤ 
  2. *⌐ª      Program: EXP15_3.PRG                                          ⌐ª
  3. *⌐ª     Function: ╩╣╙├ SELECT ╡─ INSERT INTO ├ⁿ┴ε╡─╖╢└²                ⌐ª
  4. *⌐╕⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐ñ⌐╝
  5. SET TALK OFF
  6. SET ESCAPE OFF
  7. SET SAFETY OFF
  8. CLEAR ALL
  9. CLEAR
  10.  
  11. * ╜¿┴ó╩²╛▌┐Γ
  12. CREATE TABLE test2 ;
  13.  (NAME C(12), BIRTHDAY D, ADDRESS C(20), ;
  14.   COMPANY C(10), SALARY N(8,2), SEX L)
  15.  
  16. * ╘÷╝╙╨┬╝╟┬╝
  17. INSERT INTO test2 (NAME,BIRTHDAY,ADDRESS,COMPANY,SALARY,SEX) ;
  18.    VALUES("╒╘╬─╗»",{08/08/56},"╬≈│╟╟°╬≈╡Ñ▒▒┤≤╜╓12║┼","┤≤╗¬├│╥╫",;
  19.           1000.00,.T.)
  20. INSERT INTO test2 (NAME,BIRTHDAY,ADDRESS,COMPANY,SALARY,SEX) ;
  21.    VALUES("┴⌡╧■╞╜",{02/18/52},"╢½│╟╟°╩«╠⌡20║┼","╦─┤∩╣½╦╛",;
  22.           950.00,.T.)
  23. INSERT INTO test2 (NAME,BIRTHDAY,ADDRESS,COMPANY,SALARY,SEX) ;
  24.    VALUES("┬φ┐í╨π",{07/28/58},"╬≈│╟╟°╬≈╩▓┐Γ22║┼","┤≤╢½╣½╦╛",;
  25.           1100.00,.F.)
  26.  
  27. * ╧╘╩╛╩²╛▌┐Γ╝╟┬╝
  28. SELECT * FROM test2
  29.  
  30. CLOSE DATABASES
  31. SET TALK ON
  32. SET SAFETY ON
  33. SET ESCAPE ON
  34.