Search found 338 matches

by jacklcs
Fri Jun 09, 2017 8:26 am
Forum: General discussion and questions about Aware IM
Topic: New Line Feed
Replies: 1
Views: 4936

New Line Feed

User Guide: \n -> The newline (line feed) character ('\u000A')

Good day to everyone!
May I know how to use '\n'? Any example?

Thanks.

Jack Lim
by jacklcs
Mon Dec 31, 2012 2:21 pm
Forum: General discussion and questions about Aware IM
Topic: SQL Store Procedure
Replies: 0
Views: 3275

SQL Store Procedure

Happy New Year Everyone! I need help on this area. I have a SQL Store Procedure to retrieve from an Customer Aging with the paramter of @ReportDate. After enter the @ReportDate, the return show as query which show me customer aging. How do I present in on the AwareIM Report? From the user guide: "EX...
by jacklcs
Sun Dec 16, 2012 8:06 am
Forum: General discussion and questions about Aware IM
Topic: Row_Number() Over ()
Replies: 0
Views: 3322

Row_Number() Over ()

Good day everyone.. I am using the defult Derby DB. I managed to create the query for the object and add the "Row_Number () Over()" on the query. The query show very good ================== Select ROW_NUMBER() Over () As Row.. ..... FROM .... ================== Results Row ----- 1 2 3 ==============...
by jacklcs
Sat Nov 10, 2012 6:47 am
Forum: General discussion and questions about Aware IM
Topic: Header and Line Was Changed
Replies: 1
Views: 3134

Header and Line Was Changed

Good day everyone.. I have a Header and Line Design. After the Header Save.. a process was run to create the trx to another object. Everything work fine. Now everytime click Save on the Header Page, the process run. How to write the rule such that if nothing was change on the Line, the process will ...
by jacklcs
Sat Nov 10, 2012 5:08 am
Forum: General discussion and questions about Aware IM
Topic: Database External - Sybase Connection
Replies: 0
Views: 3275

Database External - Sybase Connection

Hi Everyone

Good day to you.

I urgently need help to connect Sybase Database Using AwareIM.

I have test many way but still unable to connect to the Sybase database

Million Thanks.
by jacklcs
Tue Nov 06, 2012 9:15 am
Forum: General discussion and questions about Aware IM
Topic: Pre-Set System Parameter
Replies: 1
Views: 3176

Pre-Set System Parameter

Good day everyone.. I am thinking to setup a System Setup, for example: - Department [Yes / No] When the user setup the Department as "Yes" , the form will auto show the Department drop down otherwise it will not show. The issue is how to control the form each of the attribute for hidden or show? Pl...
by jacklcs
Mon Nov 05, 2012 2:25 am
Forum: General discussion and questions about Aware IM
Topic: Button Icon
Replies: 0
Views: 3243

Button Icon

Good day everyone..

When the form being using the process to popup.. the form button with word but without the Icon... how to put the icon beside the word..

Please help... thanks.
by jacklcs
Fri Nov 02, 2012 7:36 am
Forum: General discussion and questions about Aware IM
Topic: 2 Line Message
Replies: 0
Views: 3223

2 Line Message

Good day to you...

I have a long message as now it show as 1 line...

Message 1 ... Message 2.... Message 3...

How to break show as..

Message 1
Message 2
Message 3

thanks.
by jacklcs
Wed Oct 31, 2012 2:22 am
Forum: General discussion and questions about Aware IM
Topic: AwareIM Installer
Replies: 0
Views: 3387

AwareIM Installer

Good day everyone..

Anyone have the following AwareIM Installer Setup:

- V5.0
- V5.1
- V5.3

My Hard Disk Crash and I need the Installer so that I can recover my Database...

I can open my FTP Server for you to transfer.

Please help....
by jacklcs
Mon Oct 29, 2012 8:26 am
Forum: General discussion and questions about Aware IM
Topic: Execute Events After Save
Replies: 0
Views: 3794

Execute Events After Save

Good day everyone.. I am trying the new function of this - Execute Events After Save. I created 2 BO: Header and Line. I have created 2 simple process to prompt Message after click save: - Header Message - Record Save : "DISPLAY MESSAGE 'Header Message - Record Save.' - Line Message - Record Save: D...
by jacklcs
Mon Oct 29, 2012 8:08 am
Forum: General discussion and questions about Aware IM
Topic: Convert Amount to Negative
Replies: 2
Views: 4930

Wow... it worked.. I forget about "IN BATCHES OF 1"...

many thanks my friend....
by jacklcs
Mon Oct 29, 2012 5:40 am
Forum: General discussion and questions about Aware IM
Topic: Convert Amount to Negative
Replies: 2
Views: 4930

Convert Amount to Negative

I have the following process: If ARInvoiceHeader.TotalItems>0 Then CREATE Journal FOR EACH ARInvoiceLine WITH Journal.HeaderID=ARInvoiceHeader.ID, Journal.MyCustomerID=ARInvoiceHeader.MyCustomerID, Journal.Date=ARInvoiceHeader.Date, Journal.DocumentNo=ARInvoiceHeader.DocumentNo, Journal.Type=ARInvoi...
by jacklcs
Sun Oct 28, 2012 12:07 pm
Forum: General discussion and questions about Aware IM
Topic: Date Transactions
Replies: 5
Views: 8531

Good day everyone... In the Transactions OB, I have done this rule: Transactions.S_Day=AS_STRING(Transactions.S_Date,'dd') Transactions.S_Month=AS_STRING(Transactions.S_Date,'MMMM') Transactions.S_MonthYear=AS_STRING(Transactions.S_Date,'MMMM yyyy') Transactions.S_MonthNo=AS_STRING(Transactions.S_Da...
by jacklcs
Sun Oct 28, 2012 12:01 pm
Forum: General discussion and questions about Aware IM
Topic: Date Transactions
Replies: 5
Views: 8531

Wow... it worked!!

CREATE Transactions FOR EACH DAY BETWEEN Account.OpeningDate AND Account.ClosingDate WITH Transactions.S_Date=LOOP_ITERATION

It created 01-10-2012 to 31-10-2012...daily date..

By the way what does Loop_Iteration mean?

Million thanks.
by jacklcs
Sun Oct 28, 2012 3:53 am
Forum: General discussion and questions about Aware IM
Topic: Date Transactions
Replies: 5
Views: 8531

thank you tford...I am think of that too. I wish to write on the process to run auto. I read the MySQL books, it wrote on the Store Procedure to populate the Date to the tbl_date Table after the user enter the Date From and Date To. Work Flow: 1. Create a form called "Fiscal Period" 2. User enter th...