how do I turn it into a component or a database

[Axel Kohlepp via 4D_Tech]

Hello,

I found the following things:

https://github.com/ThomasMaul/UserMode_Component

https://github.com/ThomasMaul/Tools_TM_export

But how do I turn it into a component or a database ?

Best regards

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

v13 - Why would a query fail to change current reocrd?

[Chip Scheide via 4D_Tech]

Background
- I use 2 tables to manage listboxes.
- I am on an entry form, which includes a selection listbox.
- I am trying to display, in a dialog (Mac so a type 34 sheet window), 
a different listbox (array) to allow the user to make a selection.

before the below code executes, the current selection of 
[listbox_table] reflects the definition for selection listbox 
displaying on the current entry form (ID 1327).

I make this call : arylstbx_Setup ("lb_Display_Choices";"Choose_Item")
In the above call there are these lines of code:
  //gets base info for listbox description
QUERY([List_Box_Table];[List_Box_Table]Listbox_Name=$Listbox_Name;*)
QUERY([List_Box_Table]; & ;[List_Box_Table]Primary_Use=$Primary_Use)

$Listbox_Name = $1 = lb_Display_Choices
Primary_Use = $2 = Choose_Item

Results:
- after the Query, the current record has not changed!
- If I issue an Unload record (in debugger) before the query, no record 
is loaded
- in 'user' environment' the same query locates, and loads a different 
record (ID 1505).

State:
in transaction [Listbox_Table] is read only & Locked
all actions are occurring inside the same transaction.

My thoughts and attempts to resolve:
- entry form listbox was doing some sort of background query on 
[listbox_table] during on display detail, so I set the listbox 
invisible before opening the type 34 dialog window. -- no effect.
- I have put traces in the code for the listbox and the form  to see if 
something is running and changing the selection of the [listbox_table] 
table - noting is running.
- all of the code for the dialog is 'linear' to the entry form, i.e. 
the dialog is opened inside the same process and same transaction so - 
conceptually - no other code should be running to change the selection 
in the [listbox_table]
- relations - only one relation, completely manual.

and ideas?
sorry for wall of text

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

[MEETING] Montreal 4D Club Meeting

[Thierry Daigneault via 4D_Tech]

The next meeting of the Montreal 4D Club will be held Wednesday October 17th at 
7 PM.

PLEASE NOTE: This month’s meeting is being held at a new address.


The schedule for the next meeting is as follows:
News
Questions
Presentations
- Open meeting. Bring your questions and presentations.
End of the meeting

We usually end up at some sort of restaurant after each meeting. Come and join 
us!



Address
---
Softconcept Canada
4378 Av Pierre-De Coubertin (coin Bennett)
Montréal



Anyone can attend. Please note that the meetings are usually held in French.

If you need more information, you can check out our web page at:
http://www.macapa.com/4dmtl 

You can also write to our communications officer:
Thierry Daigneault: tdaignea...@macapa.com 
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v17R2

[Jeremy Roussak via 4D_Tech]

Thanks, Randy and Julio. I’d re-registered before I read about refresh but I 
expect that would have worked too.

Live and learn.

Jeremy

On 15 Oct 2018, 18:20 +0100, Julio Carneiro via 4D_Tech <4d_tech@lists.4d.com>, 
wrote:
> Have you tried the “Refresh” button on the License Manager? That should 
> refresh all your registered license, and I believe that’d ‘transfer’ your V17 
> to V17R2.
>
> > On Oct 15, 2018, at 4:50 AM, Jeremy Roussak via 4D_Tech 
> > <4d_tech@lists.4d.com> wrote:
> >
> > My v17 licences show up in the “build application” dialog but are greyed 
> > out and when I click “build”, 4D tells me that there are none installed. My 
> > maintenance runs to the end of next month, so that shouldn’t be a problem.
> >
> > Is there a known issue with licences in R2, or is it just me?
> >
> > Jeremy
> >
>
> --
> Julio Carneiro
> jjfo...@gmail.com
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> Archive: http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Resetting the table sequence number

[Chuck Miller via 4D_Tech]

You could also do this
c_longint($Variable_L)

begin sql

select MAX([table]ID_Field)
from [table]
into
:$Variable_L;
end sql

or
query by sql([table];max([table]ID_Field) into :$Variable_L)

I am not sue query by sql will 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 Oct 15, 2018, at 1:26 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 2 things:
> 1 - why not
> all records
> order by([table];[table]ID_Field;<)
> $New_Sequence_Value:=[table]ID_Field+1
> then you are sure to exceed the last assigned value.

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

Re: Resetting the table sequence number

[Chip Scheide via 4D_Tech]

2 things:
1 - why not
all records
order by([table];[table]ID_Field;<)
$New_Sequence_Value:=[table]ID_Field+1
then you are sure to exceed the last assigned value.

2 - try assigning **Table*($iTableNumber)* to a local variable, and 
then dereference,
sometime 4D does not like to dereference equations as a parameter to a 
command.

Chip

