blog of bird studio
March 18, 2011

About top Num in order by clause
Filed under: Asp.net —  admin @ 7:49 am 
About top num in order by clause, if  the field after order by is not identity, What we get in the sql instance will exceed than the Num behind top key words. Why ?
Because in the T-SQL in Access, Processing the TOP NUM , 1st search in the views and just display the Num lines, But after you putting order by in the clause, if the PRIVILEAGE LEVEL IS IDENTITY, All the identity levels will be displayed in the views. The lines count will exceed the default numbers.
Comments (0)
February 17, 2011

where does sales line flow into after posting
Filed under: Dynamics Navision 2009 —  admin @ 9:44 am 
Some expert will advise you not changing the field size of  the master table. But some time, we have no method to avoid this. I got this issue in my project too.
In fact when posting sales invoice, the data in the sales line will be flown into the tables below.
Sales invoice line,warehouse entry,Warehouse receipt line, Warehouse Shipment line,Sales shipment line,Reservation entry,item ledger entry,value entry,Item journal line,tracking specifition.
Comments (0)
January 13, 2011

Excelbuffer functionality.
Filed under: Dynamics Navision 2009 —  admin @ 5:56 am 
The original Contents below are from my friends Yeats http://blog.eve-duo.com/2008/12/24/54.html
which marked red color is my remarks.
Global Variable:
Name       
DataType       
Subtype         Length
XlApp       
Automation       
Unknown Automation Server.Application       
XlBook       
Automation       
Unknown Automation Server.Workbook       
XlSheet       
Automation       
Unknown Automation Server.Worksheet       
g_intColumn       
Integer       
       
EnterCell(RowNo : Integer;ColumnNo : Integer;CellValue : Text[250];Bold : Boolean)
Local Variable
Name       
DataType       
Subtype       
Length
I       
Integer               
 
 
X       
Integer               
 
 
C       
Char               
 
 
ColID       
Text               
 
30
Parm
Name       
DataType       
Subtype       
Length
RowNo       
Integer               
 
 
ColumnNo       
Integer               
 
 
CellValue       
Text               
 
250
Bold       
Boolean       
 
       
 ColID := ”;
IF ColumnNo <> 0 THEN BEGIN
 x := ColumnNo – 1;
 c := 65 + x MOD 26;
 ColID[10] := c;
 i := 10;
 WHILE x > 25 DO BEGIN
   x := x DIV 26;
   i := i – 1;
   c := 64 + x MOD 26;
   ColID[i] := c; // if you want to run on RTC you should changed it to be such : ColID := format(c); 
 END;
 FOR x := i TO 10 DO  //Remove this line
   ColID[1+x-i] := ColID[x];  //Remove this line
END;
XlSheet.Range(ColID+FORMAT(RowNo)).Value:=CellValue;
XlSheet.Range(ColID+FORMAT(RowNo)).NumberFormat:=’@';
XlSheet.Range(ColID+FORMAT(RowNo)).Font.Bold:=Bold;
XlSheet.Range(ColID+FORMAT(RowNo)).Font.Size:=10;
 
EnterNCell(RowNo : Integer;ColumnNo : Integer;CellValue : Text[250];Bold : Boolean)
Local