Fandy Xie's Blog

create table test01(id int,name varchar(20),quarter int,profile int) insert into test01 values(1,'a',1,1000) insert into test01 values(1,'a',2,2000) insert into test01 values(1,'a',3,4000) insert in... Read More

question?I have a big problem ... I have a diference between inventtrans and inventsum for some items ...I want to say that the qty in invetsum is not equal to the sum of qty in inventrans.What can i ... Read More

CREATE [ TEMPORARY | TEMP ] TABLE table ( column type [ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ] [column_constraint_clause | PRIMARY KEY } [ ... ] ] [, ... ] [, PRIMARY KEY ( col... Read More

Absolutely impossible绝对不可能的！All I have to do is learn English我所要做的就是学英语。Are you free tomorrow 你明天有空吗？Are you married 你结婚了吗？Are you used to the food here 你习惯吃这儿的饭菜吗？Be careful小心、注意。Be my guest请便、别客气。Be... Read More

A light heart lives long静以修身。 All rivers run into sea海纳百川。 All roads lead to Rome条条大路通罗马。 A bully is always a coward色厉内荏。A cat has 9 lives猫有九条命。 A cat may look at a king人人平等。A bad thing never dies遗臭万年... Read More

I will call you我会打电话给你。 I am happy to meet you很高兴见到你。 I see what your mean我了解你的意思。 I can not do this我不能这么做。Would you care to see it你要不要看I feel like taking a walk我想散步。 I want something to eat我想吃点东西。 I ... Read More

Look up Enum type data complete infomation with Jobs.Such as : Index,Name,EnumValue,Label,ConfigurationKey....Remark by Jimmy August 03th 2010 Read More

Copy table data on Intercompany with X++ code.Remark by Jimmy August 03th 2010 Read More

Sometimes,We often need to lookup the dictionary date(such as table) list or modified the propertieson AOT .so,X++ code as below:Jimmy August 3th 2010Batch set up the field for table propertiesLook up... Read More

Remark by Jimmy August 2th 2010 Read More