| Author |
Error Number 3000: Reserved Error (-3002); there is no message for this error
|
|
| dkintheuk 2005-06-29, 11:24 am |
| Help...
I've been moving code about to tidy it up and this error is occuring.
I have tracked it down to a set querydef command, i have properly
specified a database and am using correct syntax for the set command
but this error is popping up.
Any ideas why?
Please help.......
Rob.
| |
| dkintheuk 2005-06-30, 3:24 am |
| Er... gonna sound dumb now but how do I do that?
Thanks.
| |
| dkintheuk 2005-06-30, 7:25 am |
| Ok... found out how... easy really.
Unfortunately, there is no change in the behaviour of the code.
Argh!
Still could use some help here...
| |
| dkintheuk 2005-06-30, 7:25 am |
| I've now decomplied...
Then i exported all code...
Then i compacted and repaired the db
Then i reimported all the code
Then i compacted and repaired again
It still doesn't want to work!
| |
| dkintheuk 2005-06-30, 7:25 am |
| Ok... here it is - i was being thick (no surprise there).
I had a problem in my SQL in that the SQL was designed to do a
TRANSFORM to create a nice crosstab query.
I later added an INTO command to the SQL to get the output into a temp
table.
This is not allowed for TRANSFORM queries. Just need to work in two
stages and take the output from the first query into a SELECT * FROM
query...
Simple really... <grumble>
|
|
|
|