PrimoDonna
|
| Posted: 10/05/2002, 10:55 AM |
|
I have a bunch of queries in my Access database that I would like to use in CCS.
Whats the easiest way to do this.
1)When I try to import a query, CCS asks for a primary key, is there a way to work around this.
2)Can I copy and paste the SQL code that Access 2002 shows you , even if you created the query without the use of SQL.
3) If so do I have to have change the database type from Access to SQL*.*
If it is possible to import these queries, it would transform how I use Codecharge and Im sure for many other neophytes
who have not seen any mention of this either in the onsite discussion, manuals, newsgroups or tutorials.
If this is not possible, maybe a best practice example of recreating queries would be enlightning
I ask this question not just for me...but for Ethel and all the other me's
|
|
|
 |
smartalec
|
| Posted: 10/07/2002, 9:51 AM |
|
|
|
|
|
Nicole
|
| Posted: 10/08/2002, 7:00 AM |
|
Hello,
you can use Access queries in CCS. But note that you can use as tables and select as Table type datasources only those queries which select data from tables, but not update/insert/delete ones.
The other way is retype the query inside DatSource dialog.
You can also use custom queries for update table operations (insert/update/delete) if you select SQL as Custom <Operation> Type and type in sql query in the dialog.
|
|
|
|
|
