Uniface Client Server App Development

uniface software, uniface technology, uniface project, uniface forum

Archive for June, 2011

Printing OLE in Excel

Hi all,

For some (obscure) reason I’m not able the print a excel sheet using OLE
automation.
I’ve managed it in Word without any problem, but in Excel I seeing to
overlook something.
If any one could give me an example, I would be most gratefull.

By the way, if somebody could give me some information about the methods I’m
able to use in
OLE automation, I would be very gratefull too. I find out that you can see
several methods
with the objectviewer in Word or Excel (VBA), but can I use all these
methodes???

Thanks,

Pieter Uri
Pensioenfonds Nederlandse Omroep
u…@pno.org

.
posted by admin in Uncategorized and have No Comments

Uniface & Word (Ole Automation) (Yet !)

Hi, Unifacers !

I have a BIG problem with the wedding between Uniface and Word 97/95 (and
Ole like a bestman).

I try to explain it :

1) Word side:
The User creates word documents templates to merge documents with data that
Uniface provide. The user can choose the field that I provide using the
MERGE FIELD instead the horrible BOOKMARKS
(all the examples that I found are WordBasic and fill bookmarks). I provide
the list of field using a head file without data.

2) Uniface side:
With Ole automation the only that I need to do is:
    Create the word object.
    Open the template.
    For every record:
        Goto the merge field        ********* HOW ????? ************
        Insert the data into the merge field
    Print the document
    Destroy the object.

