hello friends, I would like to prepare a website, and i wnat to utilise the Navision database as backend can u provide possible ways & tips. thankful to group members & organizers.
Is it navision native database or SQL you can use C/Front, code will be like this, It may not be correct, you may need to fix it <%@ Language=VBScript %> <% dim nvdb Set cb = CreateObject(“cfront.cfrontctrl.1”) Cb.HideError = TRUE Cb.StopOnAllExceptions = true cb.SetNavisionPath “C:\Program files\Navision Attain\Client” cb.OpenDatabase “C:\Program Files\Navision Attain\Client\database.fdb”, 2000, True cb.OpenCompany “CRONUS UK Ltd.” Dim Table Dim Record Dim CompanyName Dim TableID Dim FieldNo Dim ID Dim Ok TableID=18 ok=cb.opentable(Table,TableID) ’ cb.OpenTable tbno, 18 ’ ct=cb.tablename(“18”) ’ call cb.OpenTable(CR,18) ’ CR = cb.AllocRec(CT) ’ Dim RowNo 'As Long 'RowNo = 5 ’ OK = CFRONT1.FindRec(CT, CR, “-”) ’ Do ’ Data = CFRONT1.GetFieldData(CT, CR, 1) ’ Data2 = CFRONT1.GetFieldData(CT, CR, 2) ’ List1.AddItem (Data & " " & Data2) ’ 'Sheet1.Range(“A” & RowNo).Value = Data ’ 'Sheet1.Range(“B” & RowNo).Value = Data2 ’ RowNo = RowNo + 1 ’ Loop Until CFRONT1.NextRec(CT, CR, 1) = 0 %> <%= cb.companyname %>