Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
50%
Handover everything to System Integrator from drawing BP till implementation of ERP
13%
Hire more inhouse skilled & capable IT Resource to work directly with SI
38%
Rely on SI Architects/Consultants
0%
Total votes: 8

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 14th September 2020, 11:44
Thomasm Thomasm is offline
Member
 
Join Date: Aug 2002
Location: Sweden
Posts: 51
Thomasm is on a distinguished road
Baan: B40c4 - DB: SQL-Server - OS: Windows 2003 Server
Getting strange error when zooming
Baan: Baan IVc4
C/S: None/Unknown

I am geting a strange error when I want to zoom to the session tipcs3140m000 (General Project Cost). I get the error if I zoom from the menu and if I zoom from the code (zoom.to$())

The error is:
Error 506 (Table does not exist) on tfgld008000 in db_eq
Can not continue in tipcs3140m000 (<89>)[db.eq]

Obviously that table should not exist in company 0. But why is it trying to select on company 0?

The code in the script that generates the error (in session tipcs3140m000) is:
Code:
function fill.unit.code()
	|In this function the unit code 1 of the imported ledger account
	|is read and put in variable 'ftrs.cuni'.
{
	table	ttfgld008
	tfgld008.leac = import.leac
	ftrs.cuni = db.eq(ttfgld008) ? "" : tfgld008.uni1
}
I don't have access to change standard but I can export values from the zooming session.

Any suggestions would be appreciated

Thx,
Thomas
Reply With Quote
  #2  
Old 14th September 2020, 13:46
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,482
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Is it a custom session zooming to the tipcs3140m000? Is there other code in tipcs3140m000 that sets the company based off something else in the zoom?
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 14th September 2020, 15:54
Thomasm Thomasm is offline
Member
 
Join Date: Aug 2002
Location: Sweden
Posts: 51
Thomasm is on a distinguished road
Baan: B40c4 - DB: SQL-Server - OS: Windows 2003 Server
Thanks for your reply Mark,

Yes, it is a a custom session and you are right that there is code under the 'before.zoom:' section. But there is nothing there to set the company number. And also (verified with debugger) when calling 'zoom.to$()' from a user action this section is completely bypassed.

I have then noticed that there is also a sub-session (tipcs3410s000) and when I call that instead it is the same behaviour.

The code in the session we are zooming to is defined under the section 'form.1'. To try to avoid that part of the code I created a custom session just as a copy but then put the only available form as form number 2. Did not make any changes.

So I ended up creating my own session as a copy of the session I want to zoom to and made it with own script name. Now I could copy the standard script into that and compile. So when I do that and it crashes the debugger will show me the part of code that is wrong. This way I could figure out what variable was not correctly initialised.

Turns out in the end that if I add the below code to the 'before.zoom' section in the session I am zooming from then it works. It does not end up on the correct record but as I need to do an insert anyway this is good enough for now.

Code:
	| for tipcs3140s000
	tfgld102.tcom = get.compnr()
	select
		*
	from
		tfgld008
	where
		iprj = tfgld.intr.pcs
	as set with 1 rows
	selectdo
		tfgld102.leac = tfgld008.leac
	endselect
Thanks a lot for taking your time Mark!!

Thx,
Thomas
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange Result via AFS jeffersyuan AFS/DDC/OLE: Function servers 9 27th May 2014 15:05
Zooming in SQL queries form Elrodyn Tools Development 6 17th October 2008 17:16
Strange mesage when importing EDI DELINS via tcedi7205m000 MrMarco Manufacturing & Supply Chain 0 4th November 2003 09:35
Passing the project field when zooming to tipcs2522s000 rmarles Tools Development 5 26th September 2003 21:00
tfgld418 is allocating strange extends Caner.B Operating Systems & Databases 6 18th July 2002 15:13


All times are GMT +2. The time now is 13:11.


©2001-2020 - Baanboard.com - Baanforums.com