Uniface Client Server App Development

uniface software, uniface technology, uniface project, uniface forum

Archive for July, 2010

Uniface 6/Oracle :USOURCE

Hello !!!

Uniface 6
Oracel 7.3.3

select ulan, uvar, ucomment from usource where ulabel like ‘U_FULLMONTHS
%’

returns:

ULA UVAR UCOMMENT
— —-
——————————————————————————–

USA RF40 }
5JANUARY~FEBRUARY~MARCH~APRIL~MAY~JUNE~JULY~AUGUST~SEPTEMBER~OCTOBER~NOVEMBER~

         DECEMBER

USA RF20 }
5JANUARY~FEBRUARY~MARCH~APRIL~MAY~JUNE~JULY~AUGUST~SEPTEMBER~OCTOBER~NOVEMBER~

         DECEMBER

USA GUI  } 4}
5JANUARY~FEBRUARY~MARCH~APRIL~MAY~JUNE~JULY~AUGUST~SEPTEMBER~OCTOBER~NOVEMB

         ER~DECEMBER

Some questions on this …
1.    How is the prefix determined, ie. "} 5" or "} 4} 5" for each row?
2.    Is the behavior same in version 7?
3.    Is "~" a delimter? if so what will happen if the month name has
"~"?
4.    Is this delimter same in version 7?

Thanks

—————————————–
– Saad Ahmad
– Senior Software Engineer
– McHugh Software International
– e-mail saad.ah…@mchugh.com
– http://www.bisnet.net/~javada/saad
—————————————–

cialis .
posted by admin in Uncategorized and have Comment (1)

RE: Problems with 3GL

Hi.

Like I told you about you Support Call 150674, this is a functionality =
of Visual C++.  You need set configuration in setting–> Link libraries =
option.

Moreover you know that is necessary:
Add the name and path of dll in ini or ins files.
        Set U3GL variable in autoexec.bat.
        Use asynchronous interrupt with the correct proc.

Anyway I will contact you by phone.

Regards
Ilitia
Technical Support Mexico
———-
De:  Luis Fernando Mayorga Ramirez[SMTP:lmayo...@softtek.com]
Enviado el:  Mi=E9rcoles 1 de Octubre de 1997 5:29 AM
Para:  irodrig…@idisa.spin.com.mx
Asunto:  Problems with 3GL

I compiled a program and, I had the following response:

——————–Configuration: async – Win32
Debug——————–
Linking…
async.obj : error LNK2001: unresolved external symbol _UPUTAMES
async.obj : error LNK2001: unresolved external symbol _ULOADDS
async.obj : error LNK2001: unresolved external symbol _UGETHINST
async.obj : error LNK2001: unresolved external symbol _UMAKEPROCINST
async___/async.dll : fatal error LNK1120: 4 unresolved externals
Error executing link.exe.
async.dll – 5 error(s), 0 warning(s)

My library and include directories are fine

Please help me

posted by admin in Uncategorized and have Comments (2)

Uniface and OCX controls

Hello there,

We are wanting to use Crystal Reports in our UNIFACE applications, using the
OCX container widget.

We are running Uniface 7.1.04, Windows NT server for our repository, data
etc, and Windows 95 clients for development.

We have installed Crystal Reports on the NT server and are now wishing to
use the OCX control.  We have set up a logical widget in our ini file :

[widgets]
Crystal=uOcxContainer(ocx=g:\crw\crystl32.ocx)   ; G:\ is on the NT server

It appears that the Windows Registry on the NT has been updated with the
Crystal Controls information during the Crystal Reports Installation, but
the registries on the clients have not.  Is this the reason that the Crystal
Controls do not appear in the control list in the Define OCX Properties form ?

Has anyone had to manually register an OCX on their client ?  If so, how did
you do it using Windows Utilities ?  I am assuming that we will also need to
do this when we ship our application.

Does the OCX control have to be on the client ?

Any information would be greatly appreciated.  Thanks.

