Re: right click in text variable gets menu with cut copy paste

2017-10-13 Thread Keisuke Miyako via 4D_Tech 
you'd need v14 or later to capture the click event in an enterable text input.

> 2017/10/14 11:29、ernie hilgers via 4D_Tech <4d_tech@lists.4d.com> のメール：
> Is it possible to create such a functionality in v13 or v15 for that matter ?




**
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
**

right click in text variable gets menu with cut copy paste

2017-10-13 Thread ernie hilgers via 4D_Tech 
Hi all, 
problem / request:
A user of one of my database solutions on PC W7 4D v13.6 is complaining that, 
in many of the alphanumeric fields, there is NO right click with subsequent cut 
copy paste menu. 
they absolutely refuse to use any keyboard short-cut, all must be done with the 
mouse (they are absolutely adamant) . 

I can create the menu and I am able to show this menu, however they must click 
a button on the side of the alphanumeric field, clumsy patch they say. 
It should be that right clicking a text field or variable, this menu pops up. 

I can't get a text field / variable (or string variable for that matter in 4D 
v13) to register a click in that field.  It becomes active but then a second 
click is not registered. 

Is it possible to create such a functionality in v13 or v15 for that matter ? 

Hope to hear from anyone.  

greetings 

ernie hilgers (aruba)

**
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: iPhone Panties

2017-10-13 Thread Tom Dillon via 4D_Tech 
Tim Nevels via 4D_Tech wrote:

>Something totally off topic, but made me laugh. 

:-7  People still make millions off of totally silly stuff.

Between this and the discussion about the tech list getting fainter, it has me 
wonder if the 4D Pub is still around. It was pretty well traffice, especially 
right before and after a Devcon/Summit.

-- 
   --
   Tom Dillon   825 N. 500 W.
   DataCraft   Moab, UT 84532
   tomdil...@datacraft-inc.com   720/209-6502
   --
  Eat healthy and you'll live a long life. --- Jeffrey Dahmer
   --


**
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
**

iPhone Panties

2017-10-13 Thread Tim Nevels via 4D_Tech 
Something totally off topic, but made me laugh. 

My girlfriend sent me this picture:

http://myweb.midco.net/~timnevels/iPhonePanties.png

Tim


Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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: Subrecords with subrecords

2017-10-13 Thread Tim Nevels via 4D_Tech 
On Oct 13, 2017, at 2:00 PM, Kirk Brooks wrote:

> ​Really interesting hack. ​I'm trying to visualize this - "So you have to
> replace all these lines of code with EXECUTE commands."  Do you mean
> opening the structure in 2004 will show the names of the sub-subtable
> fields so you can then write the code using that name and run it with
> EXECUTE and not choke?

You can open the structure file in 2004 and everything works. You can also 
compile no problem. The issue is when you edit a method that contains a 
sub-subtable reference. As soon as you touch a line of the method with a 
sub-subtable field reference, or a sub-subtable reference, and the method 
editor tries to tokenize that line, it fails. So you have to be very careful.

Only touch lines that need to be edited. Don’t press command-Enter to 
re-tokenize the whole method. And before you edit a line with sub-subtable 
references first do a copy and paste into a text editor. I normally would copy 
paste the entire method just to be safe.

So if the line was: 
[Invoices]InvoiceItems’ItemDetails’SerialNumber:=[InventoryItem]SerialNumber

