Michael Ferguson | 4 Sep 18:59 2015

Re: Quickbooks SOAP connection using Quickbooks Web Connector

Hi,

Does anyone have example code to connect to Quickbooks using SOAP through the Quickbooks web connector? I
am trying to create Quickbooks orders and order line items using SOAP from 4D.

Any sample code or tips would be appreciated.

Thanks,

Michael Ferguson

**********************************************************************
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe <at> lists.4D.com
**********************************************************************
Douglas von Roeder | 4 Sep 02:01 2015
Picon

Resetting Window Prefs in 13.5 (Windows)

Working with 13.5 on Win7 and, when I try to debug on the server, the
window bounds are "cattywampus".

How do I reset the window positions?

--
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe <at> lists.4D.com
**********************************************************************
Douglas von Roeder | 3 Sep 21:47 2015
Picon

Windows Standalone

Hitting an issue when launching a 13.5 volume desktop application. Code
runs fine in client/server, local mode, and when the standalone runs on
Win7 but, when launched under Win8, we're getting the following alert at
startup:

"Insufficient cache memory. 4D will now quit."

The dialog opens after the user has authenticated but before any code runs
in On Startup. We get the same message with the existing datafile (which
has been verified by MSC) as well as when the user creates a datafile.

Users experience this even though 4D has significant amounts of memory -
the machines are 4, 8, and 16 GB machines.

I've added code to dump a file containing the data from GET MEMORY
STATISTICS(1;…) and will have testers work with both 13.5 and 13.6. I'm
hoping to get test results today.

In my testing, I've run the app in Win7 when Win7 has only 500 MB RAM and
4D will operate in about 150 megs.

Has anyone else hit an issue like this with 13.5?

Any suggestions about how to resolve this?

--
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!
(Continue reading)

Jeffrey Kain | 3 Sep 17:54 2015
Picon

Legacy Java SE 6 runtime error message when launching 4D (sometimes) on Yosemite

Has anyone seen the following message when trying to launch 4D (v13.5) on Yosemite:

   To open "4D" you need to install the legacy
   Java SE 6 runtime.

I have a couple machines that pop this message every once in awhile, and I can't figure out why OS X thinks that
Java would be required.

Any clues to this? Is there a plist that OS X is reading somewhere that makes it think Java is required for 4D?
This doesn't happen every time - only once in awhile.

Jeff

**********************************************************************
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe <at> lists.4D.com
**********************************************************************
Keith White | 3 Sep 15:39 2015
Picon

Escaping text for insertion into MS SQL Server

Hi

Wondered if anyone has some code for dealing with text before inserting into a database?  I've used SQL
parameters which does this for you, but in this case I want to insert lots of rows in one call and so SQL
parameters can't be used.

I know all about using string literals and SQL injection, but this is a one-way replication of data out of 4D
and into a read-only MS SQL Server, so there isn't great danger here.

The following code does work (I've tested with data including single quotes, double quotes, commas,
carriage returns etc), but I'd be interested to hear if anyone has done this before:-

  // Escape single quotes by replacing with single quote pairs
$cText:=Replace string($cText;Char(Quote);Char(Quote)+Char(Quote))

  // Deal with comments in the data
$cText:=Replace string($cText;"*/";"*"+Char(Quote)+"+"+Char(Quote)+"/")
$cText:=Replace string($cText;"/*";"/"+Char(Quote)+"+"+Char(Quote)+"*")

Many thanks.

Best regards

Keith White
Synergist Express Ltd, UK.
**********************************************************************
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)

Medland, Paul (QuickWire | 2 Sep 21:03 2015

Duplicate Record

I am getting a duplicate record error on a primary key that is set to auto increment (longint field).  Not that
many records in the table.  Only four fields in the table.  Is 4D not supposed to handle this auto
incrementing automatically?   I ran maintenance on it and that did nothing.  Deleted .4dindx file, no
difference.  Is there some way I should be handling this?

Regards,
--
Paul

**********************************************************************
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe <at> lists.4D.com
**********************************************************************
stardata.info | 2 Sep 16:12 2015

What kind of 4d licence i have need?

Hi All,

I have developed an application with 4D V13.
I need that the my application work even with like one web server 
because i use the web browser for some data entry.
Until now i used 4d developer professional for create and test the 
application, but now i need to compile the my application and i have 
need of more web access.
What is the product that i have need to use?

Thanks
Ferdinando
**********************************************************************
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe <at> lists.4D.com
**********************************************************************
Arnaud de Montard | 2 Sep 10:47 2015
Picon

SQL and trigger

I connect a distant DB to a server DB with SQL (SQL LOGIN), to make some UPDATE and INSERT of records in one
table. Since I upgraded from v13 to v14.4, the trigger of server DB is *never* executed when a record is
created or modified from the external SQL connection. Someone has seen this before? 

--

-- 
Arnaud de Montard

**********************************************************************
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe <at> lists.4D.com
**********************************************************************
John Zigrang | 2 Sep 02:21 2015

Query in V14.4 / Help form on Web site

Does any one use the help form?  I can’t get it to work and the partner link is broken.

I have the following issues in V14.4 ( this use to work in V12).

[orders]OrderID<————[items]OrderID  (indexed, unique, Auto)

Query([orders];[items]BOL=20151190)

This should return two records in orders by only does one.
This is done with the query editor.

Also some V12 Querys will not load and give a blank alert screen.

John Zigrang
JTZ Engineering, Inc.

**********************************************************************
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe <at> lists.4D.com
**********************************************************************
Magnus Torell | 1 Sep 21:48 2015
Picon

Increasing journal file and almost empty 4DD file

Dear, 

I have come across a situation I cannot understand or resolve. 
It is a v12 built single user application running on win 7. 

After a couple of months working I got a message from the customer 
that they were unable to work. OK, they sent me the Folder of our
application. 

I could verify that upon launch I got the error that the: 4D Volume Desktop 
has stopped working. 
I restart in maintenance and try to repair. After a few tests I could enter 
into a merely empty database. No records at all more or less. 

When I investigate the individual files themselves I might have encounter
the problem. 
The datafile .4dd is only 190 kb big. and there is a .journal file of 355
Mb. 
I know, that at shipping time, the data file was something round 20 Mb. 

How can this happen?     and more important: 
How can I get the .journal data into a .4dd file. 
I understand that the backup prefs is not setup correct, and there is no 
.bkp file ever created. However, How can a datafile be more or less empty 
after 3 months running? 

Thankful for any help / insight. 

Best regards 

(Continue reading)

Kip Kumler | 1 Sep 17:26 2015

GRAPH Command - Scope

While the new GRAPH command graphics are impressive, I am having problems using it in typical real world
applications where multiple data sets do not share the same X-axis values. In particular, if you try to
create multiple line graphs of, say, sales at different markets which share only some of the same days,
although all are included in the overall range, it cannot be done. I am trying to overlay two or more line
graphs for the same period of dates. Is there a way to do this? Am I missing something?

Kip Kumler
Turtle Creek Winery
781 259 9976
http://www.turtlecreekwine.com/

In vino narratio, mirabilé dictu
"In wine is the story, marvelous in the telling"

**********************************************************************
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe <at> lists.4D.com
**********************************************************************

Gmane