Insert

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have written the following query and it does not work. I am not seeing what
is wrong with this. Any who can see let me know.

Dale

PARAMETERS showidold Long, showidnew Long;
INSERT INTO classinfo ( ShowID, ClassID, ClassNumber, ClassDescription,
ClassFee, PostEntryFee, Amateur, Equitation, SpecID, USDF, WalkTrotJog,
Halter, Sponsors, ClassCode, USDFLevel, WCRT, JumperLevel, USDFStartTime,
USDFRideTime, USDFRing )
SELECT [showidnew], ClassInfo.ClassID, ClassInfo.ClassNumber,
ClassInfo.ClassDescription, ClassInfo.ClassFee, ClassInfo.PostEntryFee,
ClassInfo.Amateur, ClassInfo.Equitation, ClassInfo.SpecID, ClassInfo.USDF,
ClassInfo.WalkTrotJog, ClassInfo.Halter, ClassInfo.Sponsors,
ClassInfo.ClassCode, ClassInfo.USDFLevel, ClassInfo.WCRT,
ClassInfo.JumperLevel, ClassInfo.USDFStartTime, ClassInfo.USDFRideTime,
ClassInfo.USDFRing
FROM ClassInfo
WHERE classinfo.showid = [showidold];
 
Dale,
I am having trouble seeing any data or error messages or results or expected
results. Can you help me with this?
 
Duane,

I am just trying to copy from one show to another using this query. I get
nothing back as a error either but no records are inserted when they should
be. If I run the select part of the query by itself it returns what I would
expect. Not sure what it is doing wrong. That is why I was hoping someone on
this newsgroup could see what maybe I am missing

Dale

Duane Hookom said:
Dale,
I am having trouble seeing any data or error messages or results or expected
results. Can you help me with this?

--
Duane Hookom
MS Access MVP
--

Dale said:
I have written the following query and it does not work. I am not seeing
what
is wrong with this. Any who can see let me know.

Dale

PARAMETERS showidold Long, showidnew Long;
INSERT INTO classinfo ( ShowID, ClassID, ClassNumber, ClassDescription,
ClassFee, PostEntryFee, Amateur, Equitation, SpecID, USDF, WalkTrotJog,
Halter, Sponsors, ClassCode, USDFLevel, WCRT, JumperLevel, USDFStartTime,
USDFRideTime, USDFRing )
SELECT [showidnew], ClassInfo.ClassID, ClassInfo.ClassNumber,
ClassInfo.ClassDescription, ClassInfo.ClassFee, ClassInfo.PostEntryFee,
ClassInfo.Amateur, ClassInfo.Equitation, ClassInfo.SpecID, ClassInfo.USDF,
ClassInfo.WalkTrotJog, ClassInfo.Halter, ClassInfo.Sponsors,
ClassInfo.ClassCode, ClassInfo.USDFLevel, ClassInfo.WCRT,
ClassInfo.JumperLevel, ClassInfo.USDFStartTime, ClassInfo.USDFRideTime,
ClassInfo.USDFRing
FROM ClassInfo
WHERE classinfo.showid = [showidold];
Click to expand...
Click to expand...
 
Hi Dale,

Is it the "same" table?

Did you try aliasing table in select clause?

I might try inserting into a temp table,
then insert from temp table.

that's all that comes to mind....

gary

Dale said:
I am just trying to copy from one show to another using this query. I get
nothing back as a error either but no records are inserted when they
should
be. If I run the select part of the query by itself it returns what I
would
expect. Not sure what it is doing wrong. That is why I was hoping someone
on
this newsgroup could see what maybe I am missing

Dale

Duane Hookom said:
Dale,
I am having trouble seeing any data or error messages or results or
expected
results. Can you help me with this?

--
Duane Hookom
MS Access MVP
--

Dale said:
I have written the following query and it does not work. I am not seeing
what
is wrong with this. Any who can see let me know.

Dale

PARAMETERS showidold Long, showidnew Long;
INSERT INTO classinfo ( ShowID, ClassID, ClassNumber, ClassDescription,
ClassFee, PostEntryFee, Amateur, Equitation, SpecID, USDF, WalkTrotJog,
Halter, Sponsors, ClassCode, USDFLevel, WCRT, JumperLevel,
USDFStartTime,
USDFRideTime, USDFRing )
SELECT [showidnew], ClassInfo.ClassID, ClassInfo.ClassNumber,
ClassInfo.ClassDescription, ClassInfo.ClassFee, ClassInfo.PostEntryFee,
ClassInfo.Amateur, ClassInfo.Equitation, ClassInfo.SpecID,
ClassInfo.USDF,
ClassInfo.WalkTrotJog, ClassInfo.Halter, ClassInfo.Sponsors,
ClassInfo.ClassCode, ClassInfo.USDFLevel, ClassInfo.WCRT,
ClassInfo.JumperLevel, ClassInfo.USDFStartTime, ClassInfo.USDFRideTime,
ClassInfo.USDFRing
FROM ClassInfo
WHERE classinfo.showid = [showidold];
Click to expand...
Click to expand...
Click to expand...
 
Back
Top