Baanboard.com

Go Back   Baanboard.com > Blogs > sasank's blog

User login

Frontpage Sponsor

Main

Google search


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

Baanboard at LinkedIn


Reference Content

 
SQL query range
By sasank at 1 Aug 2016 - 11:59

Hi,

Can any body help me how to set the range for the fields while wring the select query in SQL queries?

Regards

Sasank N 

0
No votes yet

by vamsi_gujjula on August 1, 2016 - 4:26pm
vamsi_gujjula's picture
on SQL

select
tcibd001.item | Item
from
tcibd001 | Items - General
where
tcibd001.item >= tcibd001.item.f and
tcibd001.item <= tcibd001.item.t


using session

In the attachment.

by sasank on August 2, 2016 - 5:00am
Thanks a lot Vamsi.

Regards
Sasank N

by bhushanchanda on August 5, 2016 - 12:16pm
bhushanchanda's picture
Hi,

Please post your questions in correct forums and not as blogs.

Moved to correct forum -> Tools Development


All times are GMT +2. The time now is 22:38.


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