例如:用TQuery * Query 如下:select left(发货日期,7) as 年月 into temp from t. rn"发货日期" 是时间型,执行上述sql 后年月是字符型,字段大小系统自动设为20,怎样<em>改变</em>,比如改为10.rn因为20在DBGrid里显示很宽,不美观.另外,Query 是<em>代码</em>生成的,不能用设计器的column 属性把年月的displaywidth 设为10,从而<em>改变</em>年月的字段大小,有其它办法吗?
Phone numbers rnBusinesses like to have memorable telephone numbers . One way to makea telephone number memorable 15 to have it spell a memorable word or phrase . For example , you can call the University ofw 叔terioo by dialing the memorable TUT - GLOP . Sometimes only part ofthe number 15 used to spell a word . When you get back to your hotel tonight you can order a pizza from Gino , 5 by dialing 3 10 一CINO . Another way to make a telephone number memorable 15 to group the digits ina memorable way . You could order your pizza from Pizza Htlt by calling their " three tens , , number3 一10 一10 一10 . The standard form of a telephone number 15 seven decimal digits with a hyphen between the third and fourth digits ( e . g . 888 一1200 ) . The keypad of a phone supplies the mapping of letters to numbers , as follows : A , B , and C map to ZD , E , and F map to 3G , H , and 1 map to 4J , K , and L map to SM , N , and 0 map to 6 P , R , and 5 map to 7 T , U , and V map to 8 W , X , and Y map to 9 There 15 no mapping for Q or 2 . Hyphens are not dialed , and can be added and removed as necessary . The standard form of TUT - GLOP 15 888 一4567 , the standard form of 3 10 一CINO 15 3 10 一4466 , and the standard form of3 一10 一10 一10 15 310 一1010 . Two telephone numbers are equivalent if they have the same standard form . ( They dial the same number . ) Your company 15 compiling a directory of telephone numbers from local businesses . As part ofthe quality control process you want to check that no two ( or more ) businesses in the directory have the same telephone number . rnInput : rnThe input Will consist of one case . The first line ofthe input specifies the number of telephone numbers in the directory ( u p to 100 , 000 ) as a positive integer alone on the line . The remaining lines list the telephone numbers in the directory , with each number alone on a line . Each telephone number consists of a string composed of decimal digits , uppercase letters ( excluding Q andZ ) and hyphens . Exactly seven of the characters in the string will be digits or letters . rnoutput : rnGenerate a line of output for each telephone number that appears more than once in any form . The line should give the telephone number in standard form , followed by a space , followed by the number oftimesthetelephonenumberappearsinthe directory . Arrange the output lines by telephone number in ascending lexicographical order . If there are no duplicates in the input print the line : No duplicates . rnSample Input rnl2 rn4873279 rnITS 一EASY rn888 一4567 rn3 一10 一10 一10 rn888 一CLOP rnTUT 一CLOP rn967 一11 一11 rn3 10 一CINO rnF 101010 rn888 一1200 rn一4 一8 一7 一3 一2 一7 一9 - 487 一3279 rnrnSample output rn310 一1010 2rn487 一3279 4 rn888 一4567 3 rn