error

[abc]

When I Generate the application and run it, I get the following error
"Incorrect syntax near the keyword 'as'. Incorrect syntax near the
keyword 'as'."

[Ryan Gahl]

This might be related to something in your schema being a keyword that our generator is not handling well... Can you script out your db schema and either paste it into a reply here, or as an attachment? If it's a sensitive schema and you don't want to do that, then take a look through your tables and see if you have column names like "UserName" or "Data", or anything else that might seem like a keyword that a DAL might use. Obviously, we need to fix our software so that in the future you don't have to worry about such things... but for now I just want to see if that might be your issue here...

--
Ryan Gahl
CEO
Nth Penguin, LLC
http://www.nthpenguin.com
--
WebWidgetry.com / MashupStudio.com
Future Home of the World's First Complete Web Platform
--
Inquire: 1-920-574-2218
Blog: http://www.someElement.com
LinkedIn Profile: http://www.linkedin.com/in/ryangahl

[abc]

Ryan,

I'm sending you the generation script of the database.

For more information

I'm testing your software in a

Gateway Machine with Windows Vista Ultimate 32 Bits, SqlServer Express
2008, Visual Studio 2008 Sp1.

Database Generation Script

------------------------

USE [VientoDelNorte]
GO
/****** Object: Table [dbo].[Paises] Script Date: 11/07/2008
23:55:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Paises](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Paises] [nvarchar](150) NOT NULL,
CONSTRAINT [PK_Paises] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY
= OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Estados] Script Date: 11/07/2008
23:55:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Estados](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Estados] [nvarchar](150) NOT NULL,
CONSTRAINT [PK_Estados] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY
= OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Ciudades] Script Date: 11/07/2008
23:55:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Ciudades](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Ciudades] [nvarchar](150) NOT NULL,
CONSTRAINT [PK_Ciudades] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY
= OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

-----------------------

Best Regards,

Marco Alfredo Garcia Villalobos
www.abcdinamica.com

[Ryan Gahl]

Marco, just so you know, I've created your database here and am going to be trying to figure this out this morning...

[Ryan Gahl]

Well, Marco, I'm not able to get that error you mentioned... can you send me a screenshot of that error message so I can see what's going on when it happens?

Also, please send me two other screenshots. One of your WW.DataServices web service running in your browser so I can see the URL... and another of Visual Studio with your WW.Interface project open, and the webservice connection selected in the WW.Interface plugin so I can see all the properties for that.

So, total of 3 screenshots. Thanks!

-Ryan

[abc]

Ryan,

I screen recorded the dataservices and the interface.

Please download from:

http://www.abcdinamica.com/NthPenguin/DataServices.zip
http://www.abcdinamica.com/NthPenguin/Interface.zip

And also the 2 projects

http://www.abcdinamica.com/NthPenguin/NthPenguin.zip

Best Regards,

Marco

[Jeff Kirkell]

Just a thought, but what localization for the database?

On Nov 10, 5:12 pm, abc <ma...@abcdinamica.com> wrote:
> Ryan,
>
> I screen recorded the dataservices and the interface.
>
> Please download from:
>

> http://www.abcdinamica.com/NthPenguin/DataServices.ziphttp://www.abcdinamica.com/NthPenguin/Interface.zip

[Marco Alfredo Garcia Villalo]

Jeff,

 

The language is set to English, the Server Collation is set to SQL_Latin1_General_CP1_CI_AS, and I'm using Microsoft Sql Server Express 2008 Edition with Advanced Services (ver. 10.0.1600.22).

Regards, 

 

Marco Alfredo García Villalobos

Director General

ABC Dinámica, S.A. de C.V.

+52 444 8124784, 85

www.abcdinamica.com