Windows Forms

15-Jun-07 4:34

see the datetimepeaker control in visual studio

etretyertyery

yes/no

tantoun14-Jun-07 10:45

14-Jun-07 10:45

can anybody tell me how can i insert into a column in microsoft access that have a yes/no datatype
plz help me regards

etretyertyery

Sathesh Sakthivel14-Jun-07 15:51

Sathesh Sakthivel

14-Jun-07 15:51

It just remember my college days.

Now and all i am not using MS-Access we are using Oracle and SQL SERVER 2000/2005.

For more Details about MS-Access Get it[^]

Regards,

Satips. Rose | [Rose]

Christian Graus14-Jun-07 21:20

Christian Graus

14-Jun-07 21:20

I presume that yes/no would map to a boolean data type.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

tantoun14-Jun-07 23:08

14-Jun-07 23:08

their is a sample query that i use:
update tblClient set exist='no' !!!! but their is something wrong in this query because it can't
update the following record that have a yes/no datatype.
please if we have something to do in access or something in my code so plz help me?????
thanks

etretyertyery

Pete O'Hanlon15-Jun-07 0:33

Pete O'Hanlon

15-Jun-07 0:33

I would suspect from your example there that the problem is the quotes around 'no'. This implies that it is a string type. Replace this with false instead.

Deja View - the feeling that you've seen this post before.

tantoun15-Jun-07 4:32

15-Jun-07 4:32

hey this is not the problem, i still have the problem
plz i need that any help
bye

etretyertyery

Christian Graus17-Jun-07 10:20

Christian Graus

17-Jun-07 10:20

tantoun wrote:
set exist='no'

'no' is a string. This isn't going to work, as someone else said. It's almost certainly the case that you need to use a boolean to set it.

I googled, and found this[^] within seconds. We were right, you set it using the boolean type.

Brady Kelly16-Jun-07 0:23

Brady Kelly

16-Jun-07 0:23

Access doesn't like complicated terms like boolean. It actually calls the field type Yes/No.

Form with an abstract base class?

Christian Graus17-Jun-07 10:21

Christian Graus

17-Jun-07 10:21

Yeah, I guessed that was the case. I don't use Access, except to drive my CD database, and even then, it uses SQL Server on the back end.

Jon Hulatt13-Jun-07 0:49

Jon Hulatt

13-Jun-07 0:49

Is there any way around the limitation that the designer just doesn't work with forms whose base class is abstract?

Seems like quite an irritating limitation to me.

using System.Beer;

Pete O'Hanlon13-Jun-07 2:31

Pete O'Hanlon

13-Jun-07 2:31

Unfortunately not, as the designer needs to be able to instantiate the class in order to display it on the design surface.

Deja View - the feeling that you've seen this post before.

originSH18-Jun-07 23:46

originSH

18-Jun-07 23:46

Actually there is a way around it :P

http://www.urbanpotato.net/Default.aspx/document/2001[^]

With VS 2005 additional classes were added that would allow support for forms/controls that inherit from both abstract and generic forms/controls.

This issue has been raised with MS but they have said that too few developers want this feature.

If you'd like this included at some point in the future please vote for it at:

https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=253384&wa=wsignin1.0[^]

Colin Angus Mackay19-Jun-07 0:07

Re: Form with an abstract base class? [modified]

19-Jun-07 0:07

originSH wrote:
If you'd like this included at some point in the future please vote for it at:

Even although it is marked as "Closed (Won't Fix)" I've voted for it anyway - They may reopen it... perhaps.

Actually, that designation of "Won't fix" makes them sound like a petulant child. Ho-hum...

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

originSH19-Jun-07 0:31

originSH

19-Jun-07 0:31

I just don't understand how other stuff like drag and drop support for data binding got prioritised over this.

Generics and abstraction are pretty core concepts and not a day goes by without me using them in classes for the most basic of stuff to the most advanced. Then I have to spend time working around this limitation when using WinForms :/ it sucks arse :P

Also why did they try to use backwards compatability as an excuse for not implimenting it? As I said in the comments I can understand lack of demand but which part would break backwards compatability.

Dave Kreskowiak13-Jun-07 4:37

Dave Kreskowiak

13-Jun-07 4:37

I've run into that problem myself. There is simply no way around this.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Colin Angus Mackay13-Jun-07 13:20

13-Jun-07 13:20

There is a way around it, but it is ugly and could cause you more problems in the long run. In fact, I don't recommend it at all.

Caveat out the way, here it is:

#if DEBUG
public class MyForm : Form
#else
public abstract MyForm : Form
#endif

Ugly, ain't it!

Normally you would be using the designer when your application was being built for debug. When you switch to release mode you lose the ability to use the designer, but it will still built. The main problem arises when you've forgotten that the class will really be abstract in the release build and you try and instantiate it and the release build fails.

Oh, and I think in VS2005 the MyForm.designer.cs file will keep losing the preprocessor stuff when you change things on the design surface - Fine for debug builds, but it will also cause the release build to fail.

If fact, I really really wouldn't recommend this course of action.

MidwestLimey14-Jun-07 14:27

MidwestLimey

14-Jun-07 14:27

Dear God man, how could you??

That is a truely abismal hack.

I take that back: it doesn't even qualify as a kludge let alone a hack.

Makes me want to try conditional comp. on namespaces .. Big Grin | :-D

I'm largely language agnostic  

     After a while they all bug me

Colin Angus Mackay14-Jun-07 21:20

14-Jun-07 21:20

MidwestLimey wrote:
Dear God man, how could you??

Don't say I didn't warn you! Big Grin | :-D

Colin Angus Mackay15-Jun-07 4:19