Sujit Shah | 24 Apr 01:41 2014
Picon

Anyone serving several customers (4D Clients (i.e.)) from one 4D Server?

Its only when you "peek" outside the 4D world you realize 4D is so unique.
At the moment my application is built so that each customer has its own
signed database standalone or WAN based. There are of course many
advantages to the approach including reduced risk in case of catastrophic
failures, force majeure events, individual customer backups and restores,
greater control over customisation, better security and other. Then there
are the disadvantages of increased support, dependencies on other installed
third party software, maintenance and version consistency.

Amongst the major obstacles I find, since a majority of our users are
standalone and using a part of the application that relies heavily on the
ability to backup/ rollback. How do you achieve this using a single data
file? How do you restore a part of the data but not the whole?

--

-- 

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
"There must be ingenuity as well as intention, strategy as well as
strength. "
**********************************************************************
See how easy it is to extend your 4D solutions to Web and mobile. New opportunities await you with 4D v14!

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

(Continue reading)

Dave Nasralla | 24 Apr 00:44 2014
Picon

4D Server as a backend

Hi Everyone,

I know how 4D can access other data sources, but I'm out of my knowledge
base when it come to other application getting data out of 4D.

Someone here at our company is exploring using Windward to get data from 4D
to create Office documents.
http://staging.windward.net

It seems to support a wide variety of protocols.
http://windward.net/solutions/for-your-data/

If I wanted to use 4D as a backend I get the impression I would need to buy
a SQL Server license and then clients could connect to it via SQL. Windward
mentions several flavors of SQL including:
 - Microsoft SQL
 - Oracle SQL
 - MySQL
 - PostgreSQL

Is it possible one of the tools for these would work with 4D?

Supposedly it works with JASON and REST, but I get the feeling I would need
to create my own API for that (which might work).

Any advice or direction would be appreciated.

--

-- 
David Nasralla
Clean Air Engineering
(Continue reading)

Dave Nasralla | 23 Apr 22:24 2014
Picon

Connecting to 4D via REST

Hi All,

Just for clarification. If I want to allow someone to access my 4D Data via
the REST protocol, do I need to run Wakanda as a intermediary? And what
kind of license would that require?

Thanks,

dave

--

-- 
David Nasralla
Clean Air Engineering
**********************************************************************
See how easy it is to extend your 4D solutions to Web and mobile. New opportunities await you with 4D v14!

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

Cannon Smith | 23 Apr 19:05 2014

PHP and json_encode

Hi Everyone,

I’m trying to use PHP from 4D v13.5 to prettify a JSON string, but can’t get it to work. Here is my code:

C_TEXT($tJSON;$tPrettyJSON)
C_BOOLEAN($fResult)

$tJSON:=Get text from pasteboard
$fResult:=PHP Execute("";"json_encode";$tPrettyJSON;$tJSON;"JSON_PRETTY_PRINT")
If ($fResult=True)
   SET TEXT TO PASTEBOARD($tPrettyJSON)
Else 
   ALERT("Error")
End if 

If I don’t pass the JSON_PRETTY_PRINT constant, it works (although doesn’t prettify), so I’m
guessing I shouldn’t pass the constant as text. Not sure what else to try though.

Does anyone have any ideas? Alternatively, does anyone have some 4D code to prettify JSON they would be
willing to share?

Thanks much!

--
Cannon Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236
<cannon@...>
<www.synergyfarmsolutions.com>
(Continue reading)

Piotr | 23 Apr 17:21 2014

Procedurally inserting text into a muli-style variable

Hi,

I want to procedurally insert text into a multi-style variable. I determine
the insertion point by the command get highlight. This command doesn't take
style tags into account. Then I want to manipulate (insert) text at the
insertion point by using substring. However, now the style tags ARE taken
into account and the text is inserted at the wrong position.

Am I doing anything wrong? Is there another, better way to handle this?

Thanks in advance,

Piotr Chabot Stadhouders

Timeff

The Netherlands

**********************************************************************
See how easy it is to extend your 4D solutions to Web and mobile. New opportunities await you with 4D v14!

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

Ortwin Zillgen | 23 Apr 16:09 2014
Picon

Re: Fill a popup-drop-down with a sorted list of all tables

> Is there a way to define some kind of sorting in combination of 'Get last table number' or should i first fill
an array with all table-names, sort that array, and then use that array to fill the popup-dropdown?

that'll work. As of V14, check ARRAY TO LIST  <http://doc.4d.com/4D-Programmiersprache-14.1/Arrays/ARRAY-TO-LIST.301-1410967.de.html>

check System_Tables <http://dddd.mettre.de/systemTables.shtml#english>

