I think this is what SQL EXPORT DATABASE and SQL EXPORT SELECTION do. You
might have some issues with date/time fields as well as object fields.
--
Jeffrey Kain
jeffrey.k...@gmail.com
> On Sep 7, 2017, at 11:40 AM, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> Maybe you can
Hello,
Here is the documentation :
http://doc.4d.com/4Dv16R3/4D/16-R3/Creating-and-using-macros.300-3230741.en.html
Regards,
Olivier
> Le 7 sept. 2017 à 17:40, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> Hi All I have looked on 4d and perhaps I am blind, but I am
You might try to use arrays to update and not individual records
Regards
Chuck
Chuck Miller Voice: (617) 739-0306
Informed Solutions, Inc. Fax: (617) 232-1064
Does anyone have any advice on converting a 4D Database to MSSQL. The database
is quite large at 75+gb of data and doing the conversion with an SQL Login and
looping the 4D records using Inserts into MSSQL is taking quite literally days
to convert.
Any ideas are welcome.
Thanks
Justin Will
Sure looks like it!
I wasn’t even aware of this command in 4D, but it calls it a ‘dump’, so that’s
the kind of text file I would expect this to create.
Randy
--
Randy Jaynes
Senior Programmer and Customer Support
Jeffrey,
Thank you, I was not aware of SQL EXPORT DATABASE. I might be able to make it
work by dumping to an intermediate SQL database and then converting the data to
the slightly modified schema from there.
Thanks
Justin
**
Hi All I have looked on 4d and perhaps I am blind, but I am looking for
documentation on Macros. Where might I find it
Regards
Chuck
--
-
Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
Informed
Maybe you can write 4D code to create blocks of insert statements in a text
file like
LOCK TABLES `CatalogPricing` WRITE;
INSERT INTO `CatalogPricing` (`catPriceID`, `catPriceCatalogID`, `catPriceQty`,
`catPriceAmount`, `catPriceStatus`)
VALUES
(2,2,1,15.00,'1'),
OK I found it
I have added the following macro The method below exists
ut_OpenMethod ("")
Is the on_load not available in v15. If so is there any way to identify
Thanks and regards
Chuck
On Thu, Sep 7, 2017 at 11:43 AM, Olivier Deschanels via 4D_Tech <
4d_tech@lists.4d.com> wrote:
>
If anyone has experience with successfully completing a PCI/DSS audit and
certification for your network, not just the 4D part, I would really
appreciate talking with you. Ping me off line.
Thanks
--
Kirk Brooks
San Francisco, CA
===
*The only thing necessary for the
Hello Piotr,
I’m sorry it has taken me so long to respond. I don’t have any knowledge about
this specific bug.
The process of letting 4D Engineering know about this depends on if you are a
4D Partner or not.
Partners may submit it through their Tech Support engineers (or TOAW if used in
> Le 7 sept. 2017 à 17:42, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> I think this is what SQL EXPORT DATABASE and SQL EXPORT SELECTION do. You
> might have some issues with date/time fields as well as object fields.
Unfortunately these commands have been written in a
Now is your opportunity to share your expertise
and knowledge with the 4D community. Speaker
submissions for the 2018 4D Summit in
Washington D.C. are being accepted through
November 30th.
Presentations should be about 45 minutes long,
leaving time for 10 minutes of questions. A 4D
team member
Kirk,
I can't say that I understand the nuances of the system to the point of having
any details to contribute, but after lots of trying to figure it out the thing
that finally allowed us to pass the scan was to use a VPN. We open only the
VPN ports and the ports required by the credit card
Hello,
on_load has been available since v11.
perhaps your folder is not named "Macros v2"
some macro examples:
https://github.com/miyako?utf8=✓=repositories=macro
(but I am not sure if any uses on_load in particular)
2017/09/08 1:48、Charles Miller via 4D_Tech
Thanks Chuck, I'll give that a try. Perhaps batches of 25k records as arrays
will work and speed things up.
> You might try to use arrays to update and not individual records
Justin
**
4D Internet Users Group (4D iNUG)
FAQ:
One more thing. If you can create a true stored procedure in MS sql server.
and execute by passing in that would be faster ads well
Try this link
https://technet.microsoft.com/en-us/library/
It will show you transact sql server commands etc
On Thu, Sep 7, 2017 at 5:21 PM, Justin Will via
I was reminded yesterday that it's pretty easy not to understand the
difference between dot releases and R releases. I guess it's the numbering?
I do understand it now (it took a few years), but it's still hard to
explain. I though of a new way so I'm tossing out two explanation.s
16.016.1
16.2
I fell in love with macros lately when I saw one in action that showed some
custom UI. Awesome! I now have macros where you can do stuff like this:
-- Take the highlight text (some Postgres SQL in a disabled Begin/End SQL
statement.)
-- Bring up a dialog with a bunch of bits you can adjust
--
This new keyboard is just killing me. Anyway, ignore the incomplete version
of this method.
I was reminded yesterday that it's pretty easy not to understand the
difference between dot releases and R releases. I guess it's the numbering?
I do understand it now (it took a few years), but it's still
Not to drill too deeply, but no new features != no new changes. 16.2 for
instance updates the Xerces engine, which apparently changed the case
sensitivity of existing XML commands.
And I think the company line is that R releases (the non-beta ones) are
customer ready.
But generally, yes, the
Hi Paul,
Have you updated any components and/or plugins since that update?
Regards,
Vance Villanueva
-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Paul Lovejoy
via 4D_Tech
Sent: Tuesday, September 05, 2017 10:16 PM
To: 4D iNug Technical
Cc:
John:
Just getting back to this…
Got a hitch in the git along - all the computers running 4D are on OS X.
Their accountant is using a Mac for most of her work but she has a Windows
laptop for QB. From a recent conversation, they're open to moving her to a
MacBook + Parallels for QB.
Since
Doug,
I would say that the SDK is only a windows option. I could be wrong,
but I do not believe that there is a Mac OS option for talking with QuickBooks
for Mac desktop.
Using a VM is absolutely doable. I did all of my development work on a
mac using Oracle VirtualBox. I do
24 matches
Mail list logo