Re: Tables created with SQL CREATE TABLE command and triggers

[Chip Scheide via 4D_Tech]

Pat,
how about :
1 table - each record contains an object field which holds a table definition, 
which the user can define.
1 more table - each record has an object field which holds the data for the 
table defined above


> I'm revisiting the idea of creating a flexible table structure with v16.
> Currently we have lots of user data tables defined, and they are
> activated/deactivated as required by each customer. This works OK but it
> adds a lot of overhead to the database, as it means we have more than 50
> tables, each with over 500 fields of various types. It would be much better
> to be able to define tables on the fly.
> 
> The first obstacle is triggers. We can create a new table using the SQL
> CREATE TABLE command, but I can't see a way to programmatically add a
> trigger to it. Triggers can be enabled or disabled via the ALTER TABLE
> command, but how can a trigger be created? Is there ANY way to create a
> trigger?
> 
> Thanks!
> Pat

Hell is other people 
 Jean-Paul Sartre
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

[ANN]: v2.0 of 4D v14/v15 Code Analysis Component Released

[Dani Beaubien via 4D_Tech]

I have released v2.0 of the CodeAnalysis component. Please take a look at the 
release notes below for more detail.

MY COMMITMENT - ALWAYS WILL BE FREE

This component is free and will always be free for any 4D developer’s personal 
use. I am doing this because I have benefited from the 4D community and this is 
my way of saying “thanks” and giving back.


WHAT IS IT?

Code Analysis is easy to use and offers the following features:
- Can perform analysis on "all" stored methods in the structure including 
project methods, project form/object methods, table form/object methods, 
database methods and trigger methods.
- Can perform analysis of the code to see which fields are used in a query and 
report if they are indexed or not
- Gathers stats on line counts, comment line counts, blank line counts, code 
line counts, and cyclomatic complexity.
- Can export, as disk files, every method in the structure. Can be used for 
archiving, backups, and source code management.
- Can export, as JSON files, every available form and form object property in 
the structure. Can be used for archiving, backups, and source code management.
- Can export, as JSON files, every available table and field property in the 
structure. Can be used for archiving, backups, and source code management.
- Can create HTML documentation of the methods in the structure. The HTML docs 
can be limited to only those methods that have been marked as shared with host. 
This gives 4D developers to easily produce documentation for components that 
they share.
- Can create a docset for the shared methods. Third party Docset viewers are 
available on many platforms.
- Can manage 4D Project Method Comments

Please feel free to drop me a note on suggestions and feature requests. I do 
plan to do some more tweaks and add new features in the future.


HOW TO GET IT

Go to > to get 
more information and download the component.


Code Analysis v2.0 - Mar 7, 2017
==
General
 - Minor adjustments to the user interface. Some buttons converted to icons to 
condense the amount of space that the UI takes on the various pages.
 - Optimized the code used for doing the analysis. Performance improved by 
20-30% when testing against my own code.
 - Added menu items for the main analysis window and the new explorer window.
 - Fixed bug that caused the Quick launcher window to ignore the floating 
preference setting.

Explorer Window
 - Created a new explorer window that shows all the information that the 
component has on the methods in the structure. From this window a user can open 
a method, filter visible methods and export the information shown in the grid.
 - Exposed a new shared "CA_ShowExplorer" method that opens the explorer.
 - Added a new Code Review window that is accessible from right clicking a 
method in the explorer window. The code review window parses the method and for 
variables that are used. You can select a particular variable and easily see 
all the lines of code that use the variable.

Code Analysis Window: Complexity Analysis
 - Complexity analysis no longer counts "If (True)" and "If (False)" as a point 
of complexity since there is only one way to execute that decision point.
 - Added a new graph under the "View Graphs" button that provides a break down 
of the methods by the maximum number of nested levels of control (if, for, 
case, while) statements.
 - Added a button to open the explorer window.

Code Analysis Window: Index Analysis
 - Fixed a range error bug that could occasionally occurs when exporting 
detailed reports on the indexes.
 - Made some internal optimizations that make the detection of field and table 
usage easier.



Dani Beaubien
dbeaub...@openroaddevelopment.com 
Open Road Development, Inc.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: RESOURCE LIST & XLIFF Resource Files

[Keisuke Miyako via 4D_Tech]

 Hello,

the command RESOURCE LIST was never associated with XLIFF.

resource commands that work with XLIFF are:

STRING LIST TO ARRAY
http://doc.4d.com/4Dv15/4D/15.4/STRING-LIST-TO-ARRAY.301-3274706.en.html

