Setting Alias to Combined Field

Posts   
 
    
PAZIMLI
User
Posts: 82
Joined: 01-May-2008
# Posted on: 02-May-2008 16:07:53   

// resulset ResultsetFields fields = new ResultsetFields(1);

// define your new composed field via Expression // Ref: GeneratedCode - Field expressions and aggregates fields.DefineField(new EntityField2("storyname", (ArticleFields.StorySection + " - " + ArticleFields.StoryHead)), 0);

I use this code.Bur my database is Oracle. + is used for mathematical operations at Oracle.So that My program gives me a message like that "Invalid number"

in Oracle || is used to concatanate strings. But I could not use this || in the fields.DefineField. .......

How can I solve my problem? thanks Pinar cry

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 02-May-2008 16:24:10   

Isn't this the same question as the one you have posted before here: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=13229

PAZIMLI
User
Posts: 82
Joined: 01-May-2008
# Posted on: 02-May-2008 16:30:26   

yes.same question. I could not know advantages or disadvantages of forum groups.So that I want to write same question here.?disappointed

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 02-May-2008 16:38:51   

Almost all of them are scanned by the support team. All you have to do is to post your question in the most relevant forum.

The folloiwng are the attributes of different forums: 1- The helpdesk forum is private, so only support team members can see your question, other users can't. 2- The General chat forum rarely scanned by the support team. 3- The Architecture forum has low priority.

So by posting your question here, you might attract other users attention rather than the one posted in the helpdesk.

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 08-May-2008 15:36:28   

By the way, which LLBLGen Pro runtime library version are you using?

PAZIMLI
User
Posts: 82
Joined: 01-May-2008
# Posted on: 09-May-2008 10:36:05   

llblgen 2.5

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 09-May-2008 10:45:33   

Please check the following thread to know how to get the Runtime library version number: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7722

PAZIMLI
User
Posts: 82
Joined: 01-May-2008
# Posted on: 09-May-2008 10:49:52   

2.5.7.831

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 09-May-2008 15:35:31   

Your runtime library version is an old one. It's recommended that you use the latest available release.

PAZIMLI
User
Posts: 82
Joined: 01-May-2008
# Posted on: 09-May-2008 17:14:18   

Please read this message again "// resulset ResultsetFields fields = new ResultsetFields(1);

// define your new composed field via Expression // Ref: GeneratedCode - Field expressions and aggregates fields.DefineField(new EntityField2("storyname", (ArticleFields.StorySection + " - " + ArticleFields.StoryHead)), 0);

I use this code.Bur my database is Oracle. + is used for mathematical operations at Oracle.So that My program gives me a message like that "Invalid number"

in Oracle || is used to concatanate strings. But I could not use this || in the fields.DefineField. .......

"

if it is be done in Sqlserver with my llblgen versiyon,why I can not write same statement for Oracle. My problem is how to define ||

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 10-May-2008 02:25:20   

Please see this thread (specially the latest posts): http://llblgen.com/TinyForum/Messages.aspx?ThreadID=9144

David Elizondo | LLBLGen Support Team