[dba-Tech] FW: VS.NET equivalent of single-row form

Arthur Fuller fuller.artful at gmail.com
Sun Mar 9 10:35:35 CDT 2008


fuller.artful at gmail.com.

On 3/9/08, Rocky Smolin at Beach Access Software <rockysmolin at bchacc.com>
wrote:
>
> A:
>
> What is your email address now?  The one I have is no longer valid.
>
>
> R
>
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: Rocky Smolin at Beach Access Software [mailto:rockysmolin at bchacc.com
> ]
> Sent: Sunday, March 09, 2008 8:12 AM
> To: 'Discussion of Hardware and Software issues'
>
> Subject: RE: [dba-Tech] VS.NET equivalent of single-row form
>
> A:
>
> We used arrays.  I'll send you our mdb off-line - maybe give you some
> ideas
> - with the caveat that it's not working correctly at this point.
>
> Rocky
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: dba-tech-bounces at databaseadvisors.com
> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
> Sent: Sunday, March 09, 2008 7:28 AM
> To: Discussion of Hardware and Software issues
> Subject: Re: [dba-Tech] VS.NET equivalent of single-row form
>
> There's an intermediate table which I populate with a bunch of rows
> corresponding to the available numbers (unused) and a row-column
> designator.
> The number of rows manufactured for this table depends on the number of
> numbers supplied in the problem, obviously. From there, a series of
> elaborate joins to the Problem table's row eventually results in a
> solution.
>
>
> Arrays are obviously a much more efficient approach (one for each
> sub-square
> and a big one corresponding to my intermediate table), but I wanted to see
> if I could do it in TSQL alone. Now that I have proved that I can, I will
> eventually get around to doing it the "right" way. But I need to do a few
> more things to this program to make it presentable, first. When I've got
> the
> first version done, I'll post it, and then set to work on the
> array-version.
>
> A.
>
> On 3/9/08, Rocky Smolin at Beach Access Software <rockysmolin at bchacc.com>
> wrote:
> >
> > Interesting.  I started writing one with Noah (my younger son) but
> > never finished it.  We were using a brute force method of initializing
> > each of the squares with all nine numbers and eliminating
> > possibilities based on various rules.  Got about half way there before
> > other stuff got in the way and we never finished it.
> >
> > What methods are you using to solve the puzzle?
> >
> >
> > Rocky
> >
> >
> >
> >
> >
> >
> >
> >
> > -----Original Message-----
> > From: dba-tech-bounces at databaseadvisors.com
> >
> > [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Arthur
> > Fuller
> > Sent: Sunday, March 09, 2008 6:53 AM
> > To: Discussion of Hardware and Software issues
> > Subject: Re: [dba-Tech] VS.NET equivalent of single-row form
> >
> >
> > I'm making big progress on this little toy! I'm writing a Sudoku
> > problem solver. Actually I have already written the solver code -- in
> > TSQL no less LOL), and I just need a test and display harness for it.
> > I've tracked down some allegedly difficult problems and the hardest
> > one I've found so far takes under 3 minutes to solve. No doubt the
> > code can be optimized significantly, but I wanted to see whether I
> > could do it in TSQL rather than simply using arrays, which would
> > obviously be way more efficient.
> >
> > Anyway, here's my current problem: I have a pair of forms, almost
> > identical.
> > One addresses the Problems table, the other the Solutions table. The
> > Problems table has an Identity key. The stored procedure that does all
> > the magic creates a row in the Solutions table having the FK pointing
> > to the problem it solves.
> >
> > I have a button on the Problems form that opens the Solutions form. I
> > need to pass it the ProblemID and have it do one of two things:
> >
> > 1. If the solution exists, open the form and display it.
> > 2. If the solution doesn't exist, solve the problem, then open the
> > form and display the solution.
> >
> > There is a potential wrinkle down the road, but I'm prepared to
> > postpone that part of the problem. (A given problem could have more
> > than one solution; this is generally considered bad form in posing the
> > problem in the first place, but that aside....)
> >
> > Actually, there is a second problem, too, which I have thus far
> > avoided because I'm taking my problems from web sites and newspapers,
> > so they all contain problems with solutions. But in theory, a problem
> > could be posed that obeys the setup rules but has no solution. So
> > eventually I will need a timer so I stop looking after a while. I
> > think. I'm not sure whether I can prove that problem X is unsolvable,
> > but that can wait for a while too.
> >
> > Anyway, I'm way ahead of myself here. I just need to open the Solution
> > form on the right solution (identified by ProblemID), and to detect
> > before I open the form whether there is a solution -- a simple SELECT
> > COUNT(*) but I'm not sure how to code that and obtain the result in a
> > variable for inspection so I can act accordingly.
> >
> > One more question: can I mix languages in a single module? e.g. write
> > one method in C# and another in VB and a third in Python? Not that I'd
> > want to, necessarily, it's more a theory question.
> >
> > TIA,
> > Arthur
> >
> > On 3/9/08, Arthur Fuller <fuller.artful at gmail.com> wrote:
> > >
> > > C# but I found it already. But I am going to do some parts of this
> > > thing in Python, if only for the exercise. I've been teaching myself
> > > Python, and have installed Iron Python, but haven't tried it out yet
> > > to explore the differences between it and classic Python.
> > > A.
> > >
> > > On 3/9/08, Rocky Smolin at Beach Access Software
> > > <rockysmolin at bchacc.com>
> > > wrote:
> > > >
> > > > Are you using VB.NET?  ASP.NET?  Something else?
> > > >
> > > > Rocky
> > > >
> > >
> > >
> >
> > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
> >
> > No virus found in this incoming message.
> > Checked by AVG.
> >
> > Version: 7.5.518 / Virus Database: 269.21.7/1319 - Release Date:
> > 3/8/2008
> > 10:14 AM
> >
> >
> >
> > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
> >
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.518 / Virus Database: 269.21.7/1319 - Release Date: 3/8/2008
> 10:14 AM
>
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>



More information about the dba-Tech mailing list