truegold | 3 Sep 00:59 2014

Re: PROCESS HTML TAGS (PROCESS 4D TAGS)

Hi Jaime, Keisuke, and Sir Thomas M,

> As of today we recommend to copy the QUERY code into a 4D method and call it using 4DSCRIPT (to run the query).
> Note that you can pass parameters to the method, in case you need sometimes to query for other values than 0.

Thanks for the direction. I had started that way but still generated the errors. Anyway, I fixed the method,
called it, and error has gone away.

> Yes, but only if you are running in Unicode mode.

Uggh, I thought I was set for unicode but I wasn't. Thank you!

Appreciate,
John...

--------------------------------------------------------------

John Foster 
Eternity Software
425-486-1622

 http://www.eternity-software.com	

This e-mail contains confidential & proprietary information intended for the use of the original
addressee.  If you are not the addressee you are hereby notified that any dissemination or other action in
reliance upon this communication could result in legal liability to you and your Organization.

--------------------------------------------------------------

**********************************************************************
(Continue reading)

Steve Makohin | 2 Sep 22:03 2014
Picon

Suspect bug in v13.5: QUERY always case-sensitive when uising key value >30 chars?

Hello everyone,

I have what *appears* to be 4D v13.5 defect that can be duplicates as
follows:

1. Create a [Table] record where [Table]Name="Tfirstname Tmiddlename
Tsurname" [mixed case, 31 chars]
    The table's field is A80, indexed B-Tree

2. QUERY in code:
       QUERY([Table];[Table]Name="TFIRSTNAME TMIDDLENAME TSURNAME")
    [Same string but upper case, 31 chars]

3. BUG: 0 records found.

4. QUERY for it in code:
       QUERY([Table];[Table]Name="TFIRSTNAME TMIDDLENAME TSURNAME <at> ")
    [Upper case, same name, 31 chars]

5. BUG: 0 records found.

The same query using the QUERY dialog finds the records. Also, the following
queries in code do work:

QUERY([Table];[Table]Name="TFIRSTNAME TMIDDLENAME TSURNAM <at> ")

[30 chars + wildcard]

QUERY([Table];[Table]Name=" <at> TFIRSTNAME TMIDDLENAME TSURNAME <at> ")

(Continue reading)

Steve Monteith | 30 Aug 18:14 2014

[Off] Web App Developer

Raleigh based software company located on the North Carolina State University
Centennial Campus has a job opening for a full-time Javascript programmer. 

The position will involve working on an agile development team that is
developing a web application for a top notch university. The web application
is being developed using Wakanda/4D Mobile. Self-motivated and focused, as a
Web Application Developer, you must be team-focused and flexible with
excellent communication skills and a creative approach. 

Desired Skills and Experience:

- Javascript
- jQuery
- CSS
- HTML5
- Self-motivated, goal-oriented with the ability to multi-task with little
supervision
- Strong work ethic & proven track record in meeting deadlines
- Must be able to work collaboratively with other team members during
projects

Bonus Skills: 

- Wakanda
- 4D
- Responsive Design
- UX Designer

Application Process

(Continue reading)

truegold | 2 Sep 05:00 2014

PROCESS HTML TAGS (PROCESS 4D TAGS)

Hey All,

Using 4D v12, in an upgraded application, but similar result in 4D v14...

Tried with the following compatibility setting "Use 4DVAR Comments instead of Brackets" enable as well as
disabled. Seems to have no effect.

Trying to get PROCESS HTML TAGS to work properly. Keeping it simple and baby stepping using sample 4D code as
my model from Mastering 4D TAGS. 

Problems (see code, html template, and results html below):

1. The <!--#4DIF returns a boolean error, with the test or without.

2. Auto converts "<" to &lt; and ">" to &gt; ???

3. Seems to limit the text file to 32k chars (v11 and beyond no limit right?).

Anyone give me a clue as to the reason for these results?

Appreciate,
John...

4D Method:

C_TEXT($path_t;$pathSaveTo_t;$inputText_t;$outputText)
C_BLOB($template_x;$processed_x)

$path_t:=SMBL_HTML_GetPath ("SMBL_Template.shtml")

(Continue reading)

Claudio Braga | 1 Sep 12:42 2014
Picon

Convert a mail subject header

Hello everyone, 

I need to get a readable subject string from a bunch of email files (.eml or source), the header line looks
like this

Subject: =?iso-8859-1?Q?Conferma_ordine_N=B0_40=2E986?=

I’ve tried several methods but I must miss something , the only thing I haven’t tried is convert to text,
as the actual v12 database is running in ascii compatibility mode, therefore it doesn’t work.