You do this: 
EXECUTE("[Invoices]InvoiceItems’ItemDetails’SerialNumber:=[InventoryItem]SerialNumber)

This is all just a hack to get you through a conversion process. 

Tim


Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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: Hosting Service for Small System

2017-10-13 Thread Ronald Rosell via 4D_Tech 
We’ve been very happy with Macstadium.  I have two minis hosted there, while I 
have a MacPro hosted at a Host.net  facility in Florida.  (I 
have nothing but good things to say about host.net  either, 
especially since they’ve stayed online through several major storms over the 
years, but I do worry about what’s happening to south Florida.) 

Since Macstadium also has racks for the Pros I've been considering migrating 
there.  Our current installs are at their Atlanta facility, but after the 
hurricane fire drill we had recently in Florida (which also affected Georgia) 
we’re thinking that having a server that can be a “lifeboat” for the others in 
their Las Vegas facility (the former macminicolo) makes sense.   

I agree with others that the provisioning at Macminicolo was less … reassuring 
... than Macstadium’s.  The owner of that firm seemed largely annoyed by 
requests for information.  I think he’s still onboard, but hopefully things in 
Las Vegas are better managed these days.

We recently had to do a complete wipe & reinstall of the OS on one of our Minis 
in Atlanta.  Macstadium took care of it … no extra charge.

Ron Rosell
__

Ron Rosell
President
StreamLMS


> On Oct 13, 2017, at 8:25 AM, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I'm working with a company that has a seven user server running on a Mac
> mini. They've decided to go "office-less" and are looking to have their
> system hosted.
> 
> This is a new area to me so I'm looking for recommendations for hosting
> services. We would like to use the current Mac mini and, for a variety of
> reasons, the hosting service should be located in the continental US.
> 
> Checking in on the Mac mini colo reveals that they've been absorbed by
> macstadium.com. Any comments on that service in particular?
> 
> Thanks in advance.
> 
> --
> Douglas von Roeder
> 949-336-2902 <(949)%20336-2902>
> **
> 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: Subrecords with subrecords

2017-10-13 Thread Lee Hinde via 4D_Tech 
The delimiter is a single quote:

Execute formula("x_text:=[table]subtable1’subtable2'fieldname")

All this talk of dot notation has confused you. :-)

> On Oct 13, 2017, at 11:13 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Kirk :
> yes.
> if I remember the subtable syntax correctly
> 
> Execute formula("x_text:=[table]subtable1.subtable2.fieldname")

**
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: Subrecords with subrecords

2017-10-13 Thread Lee Hinde via 4D_Tech 
Interesting idea. Thanks.

> On Oct 13, 2017, at 11:13 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Get pointers to sub_subtable_fields
> array pointer(<>Sub_sub_Field_Pointers;number_of_Sub_sub_Table_Fields)
> 
> execute 
> formula("<>Sub_sub_Field_Pointers{1}:=->[table]subtable1.subtable2.field_1_name")
> execute 
> formula("<>Sub_sub_Field_Pointers{1}:=->[table]subtable1.subtable2.field_2_name")
> execute 
> formula("<>Sub_sub_Field_Pointers{1}:=->[table]subtable1.subtable2.field_3_name")
> 
> 
> then for data extraction:
> 
> For($i;1;number of records in sub-subtable)
>  For($ii;1;size of array(<> Sub_sub_Field_Pointers))
>Text_variable :=Text_variable + utility_convert_to_Text(<> 
> Sub_sub_Field_Pointers{$ii})
>  end for
> end for
> 
> send packet(Text_variable)

**
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: Subrecords with subrecords

2017-10-13 Thread Chip Scheide via 4D_Tech 
Kirk :
yes.
if I remember the subtable syntax correctly

Execute formula("x_text:=[table]subtable1.subtable2.fieldname")

Lee 
I am not sure that this will work, but if it does it might make your 
life easier...
have 1 method (which will likely have to be hard coded) to get pointers 
to all the sub-subtable fields
populate the pointers into an inter process pointer array.
Then you can loop over them to extract data

Get pointers to sub_subtable_fields
array pointer(<>Sub_sub_Field_Pointers;number_of_Sub_sub_Table_Fields)

execute 
formula("<>Sub_sub_Field_Pointers{1}:=->[table]subtable1.subtable2.field_1_name")
execute 
formula("<>Sub_sub_Field_Pointers{1}:=->[table]subtable1.subtable2.field_2_name")
execute 
formula("<>Sub_sub_Field_Pointers{1}:=->[table]subtable1.subtable2.field_3_name")


then for data extraction:

For($i;1;number of records in sub-subtable)
  For($ii;1;size of array(<> Sub_sub_Field_Pointers))
Text_variable :=Text_variable + utility_convert_to_Text(<> 
Sub_sub_Field_Pointers{$ii})
  end for
end for

send packet(Text_variable)

On Fri, 13 Oct 2017 10:48:16 -0700, Kirk Brooks via 4D_Tech wrote:
> Tim,
> On Fri, Oct 13, 2017 at 8:50 AM, Tim Nevels via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> If I remember correctly, the 2004 method editor will show sub-subtable
>> field references, but as soon as you edit a line with the reference (or
>> maybe even retokenize the whole method) it drops the sub-subtable
>> references. So you have to replace all these lines of code with EXECUTE
>> commands. And you’ll have to write all the sub-subtable conversion code as
>> a series of EXECUTE commands for every line with a sub-subtable reference.
> 
> 
> ​Really interesting hack. ​I'm trying to visualize this - "So you have to
> replace all these lines of code with EXECUTE commands."  Do you mean
> opening the structure in 2004 will show the names of the sub-subtable
> fields so you can then write the code using that name and run it with
> EXECUTE and not choke?
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *The only thing necessary for the triumph of evil is for good men to do
> nothing.*
> 
> *- Edmund Burke*
> **
> 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
> **
---
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: Subrecords with subrecords