On Mon, 15 Oct 2018 17:56:58 +0100, Pat Bensky via 4D_Tech wrote:
> I have a method that creates record numbers using the Sequence number. I'm
> running into a situation where I am getting duplicate record numbers for
> some reason. So I added some code to check and - supposedly - fix it by
> resetting the table sequence number, but it doesn't seem to work.
> 
> This is what I'm doing:
> 
> $Sequence:=*Sequence number*(*Table*($iTableNumber)->)
> 
> *If* (*Find in field*(*$1*->;$Sequence)>-1) // $1 is a pointer to the
> record number field
> 
> *While* (*Find in field*(*$1*->;$Sequence)>-1)
> 
> $Sequence:=$Sequence+1
> 
> *End while*
> 
> *SET DATABASE PARAMETER*(*Table*($iTableNumber)->;Table sequence number;
> $Sequence)
> 
> *End if*
> 
> *$1*->:=*Sequence number*(*Table*($iTableNumber)->)
> 
> Suppose $Sequence = 4496 when we get to the SET DATABASE PARAMETER line.
> 
> Then the next call to *Sequence number* should return 4497, right? But it
> doesn't. It returns 4495.
> 
> 
> Any suggestions as to what I'm doing wrong here?
> 
> Note- this is not happening inside a transaction.
> 
> 
> Pat
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v17R2

[Julio Carneiro via 4D_Tech]

Have you tried the “Refresh” button on the License Manager? That should refresh 
all your registered license, and I believe that’d ‘transfer’ your V17 to V17R2.

> On Oct 15, 2018, at 4:50 AM, Jeremy Roussak via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> My v17 licences show up in the “build application” dialog but are greyed out 
> and when I click “build”, 4D tells me that there are none installed. My 
> maintenance runs to the end of next month, so that shouldn’t be a problem.
> 
> Is there a known issue with licences in R2, or is it just me?
> 
> Jeremy
> 

--
Julio Carneiro
jjfo...@gmail.com



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

Resetting the table sequence number

[Pat Bensky via 4D_Tech]

I have a method that creates record numbers using the Sequence number. I'm
running into a situation where I am getting duplicate record numbers for
some reason. So I added some code to check and - supposedly - fix it by
resetting the table sequence number, but it doesn't seem to work.

This is what I'm doing:

$Sequence:=*Sequence number*(*Table*($iTableNumber)->)

*If* (*Find in field*(*$1*->;$Sequence)>-1) // $1 is a pointer to the
record number field

*While* (*Find in field*(*$1*->;$Sequence)>-1)

$Sequence:=$Sequence+1

*End while*

*SET DATABASE PARAMETER*(*Table*($iTableNumber)->;Table sequence number;
$Sequence)

*End if*

*$1*->:=*Sequence number*(*Table*($iTableNumber)->)

Suppose $Sequence = 4496 when we get to the SET DATABASE PARAMETER line.

Then the next call to *Sequence number* should return 4497, right? But it
doesn't. It returns 4495.


Any suggestions as to what I'm doing wrong here?

Note- this is not happening inside a transaction.


Pat

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

Re: EAN8 barcode with Zint plugin

[Pat Bensky via 4D_Tech]

So, if I understand that correctly, Zint will create the barcode in the
appropriate format depending on how many digits are passed to it - right?
Doing some testing ... :)
Pat

On Mon, 15 Oct 2018 at 16:32, Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I think EANX includes EAN8 but I am not sure.
>
> technically there should be no need to differentiate 8 from 13.
>
> https://en.wikipedia.org/wiki/International_Article_Number
>
> 2018/10/15 23:52、Pat Bensky via 4D_Tech <4d_tech@lists.4d.com 4d_tech@lists.4d.com>>のメール:
> EAN8 isn't listed
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



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

Re: EAN8 barcode with Zint plugin

[Pat Bensky via 4D_Tech]

Seems to be the same.

On Mon, 15 Oct 2018 at 15:56, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Does this list of IDs and codes look like it matches Miyako's plug-in?
>
> http://www.zint.org.uk/Manual.aspx?type=p&page=4
>
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



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

Re: EAN8 barcode with Zint plugin

[Keisuke Miyako via 4D_Tech]

I think EANX includes EAN8 but I am not sure.

technically there should be no need to differentiate 8 from 13.

https://en.wikipedia.org/wiki/International_Article_Number

2018/10/15 23:52、Pat Bensky via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
EAN8 isn't listed



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

RE: v17R2

[Randy Engle via 4D_Tech]

Jeremy,

V17R licenses are different than v17 licences

I use the xml file to build my apps.
When I put in the license numbers, they need to be the license numbers with the 
"R" in front of them.
i.e. you need to re-register you v17(Rx) licenses so the you have license 
numbers with the R in front of the number.

Randy Engle, Director
XC2 Software LLC – XC2LIVE!

-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jeremy Roussak via 
4D_Tech
Sent: Monday, October 15, 2018 12:50 AM
To: 4D iNug Technical <4d_tech@lists.4D.com>
Cc: Jeremy Roussak 
Subject: v17R2

My v17 licences show up in the “build application” dialog but are greyed out 
and when I click “build”, 4D tells me that there are none installed. My 
maintenance runs to the end of next month, so that shouldn’t be a problem.

