Re: Create Table SQL not working
- From: "Gil, Not the Fish" <GilNottheFish@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 12 May 2005 19:20:01 -0700
My wife is into quilts and she asked me to write a program to get ALL
possibilities for combining certain patterns - it's not a 'relational
database' - I just plug in some parameters and let it go. When a solution is
found I want to save it in a table as 'Quilt1' and then it continues to
calculate a new solution and I want to save that in table 'Quilt2', etc.
Then when all solutions (unknown) are done I can review and print them by
number. I know this may not be the best environment to do this type of thing
but I think that the problem I'm having is completely separate from the
application itself. Namely, how to concatenate the number to the
'MeaningfulName' part of the filename so that the 'Create Table' SQL string
accepts it. Like I said, I can create a table called 'Solutions' but not
after I have concatenated a
Str(Number) to it- I get a syntax error - try it!! I'm using 2003, by the
way, and I chose this program just because I'm writing databases for my work
right now and I thought I could use the experience. Thanx
"Jeff Boyce" wrote:
> Gil
>
> Building multiple tables, with "meaning" embedded in the table names, is
> rarely a workable solution in a relational database. Perhaps if you explain
> a bit more what you are trying to do, with an example, folks in the
> newsgroup could offer alternate approaches.
>
> Good luck
>
> Jeff Boyce
> <Access MVP>
>
> "Gil, Not the Fish" <GilNottheFish@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message news:3BA473DA-8F91-4750-A932-7865EAB86C05@xxxxxxxxxxxxxxxx
> >I am doing calculations that have many different solutions and I would like
> > to save the solutions to different tables. It is unknown how many
> > solutions
> > there will be. I wanted to create a table for each solution (216 entries
> > each) so I put this code in after a solution was reached.
> > intSolutNum=intSolutNum+1
> > strSolutNum=Str(SolutNum)
> > strFileName="Solution" & strSolutNum
> > strSQL="Create Table " & strFileName & " (Myfield Number)"
> >
> > The code works to create a table if all I have is "Solution" for the Table
> > Name but as soon as I try to add the Number to the filename it gives me a
> > syntax error. Is there some other format for to add a number after each
> > table name. Or is there another way to go at the whole thing?? Thanx for
> > any help
> >
> > --
> > Gil
>
>
>
.
- Follow-Ups:
- Re: Create Table SQL not working
- From: Tim Ferguson
- Re: Create Table SQL not working
- From: Jeff Boyce
- Re: Create Table SQL not working
- References:
- Create Table SQL not working
- From: Gil, Not the Fish
- Re: Create Table SQL not working
- From: Jeff Boyce
- Create Table SQL not working
- Prev by Date: Re: Validation override
- Next by Date: moving outlook office xp to office 2003
- Previous by thread: Re: Create Table SQL not working
- Next by thread: Re: Create Table SQL not working
- Index(es):
Relevant Pages
|