2017-10-13 Thread Kirk Brooks via 4D_Tech 
Tim,
On Fri, Oct 13, 2017 at 8:50 AM, Tim Nevels via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> If I remember correctly, the 2004 method editor will show sub-subtable
> field references, but as soon as you edit a line with the reference (or
> maybe even retokenize the whole method) it drops the sub-subtable
> references. So you have to replace all these lines of code with EXECUTE
> commands. And you’ll have to write all the sub-subtable conversion code as
> a series of EXECUTE commands for every line with a sub-subtable reference.


​Really interesting hack. ​I'm trying to visualize this - "So you have to
replace all these lines of code with EXECUTE commands."  Do you mean
opening the structure in 2004 will show the names of the sub-subtable
fields so you can then write the code using that name and run it with
EXECUTE and not choke?

-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

*- Edmund Burke*
**
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: Communicating With BLE Devices

2017-10-13 Thread Cannon Smith via 4D_Tech 
Hi Miyako,

The specific device we are currently connecting to is a prototype RFID reader 
for cattle. We have it working correctly on iOS using CoreBluetooth. Basically, 
when we want to connect we create a central manager which looks for a certain 
peripheral name. The peripheral only has one service (0xFFE0) which has seven 
characteristics (0xFFE1 - 0xFFE7). Some are read only, some are read/write, and 
some are subscribe-able. As soon as the connection is established we read and 
subscribe to various characteristics and then call back methods are fired when 
information comes in from the reader. Occasionally we also write something to 
one of the characteristics. Then, of course, we disconnect.

I’m hoping to bring the same functionality to the desktop versions in 4D. So it 
would need to be able scan for BLE devices. Probably a callback would be 
registered for whenever another device was found. We we see the name of what we 
want we can ask the plugin to quit scanning for devices and then get the 
services it offers. Probably another callback to receive these and then 
something similar to get a list of characteristics for a service. Then methods 
to read/write/subscribe to a characteristic with callbacks for the 
read/subscribe possibilities. And then something to tear it all down and 
disconnect. Pretty much everything has to work with callback methods because of 
timing nature of BLE.

Anyway, basically what you found, but on macOS and Windows. I was hoping 
CoreBluetooth existed on macOS and something similar for Windows. For example, 
I found a free app on the Mac App Store called Adafruit Bluefruit LE Connect 
which can see our device and discover the service and characteristics and 
assumed they were using built in frameworks, but maybe not?

Thanks.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




> On Oct 11, 2017, at 7:02 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> it seems the cross platform libraries are all cross-mobile-platforms.
> 
> couldn't find anything for desktop windows and macos.
> 
> https://developer.apple.com/documentation/corebluetooth?language=objc
> https://developer.apple.com/library/content/samplecode/TemperatureSensor/Introduction/Intro.html
> 
> https://msdn.microsoft.com/en-us/library/windows/hardware/ff536585(v=vs.85).aspx
> https://github.com/Microsoft/Windows-universal-samples/tree/master/Samples/BluetoothLE
> 
> do you have a specific peripheral in mind?
> 

**
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: Connect to MS Sql database

2017-10-13 Thread STARDATA via 4D_Tech 
The problem is that i have to put data into an associative array but sql
execute doesn't seem to work. I've created a "User DSN" and i can connect to
it trough the "External connection" window that appear if you leave the
first SQL LOGIN parameter empty. After that i have an SQL EXECUTE that
doesn't seem to work eventough the connection has been established.

Thanks for your attention and for your fast reply.



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
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: Subrecords with subrecords

2017-10-13 Thread Lee Hinde via 4D_Tech 
Thanks to all who weighed in.

I wasn't entirely clear.

They're running a compiled 2004 database. And the sub-subtable is working
'fine'. I.e., it can be accessed via the ui and the code that references it
works.