Is there a known issue with licences in R2, or is it just me?

Jeremy

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

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

Re: Mac OS 10.14 Mojave and 4D 15

[Kirk Brooks via 4D_Tech]

James,
It works mostly.

WebKit is completely horked so things like the Welcome Wizard and any other
web areas that use the WebKit are screwed. They are still active, though.
For example, if you click on the blank Welcome Wizard in a space where an
active link is it still works. Not necessarily a good thing.

You can turn off WebKit and if you aren't using 'Access 4D Methods' that's
fine. However, if your app is also running on Windows 10 machines they
won't run the v15 web areas natively, at least ours didn't. My solution was
to duplicate the affected forms, configure one for Mac and one for Windows
and display accordingly.

Do not expect any v15 updates - v15 is officially sunseted by 4D.

I haven't noticed any other performance issues. Cosmetically the window
placement with multiple monitors seems fussy. But so far every v15 database
I tried to open has.

I haven't tried running it on a Mac server like you are. I have run server
on my dev machine for testing but not compiled, as I think about it. Have
you tried opening an un-compiled version on the Mini? Might let you see an
error message before it crashes. You may need to recompile for 64 bit if
it's not already. Take a look at the compatibility settings. Components and
plugins would be the next things I'd check.

On Mon, Oct 15, 2018 at 5:21 AM James Knight via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Does anyone know if 4D 15 will work on Mojave?
>

-- 
Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: EAN8 barcode with Zint plugin

[Jeffrey Kain via 4D_Tech]

Does this list of IDs and codes look like it matches Miyako's plug-in?

http://www.zint.org.uk/Manual.aspx?type=p&page=4

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

EAN8 barcode with Zint plugin

[Pat Bensky via 4D_Tech]

Using Miyako's Zint plugin, I need to create a barcode in EAN8 format.
There's a list of supported formats on the Github page:
https://github.com/miyako/4d-plugin-zint

But EAN8 isn't listed. On the ZInt website it says that EAN8 is supported.
I need to know what the id number for EAN8 is. Can't find a list of them on
the Zint website ... Anybody know what it is?

Pat

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

Mac OS 10.14 Mojave and 4D 15

[James Knight via 4D_Tech]

Hi folks 

Does anyone know if 4D 15 will work on Mojave?

We've just purchased a new Mac Mini with Mojave pre-installed, and our built 
application crashes on launch. Before I spend hours troubleshooting, would be 
helpful to know if anyone has 4D v15 working on Mojave at all, and in 
particular if a compiled/merged app will run. 

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

Re: v13 - Change Button Shortcut

[Chip Scheide via 4D_Tech]

Thanks!

> 
>> Le 12 oct. 2018 à 22:47, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> a écrit :
>> 
>> Is there a way to globally change the key shortcut assigned to a button 
>> across multiple forms.
>> 
>> I inadvertently use Command (control) + Esc as short cut rather then 
>> just Esc for form cancel buttons...
>> I just found this.
>> I would prefer NOT to have to manually go through every entry and 
>> listing form to reset this value.
>> The buttons are invisible, are all named the same, and are ubiquitous 
>> on all of my entry and listing forms.
> 
> object set shortcut (*;"allNamedTheSame"; Shortcut with Carriage 
> Return)  ;-)
> 
> I noticed this works better with all keyboards than hardcoded setting 
> (legacy dialog)

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

v17R2

[Jeremy Roussak via 4D_Tech]

My v17 licences show up in the “build application” dialog but are greyed out 
and when I click “build”, 4D tells me that there are none installed. My 
maintenance runs to the end of next month, so that shouldn’t be a problem.

Is there a known issue with licences in R2, or is it just me?

Jeremy

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

Re: Codesigning

[Jeremy Roussak via 4D_Tech]

Miyako,

I think that, as usual, you identify the issue. I installed the 4D application 
as you describe and the problem doesn’t arise from anything it contained when I 
installed it. However...

The files with extended attributes are those backed up by Dropbox (which seems 
to add its own) and some third-party plugins and components which I have 
acquired (such as XLS II). I suspect the Finder has added them.

As long as removing the attributes doesn’t hurt (and it doesn’t seem to hurt), 
the issue is easily solved; I build the application from within a method 
anyway, so using a couple of LEP calls, invoking  xattr to remove the 
attributes and codesign to sign the application, is trivially easy and works 
well.

Thanks

Jeremy


> On 14 Oct 2018, at 20:42, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hello,
> 
> are you sure you downloaded the official .dmg file from 4D,
> and copied the application out of the disk image directly to a subdirectory 
> of the Applications folder?
> 
> Finder attributes are automatically added whenever you transfer a file from 
> one Mac to another,
> via HTTP or FTP download, AirDrop or E-Mail (nut not USB or shared drive).
> 
> 2018/10/14 23:04、Jeremy Roussak via 4D_Tech 
> <4d_tech@lists.4d.com>のメール:
> Removing all the extended attributes on the huge number of files in the 
> compiled application then allows code signing to work from the command line. 
> The application seems to work OK, but I’m wondering why so many files, most 
> of them from 4D, have attributes which prevent signing from working.
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**