stand alone deployment

[john convey]

I have a customer, a charity, who are running an education 4d 2004  
standalone.
They are running our  4d GP referral system diary / simple stats
and input  using an XP desktop computer.

My question is if i upgrade from developer 2004 (mac) to 4d developer  
professional v11 SQL.
  Could i then convert the 2004 structure and  'build' a similar  
standalone?

the aim is to add a 'web client' interface so the managers in the  
back office
can read only some of the data. ie access through on web connection  
serving pages

if so, would it be  possibly for the future have them add and edit ?





john c
sci-do communications
 

**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

An all-new List box. More features, more power.
Headers, footers, cell formatting and other goodies.
See it here first! <http://www.4d.com/livedemos>

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************

[Stephane Potvin-2]

Good day all,

I am a musician and want to catalogue my music scores.

I have a database that uses a table for composers and one table for  
the music scores.
The tables are linked.

The current way of doing things is:

I create an entry for a composer.
Once in the composer record, I add a record in the music score table  
(which acts as a sub table)

I like this approach because that way I can see every score for one  
composer in one window.

The one downside is that everytime I want to create a score I have to  
go through the composer table.

I have tried creating a popup menu in the score form using the values  
from the composer table. It only kind of works. Although the value is  
indeed entered the field composer, the name of the composer does not  
show, of if I go back to the composer table, I end up with a form  
that appears empty.

In any case, my question is: can one use values from a linked table  
to populate a popup menu and have it work properly?

Here is the code I currently use.


Case of
        : (Before)
                ALL RECORDS([Composer])
                SELECTION TO ARRAY([Composer]name;pu_compo;[Composer]Number;pu_number)
                If ([Score]Composer=0)
                        pu_compo:=0
                Else
                        pu_compo:=Find in array(pu_number;[Score]Composer)
                End if
        : (During)
                [Score]Composer:=pu_number{pu_compo}
End case

Help would be greatly appreciated.

Stephane

**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

An all-new List box. More features, more power.
Headers, footers, cell formatting and other goodies.
See it here first! <http://www.4d.com/livedemos>

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************

[Robert Molina]

Hi John,
In response to your questions:

My question is if i upgrade from developer 2004 (mac) to 4d developer  
professional v11 SQL.
  Could i then convert the 2004 structure and  'build' a similar  
standalone?

Yes, you can build a merged application in 4D v11 SQL.

As far as deploying a merged web application, you will not be able to do so.
What you can do is build a compiled database and run it with 4D Desktop
application.  In order to web serve with 4D Desktop you will need to
purchase a 4D Web Application Server v11 SQL license.  For more information
regarding purchasing the license please contact our sales department at
1-800-785-3303.

Kind Regards,
 
******************************
Robert Molina
Technical Services Team Member
4D, Inc.
******************************

**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

An all-new List box. More features, more power.
Headers, footers, cell formatting and other goodies.
See it here first! <http://www.4d.com/livedemos>

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************