[ANN] 4D Summit in 3 Weeks/4D v11 SQL Briefing/Tech Note/Tech Tips

[4D News]

-------------------------------------------------------------------
4D News September 26, 2007
-------------------------------------------------------------------

Summary:

[1] Three Weeks Until 4D Summit 2007

[2] 4D v11 SQL is here, and so are the briefings!

[2] New Tech Note Now Available

[3] Weekly Tech Tips Posted


-------------------------------------------------------------------
[1] Three Weeks Until 4D Summit 2007
-------------------------------------------------------------------

With the release of 4D Web 2.0 Pack and 4D v11 SQL, 2007 has been a big
year for change in the 4D world. This year's Summit has been designed
to help you learn the most about these new technologies in just a few
intense days.

The Summit starts three weeks from today in Memphis, Tennessee, and
we're almost at capacity for some sessions. It's not too late to
register for your seat, but it won't be for much longer!

Sign up today:  <http://www.4d.com/summit>


-------------------------------------------------------------------
[2] 4D v11 SQL is here, and so are the briefings!
-------------------------------------------------------------------

4D v11 SQL is finally here, and we want to show it off to everyone.
We're holding a series of WebEx conferences for all members of the 4D
community to get acquainted with 4D v11 SQL. With a new database
engine, native SQL support, several major new features, and many new
productivity enhancements, there's a lot to learn about this exciting
new release.

In this 45-minute seminar, we'll hit the highlights of what's new and
different. For a full immersion in the details of 4D v 11 SQL, the
Summit is just a few weeks away.

Sessions start on Monday, October 1st and we expect that time slots
will fill up fast. Please go to <http://www.4d.com/4Dv11SQL-preview>
today to make sure there's a seat open for you!

Please note: These sessions are available to US & Canadian customers
only.


-------------------------------------------------------------------
[3] New Tech Note Now Available
-------------------------------------------------------------------

New List Box Features in 4D v11 SQL

4D v11 SQL has added several new features for working with List Box
form objects. A List Box is quite useful in many ways but was limited
to only using arrays in previous versions of 4D. Now you can not only
use arrays, you can also use fields and expressions to populate the
List Box. This Technical Note presents three examples that are very
similar in how they appear to the user, but each uses a different "Data
Source" for populating, displaying and using the data in a List Box.

Tech notes are exclusive to members of the 4D Partners program. For
more information, please visit <http://www.4d.com/support/partner.html>

--------------------------------------------------------------------
[4] Weekly Tech Tips Posted
--------------------------------------------------------------------

The weekly tech tips for the week of 09/24/07 have been posted to the
4D, Inc. Web site at: <http://www.4D.com/support/techtips.html>

47129 How can I rebuild all indexes in 4D v11 SQL?
                <http://www.4d.com/knowledgebase?CaseID=47129>

47231 Where do I install Macros in 4D v11 SQL?
                <http://www.4d.com/knowledgebase?CaseID=47231>

47243 User Mode is now a part of Design Mode
                <http://www.4d.com/knowledgebase?CaseID=47243>

47543 New way to reference Hierarchical Lists!
                <http://www.4d.com/knowledgebase?CaseID=47543>

47545 Sorting Fields in a Table
                <http://www.4d.com/knowledgebase?CaseID=47545>


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

4D v11 SQL - A 21st Century database for 21st Century developers
http://www.4D.com/products/new.html

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

[Stephane Potvin-2]

Good day,

I have created a database for a local group a few years ago. Since  
then, the users have added items to lists, added and modified users  
and passwords, etc.

Now I want to provide them with an update I have done to the DB.  
However if I only send them a new structure file, they will loose all  
the users information, and all the list items. How can I update the  
DB without loosing all that?

Can 4D create a patch to update only specific code? Or is there a 3rd  
party solution?

Thank you,

Stephane Potvin

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

4D v11 SQL - A 21st Century database for 21st Century developers
http://www.4D.com/products/new.html

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

[Mehboob Alam]

I believe this does what you need.
http://www.inforce.sk/product_updater.html

--- Stephane Potvin <stephane.potvin@...> wrote:

> Good day,
>
> I have created a database for a local group a few years
> ago. Since  
> then, the users have added items to lists, added and
> modified users  
> and passwords, etc.
>
> Now I want to provide them with an update I have done to
> the DB.  
> However if I only send them a new structure file, they
> will loose all  
> the users information, and all the list items. How can I
> update the  
> DB without loosing all that?
>
> Can 4D create a patch to update only specific code? Or is
> there a 3rd  
> party solution?
>
> Thank you,
>
> Stephane Potvin
>
>

**********************************************************************