They also gave me the 2004 source code, which I'm able to open and see, in
2004. I was hoping to be able to write an export on the sub-subtable in
2004.

As Tim describes, any code that references the 2nd level won't tokenize and
throws a compiler error if I try to compile. Existing code that references
the sub-subtable 'de-tokenizes' if I touch it in 2004.

The 'put it in an execute' rings a bell and I'll start with that. Thanks!



On Fri, Oct 13, 2017 at 8:50 AM, Tim Nevels via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> > On Oct 13, 2017, at 9:20 AM, Lee Hinde wrote:
> >
> > New client with a database to update to v16. It's currently running in
> > 2004. But it has subtables with subtables, which, as I'm discovering,
> isn't
> > really supported in 2004.
> >
> > So, how did they do that? That is, run a compiled database in 2004 that
> has
> > a two level deep subtable?
> >
> > And, is there a way to reference the 2nd level in 2004?
> >
> > In v16 the 2nd level subtable isn't moved over. The field is in the 1st
> > level subtable. My goal with all this is to write something to migrate
> the
> > data.
>
> I ran into an issue with 2nd level subtables many years ago. You may need
> to do an interim update with 2004 first. Open it in 2004. Gonna be hard to
> do with macOS as you need Mac OS 9 or the old “Classic” environment in
> macOS X. Probably easier to use Windows for the 2004 version.
>
> Create new tables for the subtables and subtables of subtables in 2004.
> Write some code to move the subtable data to the new tables. But doing this
> is tricky because of the method editor. If I remember correctly, the 2004
> method editor will show sub-subtable field references, but as soon as you
> edit a line with the reference (or maybe even retokenize the whole method)
> it drops the sub-subtable references. So you have to replace all these
> lines of code with EXECUTE commands. And you’ll have to write all the
> sub-subtable conversion code as a series of EXECUTE commands for every line
> with a sub-subtable reference. Yes, this is a super big drag.
>
> So old subsubtable code is tokenized correctly and will run interpreted
> and will even compile and run. But the method editor can’t handle it. So as
> long as you don’t touch it, it will keep working. EXECUTE is your savior in
> the case where you need to fix something or write something new.
>
> Tim
>
> 
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@mac.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
> **
>
**
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: Hosting Service for Small System

2017-10-13 Thread Douglas von Roeder via 4D_Tech 
Guy:

"These guys are awesome. Been using them for about 4 years. If you use
their Enterprise plan, your hardware is covered by their Perpetual hardware
warranty."

Their pricing is very comparable to Mac Stadium but I like the "extras". In
addition to that warranty, they also offer a loaner. There's extra value in
that.

Thank you!


--
Douglas von Roeder
949-336-2902

On Fri, Oct 13, 2017 at 9:53 AM, Guy Algot  wrote:

> These guys are awesome. Been using them for about 4 years. If you use
> their Enterprise plan, your hardware is covered by their Perpetual hardware
> warranty.
>
> https://www.macminivault.com
>
> On Oct 13, 2017, at 9:25 AM, Douglas von Roeder via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> I'm working with a company that has a seven user server running on a Mac
> mini. They've decided to go "office-less" and are looking to have their
> system hosted.
>
> This is a new area to me so I'm looking for recommendations for hosting
> services. We would like to use the current Mac mini and, for a variety of
> reasons, the hosting service should be located in the continental US.
>
> Checking in on the Mac mini colo reveals that they've been absorbed by
> macstadium.com. Any comments on that service in particular?
>
> Thanks in advance.
>
>
>
> Later,
>
> Guy
>
>
> --
>
> Guy Algot, Solutions Specialist
>
> Edmonton, Alberta
>
> (780) 974-8538
>
>
> hardware, installation, training, support, programming, internet
>
> specializing in 4th Dimension
>
> =-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>
> "Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
>
> they use Borg to do their marketing and Ferengi to do their programming."
>
> -- Simon Slavin
>
>
>
>
**
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: Connect to MS Sql database

2017-10-13 Thread Randy Engle via 4D_Tech 
You have two options that I know of.

1.  ODBC
2.  ADO plugin from Rob Laveaux/Pluggers

You will, of course, need to write some SQL code and dump any data results into 
arrays.

Randy Engle, Director
XC2 Software LLC – XC2LIVE!


-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of STARDATA via 
4D_Tech
Sent: Friday, October 13, 2017 3:29 AM
To: 4d_tech@lists.4d.com
Cc: STARDATA 
Subject: Connect to MS Sql database