and

Get indexed string
http://doc.4d.com/4Dv15/4D/15.4/Get-indexed-string.301-3274707.en.html

see also:

Appendix C: XLIFF architecture
http://doc.4d.com/4Dv15/4D/15.4/Appendix-C-XLIFF-architecture.300-3285323.en.html

> 2017/03/08 1:22、Steven via 4D_Tech <4d_tech@lists.4d.com> のメール：
> Does the 4D command “RESOURCE LIST” still work with XLIFF string resource 
> files?




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

RE: 4D 15.4 HF1 (windows) - crashes when run as service

[Randy Engle via 4D_Tech]

Hi Tim,

Thanks for the detailed info.  Appreciated.

Will try all of the above.

The only plugins that were changed were 4D plugins (Write/Internet/ODBC/Pack)
But I'll test everything.

Randy Engle
XC2 Software LLC

-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Timothy Penner 
via 4D_Tech
Sent: Tuesday, March 07, 2017 3:11 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Timothy Penner 
Subject: RE: 4D 15.4 HF1 (windows) - crashes when run as service

Hi Randy,

> Anyone else notice this?

Not me; I tested 4D Server 32/64 bits v15.4HF1 on Windows 10 using 
non-interactive service.

I tested with a brand new blank database - does it crash for you with a brand 
new blank database?

If it is only your database that is crashing on startup then I would suggest:
1) Isolate the plugin to narrow it down, make sure the crash doesn’t depend on 
a plugin: http://kb.4d.com/assetid=77256
2) If it is related to a plugin notify the plugin developer.
3) If it isn't related to a plugin then use 4D singleuser to enable the debug 
log in human readable (v13) format on the first line of On Server Startup and 
then launch it as a service and check the log after it crashes to see the last 
item it tried to execute.

Open a case on TAOW (taow.4d.com) for further assistance.

-Tim



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

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

Re: Tables created with SQL CREATE TABLE command and triggers

[Pat Bensky via 4D_Tech]

I think you're on to something there Chuck! We would still need to have all
those tables but any that are not being used only have 1 field instead of
over 500! Why didn't I think of that?

Pat

On Wed, 8 Mar 2017 at 00:27, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Yu could simply create tables with only journal field and allow users to
> adjust as need be. Set triggers to run as needed and uses footprints to run
> trigger method. I know this last part is not pretty but it may work
>
> Regards
>
> Chuck
>
> 
>  Chuck Miller Voice: (617) 739-0306
>  Informed Solutions, Inc. Fax: (617) 232-1064
>  mailto:cjmillerinformed-solutions.com
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D and Sybase connectivity
>   http://www.informed-solutions.com
>
> 
> This message and any attached documents contain information which may be
> confidential, subject to privilege or exempt from disclosure under
> applicable law.  These materials are intended only for the use of the
> intended recipient. If you are not the intended recipient of this
> transmission, you are hereby notified that any distribution, disclosure,
> printing, copying, storage, modification or the taking of any action in
> reliance upon this transmission is strictly prohibited.  Delivery of this
> message to any person other than the intended recipient shall not
> compromise or waive such confidentiality, privilege or exemption from
> disclosure as to this communication.
>
> > On Mar 7, 2017, at 6:15 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> >
> > I'm revisiting the idea of creating a flexible table structure with v16.
> > Currently we have lots of user data tables defined, and they are
> > activated/deactivated as required by each customer. This works OK but it
> > adds a lot of overhead to the database, as it means we have more than 50
> > tables, each with over 500 fields of various types. It would be much
> better
> > to be able to define tables on the fly.
> >
> > The first obstacle is triggers. We can create a new table using the SQL
> > CREATE TABLE command, but I can't see a way to programmatically add a
> > trigger to it. Triggers can be enabled or disabled via the ALTER TABLE
> > command, but how can a trigger be created? Is there ANY way to create a
> > trigger?
> >
> > Thanks!
> > Pat
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

-- 
*
CatBase - The Database Publishing Solution
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Tables created with SQL CREATE TABLE command and triggers

[Chuck Miller via 4D_Tech]

Yu could simply create tables with only journal field and allow users to adjust 
as need be. Set triggers to run as needed and uses footprints to run trigger 
method. I know this last part is not pretty but it may work

Regards

Chuck

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  

