Re: Anyone have a link to a Northwind SQL dataset?

2017-12-10 Thread Keisuke Miyako via 4D_Tech 
Hello,

there might be benefits in having a NorthWind / Pubs example in 4D,
but the Neo4j example seems to have more to do with importing CSV.

https://neo4j.com/developer/guide-importing-data-and-etl/

what you really need is a decent method that can export CSV from 4D (with 
headers).

EXPORT DATA with delimiter_field:44 might work if the data set is really simple.
otherwise, PROCESS 4D TAGS with good escape functions seems to be the best 
option.
SEND PACKET works too, but it can be quite slow for these kind of operations.

> What I was trying to do was create the Northwind db in a 4D database so I
> could practice exporting the data neo4J is using in its demo. I thought it
> would be useful for working out the code on the 4D side if I could be
> working from the same dataset. But it's looking like more trouble than the
> benefit.



**
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-unsubscr...@lists.4d.com
**

Re: Anyone have a link to a Northwind SQL dataset?

2017-12-10 Thread Kirk Brooks via 4D_Tech 
 Pat,
If I'm looking at it correctly this would allow me to access a running MySql
database from 4D.

What I was trying to do was create the Northwind db in a 4D database so I
could practice exporting the data neo4J is using in its demo. I thought it
would be useful for working out the code on the 4D side if I could be
working from the same dataset. But it's looking like more trouble than the
benefit.

On Sun, Dec 10, 2017 at 10:08 AM, Pat Bensky via 4D_Tech <4d
_t...@lists.4d.com> wrote:

> Hey Kirk,
>
> I haven't looked into this with v16 yet (it's on my To Do list) but in
> previous versions you needed to install an ODBC driver on Mac. See:
> https://www.catbase.com/configuring-an-odbc-driver
>
> Does that help?
>

-- 
Kirk Brooks
San Francisco, CA
===

The only thing necessary for the triumph of evil is for good men to do
nothing.

- Edmund Burke
**
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-unsubscr...@lists.4d.com
**

Re: Anyone have a link to a Northwind SQL dataset?

2017-12-10 Thread Pat Bensky via 4D_Tech 
Hey Kirk,

I haven't looked into this with v16 yet (it's on my To Do list) but in
previous versions you needed to install an ODBC driver on Mac. See:
https://www.catbase.com/configuring-an-odbc-driver

Does that help?

Pat

On 10 December 2017 at 16:02, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com>
wrote:

>  For those of you playing along at home - I found this site on Github where
> you can get the basic data set. The structure is pretty simple to just make
> in 4D.
>
> https://github.com/tmcnab/northwind-mongo
>
>
> On Sat, Dec 9, 2017 at 2:14 PM, Kirk Brooks  wrote:
>
> > Hi Folks,
> > I would like to setup the Northwind sample data set. I found this site:
> >
> > https://northwinddatabase.codeplex.com/
> >
> > but 4D fails when attempting to use SQL EXECUTE SCRIPT on it. I looked at
> > the Microsoft site but have no idea which flavor would/could work.
> >
> > So - anyone have a suggestion?
> >
> > --
> > Kirk Brooks
> > San Francisco, CA
> > ===
> >
> > *The only thing necessary for the triumph of evil is for good men to do
> > nothing.*
> >
> > *- Edmund Burke*
> >
> >
>
>
> --
> Kirk Brooks
> San Francisco, CA
> ===
>
> *The only thing necessary for the triumph of evil is for good men to do
> nothing.*
>
> *- Edmund Burke*
> **
> 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-unsubscr...@lists.4d.com
> **
>



-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
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-unsubscr...@lists.4d.com
**

Re: Anyone have a link to a Northwind SQL dataset?

2017-12-10 Thread Kirk Brooks via 4D_Tech 
 For those of you playing along at home - I found this site on Github where
you can get the basic data set. The structure is pretty simple to just make
in 4D.

https://github.com/tmcnab/northwind-mongo


On Sat, Dec 9, 2017 at 2:14 PM, Kirk Brooks  wrote:

> Hi Folks,
> I would like to setup the Northwind sample data set. I found this site:
>
> https://northwinddatabase.codeplex.com/
>
> but 4D fails when attempting to use SQL EXECUTE SCRIPT on it. I looked at
> the Microsoft site but have no idea which flavor would/could work.
>
> So - anyone have a suggestion?
>
> --
> Kirk Brooks
> San Francisco, CA
> ===
>
> *The only thing necessary for the triumph of evil is for good men to do
> nothing.*
>
> *- Edmund Burke*
>
>


-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

*- Edmund Burke*
**
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-unsubscr...@lists.4d.com
**

Re: Anyone have a link to a Northwind SQL dataset?

2017-12-09 Thread Kirk Brooks via 4D_Tech 
 Hey Pat,
I'm using v16.3 on a Mac. I put the file in the folder with the database
and ran

SQL EXECUTE SCRIPT("northwind.sql";SQL On error confirm)