Hi everyone,

I'm looking for a way to connect 4d to sql server and query it as if it is a 4D 
database. Can anyone help me?




--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
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: Print From Web Area

2017-10-13 Thread Cannon Smith via 4D_Tech 
Hi Kirk,

I didn’t realize printing was an option from there. Thanks!

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




> On Oct 12, 2017, at 3:48 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I would enable the context menu and let the user invoke printing with a
> right click on the web area.
> 

**
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: Print From Web Area

2017-10-13 Thread Cannon Smith via 4D_Tech 
Hi Ortwin,

No, I haven’t tried that, but I’ll give it a shot.

Thanks!

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




> On Oct 12, 2017, at 11:06 AM, Ortwin Zillgen via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
>> What command would I use to invoke the printing in the first place?
> 
> have you tried this?
> 

**
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: Hosting Service for Small System

2017-10-13 Thread Guy Algot via 4D_Tech 
These guys are awesome. Been using them for about 4 years. If you use their 
Enterprise plan, your hardware is covered by their Perpetual hardware warranty.

https://www.macminivault.com

> On Oct 13, 2017, at 9:25 AM, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I'm working with a company that has a seven user server running on a Mac
> mini. They've decided to go "office-less" and are looking to have their
> system hosted.
> 
> This is a new area to me so I'm looking for recommendations for hosting
> services. We would like to use the current Mac mini and, for a variety of
> reasons, the hosting service should be located in the continental US.
> 
> Checking in on the Mac mini colo reveals that they've been absorbed by
> macstadium.com. Any comments on that service in particular?
> 
> Thanks in advance.
> 


Later,
Guy

--
Guy Algot, Solutions Specialist
Edmonton, Alberta
(780) 974-8538

hardware, installation, training, support, programming, internet
specializing in 4th Dimension
=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their programming."
-- Simon Slavin



**
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: Hosting Service for Small System

2017-10-13 Thread BTB-David via 4D_Tech 
Hi Doug,

We’ve used Mac Mini Colo & Mac Stadium for years.  Actually I liked the 
provisioning of Mac Stadium better than Mac Mini Colo so I was happy when they 
were absorbed.

We’ve been very happy with the service and support.  

The biggest thing I’d warn you is to use the Legacy Network Layer when going 
over the WAN (if possible).  We’ve also kept the machines at Yosemite as I’ve 
seen performance issues on the boxes when going beyond that OS version (I 
haven’t tried High Sierra yet).  The performance issues had to do with an OS X 
process taking up high CPU usage.  I could kill it but it would come back.

The other nice thing about Mac Stadium is that you can have them install 
windows on the mac if you’d prefer to run the server on windows (you need to 
give them a windows license).  Their price point is much cheaper than other 
hosting environments.

My two cents worth…

David Conley
By The Book, Inc.
Office: 815-234-7530
Direct Line: 815-406-5502
Fax: 815-234-7532
http://www.bythebook.com




> On Oct 13, 2017, at 10:25 AM, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I'm working with a company that has a seven user server running on a Mac
> mini. They've decided to go "office-less" and are looking to have their
> system hosted.
> 
> This is a new area to me so I'm looking for recommendations for hosting
> services. We would like to use the current Mac mini and, for a variety of
> reasons, the hosting service should be located in the continental US.
> 
> Checking in on the Mac mini colo reveals that they've been absorbed by
> macstadium.com. Any comments on that service in particular?