But the problem is that I don’t know the methods in the Ole server to find a
merge field and I speed a lot of hours to try to find
this or an example to do this in the Microxof Web Site. I’m MAD :-(((((((

Can anyone help?

Regards,

Carles Zaragoza Roig
c.zarag…@midland-software.co.uk

posted by admin in Uncategorized and have No Comments

List of modal forms

Hi,

   How can I find the list of modal forms which are open ?

My problem is the following :
All forms are modals.
The form F1 execute "activate F2.EXEC(…)".
The form F2 execute "activate F1.EXEC(…)". I want to execute this
instruction only if the form F1 isn’t open.
In my test, even if F1 is open, the instruction activate F1.exec() from
F2 execute the EXEC trigger. The F2 is still painted but nothing reply

Thanks.

Laurent BUFFEL

posted by admin in Uncategorized and have Comments (3)

Re: [U-L] Uniface & Word (Ole Automation) (Yet !)

Sorry not quite getting you here, in order to mail merge you need two
documents a main document and a datasource document.

All you need to do, is insert the uniface data in the relevant datasource
file, save the datasource file.
Open the main file document/template and mailmerge.

I’ve probably misunderstood what you want here, (but I hope it helps)

Regards

Sieu Ngu

- — -

—–Original Message—–
From: Carles Zaragoza [mailto:c.zarag...@midland-software.co.uk]
Sent: Monday, April 19, 1999 12:16 PM
To: unifac…@uug.org
Subject: [U-L] Uniface & Word (Ole Automation) (Yet !)

Hi, Unifacers !

I have a BIG problem with the wedding between Uniface and Word 97/95 (and
Ole like a bestman).

I try to explain it :

1) Word side:
The User creates word documents templates to merge documents with data that
Uniface provide. The user can choose the field that I provide using the
MERGE FIELD instead the horrible BOOKMARKS
(all the examples that I found are WordBasic and fill bookmarks). I provide
the list of field using a head file without data.

2) Uniface side:
With Ole automation the only that I need to do is:
    Create the word object.
    Open the template.
    For every record:
        Goto the merge field        ********* HOW ????? ************
        Insert the data into the merge field
    Print the document
    Destroy the object.

But the problem is that I don’t know the methods in the Ole server to find a
merge field and I speed a lot of hours to try to find
this or an example to do this in the Microxof Web Site. I’m MAD :-(((((((

Can anyone help?

Regards,

Carles Zaragoza Roig
c.zarag…@midland-software.co.uk

—————————————————————–
This email was scanned for 41836 known viruses by kerberos.hamilton.co.uk.
It was deemed clean for transmission.
—————————————————————–

—————————————————————–
This email was scanned for 41836 known viruses by kerberos.hamilton.co.uk. It was deemed clean for transmission.
—————————————————————–

posted by admin in Uncategorized and have No Comments

Re: [U-L] VCLINK in combination with VSS

Nico,

You have two basic options for SCM in Uniface.

The first, UVCS, is not a really a valid option. It has too many problems
today and Compuware have announced that they will no longer develop or
enhance the product.

The second choice is using PVCS. PVCS is a world-class SCM. In order to use
it with UNIFACE,  you will need to add VC-Link to your development SEK’s.
This option must be purchased, more or less as if it were an additional DBMS
driver.

With VC-Link, PVCS integrates into the IDE as choices on the
Utilities/Version Control menu. You need to be aware of a couple of things
when using PVCS with UNIFACE.

Firstly, UNIFACE PVCS projects do not integrate terribly well with
non-UNIFACE PVCS projects. It can be done, but it is a LOT of work.

Secondly, UNIFACE stores objects in PVCS in the beloved TRX format. This
format is not very robust for SCM purposes, e.g., using PVCS to view
differences between two versions of an object will be mostly meaningless.
This also means that it is mostly impossible to use the PVCS macro
facilities to include version information in your UNIFACE objects. I know,
this really sucks (pardon my French!), but that’s the way it is.

Until Compuware decide to create a text-based source code for UNIFACE
objects, these two limitations will not be easily overcome.

<RANT>

Compuware — are you listening? A text-based source code for UNIFACE objects
would be a God-send for a MYRIAD of reasons.  Let me give you two (2) really
good ones.

1. SCM with tools like PVCS will be greatly simplified and enhanced.
(Almost?) every SCM tool on the market is deisnged to work with text-based
souce code, so… Well, you get my drift.

2. Text-based source code for UNIFACE objects will also provides a more
reasonable method for generating/building objects from external tools (e.g.,
CASE Tools, home-grown tools, etc). These objects can then be imported into
the UNIFACE repository by "compiling" the source code. This would eliminate
the need for direct update access to the repository in most cases.

</RANT>

Okay, there. I’ve said it. Sorry for the soapbox. That one has been in the
corner waiting for a forum for quite some time.

Rick Culpepper
Project Manager
PayMaxx, Inc.

- — -

—–Original Message—–
From: nblokh…@my-dejanews.com [mailto:nblokh...@my-dejanews.com]
Sent: Monday, April 19, 1999 2:05 AM
To: unifac…@uug.org
Subject: [U-L] VCLINK in combination with VSS

Does anyone know whether it is possible to use VSS (Visual SourceSafe)
instead of PVCS as sourcecode control system for Uniface ?
Thanks for your cooperation,
Nico Blokhuis

———–== Posted via Deja News, The Discussion Network ==———-
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    

posted by admin in Uncategorized and have No Comments

UniFace 7.2.04/SQL Server7 data time overflow

I am trying to run UniFace on a SQL Server 7 and am having trouble with
milliseconds.  I cannot update the database using UniFace, I get a DataTime
overflow error.  I am using version 3.70.06 version of the SQL Server Driver.
How do I work around this?

-Tracey

———–== Posted via Deja News, The Discussion Network ==———-
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    

posted by admin in Uncategorized and have No Comments

Searching for Epson Comp. Printer Driver.

I am looking for a Uniface (Six) printer device table for the Epson
compatible matrix
printers.

I thought it was included in the Uniface repository, but it is not as
far as I know.

T.i.a.

Edu Körnmann.

posted by admin in Uncategorized and have No Comments

Re: [U-L] Glyphs an SQL Server

Hi Andre,

A quick way to get around the problem is to define you field as follows:

PROPERTIES:

Initial value -> @filename (make sure you have either an assignment in
the *.asn file for the path, or put file in startup dir.
Datatype -> Image(any source) (or any of the other image data types)
Widget Type -> UNIFIELD
Interface -> SC*

The message when trying to define a glyph might be because the BMP is
not windows standard. There is three standards used for saving a BMP
file, yet only one is a windows BMP compatible format. The above method
should make your BMP appear on your form while you are still in
development. If it does not or gives you the ! in the field, there might
be something wrong with the BMP file.

Regards
Jacques von Benecke

- — -

> —–Original Message—–
> From:      Andre Fettermann [SMTP:andr...@my-dejanews.com]
> Sent:      12 April 1999 20:27
> To:        unifac…@uug.org
> Subject:   [U-L] Glyphs an SQL Server

> Hello again!!!

> Thanks Marco and Paul for your last tips. Now i have a new question
> for all of
> you. I am tryingo to define a Glyph or to use Image(any source) in my
> form and
> it is not working.

> If i try to use as file (inital value->@filename) nothing is shown. I
> get the
> message 6899 – Can not load or handle the image when i try to define
> the
> glyph.

> Does anyone know the reason for that? Thank you

> Uniface 7.2.02 SQL Server 6.5 Windows NT 4.0 BMP files
> —
> Andre Fettermann de Andrade
> Multiterminais Alfandegados do Brasil Ltda

> ———–== Posted via Deja News, The Discussion Network
> ==———-
> http://www.dejanews.com/       Search, Read, Discuss, or Start Your
> Own    

posted by admin in Uncategorized and have No Comments

Relocation expenses paid

One of the many roles available:

Analyst Programmer

Urgent requirement for UNIFACE Professionals with strong communication
skills and solid UNIFACE V.6 or 7 experience. This position offers variety,
training and an excellent career path, in a team oriented, business focused
environment.

£25 to £35,000 + Benefits
London area

Guy Morrison
BOA Ltd

posted by admin in Uncategorized and have Comment (1)

Tasco Planner

We are looking at emulating a tasco year planner in our application.

Has anyone done this and how.

I have been looking for OCX controls that do such a thing but they are all
calendar controls rather than planners

Thanks,

Anthony Widdowson
System Architect
Midland Software Limited
Tel:    +44(0)115 9456000
Fax:    +44(0)115 9405286
http:\\www.midland-software.com
mailto:a.widdow…@midland-software.co.uk
mailto:anthony.widdow…@widdowson0.demon.co.uk

MIDLAND SOFTWARE – YOUR LIFETIME PARTNER IN HUMAN RESOURCES

The information contained in this email is intended only for the named
recipient(s) and may be confidential and/or privileged.  Unauthorised use
or reproduction (including storage or re-distribution in any media) is
prohibited.

posted by admin in Uncategorized and have No Comments