Re: v17 kind of gotcha

[Keisuke Miyako via 4D_Tech]

in addition to accidental duplicates by SQL,
it was also possible to end up when a listbox is grouped, duplicated and 
ungrouped. (ACI0069120 fixed in 12.6)
also possible for headers and footers via OBJECT DUPLICATE (ACI0083469, fixed 
in 15.1 HF1)

MSC added checks for duplicate object names (see v13 upgrade reference page 90)

http://download.4d.com/Documents/Products_Documentation/LastVersions/Line_13/VIntl/PDF_Format/4D_v13_Upgrade.pdf

2018/12/06 8:17、Arnaud de Montard via 4D_Tech 
<4d_tech@lists.4d.com>のメール:

I remember that bug, I had to rename listbox columns filled with "SELECT ... 
INTO listbox":

bug ACI0096810, fixed here:




**
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: v17 kind of gotcha

[Arnaud de Montard via 4D_Tech]

> Le 5 déc. 2018 à 19:18, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> I know one should never have two objects on a form with the same name. I have 
> code that creates list boxes on forms. In v16 compiled or source, I get no 
> errors. In v17 I get error as I had named columns the same thing on multiple 
> pages in different list boxes on the same form

I remember that bug, I had to rename listbox columns filled with "SELECT ... 
INTO listbox":

bug ACI0096810, fixed here:


-- 
Arnaud de Montard 




**
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: [ANN] Service disruption Today @ noon PST - back online now

[Timothy Penner via 4D_Tech]

Everything should be back to normal now.

-Tim





-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Timothy Penner via 
4D_Tech
Sent: Wednesday, December 05, 2018 9:49 AM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Timothy Penner 
Subject: [ANN] Service disruption Today @ noon PST

Hi All,

Today starting at 12:00 PM noon PDT / 7 PM UTC we will be performing an upgrade 
of our fiber optic circuit and router at the 4D Inc office. The service 
disruption is expected to last less than between 1-2 hours (hopefully no longer 
but it is possible).

During this time, both internet & phone service in the San Jose office will be 
interrupted. This will also cause the following websites to be temporarily 
unavailable:

• kb.4d.com
• lists.4d.com
• services.4d.com
• partnercentral.4d.com

We hope to have everything back up and running quickly, so please bear with us 
as this brief disruption may affect other sites within the 4D.com network.

-Tim








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

v17 kind of gotcha

[Chuck Miller via 4D_Tech]

I know one should never have two objects on a form with the same name. I have 
code that creates list boxes on forms. In v16 compiled or source, I get no 
errors. In v17 I get error as I had named columns the same thing on multiple 
pages in different list boxes on the same form

Regards and hope this helps someone else

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. 

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

[ANN] Service disruption Today @ noon PST

[Timothy Penner via 4D_Tech]

Hi All,

Today starting at 12:00 PM noon PDT / 7 PM UTC we will be performing an upgrade 
of our fiber optic circuit and router at the 4D Inc office. The service 
disruption is expected to last less than between 1-2 hours (hopefully no longer 
but it is possible).

During this time, both internet & phone service in the San Jose office will be 
interrupted. This will also cause the following websites to be temporarily 
unavailable:

• kb.4d.com
• lists.4d.com
• services.4d.com
• partnercentral.4d.com

We hope to have everything back up and running quickly, so please bear with us 
as this brief disruption may affect other sites within the 4D.com network.

-Tim








**
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: View Pro

[Jeremy French via 4D_Tech]

Hi Jeremy,

I believe 4D View Pro is actually a 4D web area.

The 4D View Pro spread sheet is based on SpreadJS.

SpreadJS documentation (difficult to read) is at:
http://help.grapecity.com/spread/SpreadJSWeb/webframe.html#welcome.html

You can use the command WA Evaluate JavaScript to do some limited things, like 
setting and getting cell values, formatting and so on.

Here’s an example of using JSON and a single JavaScript line to place data in 
4D View Pro:
http://help.grapecity.com/spread/SpreadJSWeb/webframe.html#scbindadd.html

Here’s another example using several “single” lines of JavaScript to place data 
in 4D Pro. See commented example "or use bindColumns to bind all custom 
columns”.

https://www.grapecity.com/en/demos/spread/JS/TutorialSample/#/demos/sheetLevelBinding

For individual cell set/get see:
http://help.grapecity.com/spread/SpreadJSWeb/webframe.html#scvalue.html
http://help.grapecity.com/spread/SpreadJSWeb/webframe.html#scgetvalue.html

As for 4D documentation, see this post from Laurent Esnault at 4D:
http://forums.4d.com/Post/FR/26665847/1/26673658#26673658

There are a few helpful 4D View Pro examples at blog.4d.com. Search for “View”.

- Jeremy French



> On Dec 5, 2018, at 9:25 AM, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I’ve never used View before. Older versions than v17 seem to have a suite of 
> PV commands for getting and setting cell values and so on. They aren’t listed 
> in the 4D View Pro documentation. What am I missing? (something obvious, I’m 
> sure).
**
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: [TIP]: Esoteric method for calculating Excel column references

[Arnaud de Montard via 4D_Tech]

> Le 2 déc. 2018 à 00:00, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> I had need to calculate column references for an Excel spreadsheet for
> columns greater than 26. You know, so you can come up with the reference
> like: A1:AG1.

