Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
29%
500 - 800 GB
3%
800 - 1200 GB
8%
1200 - 1500 GB
8%
1500 - 2000 GB
12%
> 2000 GB
22%
Total votes: 76

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 3rd September 2019, 10:13
RavCOder's Avatar
RavCOder RavCOder is offline
Member
 
Join Date: Jul 2019
Posts: 87
RavCOder is on a distinguished road
Baan: 10.3 - DB: SQL Server - OS: Windows
Exclamation Error script
Baan: Other/Unknown
C/S: None/Unknown

Hi ,
I have these errors in my script:
Code:
ptdsls05010 ( 84): Error: '}' not expected
ptdsls05010 ( 87): Fatal Error : FUNCTION within function 'create.records' not expected
this is my code:

Code:
---------FUNCTION SECTION------------
functions:
function create.records()
{
select tdsls400.*
from tdsls400
selectdo
select tdsls401.*
from tdsls401
where tdsls401.orno = tdsls401.orno
selectdo
endselect
}
Reply With Quote
  #2  
Old 3rd September 2019, 10:34
JaapJD's Avatar
JaapJD JaapJD is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 840
JaapJD will become famous soon enoughJaapJD will become famous soon enough
Baan: BaanIV, BaanERP, ERP LN 6.1 - DB: Oracle, SQL Server - OS: Unix, Windows
You are missing an "endselect".
Reply With Quote
Sponsored Links
  #3  
Old 3rd September 2019, 10:46
RavCOder's Avatar
RavCOder RavCOder is offline
Member
 
Join Date: Jul 2019
Posts: 87
RavCOder is on a distinguished road
Baan: 10.3 - DB: SQL Server - OS: Windows
I have another errors:
Code:
ptdsls05010 (82): Warning: missing selectdo; break generated.
ptdsls05010 (83): Error SELECTDO already present
ptdsls05010 (93): Error SQL: SQLState 42I00: Unexpected token ':' (error 302)
ptdsls05010 (97): Error SQL: SQLState 42I60: FROM clause not found where expected. Found ':' instead (error 302)
ptdsls05010 (103): Error: '}' not expected
ptdsls05010 (105): Fatal Error: FUNCTION within function 'sum.quantity' not expected.
my code:
Code:
function sum.quantity()
{
select tdsls400.item, tccom100.bpid 
from tdsls400, tccom100
where tdsls400.orno = tdsls400.orno
group by select tdsls400.item, tccom100.bpid
selectdo
 select sum (a.qoor) : sum.qoor
   from tdsls400 a, tccom100 b
where a.item =: tdsls400.item
and b.bpid = : tccom100.bpid

endselect
}
thanks and regards,
-RavCoder-
Reply With Quote
  #4  
Old 3rd September 2019, 14:25
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,365
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Do you have spaces after the colons - i removed them below. PLus for the select sum I would include the selectdo and endselect.
Code:
function sum.quantity()
{
select tdsls400.item, tccom100.bpid 
from tdsls400, tccom100
where tdsls400.orno = tdsls400.orno
group by select tdsls400.item, tccom100.bpid
selectdo
 select sum (a.qoor):sum.qoor
   from tdsls400 a, tccom100 b
   where a.item = :tdsls400.item
    and b.bpid = :tccom100.bpid 
    selectdo
    endselect
endselect
}
__________________
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
  #5  
Old 3rd September 2019, 14:28
RavCOder's Avatar
RavCOder RavCOder is offline
Member
 
Join Date: Jul 2019
Posts: 87
RavCOder is on a distinguished road
Baan: 10.3 - DB: SQL Server - OS: Windows
Hi, thanks you I have resolve !!!
Regards,
-RavCoder-
Reply With Quote
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


All times are GMT +2. The time now is 18:58.


©2001-2018 - Baanboard.com - Baanforums.com