This message and any attached documents contain information which may be 
confidential, subject to privilege or exempt from disclosure under applicable 
law.  These materials are intended only for the use of the intended recipient. 
If you are not the intended recipient of this transmission, you are hereby 
notified that any distribution, disclosure, printing, copying, storage, 
modification or the taking of any action in reliance upon this transmission is 
strictly prohibited.  Delivery of this message to any person other than the 
intended recipient shall not compromise or waive such confidentiality, 
privilege or exemption from disclosure as to this communication. 

> On Mar 7, 2017, at 6:15 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I'm revisiting the idea of creating a flexible table structure with v16.
> Currently we have lots of user data tables defined, and they are
> activated/deactivated as required by each customer. This works OK but it
> adds a lot of overhead to the database, as it means we have more than 50
> tables, each with over 500 fields of various types. It would be much better
> to be able to define tables on the fly.
> 
> The first obstacle is triggers. We can create a new table using the SQL
> CREATE TABLE command, but I can't see a way to programmatically add a
> trigger to it. Triggers can be enabled or disabled via the ALTER TABLE
> command, but how can a trigger be created? Is there ANY way to create a
> trigger?
> 
> Thanks!
> Pat

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

RE: Tables created with SQL CREATE TABLE command and triggers

[Timothy Penner via 4D_Tech]

Correct – METHOD SET CODE cannot be executed in compiled mode.
You would get the following error if you used it in compiled mode:


The command cannot be executed in a compiled database.

Error code: -9762
The command cannot be executed in a compiled database.
component: '4DRT'
task -1, name: 'Application process'



-Tim




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

Re: Tables created with SQL CREATE TABLE command and triggers

[Pat Bensky via 4D_Tech]

Thanks Tim - but METHOD SET CODE doesn't work in a compiled database, does
it?

On 7 March 2017 at 23:40, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> > I can't see a way to programmatically add a trigger to it
> > Triggers can be enabled or disabled via the ALTER TABLE command,
> > but how can a trigger be created? Is there ANY way to create a trigger?
>
> METHOD SET CODE would likely work for you to set the code, something like
> this: METHOD SET CODE("[trigger]/table_1";$code)
>
> The problem I think you will find is how to enable the individual trigger
> checkboxes, the ones you normally click in the table properties...
>
> ALTER TABLE allows you to disable or enable the Trigger mechanism, it does
> not allow you to select which triggers are enabled or disabled (i.e. it
> doesn’t change the state of the checkboxes on the table properties).
>
> You need the ability to alter the checkbox state of the triggers at the
> table properties level; I am not aware of a feature for this.
>
> -Tim PENNER
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **




-- 
*
CatBase - The Database Publishing Solution
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Tables created with SQL CREATE TABLE command and triggers

[Timothy Penner via 4D_Tech]

> I can't see a way to programmatically add a trigger to it
> Triggers can be enabled or disabled via the ALTER TABLE command,
> but how can a trigger be created? Is there ANY way to create a trigger?

METHOD SET CODE would likely work for you to set the code, something like this: 
METHOD SET CODE("[trigger]/table_1";$code)

The problem I think you will find is how to enable the individual trigger 
checkboxes, the ones you normally click in the table properties...

ALTER TABLE allows you to disable or enable the Trigger mechanism, it does not 
allow you to select which triggers are enabled or disabled (i.e. it doesn’t 
change the state of the checkboxes on the table properties).

You need the ability to alter the checkbox state of the triggers at the table 
properties level; I am not aware of a feature for this.

-Tim PENNER



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

Tables created with SQL CREATE TABLE command and triggers

[Pat Bensky via 4D_Tech]

I'm revisiting the idea of creating a flexible table structure with v16.
Currently we have lots of user data tables defined, and they are
activated/deactivated as required by each customer. This works OK but it
adds a lot of overhead to the database, as it means we have more than 50
tables, each with over 500 fields of various types. It would be much better
to be able to define tables on the fly.

The first obstacle is triggers. We can create a new table using the SQL
CREATE TABLE command, but I can't see a way to programmatically add a
trigger to it. Triggers can be enabled or disabled via the ALTER TABLE
command, but how can a trigger be created? Is there ANY way to create a
trigger?

Thanks!
Pat

-- 
*
CatBase - The Database Publishing Solution
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: 4D 15.4 HF1 (windows) - crashes when run as service

[Timothy Penner via 4D_Tech]

Hi Randy,

> Anyone else notice this?

Not me; I tested 4D Server 32/64 bits v15.4HF1 on Windows 10 using 
non-interactive service.

I tested with a brand new blank database - does it crash for you with a brand 
new blank database?

