Best Of

Hi,

You would need to have a look in the code down below ans see how the assigned data is used. 4 lines of code taken out of context almost never makes sense.

It could be used just to remember values of Document No. / Type to be used somewhere else. SETRANGE will only set the filter, without putting a value in the actual fields, so if you had used SETRANGE only and later want to have the "Document Type" assigned somewhere later you in the code would have to use IF EVALUATE(GETFILTER("DocumentType")) rather that straightforward assignment.

Slawek

This is done to set filters and values to the object SalesLine.
There is no FIND after the SETRANGE so the filer is not executed.

This object is passed in the next statements:

HasAmount := HasAmount OR ("Qty. Shipped Not Invoiced" <> 0);
SalesShptLine.InsertInvLineFromShptLine(SalesLine);

The SETRANGE is used to determine the next lineno.
(IF SalesLine.FIND('+') THEN)

And to set the values:
SalesLine."Document Type" := TempSalesLine."Document Type";
SalesLine."Document No." := TempSalesLine."Document No.";

InsertInvLineFromShptLine(VAR SalesLine : Record "Sales Line")
SETRANGE("Document No.","Document No.");

TempSalesLine := SalesLine;
IF SalesLine.FIND('+') THEN
 NextLineNo := SalesLine."Line No." + 10000
ELSE
  NextLineNo := 10000;

IF SalesInvHeader."No." <> TempSalesLine."Document No." THEN
  SalesInvHeader.GET(TempSalesLine."Document Type",TempSalesLine."Document No.");

IF SalesLine."Shipment No." <> "Document No." THEN BEGIN
  SalesLine.INIT;
  SalesLine."Line No." := NextLineNo;
  SalesLine."Document Type" := TempSalesLine."Document Type";
  SalesLine."Document No." := TempSalesLine."Document No.";
  SalesLine.Description := STRSUBSTNO(Text000,"Document No.");
  SalesLine.INSERT;
  NextLineNo := NextLineNo + 10000;
END;

NAS runs as Background session which don't count as concurrent User connections.

Hi

English language uses first 127 codes of ascii, as far as I am aware these stay invariant regargless of the code page or collation used. If you have only English + Chinese languages in your database it should be safe to use different code page for conversion.

You can fix the data using SQL queries after conversion. This is not officialy supported way, but possible. The trouble with this approach is to build a query, or rather a series of SQL queries converting the data. Many tables/many fields and many characters to replace - and the REPLACE function in SQL can address just one character pair at a time.

If you wait for SQL 2017 to be released, and upgrade your SQL Server to 2017, you will have TRANSLATE function in there, working much like CONVERTSTR in NAV, but I guess that's not very helpful for you

You could also write some SQL queries to create a copy of your tables in SQL, and make copies while the databas is in 2009 version, before conversion. These tables would not get converted into unicode, NAV ignores anything non-NAV in the database. Then after conversion you could copy affected columns across, manually specyfying covnersion collation. Still not ideal an there will be a lots of SQL code to write, but I quess less tedious that writting tons of REPLACE functions

Slawek

jhanvincent14 wrote: »

i have another question, How can I get the active row of a list in navision ?

The active row on a list, while it is displayed, is always in Rec. If you need the active row from within the page, just use Rec. If you need it from an external object, create a global function that returns Rec or it's primary key and call that function. To do that you need to declare the page as a variable and open it from this variable; or if it is a subpage (Part) you can find and call it through CurrPage.

For options under different circumstances, see Slawek's answer above.

Hi,

There are a few ways.

You can delcare the page in some PageVar, run im and when RUNMODALL call returns use PageVar.GETRECORD(recvar), or you can also use PageVar.SETSELECTIONFILTER(recvar) and (then recvar.FIND() )

If you run the page without declaring a page variable, using the PAGE.RUNMODAL(pagenumber, recvar), then after the page is closed the recvar points to an active record.

In all cases you need to check that user actually selected some record.

Unfortunately you need to use code to open the page to be able to get back an active record. You cannot get an active record off the page opened using a link (RunObject property)

Slawek

Filtering the column RelationTableNo for numbers 91 or 2000000120 gives you a list of fields which have a relation defined to either table 91 User Setup, or to table 2000000120 User.

These are fields which are supposed to have only values present either in table 91 or in table 2000000120 - so the most likely places where your service account may have been used.

Slawek