> 4D Basics hosted by 4D, Inc.                      
> http://www.4D.com/
>
> 4D v11 SQL - A 21st Century database for 21st Century
> developers
> http://www.4D.com/products/new.html
>
> To Unsubscribe:                      
> mailto:4DBasics-off@...
>

**********************************************************************
>
>
>


sincerely,
mehboob alam

"My interest is in the future because I am going to spend the rest of my life there." - Charles Kettering

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

4D v11 SQL - A 21st Century database for 21st Century developers
http://www.4D.com/products/new.html

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

[Tom Dillon-2]

Stephane Potvin sez:

>Now I want to provide them with an update I have done to the DB.  
>However if I only send them a new structure file, they will loose all  
>the users information, and all the list items. How can I update the  
>DB without loosing all that?

Is the structure compiled? If not, you can sign on as Administrator and
save the Users and Groups. And you could save the lists using List To
Array, then exporting each array into a text file, then reverse the
process when you open the new structure.

This brings up your update then. You might want to add in List and User/
Group/Password data storage to your new structure before you send it to
them. It's pretty easy. I use Foundation which uses a table for Lists
and I generally a table each for Users and Groups. If you're interested
I can dig up the code for that. In fact I may put it on my
4thDimension.com website as a demo database as soon as the site's back up.

--
   ------------------------------------------------------------------
   Tom Dillon                                        900 S. Coors Dr.
   DataCraft                                       Lakewood, CO 80228
   TomDillon@...                           720/962-4880
   ------------------------------------------------------------------
      The focus of the pilot should not be on the dead fly stuck
      to the windshield. --- Sunastar
   ------------------------------------------------------------------



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

4D v11 SQL - A 21st Century database for 21st Century developers
http://www.4D.com/products/new.html

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

[Allen Matlick]

Stephane,

I've dealt with the question of saving list info by creating a data
table to hold list information.  Then, prior to an update a set of
methods is run to copy the list info into the data table.  After the
update another set of methods is run to copy the data back from the
table into the lists.

The drawbacks are that you have to be able to trigger the methods and
you must explicitly list all of the lists you want to save in code.

I use  'Prepare for update'  and 'Finish update' menu items to
trigger the code.  My update instructions to the users tell them to
use these buttons as part of the update process.

Here's my code if you find it useful.

Allen


Table: Lists `this table holds the list name, list elements and
element position within the list

Id: alpha 32  `this is the name of the list
Item: alpha 80 `this is a list element
Sequence: Longint `this is the item position in the list

*************

Method used to save an individual list:

Method: Lists_Save_One
   `saves the contents of a list into an array of records
   `ham 7/99

C_STRING(32;$sList_Name)

$sList_Name:=$1

   `remove old list contents from storage table
MESSAGES OFF
QUERY([Lists];[Lists]Id=$sList_Name)
DELETE SELECTION([Lists])

LIST TO ARRAY($sList_Name;$asList_Contents)  `save the current list
contents as an array

For ($i;1;Size of array($asList_Contents))
        CREATE RECORD([Lists])
        [Lists]Id:=$sList_Name
        [Lists]Item:=$asList_Contents{$i}
        [Lists]Sequence:=$i  `keep track of the entry order
        SAVE RECORD([Lists])
End for

MESSAGES ON

*******************

Method: List_Load_One
   `saves the contents of an array of records into a list
   `ham 7/99

C_STRING(32;$sList_Name)

$sList_Name:=$1

   `get list contents from storage table
MESSAGES OFF
QUERY([Lists];[Lists]Id=$sList_Name)

   `only replace list contents if there is something
   `to replace them with
If (Records in selection([Lists])>0)

        ORDER BY([Lists];[Lists]Sequence;>)

        SELECTION TO ARRAY([Lists]Item;$asList_Contents)
        ARRAY TO LIST($asList_Contents;$sList_Name)

Else
          `this list has never been set - clear whatever might be in
the current list.
          `this will clear the dev gus lists for departments which
have never initialized this list.
        ARRAY TEXT($atList_Contents;0)
        ARRAY TO LIST($atList_Contents;$sList_Name)
End if

MESSAGES ON

***********
Method fragment to save my lists  (part of 'Prepare for update')

LIST_Save_One ("Actions")
LIST_Save_One ("Agencies")
LIST_Save_One ("Agency_Division")
LIST_Save_One ("Agency_HList")

Method fragment to load the lists  (part of 'Finish update')

LIST_Load_One ("Agencies")
LIST_Load_One ("Agency_Division")
LIST_Load_One ("Agency_HList")
LIST_Load_One ("Agency_List")