If it is only your database that is crashing on startup then I would suggest:
1) Isolate the plugin to narrow it down, make sure the crash doesn’t depend on 
a plugin: http://kb.4d.com/assetid=77256
2) If it is related to a plugin notify the plugin developer.
3) If it isn't related to a plugin then use 4D singleuser to enable the debug 
log in human readable (v13) format on the first line of On Server Startup and 
then launch it as a service and check the log after it crashes to see the last 
item it tried to execute.

Open a case on TAOW (taow.4d.com) for further assistance.

-Tim



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

Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?

[Paul Lovejoy via 4D_Tech]

Wow!

It’s great having a benevolent resident genius here!

Thanks Miyako.


Paul


> Le 7 mars 2017 à 08:10, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> Thank you Arnaud your code gave me the needed inspiration :)
> 
> https://github.com/miyako/4d-component-classic-query-editor/
> 
> 2017/03/07 5:42、Arnaud de Montard via 4D_Tech <4d_tech@lists.4d.com> のメール：
> I just translated some comments, and, again, I never ended the job. HTH…
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?

[Paul Lovejoy via 4D_Tech]

You missed my point on your point ;-)

You can offer all of that without giving the user access to that in case you 
DON’T want them to have it. For example, you could create a set via a query, 
then give your users access to ONLY query the selection, or whatever. You don’t 
need that new 4D weird editor to do that.

In a complex application it is normal to have to do a little extra coding. For 
example, we have a multi-company accounting system. When a user connects to one 
company we want to shield him from inadvertently access data from another 
company. So no matter what query he does, we will narrow the selection 
programmatically to exclude data we don’t want displayed.

The nice thing about Miyako’s component is you can customize it to do these 
types of things, whereas 4D’s new query editor doesn’t leave you any choice.


Cheers,


Paul


> Le 7 mars 2017 à 16:59, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> You missed my point. Let's say I have a db where users can only see only
> certain regions of data. So You code that when you launch the process for
> them, their all records actually shows a subset. In the old quest editor if
> you had a command query selection that is all the user could do. In the new
> query editor, the user can switch to create a new selection, into a set etc.
> 
> Thus you as a developer must add extra code every time they do a query,
> where in previous versions you did not
> 
> Regards
> 
> Chuck

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

Re: Copy or Drag from a listbox?

[info--- via 4D_Tech]

when using selection listbox don't forget QuickReport for exporting.
- create a qr
- copy listbox-columns into qr-columns
- use selection
- set qr destination
- qr run
done


Regards
O r t w i n Z i l l g e n
-
Mitglied des Entwicklernetzwerkes www.die4dwerkstatt.de
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

v13 - Check box active when not enabled and not enterable

[Chip Scheide via 4D_Tech]

following code run during on load of an entry form.
OBJECT SET ENABLED(*;"obj_cb_Aliquot";$Enterable)
OBJECT SET ENTERABLE(*;"obj_cb_Aliquot";$Enterable)

in debugger, when clicking on cb_ALiquote
OBJECT Get enterable(cb_Aliquote)...false
OBJECT Get Enabled(cb_Aliquote) ... false

So.. why does the check box variable allow clicking (turning on/off)? 

Thanks
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Copy or Drag from a listbox?

[Arnaud de Montard via 4D_Tech]

> Le 7 mars 2017 à 10:33, Koen Van Hooreweghe via 4D_Tech 
> <4d_tech@lists.4d.com> a écrit :
> 
> [...]
> 
> I have done something similar from a button on the form, but the list box was 
> array based. A bit easier, because I could loop over the arrays to get the 
> data out of them.

With a selection listbox, execute on server is (quite) mandatory, for 
performance reasons. Some formula columns can be difficult (ex: formula using 
data loaded on client side only). 

-- 
Arnaud de Montard 




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

Re: Copy or Drag from a listbox?

[Koen Van Hooreweghe via 4D_Tech]

Hi Keith,

For copy/paste you have to put a tab delimited text on the pasteboard.

First of all you'll have to intercept the cmd-c and Copy menu items in 4D to 
make it run your code when the listbox has focus.
Then run over the selected lines (records) to get the data. Finally loop over 
the fields set in the columns to get the right data.

A bit of work, but can be done IMHO.

I have done something similar from a button on the form, but the list box was 
array based. A bit easier, because I could loop over the arrays to get the data 
out of them.

Kind regards,
Koen

Op 6-mrt.-2017, om 20:26 heeft Keith Goebel via 4D_Tech <4d_tech@lists.4d.com> 
het volgende geschreven:

> I can't think how to do it using copy/paste.



—
Koen Van Hooreweghe
—


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

