informix如何用语句批量建form？

ryr1990

informix如何用语句批量建form？

3sane

回复 1# ryr1990

1. 
   
2. [ $# -lt 1 ] && { echo "Usage: crtforms database"; exit; }
   
3. dbname=$1
   
4. echo "Get table information..."
   
5. isql -s $dbname << ! |awk '{print substr($0,4)}'>/tmp/tabnames
   
6. select "isql -s $dbname -fg "||tabname[1,10]||' '||tabname||" -t" c from systables where tabid>99 and tabname matches "[a-z]*"
   
7. !
   
8. echo
   
9. echo "Creatting forms..."
   
10. . /tmp/tabnames
    
11. echo
    
12. rm -f /tmp/tabnames
    
13. echo "OK!"
    

复制代码