>Good day,
>
>I have created a database for a local group a few years ago. Since
>then, the users have added items to lists, added and modified users
>and passwords, etc.
>
>Now I want to provide them with an update I have done to the DB.
>However if I only send them a new structure file, they will loose
>all the users information, and all the list items. How can I update
>the DB without loosing all that?
>
>Can 4D create a patch to update only specific code? Or is there a
>3rd party solution?
>
>Thank you,
>
>Stephane Potvin
>
>**********************************************************************
>4D Basics hosted by 4D, Inc.                       http://www.4D.com/
>
>4D v11 SQL - A 21st Century database for 21st Century developers
>http://www.4D.com/products/new.html
>
>To Unsubscribe:                        mailto:4DBasics-off@...
>**********************************************************************

--

------------------------------
Allen Matlick
allen@...
805-893-5219
------------------------------

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

4D v11 SQL - A 21st Century database for 21st Century developers
http://www.4D.com/products/new.html

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

[Stephane Potvin-2]

Thank you everyone for your help.

I must admit I was hoping there would be a simple solution for the  
end user, ie launch the updater and let it do its thing without  
intervention on the user part.

Maybe one day. In the meantime I am grateful for the codes provided.

Thank you,

Stephane Potvin

On 07-10-01, at 14:10, Allen Matlick wrote:

> Stephane,
>
> I've dealt with the question of saving list info by creating a data  
> table to hold list information.  Then, prior to an update a set of  
> methods is run to copy the list info into the data table.  After  
> the update another set of methods is run to copy the data back from  
> the table into the lists.
>
> The drawbacks are that you have to be able to trigger the methods  
> and you must explicitly list all of the lists you want to save in  
> code.
>
> I use  'Prepare for update'  and 'Finish update' menu items to  
> trigger the code.  My update instructions to the users tell them to  
> use these buttons as part of the update process.
>
> Here's my code if you find it useful.
>
> Allen
>
>
> Table: Lists `this table holds the list name, list elements and  
> element position within the list
>
> Id: alpha 32  `this is the name of the list
> Item: alpha 80 `this is a list element
> Sequence: Longint `this is the item position in the list
>
> *************
>
> Method used to save an individual list:
>
> Method: Lists_Save_One
>   `saves the contents of a list into an array of records
>   `ham 7/99
>
> C_STRING(32;$sList_Name)
>
> $sList_Name:=$1
>
>   `remove old list contents from storage table
> MESSAGES OFF
> QUERY([Lists];[Lists]Id=$sList_Name)
> DELETE SELECTION([Lists])
>
> LIST TO ARRAY($sList_Name;$asList_Contents)  `save the current list  
> contents as an array
>
> For ($i;1;Size of array($asList_Contents))
> CREATE RECORD([Lists])
> [Lists]Id:=$sList_Name
> [Lists]Item:=$asList_Contents{$i}
> [Lists]Sequence:=$i  `keep track of the entry order
> SAVE RECORD([Lists])
> End for
>
> MESSAGES ON
>
> *******************
>
> Method: List_Load_One
>   `saves the contents of an array of records into a list
>   `ham 7/99
>
> C_STRING(32;$sList_Name)
>
> $sList_Name:=$1
>
>   `get list contents from storage table
> MESSAGES OFF
> QUERY([Lists];[Lists]Id=$sList_Name)
>
>   `only replace list contents if there is something
>   `to replace them with
> If (Records in selection([Lists])>0)
>
> ORDER BY([Lists];[Lists]Sequence;>)
>
> SELECTION TO ARRAY([Lists]Item;$asList_Contents)
> ARRAY TO LIST($asList_Contents;$sList_Name)
>
> Else
>  `this list has never been set - clear whatever might be in the  
> current list.
>  `this will clear the dev gus lists for departments which have  
> never initialized this list.
> ARRAY TEXT($atList_Contents;0)
> ARRAY TO LIST($atList_Contents;$sList_Name)
> End if
>
> MESSAGES ON
>
> ***********
> Method fragment to save my lists  (part of 'Prepare for update')
>
> LIST_Save_One ("Actions")
> LIST_Save_One ("Agencies")
> LIST_Save_One ("Agency_Division")
> LIST_Save_One ("Agency_HList")
>
> Method fragment to load the lists  (part of 'Finish update')
>
> LIST_Load_One ("Agencies")
> LIST_Load_One ("Agency_Division")
> LIST_Load_One ("Agency_HList")
> LIST_Load_One ("Agency_List")
>
>
>
>> Good day,
>>
>> I have created a database for a local group a few years ago. Since  
>> then, the users have added items to lists, added and modified  
>> users and passwords, etc.
>>
>> Now I want to provide them with an update I have done to the DB.  
>> However if I only send them a new structure file, they will loose  
>> all the users information, and all the list items. How can I  
>> update the DB without loosing all that?
>>
>> Can 4D create a patch to update only specific code? Or is there a  
>> 3rd party solution?
>>
>> Thank you,
>>
>> Stephane Potvin
>>
>> *********************************************************************
>> *
>> 4D Basics hosted by 4D, Inc.                       http://www.4D.com/
>>
>> 4D v11 SQL - A 21st Century database for 21st Century developers
>> http://www.4D.com/products/new.html
>>
>> To Unsubscribe:                        mailto:4DBasics-off@info.
>> 4D.com
>> *********************************************************************
>> *
>
> --
>
> ------------------------------
> Allen Matlick
> allen@...
> 805-893-5219
> ------------------------------
>
> **********************************************************************
> 4D Basics hosted by 4D, Inc.                       http://www.4D.com/
>
> 4D v11 SQL - A 21st Century database for 21st Century developers
> http://www.4D.com/products/new.html
>
> To Unsubscribe:                        mailto:4DBasics-off@...
> **********************************************************************

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