​The error seems to happen right away:

​
Error when executing the method "__test" at line number 5

Generic parsing error. Parsing failed in or around the following substring
interval - ( 1, 15 ) on line 1 - ...SE [Northwind]
...

Error code: 1301
Generic parsing error. Parsing failed in or around the following substring
interval - ( 1, 15 ) on line 1 - ...SE [Northwind]
...
component: 'SQLS'
task -5, name: 'P_1'

Error code: 200
Attempt to read beyond end of stream
xtoolbox
task -5, name: 'P_1'

Error code: -39
End of file (eofErr).
component: 'CARB'
task -5, name: 'P_1'




On Sat, Dec 9, 2017 at 6:36 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com
> wrote:

> Are you connecting from a Mac or PC?
> Which version of 4D?
> Can you make the connection to the Northwind db OK?
> What error do you get?
> What's the script contents?
>
> So many questions ... :)
>
> Pat
>
> On 9 December 2017 at 21:14, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com
> >
> wrote:
>
> > Hi Folks,
> > I would like to setup the Northwind sample data set. I found this site:
> >
> > https://northwinddatabase.codeplex.com/
> >
> > but 4D fails when attempting to use SQL EXECUTE SCRIPT on it. I looked at
> > the Microsoft site but have no idea which flavor would/could work.
> >
> > So - anyone have a suggestion?
> >
> > --
> > Kirk Brooks
> > San Francisco, CA
> > ===
> >
> > *The only thing necessary for the triumph of evil is for good men to do
> > nothing.*
> >
> > *- Edmund Burke*
> > **
> > 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-unsubscr...@lists.4d.com
> > **
>
>
>
>
> --
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 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-unsubscr...@lists.4d.com
> **
>



-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

*- Edmund Burke*
**
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-unsubscr...@lists.4d.com
**

Re: Anyone have a link to a Northwind SQL dataset?

2017-12-09 Thread Kirk Brooks via 4D_Tech 
 Hi Lee,
I've started looking at Neo4js and they use Northwind as a demo data set. I
want to put the same dataset into a 4D database to work out interacting
with Neo4js from 4D. I thought it would be easy...

On Sat, Dec 9, 2017 at 2:43 PM, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> That looks like a sql server sample database.
>
> https://docs.microsoft.com/en-us/dotnet/framework/data/
> adonet/sql/linq/downloading-sample-databases  en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases>
>
> why were you curious about it?
>
-- 
Kirk Brooks
San Francisco, CA
===

The only thing necessary for the triumph of evil is for good men to do
nothing.

- Edmund Burke
**
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-unsubscr...@lists.4d.com
**

Re: Anyone have a link to a Northwind SQL dataset?

2017-12-09 Thread Pat Bensky via 4D_Tech 
Are you connecting from a Mac or PC?
Which version of 4D?
Can you make the connection to the Northwind db OK?
What error do you get?
What's the script contents?

So many questions ... :)

Pat

On 9 December 2017 at 21:14, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Hi Folks,
> I would like to setup the Northwind sample data set. I found this site:
>
> https://northwinddatabase.codeplex.com/
>
> but 4D fails when attempting to use SQL EXECUTE SCRIPT on it. I looked at
> the Microsoft site but have no idea which flavor would/could work.
>
> So - anyone have a suggestion?
>
> --
> Kirk Brooks
> San Francisco, CA
> ===
>
> *The only thing necessary for the triumph of evil is for good men to do
> nothing.*
>
> *- Edmund Burke*
> **
> 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-unsubscr...@lists.4d.com
> **




-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
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-unsubscr...@lists.4d.com
**

Re: Anyone have a link to a Northwind SQL dataset?

2017-12-09 Thread Lee Hinde via 4D_Tech 
That looks like a sql server sample database.

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases
 


why were you curious about it?
> On Dec 9, 2017, at 1:14 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Folks,
> I would like to setup the Northwind sample data set. I found this site:
> 
> https://northwinddatabase.codeplex.com/
> 
> but 4D fails when attempting to use SQL EXECUTE SCRIPT on it. I looked at
> the Microsoft site but have no idea which flavor would/could work.
> 
> So - anyone have a suggestion?
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *The only thing necessary for the triumph of evil is for good men to do
> nothing.*
> 
> *- Edmund Burke*
> **
> 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-unsubscr...@lists.4d.com
> **

**
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-unsubscr...@lists.4d.com
**

Anyone have a link to a Northwind SQL dataset?

2017-12-09 Thread Kirk Brooks via 4D_Tech 
Hi Folks,
I would like to setup the Northwind sample data set. I found this site:

https://northwinddatabase.codeplex.com/

but 4D fails when attempting to use SQL EXECUTE SCRIPT on it. I looked at
the Microsoft site but have no idea which flavor would/could work.

So - anyone have a suggestion?

-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

*- Edmund Burke*
**
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-unsubscr...@lists.4d.com
**