gmane.comp.lang.inug-4d.tech

Re: SQL Subquery example?

Tony Ringsmuth — 2013-05-21T20:10:20

Justin,


On 5/21/13 9:54 AM, "Justin Will" <jwill-6WREZh/pINaakBO8gow8eQ< at >public.gmane.org> wrote:
Yes:  I knew that: what would other SQL engines do: return the ID of the
first found child.ID?  That's what I was hoping for.

I thought that might be the case.

I wish 4D was more robust in SQL.

I've created a feature request as:
http://forums.4d.fr/Post//12790189/1/

Thanks!

--
Tony Ringsmuth
Business Brothers Inc.
763-420-8686



**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: FULL SCREEN

Keith Culotta — 2013-05-21T20:07:54

One of my customers uses the Mac's Parental Controls to restrict the users' wanderings. 

Keith
Computer Dimensions, Inc. 

On May 21, 2013, at 2:11 PM, Doug Cottrill <dkc-SiTW4nCLoMglk5EcyZIkJQ< at >public.gmane.org> wrote:



**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: Four lines of code onto one line. Why?

Bruno LEGAY — 2013-05-21T12:26:13

Hi,

Interesting subject :-)

One line is not necessary faster... 

Especially when compiled. This is a good example :-)

Benchmark code :

C_LONGINT($vl_nbMillisec;$vl_count)

C_TEXT($vt_text;$vt_buffer)
$vt_text:="aa\r\n"*10000
$vt_buffer:=""

$vl_nbMillisec:=Milliseconds
$vl_count:=TXT_countInText ("\r\n";$vt_text;False)
$vl_nbMillisec:=Milliseconds-$vl_nbMillisec
$vt_buffer:=$vt_buffer+"function (non diacritical) : "+String($vl_count)+" found in "+String($vl_nbMillisec)+"ms"+"\r"

$vl_nbMillisec:=Milliseconds
$vl_count:=TXT_countInText ("\r\n";$vt_text;True)
$vl_nbMillisec:=Milliseconds-$vl_nbMillisec
$vt_buffer:=$vt_buffer+"function (diacritical) : "+String($vl_count)+" found in "+String($vl_nbMillisec)+"ms"+"\r"

$vl_nbMillisec:=Milliseconds
$vl_count:=(Length($vt_text)-Length(Replace string($vt_text;"\r\n";"")))\2
$vl_nbMillisec:=Milliseconds-$vl_nbMillisec
$vt_buffer:=$vt_buffer+"one liner : "+String($vl_count)+" found in "+String($vl_nbMillisec)+"ms"+"\r"

SET TEXT TO PASTEBOARD($vt_buffer)

Result

Re: FULL SCREEN

Doug Cottrill — 2013-05-21T19:11:59

In some instances, you want to keep the user from switching applications or see the desktop (or quit the program).  Think of a kiosk application- I suspect that is what is being requested here.  I think WinAPI can do this, but have never had the need.

DKC

On May 21, 2013, at 12:43 PM, Charles Miller wrote:



--------------------------
Doug Cottrill
PTM Software, LLC



**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: FULL SCREEN

Scott Gelvin — 2013-05-21T18:45:30

Ferdinando,

On May 21, 2013, at 9:43 AM, stardata.info <stardata-GqsWfeXCFFwk+I/owrrOrA< at >public.gmane.org> wrote:


We use a 4D app as an HDTV dashboard, and used Jeff Kain's Win32API plugin to suppress the window title bar and the Task bar to take full advantage of just about every pixel of space for our form. (FWIW, it's easier on Mac; didn't need a plugin!)


Scott Gelvin
Footprints, Inc.
4D specialists since 1987




**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: Four lines of code onto one line. Why?

Doug Hall — 2013-05-21T18:42:25

Incidentally, I also write comments about what the following block of code
will do. I do that all the time, and completely agree with that part of
your statement.


