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

{plain} BitTorrent Sync & 4D

James Brown — 2013-05-24T00:25:52

Has anyone had any experience with BitTorrent Sync and 4D datafiles?

I heard that it worked in 4MB block sizes and would only re-transmit those blocks if they changed. But to me it seems to re-upload the entire datafile each time.

Or does 4D somehow make changes everywhere? (4D Client was not doing anything. This was our Disaster Recovery system, which was just sitting there - client was connected but not being used).

Any thoughts?

Thanks,

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

Event publishing from 4D

Bill Weale — 2013-05-23T21:48:21

Is anyone publishing a "calendar" from 4D that iCal, Outlook etc. clients can subscribe to?

If so, how are you doing it?

Thanks,

Bill

envoyé par ma Etch-a-Sketch
R.I.P.  Andre Cassagnes
**********************************************************************
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
**********************************************************************

External SQL Database connection question

Bob McKeever — 2013-05-23T19:06:18

4D V11.9, Mac.

I need to make a DSN entry for a Microsoft SQL Server running on a PC. Running V11 on the same machine as the SQL server, with a DSN Entry, all the 4D code works fine. I just need to connect from a Mac.

_________________________________________
Bob McKeever                      http://www.mswl.com
McKeever's Software Wizardry
Maple Ridge, B.C.
bobmckeever-ee4meeAH724< 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.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
**********************************************************************

Upgrading computers still wanting to use 4D2003 help!

James Knight — 2013-05-23T07:53:18

Hi

I've been asked to help with a system I wrote 10 years ago using 4D 2003. This runs on a small network using Mac PPC computers.

At least one of these computers now needs to be upgraded to an Intel Mac.

I think this means that they can no longer use 4D Client 2003?

However they cannot afford the client/server upgrade costs plus the potential development time which might be involved in porting the 2003 database to a more recent version.

Does anyone have any tips or ideas which could help us to run 4D Client 2003 on an Intel Mac?

Hope someone can help

cheers

James 


James Knight

james< at >waveneyrivercentre.co.uk
07860-599015



Waveney River Centre

The Norfolk Broads National Park's
Premiere Holiday Park & Marina

David Bellamy Gold Conservation Award 2009 - 2012/13
The Yacht Harbour Association 5 Gold Anchors
Practical Boat Owner Green Award 2010 (Marine Service & Support)
Winner EDP Norfolk Tourism Best Caravan or Holiday Park Award 2010
Winner EDP Norfolk Tourism Best Broads Holiday Experience 2010
Winner EDP Norfolk Tourism Customer Care Award 2010

Tel: +44 (0) 1502-677343
Fax: +44 (0) 1502-677566
Email: info< at >waveneyrivercentre.co.uk

Find us on the web: http://www.waveneyrivercentre.co.uk

Waveney River Centre is home to the world's largest steel pike, we believe - get all the latest news on Eddie's blog - http://www.afishcallededdie.com/ 

Eddie on Facebook - http://www.facebook.com/afishcallededdie
Eddie on Twitter - http://twitter.com/fishcallededdie

Waveney River Centre (2003) Ltd.

UK Company registration number 4887417.
Registered office: Bankside 300, Peachman Way, Broadland Business Park, Norwich NR7 0LB
VAT registration number GB 823 9428 15

The information contained in this email is intended only for the person or organisation to which it is addressed. If you have received it by mistake, please disregard and notify the sender immediately. Unauthorised disclosure or use of such information may be a breach of legislation or confidentiality and may be legally privileged.
Waveney River Centre (2003) Ltd.

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

Debugger Problems

Stephen J. Orth — 2013-05-22T15:51:30

I was doing some testing on my V13 database which involved having to change
screen resolutions. Basically, I had to reduce my resolution to ensure the
logic worked correctly.

While doing this, the debugger opened, and when I went back to my normal
resolution, the window is sort of messed up.

In the code pane, I no longer have a vertical scroll bar, it's just gone.
I'm unable to scroll through code while debugging.

How do I get this fixed?

*********************************************
  Stephen J. Orth                                                
  The Aquila Group, Inc.         Office:  (608) 834-9213
  P.O. Box 690                           Mobile:  (608) 347-6447
  Sun Prairie, WI 53590

  E-Mail:  s.orth-rh6yEg8ZcI5wjJYsA5hikVaTQe2KTcn/< 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.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
**********************************************************************

Debugger Watch Panes

Welsh Harris — 2013-05-22T15:32:12

Can anyone tell me how to change the font size for the text displayed in the debugger watch panes (ie Expression, Value, Call Chain, and Expression)?

I'm using v12 and can't seem to find a pref that effects that.

Thanks,
Welsh



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

Why is Progress Set Progress so slow on 4D Remote?

Kirk Brooks — 2013-05-22T15:30:57

Has anyone noticed this? I just noticed this while troubleshooting a very
slow update process. Consider this simple little loop:

$n:=5000
$prog_id:=THERM_start

For ($row;1;$n;1)
    Progress SET PROGRESS ($prog_id;$row/$n)
End for