I can't find any 4D command that can help me here, then I’ve given a try to the textutil command in osx
terminal but It doesn’t seem to work either.

So , how can I treat this string to get a readable result ? Any hint ?

Thank you in advance

Ciao

Claudio Braga
**********************
claudiobraga@...
claudiobraga@...
**********************

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

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

Peter Hay | 1 Sep 04:52 2014
Picon

Setting a WEDD signature

Hi,

I'm trying to set a WEDD signature, but I can't get it to work.

This is the code I'm running;
SET DATABASE PARAMETER(WEDD Signature;"MyApp")

But I can still open any data file, so the WEDD isn't working, and when I
run this;
$l_Result:=Get database parameter(WEDD Signature;$t_WEDD)

$t_WEDD is empty.

I'm sure I'm missing something obvious. Anybody know what it is?

Thanks,
Pete Hay

--

-- 
Pete Hay
Managing Director
Foreground Software Limited
New Zealand
**********************************************************************
See how easy it is to extend your 4D solutions to Web and mobile. New opportunities await you with 4D v14!

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
(Continue reading)

David Ringsmuth | 31 Aug 04:47 2014
Picon

4D Server as a Service SQL Login to MS SQL Server

WS2008 R2 SP1 64Bit
4D Server v13.5.163497 64Bit
MSODBCSQL11.dll 64bit
MSSQL 2008

When I run 4D Server as a SERVICE the SQL Login to MS SQL fails.

When I run 4D Server as an APPLICATION the SQL Login to MS SQL works and
subsequent SQL commands work.

Is this a bug that 4D running as a service does not correctly connect to MS
SQL using the OS ODBC connection?

This does not the ODBC plugin, but the OS ODBC driver.

Thanks,
David Ringsmuth

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

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

Bertrand SOUBEYRAND | 30 Aug 11:41 2014

Autocompletion in a listbox cell

Is it possible to use autocompletion in a v14 listbox cell?

HIGHLIGHT TEXT in a cell seems to be a feature for 4D v17

Thank you

Bertrand SOUBEYRAND
---
La Soub Compagnie
33 bd de la Liberté - 13001 Marseille
Bureau : +33 4 84 25 21 99
http://www.soub.org/

Bureau Belgique : +32 87 84 00 88

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

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

Jacques Chatenay | 30 Aug 00:21 2014
Picon

Sorting a text field in numeric order

I have a situation where my client wants to store that an ID number in a
field the ID numbers are always digits 1-0 but  the catch is that the Id
number sometimes begins with a 0 like 025687 so I am left with storing the
data in a text or string field no problem so far.

Now the client wants to have the records sort in numeric order 1 2  10 20
100 200 not 1 10 100 2 20 200 as text fields normally sort.

I thought about sorting using ORDER BY
FORMULA([Table_1];Num([Table_1]Field_1)) but I am afraid that that will be
very slow and it will not put the items that start with 0 at the top

The selection of records will be relatively small a few thousand and I can
most likely get them to accept that the  items that start with 0 will not
be at the top so ORDER BY FORMULA should not be to bad but I would like to
give them what they want if at all possible.

Am I missing something simple I hope.

I am using V13

Any help would be appreciated

Thanks

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

4D Internet Users Group (4D iNUG)
(Continue reading)

Richard Wright | 29 Aug 23:36 2014

Re: Duplicated Key error

id_added_by_converter is the foreign key, so it is not unique. 4D does not add a unique primary key to subtables.

Even if it is an internal 4D timing issue, the last thing I would want to do is call Delay Process in a trigger
for hundreds of subrecords.

> Date: Fri, 29 Aug 2014 09:24:12 -0400
> From: Chip Scheide <4d_Only@...>

> doesn't the 'subtable' have its own, internal to 4D, ID?
> could it be that this is where the problem is?
> 
> Since there are 2 errors, rather then the expected 1, maybe the batch 
> processing is too fast for some internal locking mechanism on that ID.
> 
> maybe a DELAY PROCESS (current process;1) would resolve it....

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

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

Douglas von Roeder | 29 Aug 23:31 2014
Picon

Using Runtime Explorer to Catch a Field Value being Cleared

I'm trying to use the "Catch" feature in the Runtime Explorer to alert me
when a field value is cleared.

The Design Reference and LR discuss catching commands I don't see anything
on evaluation a function.

In this case, I'm trying to catch a function a la:

$0:=([People]First_Name="")

Can anyone give me some guidance on this or point me to the docs that
describe how to do this?

¡Muchas graçias!

--
Douglas von Roeder
949-336-2902
**********************************************************************
See how easy it is to extend your 4D solutions to Web and mobile. New opportunities await you with 4D v14!

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


Gmane