This email was sent to 4d_tech@lists.4d.com (mailto:4d_tech@lists.4d.com)
unsubscribe from this list 
(http://emailclicks.bythebook.com/track/unsub.php?u=30055319=76edb9f29fdc48898e14e6e2dcb26f07.6uKpduIsjJ%2FEqVQ1r%2BdLr66Tu1w%3D=https%3A%2F%2Fmandrillapp.com%2Funsub%3Fmd_email%3D4d_tech%2540lists.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: Subrecords with subrecords

2017-10-13 Thread Tim Nevels via 4D_Tech 
> On Oct 13, 2017, at 9:20 AM, Lee Hinde wrote:
> 
> New client with a database to update to v16. It's currently running in
> 2004. But it has subtables with subtables, which, as I'm discovering, isn't
> really supported in 2004.
> 
> So, how did they do that? That is, run a compiled database in 2004 that has
> a two level deep subtable?
> 
> And, is there a way to reference the 2nd level in 2004?
> 
> In v16 the 2nd level subtable isn't moved over. The field is in the 1st
> level subtable. My goal with all this is to write something to migrate the
> data.

I ran into an issue with 2nd level subtables many years ago. You may need to do 
an interim update with 2004 first. Open it in 2004. Gonna be hard to do with 
macOS as you need Mac OS 9 or the old “Classic” environment in macOS X. 
Probably easier to use Windows for the 2004 version.  

Create new tables for the subtables and subtables of subtables in 2004. Write 
some code to move the subtable data to the new tables. But doing this is tricky 
because of the method editor. If I remember correctly, the 2004 method editor 
will show sub-subtable field references, but as soon as you edit a line with 
the reference (or maybe even retokenize the whole method) it drops the 
sub-subtable references. So you have to replace all these lines of code with 
EXECUTE commands. And you’ll have to write all the sub-subtable conversion code 
as a series of EXECUTE commands for every line with a sub-subtable reference. 
Yes, this is a super big drag. 

So old subsubtable code is tokenized correctly and will run interpreted and 
will even compile and run. But the method editor can’t handle it. So as long as 
you don’t touch it, it will keep working. EXECUTE is your savior in the case 
where you need to fix something or write something new.

Tim


Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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
**

Hosting Service for Small System

2017-10-13 Thread Douglas von Roeder via 4D_Tech 
I'm working with a company that has a seven user server running on a Mac
mini. They've decided to go "office-less" and are looking to have their
system hosted.

This is a new area to me so I'm looking for recommendations for hosting
services. We would like to use the current Mac mini and, for a variety of
reasons, the hosting service should be located in the continental US.

Checking in on the Mac mini colo reveals that they've been absorbed by
macstadium.com. Any comments on that service in particular?

Thanks in advance.

--
Douglas von Roeder
949-336-2902 <(949)%20336-2902>
**
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: Min/Max for Date Fields in 4D

2017-10-13 Thread Alan Tilson via 4D_Tech 
Arnaud,
Your point finally caused me to realize this morning that my testing has
been on a virtual machine hosted by the same real machine that hosts the
virtual machine that runs 4D Server. So communications between my 4D Client
and 4D Server are ultra fast. I will try to test this on a computer that
utilizes the LAN and post my results.
Thank you for your input!
Alan

On Thu, Oct 12, 2017 at 6:40 PM, Arnaud de Montard via 4D_Tech <
4d_tech@lists.4d.com> wrote:

>
> > Le 12 oct. 2017 à 22:37, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com>
> a écrit :
> >
> > ​Another interesting point is that with a larger selection of 446.5k
> > records and a warm database I got:
> > 3 ticks for DV approach
> > 6 ticks for the record sorting approach
>
> Guessing… Only twice more for the record sorting approach makes me suppose
> the test is not in C/S but standalone. I wouldn't be surprised by a much
> greater difference in C/S.
>
> --
> 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
> **
>
**
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
**

Connect to MS Sql database

2017-10-13 Thread STARDATA via 4D_Tech 
Hi everyone,

I'm looking for a way to connect 4d to sql server and query it as if it is a
4D database. Can anyone help me?




--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
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
**

Connect to MS Sql database

2017-10-13 Thread STARDATA via 4D_Tech 
Hi everyone,

I'm looking for a way to connect 4d to sql server and query it as if it is a
4D database. Can anyone help me?




--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
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: v13 - odd compiler error

2017-10-13 Thread Nigel Greenlee via 4D_Tech 
Chip

Ah..The joy of auto declared variables removes this problem for me..so much 
that when i work on databases that don’t do the declarations for me it is a 
pain.

Nigel Greenlee

> On 12 Oct 2017, at 22:36, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> well your "friend"  ;) was right...
> DUH!
> c_pointer($43;
> 
> of course, I have copy pasted, into a new method window, deleting the 
> original, compacted, and had *just* finished manually retyping the 
> method (not long fortunately)...
> 
> 
> 
> On Thu, 12 Oct 2017 10:26:01 -1000, David Adams via 4D_Tech wrote:
>> Check if there is a typo and you've declared $43 instead of $3. The errors
>> you describe are almost exactly what I would expect in this case. Not that
>> I've ever done anything like that...but it happened to a friend once or
>> twice.
>> **
>> 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
>> **
> ---
> 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
> **

**
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
**