RESOURCE LIST & XLIFF Resource Files

[Steven via 4D_Tech]

Good morning all.

Running 4D v16 on OS X 10.10.5:

Does the 4D command “RESOURCE LIST” still work with XLIFF string resource 
files?  

Having converted my STR# resources to XLIFF files I find my old methods relying 
on 4D resource commands are broken and that the commands themselves either 
result in errors, i.e. -199 Document cannot be opened (open resource file), or 
empty arrays (RESOURCE TYPE LIST & RESOURCE LIST).  

If RESOURCE LIST still works with XLIFF files, what has changed and how do I 
need to adapt my old code to get it to work, i.e. replace “STR#” passed as $1 
with another appropriate resource type identifier?  If not, has anyone 
developed code to replicate its functionality with XLIFF resources, i.e. 
extract the resource ids and names into arrays?  Knowing nothing about XML and 
4D's XML integration, sample code would be greatly appreciated.  

I suspect that I may be missing something simple, but cannot figure out what it 
might be from the docs or by testing.  Otherwise, I am way out of my depth with 
respect to 4D XML capabilities.  

Thanks in advance for any suggestions or guidance.  

Best from sunny Santa Fe,

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

Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?

[Charles Miller via 4D_Tech]

On Tue, Mar 7, 2017 at 1:23 AM, Paul Lovejoy via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Chuck,
>
> As a developer I’ve already offered the functionality to query in the
> selection, join to the existing selection or use a query result to exclude
> from the selection.
>

You missed my point. Let's say I have a db where users can only see only
certain regions of data. So You code that when you launch the process for
them, their all records actually shows a subset. In the old quest editor if
you had a command query selection that is all the user could do. In the new
query editor, the user can switch to create a new selection, into a set etc.

Thus you as a developer must add extra code every time they do a query,
where in previous versions you did not

Regards

Chuck


-- 
-
 Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
 Informed Solutions, Inc.
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D, Sybase & SQL Sever connectivity
  http://www.informed-solutions.com
-
This message and any attached documents contain information which may be
confidential, subject to privilege or exempt from disclosure under
applicable law.  These materials are intended only for the use of the
intended recipient. If you are not the intended recipient of this
transmission, you are hereby notified that any distribution, disclosure,
printing, copying, storage, modification or the taking of any action in
reliance upon this transmission is strictly prohibited.  Delivery of this
message to any person other than the intended recipient shall not
compromise or waive such confidentiality, privilege or exemption
from disclosure as to this communication.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Can 4D connect to Firebird?

[Sujit Shah via 4D_Tech]

Thanks


I think the requirements are to replace  a firebird based desktop solution
with a web interface.

Firebird is a pretty decent sql compliant framework but it does not seem to
have many followers

I will PM you if the project gets the nod


On Tue, 7 Mar 2017 at 5:16 pm, David Samson via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I have a 4D system that pulls in data from a Firebird database every few
> minutes throughout the day. Has been working for years. I use ODBC for
> which you need the Firebird driver. I use Flamerobin to manage the Firebird
> tables.
>
> If you require more details as to the driver etc. just let me know.
>
>
> > Before I commit to a project I though I will find out if 4D can connect
> to
> > Firebird SQL..
> >
> > David Samson
> Manchester
> UK
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

-- 

xxx
"There must be ingenuity as well as intention, strategy as well as
strength. "
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Can 4D connect to Firebird?

[David Samson via 4D_Tech]

I have a 4D system that pulls in data from a Firebird database every few
minutes throughout the day. Has been working for years. I use ODBC for
which you need the Firebird driver. I use Flamerobin to manage the Firebird
tables.

If you require more details as to the driver etc. just let me know.


> Before I commit to a project I though I will find out if 4D can connect to
> Firebird SQL..
>
> David Samson
Manchester
UK
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Strategy to allow one user to drop another from the server

[Douglas Cryer via 4D_Tech]

Kirk,

We had a similar requirement.  In our case it was users remaining logged on 
after they had gone home.  We needed them to be kicked off in order to run 
maintenance and so the backup was not slowed.

I used execute on client to display a dialog to the user informing them that 
they would be logged off in x seconds/minutes.  In our case they had a choice.  
If they were really there and wanted to continue working they could click one 
response, or they could click quit.  After the specified time the user was quit 
out.  It would be easy enough to write a corresponding reply to the original 
user to inform them that the target user did not wish to quit.

Regards,  Dougie


telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218
2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
Email : jdcr...@telekinetix.com   Web : 
http://www.telekinetix.com 

 

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