Discussions

So, if I want a win8 tablet, and want to occasionally play with code on it, I should go Pro tablet, or a Win8 hybrid. Gotcha.

@Sven Groot: 2 Questions:

1) Will any version of Visual Studio work on RT? I know VS 2012 will let you develop for RT, but if I buy an RT tablet, will I be able to do any sort of development. (A full PC would be my primary development environment.)

2) How does 'Right-Click' work on a tablet? Does it exist? Is it a gesture?

lensman... of course I checked that. How foolish... fine, let's do it again...

Dang! One record! Where'd that come from!

Thanks, I hang my head in shame. Figured it was something stupid.

Yes...

However, that would mean, not only writing the system that reads this data, which is the job I'm working on, it would mean re-writing the system that collects the data which is handled by someone else. So, I either fix their mess for double the time, or I try to work with what I've got.

The Create script on family_fishing_reg looks like this:

CREATE TABLE [dbo].[family_fishing_reg](
    [program] [nvarchar](23) NULL,
    [FeatureDate] [nvarchar](9) NULL,
    [programnumber] [nvarchar]( 6 ) NOT NULL,
    [site] [nvarchar](48) NULL,
    ...

,
    [randomnumber] [nvarchar](36) NOT NULL,
    [num_under_8] [nvarchar](1) NULL,
    [num_8-12] [nvarchar](1) NULL,
    [num_18-35] [nvarchar](1) NULL,
    [num_13-15] [nvarchar](1) NULL,
    [num_over35] [nvarchar](1) NULL,
 CONSTRAINT [PK__family_fishing_reg] PRIMARY KEY CLUSTERED
(
    [randomnumber] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, I

I have this SQL:

ALTER TABLE dbo.family_fishing_reg
ADD CONSTRAINT     FK_family_fishing_reg_family_fishing
FOREIGN KEY     (    programnumber    )
REFERENCES dbo.family_fishing     (    PROGRAMNUMBER    )
ON UPDATE  NO ACTION
ON DELETE  NO ACTION
    
GO

And I get this error:

Msg 547, Level 16, State 0, Line 5
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_family_fishing_reg_family_fishing". The conflict occurred in database "form_data", table "dbo.family_fishing", column 'PROGRAMNUMBER'.

What could be causing this?

The table is defined like this:

CREATE TABLE [dbo].[family_fishing](
    [date] [nvarchar](255) NULL,
    [PROGRAMNUMBER] [nvarchar]( 6 ) NOT NULL,

....

    [event_description] [nvarchar](333) NULL,
 CONSTRAINT [pk_family_fishing_pNumber] PRIMARY KEY CLUSTERED
(
    [PROGRAMNUMBER] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

So, I created my test which scoped out one table to sync. This worked, now I want to add subsequent tables.

It appears I have to DeProvision the scope and then Provision it again. Or add a second scope.

The process seems... clunky. Granted, the SyncFramework is doing a lot under the scenes, but I haven't found any simple way to modify a scope. Here's how I see it, tell me if I'm wrong.

If I have an existing scope and need to change it, I have to add code to my app to Deprovision the scope and re-create, or build in logic to skip tables in the build process. Is this correct?

What if I add columns to a table at some point?

I have two tables, family_fishing (the parent table) with a key of PROGRAMNUMBER and family_fishing_reg with a key of randomnumber (seriously, I did not design these tables) and a column of programnumber which should be the foreign key.

ProgramNumber in both tables is NOT NULL. The type in both tables is the same.

When I bring them into Entity Framework and create an assocation, the association wantd the dependant key to be the randomnumber column, the entity key on the child table. (RandomNumber is a guid.)

When I double click on the association I can ONLY select randomnumber for the dependant key but this will never relate to family_fishing.PROGRAMNUMBER which is an nvarchar(6). (Yes, a key column as an nvarchar is not my choice either.)

I have to work with the tables that I have. I'm trying to plug into a database that is not managed by me. I have binged and googled all over and can't seem to understand why this is. The association is looking for a mapping, which also wants to use the randomnumber column. But this should be a typical 1 to many foreign key association.

What can I try? What can I read? Who can I ask to find an answer to this?

I don't think you folks are hearing what I'm saying. I went with a standard Sharepoint 2010 template that Sharepoint provides, and its called a Web Database, and configured through Access. Sharepoint chose the Access stuff. I didn't.

So, I don't know that I'm going to get many answers here.

So, here's what it comes down to. The Windows tablet approach will have lower development costs, but there is a company willing to do a pilot by loaning us 3 free android tablets. Free is nice.

For Windows Tablets, here's what we would want, secure (of course), locked down to only supported apps, and remotely wipable. Other than that, rugeddeized which almost any tablet can be, wireless, which any tablet can be, and larger screen, which windows tablets seem to have.