THERM_END ($prog_id)


Therm_start and _end are just wrappers - they don't affect anything.
Running on 4D Local the time to run is a couple of seconds. Running the
same code on the same machine in a client using 4D Server and it takes a
long time - like a few minutes.

This is an un-compiled app. I don't get why this should take so long. I
expect the progress actions to be happening on the local machine (which has
plenty of memory) so I just don't get why it moves so slow.

A) is there anything I can do about it?
B) what's the dang deal?

Simple jQuery question

Kirk Brooks — 2013-05-21T22:05:27

I have an html doc in the web folder for 4D web server. I'm working on a
local copy for development. If I open the html doc in a browser everything
looks as I expect it to and some javascript runs as expected.

If I open this same document through the web server it doesn't. It seems
the javascript doesn't run. I'm thinking I need to provide some information
to the 4dD web server about where to find some resources but don't really
understand what it's going to need.

Can someone help me out with this? Thanks much

Check TCP port in use

Joshua Hunter — 2013-05-21T21:06:28

We are trying to use 4D's php interpreter, but are running into problems when the port is already in use by another application.

What is the best/fastest/most reliable way to check if a port is in use so I can alert the user? I'm hoping I've missed a command somewhere.

I currently have a working kludge in which I do the following:
--------------------
//Get the port set for the PHP interpreter
C_LONGINT($LPHPPort)  //port used by php interpreter
$LPHPPort:=Get database parameter(PHP Interpreter port)

  // Get the current timeout, set it temporarily to as short as possible, 1 second
C_LONGINT($LCurrentTimeOut)  // The current internet commands timeout. We need to reset it later.
IT_GetTimeOut ($LCurrentTimeOut)  //get current timeout
IT_SetTimeOut (1)  //set current timeout to 1 second. 0 would be forever

// Attempt to open a connection on desired PHP port
C_LONGINT($LSessionError)  // holds the error number of the tcp connection attempt. 0 = no error
C_LONGINT($LSessionID)  // If we manage to open the connection, this is the session ID
$LSessionError:=TCP_Open ("";$LPHPPort;$LSessionID;0)  // "" listens on all available addresses

If ($LSessionError=0)  // A connection was established
    TCP_Close ($LSessionID)  // Close the session, we don't really want it.
    $0:=True
Else   // Couldn't establish a connection, assume port not in use
     $0:=False
End if

//Set the timeout back to what it was before we set it to 1 second
IT_SetTimeOut ($LCurrentTimeOut)

------------------
Thanks,
Joshua

Joshua Hunter
joshua-Ni5i+kYjIuUAvxtiuMwx3w< at >public.gmane.org<mailto:joshua-Ni5i+kYjIuUAvxtiuMwx3w< at >public.gmane.org>
(425) 673-1974
www.dwdev.com<http://www.dwdev.com/>
Dataworks Development, Inc.
Providing secure and configurable data management solutions for research and clinical labs 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
**********************************************************************

Web Process var value persistence?

Jim Labos - infobase — 2013-05-21T21:01:26

I am not sure if this has ben posted before but I am upgrading an application
using the Web Server and in v13 (I jumped form 2004 to v13) the processes
are reused.

What seems to occur, and I guess it is a normal behaviour is that the
process vars retain their values. This means we have to be careful to
re-initialize all process vars.

Furthermore (I did not test this one so I may be off here) I also notice the
record selection seems to also keep it's old values regardless of updating
value in teh record. For instance if the [TABLE]Date_Now was 01/01/2013 in
the process, the next time (and all other times) it is re-used if I change
the date of that field to 02/02/2013 the process will still show 01/01/2013.
I just came across this so I am not positive it was not something else.

It would be nice to hear form others if this is normal in v13 I had no
problems in v2004.

Thanks

Cheers





-----
Jim Labos - infobase
--
View this message in context: http://4d.1045681.n5.nabble.com/Web-Process-var-value-persistence-tp5722439.html
Sent from the 4D Tech mailing list archive at Nabble.com.

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

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

Determine What Version a Given .4DC Structure was Compiled

Tom Benedict — 2013-05-20T21:32:50

Is there a way to determine the version of 4D under which a given .4DC structure was compiled/built?

Similarly is there a way to know what version of 4D a given .4DB structure, .4DD data file or .4DIndx file was compacted, repaired or verified?

Thanks,

Tom Benedict


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

Tony Ringsmuth — 2013-05-20T21:20:24

I'm trying to write na SQL Subquery in 4D:

SELECT Last_Name, (select ID from Child where Child.Parent_ID = Parent.ID)
as FirstChildID
FROM Parent

The 4D SQL sql Ref (v12.1) says, under the heading of:
Syntax Rulys/Subquery:
A subquery is like a separate SELECT statement enclosed in parentheses and
passed in the predicate of another SQL statement (SELECT, INSERT, UPDATE or
DELETE). It acts as a query within a query and is often passed as part of a
WHERE or HAVING clause.

What am I doing wrong?

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

find number of commas in a string?

Laura Mayer — 2013-05-20T17:10:26