Regards
O r t w i n  Z i l l g e n
---------------------------------------------
<mailto:info@...>   <http://dddd.mettre.de?4713>
<feed://dddd.mettre.de/dddd.xml> <https://twitter.com/Ozett>
member of developer-network <http://www.die4dwerkstatt.de>

**********************************************************************
See how easy it is to extend your 4D solutions to Web and mobile. New opportunities await you with 4D v14!

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

Florian Pöck | 23 Apr 14:23 2014
Picon

Fill a popup-drop-down with a sorted list of all tables

Hi,

for debugging/learning and other issues i've created a form called 'SQL-Browser' in my application.
This section lets me run sql-queries and displays the results in a dynamic listbox.

As a sidefunction there is a popup-dropdown which gets filled on load of the form with a list of all tables
(using the  Get Last Table number command). Like that i can easily select an entire table and on button press
all records of this table are selected via sql and displayed in my listbox as well

Now lets take a look on the 'still-to-do-area'
##########################################
My popup-dropdown, which is filled via 'Get Last table number' seems to be ordered by the table ids - not on
the table names.
Is there a way to define some kind of sorting in combination of 'Get last table number' or should i first fill
an array with all table-names, sort that array, and then use that array to fill the popup-dropdown?

Best regards
Florian

--

-- 
 - Stromversorgungen für industrielle Anwendungen -
 - Power supplies for industrial applications -

    Kniel System-Electronic GmbH
        Postfach/Postbox 210849 - 76158  Karlsruhe - Deutschland/Germany
        Telefon/Phone +49 721 95920 - Fax +49 721 9592100
        www.kniel.de
        -
        Geschäftsführer/Managers:
        Dipl. Ing. (FH) Helmut Kniel
(Continue reading)

stardata.info | 23 Apr 12:32 2014

REDUCE SELECTION ERROR

Hi All,

I use this command and some time receive this error:
"Cannot complete scan on index kind, id of database Ais"

Have a suggestion?

Thanks
/Ferdinando/
**********************************************************************
See how easy it is to extend your 4D solutions to Web and mobile. New opportunities await you with 4D v14!

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

Tom Dillon | 23 Apr 03:13 2014
Picon

Plugins No Longer Recognized

I just got a call from someone using 4D Server 2004.8 on a Mac (10.6.7 / 4GB / 2.4 GHz Intel Core Duo) whose
database suddenly no loger recognizes the plugins. They don't tokenize as plugins in the design
environment or show up in the method editor list.

Both folders

Even more puzzling, I created a new DB, placed the Mac4DX and Plugins folders along side it and that DB
doesn't see them either.

I also tried Mac4DX and Plugins folders from another directory that hadn't been touched in a while.

I repaired permissions, BTW.

Anybody have any ideas?

--

-- 
   ------------------------------------------------------------------
   Tom Dillon                                           825 N. 500 W.
   DataCraft                                           Moab, UT 84532
   TomDillon@...                           720/209-6502
   ------------------------------------------------------------------
   When your memories exceed your dreams you're headed for the grave.
 	 --- Jim Horsl
   ------------------------------------------------------------------

**********************************************************************
See how easy it is to extend your 4D solutions to Web and mobile. New opportunities await you with 4D v14!

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
(Continue reading)

Keith Goebel | 22 Apr 22:55 2014
Picon

Re: PDF Creator install for 4D Client

Peter,
Can you tell me what settings would make it "configured correctly"?
Cheers, Keith

> Keith Goebel wrote
>> Do you have to install pdfCreator onto every 4D Client machine in order
>> for each them to be able to print to pdf?
> 
> Peter Lerch wrote
>  Yes, but you could check in your application if it's installed and
> configured correctly and install it if necessary.
> 

**********************************************************************
See how easy it is to extend your 4D solutions to Web and mobile. New opportunities await you with 4D v14!

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

Bill Hutten | 22 Apr 15:12 2014

4D v14 REST details?

Hi all: 

Can anyone point me to detailed documentation on the v14 REST server?
I'm wondering about the possibility of using it from a Javascript app
(not Wakanada) and am looking for detailed information on the syntax.

Looking at the logs generated by a simple test Wakanada app, I see URLs
like these:

/rest/$catalog/$all
/rest/$directory/login
/rest/Clients?$top=40&$method=entityset
/rest/Clients(9891FD64023E46C5B2FC03B9D14532C8)
/rest/Clients/$entityset/BF38320F2F9C4CF9A2F37FCD3138EBEA?$top=40&$skip=40
/rest/Clients?$top=1&$method=entityset

I can spend a few hours figuring this all out via trial-and-error, but
I'd rather avoid that if possible. (Maybe I just missed a 4D doc??)

- bill
**********************************************************************
See how easy it is to extend your 4D solutions to Web and mobile. New opportunities await you with 4D v14!

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

(Continue reading)


Gmane