[dba-VB] SCRUM: Invalid Columns

Hi Mike,

Did you get restored databasse from backup after you've got attached .mdf db file?

The .mdf db file has old version of tables with some fields' names being different: remember Gustav prposed to rename some fields? 

Please restore db from backup published on MS LIve dba-vb several days ago in the same SkyDrive folder, then preview should work I expect (in old [Order] table the current Order.[ID] field ws named OrderId, and the current Order.ShipperId field was named [ShipVia]

Thank you.

--
Shamil

-----Original Message-----
From: "Mike Mattys" <mmattys at rochester.rr.com>
To: "Salakhetdinov Shamil" <mcp2004 at mail.ru>
Date: Wed, 25 Mar 2009 17:19:41 -0400
Subject: Re: [dba-VB]SCRUM: Invalid Columns

> Hi Shamil,
> 
> Invalid Columns requires new/other fields in query?
> 
> -
> Michael R Mattys
> MapPoint and Database Dev
> www.mattysconsulting.com
> -
> ----- Original Message ----- 
> From: "Salakhetdinov Shamil" <mcp2004 at mail.ru>
> To: "Discussion concerning Visual Basic and related programming issues." 
> <dba-vb at databaseadvisors.com>
> Sent: Wednesday, March 25, 2009 5:09 PM
> Subject: Re: [dba-VB]SCRUM: HowTos: Video Clip/Screenshots - HowtoMakeaBound 
> .NET WinForm with SubForm...
> 
> 
> > Mike,
> >
> > What is exactly the message?
> > Can you make a screenshot and send it to me privately or publish it on MS 
> > Live dba-vb?
> >
> > Thank you.
> >
> > --
> > Shamil
> >
> > -----Original Message-----
> > From: "Mike Mattys" <mmattys at rochester.rr.com>
> > To: "Discussion concerning Visual Basic and related programming 
> > issues."<dba-vb at databaseadvisors.com>
> > Date: Wed, 25 Mar 2009 16:30:24 -0400
> > Subject: Re: [dba-VB] SCRUM: HowTos: Video Clip/Screenshots - 
> > HowtoMakeaBound .NET WinForm with SubForm...
> >
> >> I'm stuck.
> >> Dataset-DataModelDataSet not working for my setup
> >> Keeps telling me that ID and Name are invalid.
> >> What should I be looking for to correct this?
> >>
> >> -
> >> Michael R Mattys
> >> MapPoint and Database Dev
> >> www.mattysconsulting.com
> >> -
> >> ----- Original Message ----- 
> >> From: "Mike Mattys" <mmattys at rochester.rr.com>
> >> To: "Discussion concerning Visual Basic and related programming issues."
> >> <dba-vb at databaseadvisors.com>
> >> Sent: Wednesday, March 25, 2009 4:14 PM
> >> Subject: Re: [dba-VB] SCRUM: HowTos: Video Clip/Screenshots - How
> >> toMakeaBound .NET WinForm with SubForm...
> >>
> >>
> >> > Wrong - these are keys to the Orders Table
> >> > Try again.
> >> > -
> >> > Michael R Mattys
> >> > MapPoint and Database Dev
> >> > www.mattysconsulting.com
> >> > -
> >> > ----- Original Message ----- 
> >> > From: "Mike Mattys" <mmattys at rochester.rr.com>
> >> > To: "Discussion concerning Visual Basic and related programming 
> >> > issues."
> >> > <dba-vb at databaseadvisors.com>
> >> > Sent: Wednesday, March 25, 2009 4:09 PM
> >> > Subject: Re: [dba-VB] SCRUM: HowTos: Video Clip/Screenshots - How to
> >> > MakeaBound .NET WinForm with SubForm...
> >> >
> >> >
> >> >>
> >> >> With the Shippers dataset, the columns ID and Name were unknown and
> >> >> I chose to edit the query. I think that the Alias did not hold, so I 
> >> >> put
> >> >> ShipperID, ID and CompanyName, Name
> >> >>
> >> >> Seems to work.
> >> >>
> >> >> -
> >> >> Michael R Mattys
> >> >> MapPoint and Database Dev
> >> >> www.mattysconsulting.com
> >> >
> >> > _______________________________________________
> >> > dba-VB mailing list
> >> > dba-VB at databaseadvisors.com
> >> > http://databaseadvisors.com/mailman/listinfo/dba-vb
> >> > http://www.databaseadvisors.com
> >> >
> >>
> >> _______________________________________________
> >> dba-VB mailing list
> >> dba-VB at databaseadvisors.com
> >> http://databaseadvisors.com/mailman/listinfo/dba-vb
> >> http://www.databaseadvisors.com
> >>
> >
> > _______________________________________________
> > dba-VB mailing list
> > dba-VB at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-vb
> > http://www.databaseadvisors.com
> > 
> 
> ATTACHMENT: image/jpeg (invcol.jpg)
>