Morning,

I have an string (vtGetText) that I have parsed from an array:
(atAI_FileLines{$i})

For ($i;1;$lc)
vtGetText:=atAI_FileLines{$i}
End for

Then I want to see how many commas are in that string:
(Species,BullName,id_num,NAABCode,Country,Breed)

I tried count in array but I keep getting the error arguments are not
compatible.

Is there another way to do this?

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

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

Keith White — 2013-05-20T16:24:10

Hi

It's been many years since I crossed the pond, but this July I'm taking my vacation in the USA, flying into Las Vegas and flying out of San Diego, 3 weeks later.  The staging places on my route are:-

Las Vegas
Mammoth Lakes
Bass Lake - near Yosemite
San Francisco
Big Sur
Santa Barbara
Los Angeles area
San Diego

If anyone has any small tips on any must-see, do, or eat-at places, I'd love to hear from you.

Many thanks.

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

Nothing for the last two days

devteam — 2013-05-20T13:13:34

I don't seem to be getting any posts.


François
**********************************************************************
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
**********************************************************************

Interpreted structure, compiled component, is this a bug?

Jeffrey Kain — 2013-05-16T19:29:30

We're running some tests using an interpreted structure and a compiled component. In the interpreted structure, we have this method:

Tcp_receive
$0 - longint - error
$1 - longint - TCP/IP stream handle
$2 - pointer - Pointer to text to receive

The component is calling back to the host like this:

$buf:=""
$lErr:=Tcp_receive ($lStream;->$buf)

We set a breakpoint in Tcp_receive in the host database, and examine $2. The debugger shows the value of $2 as something like ->|}O_ (i.e. pointer to garbage), instead of ->$buf.

If you expand the $2 (pointer) in the debugger, instead of showing $buf we see |}O_, and obviously nothing is contained in this garbage variable.

And the code doesn't work - it's not just cosmetic, it just won't work correctly.

If I put the interpreted component in with the interpreted structure, everything is fine, the pointers are correct, and the code works.

This is a bug in 4D, right? Anyone ever seen anything like this?

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

AreaList Pro v9.6b1 is available

Philippe Ganter — 2013-05-16T15:00:53

Dear developers,

AreaList Pro 9.6 b1 is now available at
http://www.e-node.net/ftp/AreaListPro/9.6_Next_Version

Please check out the release notes for details.

Main new features:

- Calculated columns in arrays mode
- Individual row hiding: ALP_Row_Hide, ALP_Object_RowHide
- Insert and delete rows on the fly (with or without calls to 4D array commands): AL_ModifyArrays
- Error alerts in compiled mode
- Header foreground color setting using AL_SetForeColor, AL_SetForeClr and AL_SetForeRGBColor


Regards,

4Dv11r9 Client Crash Result in Loss of Data

Ronnie Teo — 2013-05-16T10:20:00

Hi,

I came across a scenario that I do not understand.  Is anybody able to give
some hints as to how this could have happened.

The client is a clinical facility.  The database is a 4Dv11r9 application
running on Windows Server 2008R2.
One of the user station crashed mid-way through data entry when the user was
adding a case record to one of the patient records.
The server carried out on running as per normal with other users logged in.

When the same user logged back in, not only did he lose the record he was
entering (expected event), he also lost the patient master record itself and
all case history records related to the patient.  Seems like all the related
many records (across different tables) linked to the patient table were
deleted by the crash.  The user had encountered ³unexpected quit² incident
before but never a loss of data.

How do I explain this to the user without knowing how it happened.  Has
anybody encountered this before?

Regards,
Ronnie Teo
Tarawerkz

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

Capture and parse web content from web area

Sujit Shah — 2013-05-16T06:54:15

I dont remember which plugin it was that allowed you to do this? Can anyone
recollect or lead me to a simple solution.

Summit Session

Stephen J. Orth — 2013-05-15T23:07:55

I would like to solicit some input from our 4D Community regarding a
possible topic for the upcoming Summit.

We have spent the past two years creating a completely new version of our
OEM manufacturing system. It is based completely on 4D V13 and has utilized
web areas extensively throughout the system, as standard interfaces for our
users.

We like to think (and I've been told) our interface is very nice, and
nothing like what a typical 4D application would look like. No disrespect
to 4D intended..

My question is directed to those who are, or considering, coming to the
Summit in Las Vegas. Would a topic that covers how we have utilized web
areas as a user interface (a real-world example, not something contrived) be
a topic people would attend? If so, besides seeing what we have
implemented, what other items would be of interest on this topic?

Thanks!

Steve

*********************************************

Stephen J. Orth

The Aquila Group, Inc. Office: (608) 834-9213

P.O. Box 690 Mobile: (608) 347-6447

Sun Prairie, WI 53590

E-Mail: <mailto:s.orth-rh6yEg8ZcI5wjJYsA5hikVaTQe2KTcn/< at >public.gmane.org> s.orth-rh6yEg8ZcI5wjJYsA5hikVaTQe2KTcn/< at >public.gmane.org

*********************************************