[dba-VB] SCRUM: Invalid Columns

Mike Mattys mmattys at rochester.rr.com
Wed Mar 25 17:04:07 CDT 2009


Having trouble finding a way to shut down In-Use database.

-
Michael R Mattys
MapPoint and Database Dev
www.mattysconsulting.com
-
----- Original Message ----- 
From: "Salakhetdinov Shamil" <mcp2004 at mail.ru>
To: "dba-VB" <dba-vb at databaseadvisors.com>
Sent: Wednesday, March 25, 2009 5:41 PM
Subject: Re: [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)
>>
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 




More information about the dba-VB mailing list