UDT.OPTIONS question

2004-02-26 Thread Peter Gonzalez
UDT.OPTIONS 51 ON

(then list options)

51  U_ALT_DATEFORMAT ON

when we try the above command, then LIST ORDER ENTRY.DATE.  We get the same 
american date format instead of european. Could somebody tell me what's 
missing? thanks



Module Name Version   Licensed

UniData RDBMS 4.1 Yes

running on SCO.



Thank you,

Peter Gonzalez
Senior Programmer
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: Unicode for System Builder

2004-02-20 Thread Peter Gonzalez
i'm looking for the same thing, but for straight Unidata code.

At 08:31 AM 2/20/04 -0800, you wrote:
Does anyone have knowledge or experience of using UniData double byte and
SB+ to implement an application in Chinese?
Does SB+ support Unicode?
Thanks
 <<...OLE_Obj...>>

Tom Jobe
Database Administration Group
Yamanouchi Consumer, Inc.
4747 Willow Rd
Pleasanton, CA 94588
Phone: (925) 924-2156
Fax:(925) 924-3660
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Thank you,

Peter Gonzalez
Senior Programmer
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Re: Memo: RE: multi-currency

2004-02-13 Thread Peter Gonzalez
our accounting will be keep in USD. there is a control file that has an 
item id of USD*13191, EUR*13191, SGD*13191 (currency*internal date). rates 
will be supplied by the bank of london.

USD*13193
attribute<1> = the conversion rate for that currency and date
attribute<2> = currency sign ($)
if customer purchases 3,000.00 EUR of parts, that will convert to some USD 
amount and written to our files in USD. when the customer pays 3,000.00 EUR 
for the parts, we will convert to USD based on the day that the order was 
placed.





At 04:30 PM 2/13/04 +, you wrote:





> Pretty major thing.  Not quite as simple as it looks on the surface.  The
> major concept that throws a wrench into the works is the varying
conversion
> rates.   Pretty simple to flip-flop transactions at the current exchange
> rate.   It gets real sticky at the G/L level where for any given
transaction
> you would have gains or losses due to currency fluctuations.   Your $1000
> booked invoice only nets you the equivalent of $950 when paid.   The
other
> little pain is showing old transactions.   What rate do you use?   It
gets
> to be quite interesting.
sorry about the previous post - I must have hit the send button on a draft.
Here is what I meant to say:
You have to have a currency control account in the general ledger, usually
one for each currency. Then you have currency revaluation process that runs
periodically and calcualates the difference between the value on the
transaction and the value at the current exchange rate. You adjust the
transaction by that amount and also post it to the currency control
account.

HSBC Bank plc
Registered Office: 8 Canada Square, London E14 5HQ
Registered in England - Number 14259
Authorised and Regulated by the Financial Services Authority
Member of the HSBC Bank marketing group. We sell life assurance, pensions
and collective investment schemes and advise only on our own range of these
products.



_

This transmission has been issued by a member of the HSBC Group
"HSBC" for the information of the addressee only and should not be
reproduced and / or distributed to any other person. Each page attached
hereto must be read in conjunction with any disclaimer which forms part
of it. Unless otherwise stated, this transmission is neither an offer nor the
solicitation of an offer to sell or purchase any investment. Its contents are
based on information obtained from sources believed to be reliable but
HSBC makes no representation and accepts no responsibility or liability as
to its completeness or accuracy.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Thank you,

Peter Gonzalez
Senior Programmer
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


multi-currency

2004-02-12 Thread Peter Gonzalez
Hello,
I we have been given the task of redesigning our existing software to 
handle multiple currencies.  This means that at any time on the screen you 
could switch from USD to EUR, or USD to SGD (Singapore dollar) and back again.

i was thinking of using FUNCTION. then depending on the customer's currency 
code redisplay the amount. obviously i need to read some control file that 
contains the conversion factor for that particular day. btw: i have decided 
that is better to write amounts in USD, since our accounting will be done 
is USA.

does anybody have any suggestions, opinions??? any feed back will be 
appreciated.

At 01:18 PM 2/12/04 -0600, you wrote:
Could anyone let me know where can I found information about the way the
Hash Algorithm Works with each one of the File Types in UniVerse?
Thanks in advance

ABDP

José Luis Gutiérrez de la Peza
Director General
Asesores en Bases de Datos Profesionales, S.A. de C.V.
Tel. (52) 55-59-12-44 y/o (52) 55-75-21-29
Móvil (044) 55 52-48-33-87
www.abdp.com.mx


--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users


Thank you,

Peter Gonzalez
Senior Programmer
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users