4D v11 SQL - A 21st Century database for 21st Century developers
http://www.4D.com/products/new.html

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

[Oliver, Bonita J. (SSC-NASA)[Computer Sciences Corp]]

Here is my line of code.....

SELECTION TO
ARRAY([Contacts]FullName;Name;[Contacts]Phone;Phone;[Contacts]Email;Emai
l;[OrgInfo]Code;Code;[Contacts]CivilServant;CS;[Contacts]Date_Last_Surve
yed;LastSurveyDate)

I am getting an error stating "Changing the number of dimensions in an
array".  What does this mean?

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

Did you know?  The 4D Partner Program now gives you
access to Hotfix releases as soon as they are available!
To learn more, go to http://www.4D.com/support/partner.html

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

[Bill Leddy]

Check that you have not declared one of the arrays as 2 dimensional  
somewhere else in the code.
A 2 dimensional array is defined something like:
         Array Text(ArrayName;0;0)
instead of simply:
         Array Text(ArrayName;0)

Kind Regards,

*********************************************************************
Bill Leddy


On Feb 7, 2008, at 8:06 AM, Oliver, Bonita J. (SSC-NASA)[Computer  
Sciences Corp] wrote:

> Here is my line of code.....
>
> SELECTION TO
> ARRAY([Contacts]FullName;Name;[Contacts]Phone;Phone;[Contacts]
> Email;Emai
> l;[OrgInfo]Code;Code;[Contacts]CivilServant;CS;[Contacts]
> Date_Last_Surve
> yed;LastSurveyDate)
>
> I am getting an error stating "Changing the number of dimensions in an
> array".  What does this mean?

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

Did you know?  The 4D Partner Program now gives you
access to Hotfix releases as soon as they are available!
To learn more, go to http://www.4D.com/support/partner.html

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

[Tom Dillon-2]

Bonita Oliver sez:

>Here is my line of code.....
>
>SELECTION TO
>ARRAY([Contacts]FullName;Name;[Contacts]Phone;Phone;[Contacts]Email;Emai
>l;[OrgInfo]Code;Code;[Contacts]CivilServant;CS;[Contacts]Date_Last_Surve
>yed;LastSurveyDate)
>
>I am getting an error stating "Changing the number of dimensions in an
>array".  What does this mean?

Like Bill Leddy said, it's probably a two dimensional array. A fast way
to determine which variable is the culprit would be to put a TRACE or
break point at the Selection to Array and look at the variables to see
what they're defined as.

If this code is in a [Contacts] form, and you're using the same name for
some fields and variables, 4D may be interpreting them as fields. For
instance, Phone, may be interpreted as [Contacts]Phone, which would
cause a problem. I seem to remember that this only occurs if you use the
Default Table command, but I'm not sure.

You might want to weigh the possibility of looking into the idea of
considering a better variable naming convention that would allow you to
tell the difference in fields, single variables and arrays. Check out
some of the discussions on GMane: <http://search.gmane.org/?
query=variable+naming+convention&group=gmane.comp.lang.inug-4d.tech>

--
   ------------------------------------------------------------------
   Tom Dillon                                        900 S. Coors Dr.
   DataCraft                                       Lakewood, CO 80228
   TomDillon@...                           720/962-4880
   ------------------------------------------------------------------
          The butterfly will only land on you after you stop
          grabbing for it. --- Sunastar
   ------------------------------------------------------------------



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

Did you know?  The 4D Partner Program now gives you
access to Hotfix releases as soon as they are available!
To learn more, go to http://www.4D.com/support/partner.html

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