+——————————+
| Chris Clapp                  |
| Inforsoft Pty Ltd            |
| Hall Village Court           |
| Hall   ACT    2618           |
| Australia                    |
+——————————+

posted by admin in Uncategorized and have Comments (2)

Matching Indices in Uniface and Sybase

Hi,

We are using Uniface 6.1.dl with Sybase 11.
We have a situation where in one of the Sybase tables Indices are
defined as
I1 – CLUSTERED, fields 1,2,3,4,5,6
I2 – NONCLUSTERED, field 3,1,2
I3 – NONCLUSTERED, field 7
I4 – NONCLUSTERED, field 8

Group of fields on which index I1 is defined is not unique. In Uniface, we
have to define a primary key and knowing that a primary key is always
the first key in the entity (correct me if I am wrong) we defined a primary
key on the field A. Obviously, field A is unique. But our Sybase DBA
doesn’t want to define a clustered unique index (as created by Uniface
in the script on Create Table utility) just for field A, especially when field
A is not even used in the retrieval/search etc. In other words field A is
insiginificant, it’s just a sequential number.
In Sybase we can define only one clustered index and we don’t
necessarily need to define an index for the primary key in Uniface, right?
But now in Uniface my keys refer to wrong indices in Sybase.
1 – -Primary key on field A
2  –Index, fields 1,2,3,4,5,6
3 – -Index, field 3,1,2
4 – -Index, field 7
5 – -Index, field 8

Only solution that I think of right now is to redefine the indices in Sybase
by  incrementing them by one so they will match Uniface index keys
sequence.  Finally, we will have I2, I3, I4, I5 and  NO I1.

Let me know if you could think of a better solution to resolve this
problem? Thanks.

-Vikram

ps: Will it be ok to define a nonclustered index on a primary key (field A),
if we really have to define an index I1 on field A (primary key) in
Sybase?

posted by admin in Uncategorized and have Comment (1)

Beware of ORDER BY clause

—— =_NextPart_000_01BCCEBA.D482EBC0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I want to warn other developers about a Uniface bug that crashes the =
application with an infinite loop. This rarely gets out of the shop =
because it either hangs the machine or gives you a GPF. Until Compuware =
fixes it (I am using 6.1dp) here is a warning that will help you =
diagnose bizarre crashes.

I often get into the SQL syntax habit of typing=20
select…where…order by FIELDA

I then type this into Uniface as=20
read u_where…order by FIELDA=20
(forgetting the "double quotes" around "FIELDA").=20

In this situation Uniface gets caught in an infinite loop because during =
the retrieve, it fires the <read> trigger to get the first record but

in order to use the value of FIELDA to substitute as a string to use for =
the order by clause it must fire the <read> trigger to read the value of =
FIELDA but

in order to use the value of FIELDA to substitute as a string to use for =
the order by clause it must fire the <read> trigger to read the value of =
FIELDA but

in order to use the value of FIELDA to substitute as a string to use for =
the order by clause it must fire the <read> trigger to read the value of =
FIELDA but

in order to use the value of FIELDA to substitute as a string to use for =
the order by clause it must fire the <read> trigger to read the value of =
FIELDA but

in order to use the value of FIELDA to substitute as a string to use for =
the order by clause it must fire the <read> trigger to read the value of =
FIELDA but

in order to use the value of FIELDA to substitute as a string to use for =
the order by clause it must fire the <read> trigger to read the value of =
FIELDA but

in order to use the value of FIELDA to substitute as a string to use for =
the order by clause it must fire the <read> trigger to read the value of =
FIELDA but

in order to use the value of FIELDA to substitute as a string to use for =
the order by clause it must fire the <read> trigger to read the value of =
FIELDA but

in order to use the value of FIELDA to substitute as a string to use for =
the order by clause it must fire the <read> trigger to read the value of =
FIELDA but…

I hope this helps,

Howard Berg
Kitchener, Ontario, Canada.
—— =_NextPart_000_01BCCEBA.D482EBC0
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

<encoded_portion_removed>
AAEAAAAAAAAAAwANNP03AAA1/g==

