Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
0%
200 - 500 GB
25%
500 - 800 GB
0%
800 - 1200 GB
0%
1200 - 1500 GB
0%
1500 - 2000 GB
75%
> 2000 GB
0%
Total votes: 4

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 17th October 2016, 18:26
avpatil avpatil is offline
Guru
 
Join Date: Feb 2002
Posts: 720
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
Reading text directly from SQL
Baan: Other/Unknown
C/S: None/Unknown

Is there a SQL function that can read text from ttxt010 table? If we directly output the text field it will put garbage character,

Arvind
Reply With Quote
Sponsored Links
  #2  
Old 17th October 2016, 19:24
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,064
NPRao will become famous soon enough
Baan: Baan 4-5,5.2(Reger),LN-6.1,Infor LN-10.x - DB: Oracle,MS-SQL - OS: HPUX, Linux, Windows
Arvind, you can use search option on the forum for some pointers -

Binary "Text" field in Crystal 7

Quote:
I just created View for the text table using following SQL and use the new View in all Crystal reports.

SELECT t_ctxt, t_clan, t_seqe, t_text, CONVERT(char(250), t_text)
AS EXPR1
FROM dbo.ttttxt010200

EXPR1 has the text inside. Don't forget to present Views in Crystal along with Tables.
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
  #3  
Old 17th October 2016, 19:56
avpatil avpatil is offline
Guru
 
Join Date: Feb 2002
Posts: 720
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
Thank you.

Arvind
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Programming Question mr_suleyman Tools Development 37 11th November 2016 08:14
Reading Text from text number rathodne Tools Development 4 16th February 2011 18:58
Strange error while importing tables: Can not create index 9999 eppesuiG Tools Administration & Installation 8 17th March 2008 04:35


All times are GMT +2. The time now is 03:36.


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