On Tue, May 21, 2013 at 1:35 PM, Doug Hall <doughalldev-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:


**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: Four lines of code onto one line. Why?

Doug Hall — 2013-05-21T18:35:13

Tim, I agree on the surface that comments are often necessary, but I stand
by what I said. Let's look at my own example:

$Number_L:=Length($string)-(Length(Replace string($string;",";""))

is not NEARLY as clear or as useful as

$Number_L:=str_CountNumberOf($string;",") // or something similarly
(clearly) named.

The first line is Chuck's one liner, copied directly from his message. It
needs a comment. BADLY. The third line is what I proposed in its place (and
it's what Charles clarified that he would do too.) Here's my question to
you. What is it about my third line that needs a comment? Inside the
method, maybe a short comment is needed. But even then, if the method is
simple enough and named well enough, it needs (as I quoted) "little or no
commenting". I've often found that when I can't come up with a good name
for a method, that's an indicator that I didn't refactor that method well
enough to begin with. Yes, you'll still occasionally have complicated
methods. When that happens, comment them. But don't

Re: Four lines of code onto one line. Why?

Tom Benedict — 2013-05-21T16:54:15

So if you shave off 10 milliseconds from each iteration will it finish before it starts?   ;)

Tom Benedict
Alere Wellbeing, Inc



**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: FULL SCREEN

Charles Miller — 2013-05-21T16:43:46


I do not think you can or want to eliminate the window or mac menu bars.
You will limit navigation between applications and while on windows that
take up more space, I can not see why you would need it. Just get a bigger
monitor and stick with useable area

Chuck

Regards

Re: Four lines of code onto one line. Why?

Charles Miller — 2013-05-21T16:40:04



Ah the difference between procedural based languages and object based one.
Procedural languages (4D, Cobol, ) are pretty self documenting C++ on the
other hand is not.

Regards


Chuck

Re: Four lines of code onto one line. Why?

Tim Nevels — 2013-05-21T16:35:06


I have to disagree with that comment.  Good code BEGINS with good comments. 

I think of writing a block of code like writing a paragraph. Remember what they taught us in school that the first sentence of a paragraph should be a summary of what the paragraph is about. 

So first write a comment line about what the following block of code is supposed to do. Then write the block of code. Add more comments as needed to the lines of code. Example:

// Clean up the data before processing
$data_t:=Replace String($data_t;"  ";" ")   // replace double spaces with a single space
$data_t:=Replace String($data_t;",";"")   // strip out commas

Tim

********************************************
Tim Nevels
Innovative Solutions
785-749-3444
timnevels-Uj//cgyaSZJ54TAoqtyWWQ< at >public.gmane.org
********************************************


**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.co

re:insert listbox columns and setting column header

Laura Mayer — 2013-05-21T16:17:09

Thanks Jeremy I'll take a look.

**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: insert listbox columns and setting column header

Jeremy Roussak — 2013-05-21T16:03:33

The header is a button, so you use whatever command was used in v11 to set the text of a button. I forget what it was, I'm afraid. BUTTON SET TITLE, perhaps?

Jeremy


Jeremy Roussak
jbr-ee4meeAH724< at >public.gmane.org

On 21 May 2013, at 16:55, Laura Mayer <mayer4-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:



**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: Four lines of code onto one line. Why?

Terry Pierce — 2013-05-21T16:01:16

A millisecond is one thousandth of a second.

If I may cite an example, I'd point to a recent experience that I've had.  Working on a system in which 60,000 records were being used to populate an array based listbox.  The initial population time for this listbox was a bit over 10 minutes.  In the loop to create the arrays, records were being queried, comparisons and mathematical calculations were being run.  There were about 1500 lines of code in the loop.  For every 1 millisecond you can save in running this, you will save 1 minute of execution time.  That's what I meant when I said a few milliseconds here, a few milliseconds there….

On the other hand, for the original example (one line versus 4 lines), there isn't a measurable difference between the two.


On May 21, 2013, at 6:58 AM, Peter Bozek <peter.bozek-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:



**********************************************************************
4D v13 is available now - with more than 200 new features to make
your appl

insert listbox columns and setting column header

Laura Mayer — 2013-05-21T15:55:10

Morning,

I looked around the forum and found some examples on how to set the column
header after you set up the listbox column using:

$last:=Get number of listbox columns(*;"lb_SireInfo")+1
INSERT LISTBOX
COLUMN(*;"lb_SireInfo";$last;"Column4";atAI_Field4;"Field4";vtFieldName4)

I am only on v11 SQL so the command Object Set title is not a choice. Is
there a way in v11 to do this? The column gets set fine with the contents
of the array but I can't see to get the header set.

Thanks

Laura

**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

FULL SCREEN

stardata.info — 2013-05-21T15:43:46

Hi all,

I need to use 4d on the all screen on the windows.
I possible at the open of the 4d application hide the windows bar
and work with the 4d application on the full screen?

Thanks
Ferdinando

**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

SQL Subquery example?

Bart Davis — 2013-05-21T15:36:24

Sorry for the bad news, but 4D can't handle subqueries like that.  Been there, done that.

You can rewrite the query as:

select p.last_name, c.id
from parent p, child c
where c.parent_id = p.id
order by p.last_name




On May 21, 2013, at 7:55 AM, 4d_tech-request-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org wrote:



**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: Four lines of code onto one line. Why?

Jorge — 2013-05-21T13:16:50

bikeshed party!

Re: [OFF] Coming to (the west coast of) America

Keith White — 2013-05-21T09:47:34

Thanks to all who replied on this list and privately, that is excellent.

Best regards

Keith White
Synergist Express Ltd, UK



**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: [OFF] Coming to (the west coast of) America

Jeremy Roussak — 2013-05-21T07:24:42

It depends on your interests, of course. I am a photography nut, so that part of the world is a Mecca.

Death Valley National Park is one of the most beautiful places I have seen, although it might be a little on the warm side in July. The dunes near Stovepipe Wells at sunset, and Zabriskie Point at dawn, are amazing: I took more photographs worth keeping in two hours at the dunes than I normally manage in a week. Stay in the ranch rather than the hotel, unless you've money to burn. Between DVNP and Los Angeles is Joshua Tree, which is worth a visit.

If you have the time (it's a good drive from Las Vegas, in the opposite direction to most of your trip), the North Rim of the Grand Canyon is awe-inspiring, particularly Cape Royal at dawn. You'll be lucky to get a room at Bright Angel Lodge at such short notice, though.

Near Las Vegas, Red Rock Canyon and the Valley of Fire State Park are impressive.

The concrete jungle that is LA is one of my least favourite places, but I know lots of people like it.

The c

RE: SQL Subquery example?

Justin Will — 2013-05-21T14:54:32

Tony,

Well the first thing I see here is your current subquery could return more
than 1 row this so that would potentially be a problem.

This query would work in most  other SQL engines in some rendition but 4D's
SQL implementation is very limited and buggy as compared to most other
databases I have every used such as MySQL, MSSQL, Postgres etc.

SELECT Parent.Last_Name, (select ID from Child where Child.Parent_ID =
Parent.ID Order By Child.ID ASC LIMIT 1) as FirstChildID FROM Parent

I don't think 4D supports subqueries in the select list.  Major missing
feature in my book.



This query would get you the first child for an individual parent.

Select Last_Name, Child.ID as FirstChildID from Parent Inner Join Child on
Parent.ID = Child.Parent_ID
Where Parent.ID = :$parentID
Order By Child.ID ASC
Limit 1

HTH
Justin


-----Original Message-----
From: 4d_tech-bounces-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org [mailto:4d_tech-bounces-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org] On
Behalf Of Tony Ringsmuth
Sent: Mond