newattitude
Posts: 18
|
| Posted: 04/21/2005, 4:51 AM |
|
I have learned that I can't seem to get a 'macro' to run in event
I also can't seem to get my queries to run because many of them are doing an append and ONLY the records that don't violate the unique rules successfully go into the database which is not a problem in access because I setwarnings off but through the asp any query that can't complete without a warning just does NOT run??
I of course have the options in the database set so no warnings occur but it doesnt matter
for example a query that runs a make table
the first time you run it when no table is there succeeds through asp code but next time it is run fails
Also - query doing an append and there is a field that does not allow duplicates - say the append for that instance is 20 rows but 10 can't go in because of unique values - that query will NOT run through asp because it could not pass all the records
PLEASE HELP - I use code charge studio and It is VERY easy to call the queries as per my example
sql="exec query2"
DBLion.Execute sql
sql="exec query_misc1"
DBLion.Execute sql
but I am SOL without a way to run queries that don't always meet the 'rules'
thank you very much
_________________
More Later,
Susan Justice |
 |
 |
peterr
Posts: 5971
|
| Posted: 04/21/2005, 9:26 AM |
|
I think that there is no way to get marcos to run in ASP at all. If there is such a way then it should work in events.
As for running non-SELECT queries, I also think that you're limited only by what ASP itself allows. If ASP doesn't allow something then it just won't work with- or without CCS.
However, you could try:
1. In case you're using ODBC connection, try using JET connection instead.
2. Search the Internet (Google) to see how others deal with this in ASP.
3. Best method: execute the SQL statement instead of MS Access Query. Just view the SQL of your MS Access query, then execute that SQL. Of course it may have to be a 'clean' SQL that doesn't use any MS Access VB statements or macros.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