Hi Kirk, 
I had the same problem in the past… I used a similar solution, but recursive: 

++
  //Utl_spreadsheetColumn (column_l) -> text
  //convert column number to spreadsheet reference
C_TEXT($0;$out_t)
C_LONGINT($1;$unit_l;$base_l;$column_l)
  //_
$out_t:=""
Case of 
: (Count parameters<1)
  //nope
: ($1<1)
  //nope
Else 
$column_l:=$1
$unit_l:=(($column_l-1)%26)+1
$base_l:=($column_l-1)\26
If ($base_l>0)
$out_t:=Utl_spreadsheetColumn ($base_l)+$out_t
End if 
$out_t:=$out_t+Char($unit_l+64)
End case 
$0:=$out_t
++

unit test:
++
APPEND TO ARRAY($col_al;1)
APPEND TO ARRAY($ut_at;"a")
APPEND TO ARRAY($col_al;26)
APPEND TO ARRAY($ut_at;"z")
APPEND TO ARRAY($col_al;27)
APPEND TO ARRAY($ut_at;"aa")
APPEND TO ARRAY($col_al;702)
APPEND TO ARRAY($ut_at;"zz")
APPEND TO ARRAY($col_al;703)
APPEND TO ARRAY($ut_at;"aaa")
APPEND TO ARRAY($ut_at;"aaa")
APPEND TO ARRAY($col_al;1024)
For ($i_l;1;Size of array($col_al))
$ref_t:=Utl_spreadsheetColumn ($col_al{$i_l})
ASSERT($ref_t=$ut_at{$i_l})
End for 
++

-- 
Arnaud de Montard 




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

View Pro

[Jeremy Roussak via 4D_Tech]

I’ve never used View before. Older versions than v17 seem to have a suite of PV 
commands for getting and setting cell values and so on. They aren’t listed in 
the 4D View Pro documentation. What am I missing? (something obvious, I’m sure).

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: Publishing a DB on the WWW. Howto.

[Pat Bensky via 4D_Tech]

Thanks Tim.
Actually we do already use Wix for our website (catbase.com) and one other,
but haven't tried the database integration tools yet.
Yes there are some limitations, but we've found workarounds for everything
we needed to do so far. For example, we wanted to embed videos from Wistia
instead of YouTube, and Wix tech support people said it couldn't be done.
But it was actually quite easy to do with a bit of HTML
I will report back on the database integration aspect after I try it in
case anybody is interested.
Pat

On Tue, 4 Dec 2018 at 21:32, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> On Dec 4, 2018, at 2:00 PM, Pat Bensky wrote:
>
> > We've been looking into ways to make it easy for our customers to build
> > custom websites using data from our 4D app (CatBase). I'm quite
> interested
> > in the Wix solution but haven't had time to properly look into it.
> Anybody
> > tried this?
> >
> > Basically, you can create a database on your Wix website and populate it
> by
> > importing a csv file (AFAIK this is the only upload format currently
> > supported). They also have an API which will probably offer much better
> > opportunities for integration but I haven't looked into that yet.
> >
> > Then you can build your website interface using their excellent tools -
> no
> > coding required. Create interactive forms, edit the database, etc. So the
> > 4D developer doesn't need to know more than the basics of web
> > design/development and can focus on what they know best ... 4D coding :)
> > And the end-user should be able to easily create their website or you
> could
> > offer that as an additional service.
> >
> > All theoretical of course. It's something I hope to find time to
> experiment
> > with soon (a nice little Christmas holiday project, perhaps!).
>
> Hi Pat,
>
> I just did a Wix database for a friend and it is pretty good. Great
> development tools for the average guy. WYSIWYG for the most part. Has many
> features. Full mobile support so it will adapt to tablet or phone or
> Desktop. So that’s a big plus. Has may tools for the store for managing
> contacts and processing orders. Great integration if you are doing a
> shopping cart for credit card processing with Stripe and also easy PayPal.
> Lot of options for easy coupon support, and “it’s on sale 20% off” type
> things.
>
> Has a mini database of course, but I did no integration work. No export or
> import work or connecting to 4D. The project was just set up a website with
> a store for a friend that wanted it to look very, very nice and have full
> iPhone and iPad support. Wix satisfied all of that.
>
> You’ll find it a pleasure to use and very beautiful. Great iPhone app that
> lets you deal with “chat” from the website in real time if you want to
> offer that feature. Only thing is you can only do what Wix lets you do.  If
> they have a button for it, or a menu item for it, or an option for what you
> want, you can do it, and it’s easy. If you want to do something it doesn’t
> provide, it’s super hard or you just can’t.
>
> So keep that in mind. As a 4D developer sometimes that is a hard pill to
> swallow. We usually get our way and build whatever we want/need. With Wix
> you use their tool. It is a website creation for mere mortals, not
> hard-core developers.
>
> I would recommend you get a free Wix account and try it out over the
> holidays. Spend some hours building a site and see if you like it and it
> does what you want. It is super popular so there is a lot of help and
> examples on the web. You may find out how to do automate database
> integration. Someone may have already done the hard work and you can read
> how they did it can copy it. You can upgrade to the paid version later if
> it meets your needs.
>
> Tim
>
> *
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@mac.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
> **



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