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 <[email protected]
> 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 <[email protected]
> >
> 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:[email protected]
> > **********************************************************************
>
>
>
>
> --
> *************************************************
> 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:[email protected]
> **********************************************************************
>
--
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:[email protected]
**********************************************************************