—— =_NextPart_000_01BCCEBA.D482EBC0–

posted by admin in Uncategorized and have Comments (2)

"SIGNOFF UNIFACE-L"

 "SIGNOFF UNIFACE-L"

posted by admin in Uncategorized and have No Comments

RE: store -6

—— =_NextPart_000_01BCCF2E.127F2920
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

If you get a -6, something is wrong with your database. Look in the =
message FRAME. There should be error(s) in there. They tend to be =
technically accurate.

POP

- Hide quoted text — Show quoted text -

—–Original Message—–
From:   Colin Blair [SMTP:co...@sei.co.uk]
Sent:   Thursday, October 02, 1997 12:07 PM
To:     m…@rubico.com
Subject:        store -6

Uniface 6.1.dp – Informix 7.12

We occasionally get a -6 error when we attempt a store, but if you clear
and re-input data, the store is successful. The manual gives us the
"Exceptional i/o error" stuff but not much else and we are having
difficulty tracking down the source of these errors.

Does anyone have any ideas or suggestions? We would be most pleased.

colin blair – soi
(co…@sei.co.uk)

—— =_NextPart_000_01BCCF2E.127F2920
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

<encoded_portion_removed>
AD0AAQAAAAUAAABSRTogAAAAAAMADTT9NwAAlGg=

—— =_NextPart_000_01BCCF2E.127F2920–

posted by admin in Uncategorized and have Comments (7)

Order by clause without quotes…

– [ From: Adrian Swift * EMC.Ver #2.5.02 ] —

I believe the read with order by has behaved this way since v5

Adrian

=================================================
Adrian Swift
Western Pacific Data Systems
San Diego, CA, 92037

Voice Mail : (619) 454-0028 x815
Email : adri…@wpds.com

Project : IMDS (c/o Andersen Consulting)
Tel : (904) 244-6200 / 6256
=================================================

posted by admin in Uncategorized and have Comments (7)

(no subject)

This is a multi-part message in MIME format.
————–DC7F3C0AFE3D2AD31F8D51DA
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

signoff uniface-l

————–DC7F3C0AFE3D2AD31F8D51DA
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Hubert Bucher
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Hubert Bucher
n:              Bucher;Hubert
org:            Sidata GmbH
email;internet: h…@sidata.com
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard

————–DC7F3C0AFE3D2AD31F8D51DA–

posted by admin in Uncategorized and have No Comments

Re: Migrating V6 forms to V7…

Adrian,
I have exported / imported V6 to V7 several times now, and have had
problems when I followed the online help procedures.  When I have followed
the book procedure, section "Migrating from V6 without UVCS", I have had no
problems.

Justin Curry, Canmax Inc.

At 04:13 PM 9/15/97 -0700, you wrote:

- Hide quoted text — Show quoted text -

>– [ From: Adrian Swift * EMC.Ver #2.5.02 ] —

>Folks,

>Has anyone experienced difficulty migrating forms from V6 to V7 ??

>I have successfully ‘sucked’ in messages, menus, procs, regs, etc.

>When I export a V6 form and import into V7 all appears to go well until I
>try and open the form.  I have tried ‘trx’ and ‘exp’.

>The message frame shows a successful import into uform, uxgroup, uxregs and
>uxfield.  The database also seems to have sensible looking data.

>The form editor reports "no occurrences".  If I try and create a form with
>the same name as the form I tried to import it reports that a form called
>"dummy2.dummy" already exists.  (dummy2 or dummy do not exist on the form.)

>I can successfully create, store and recall a new form in V7.

>The U tables were created in Oracle using the supplied scripts.

>Any suggestions ??

>TIA
>Adrian
>–

>=================================================
>Adrian Swift
>Western Pacific Data Systems
>San Diego, CA, 92037

>Voice Mail : (619) 454-0028 x815
>Email : adri…@wpds.com

>Project Office : (904) 244-6200 / 6256
>=================================================

posted by admin in Uncategorized and have No Comments