meridiano
|
| Posted: 08/08/2002, 9:16 AM |
|
We have .MDB files with tables and querys. Querys are both types, like views and action queries (upfate, insert, etc.).
So, I want to know if is possible execute from CCS an action query saved on a .MDB database. I thinking in similar concept to store procedure.
|
|
|
 |
Nicole
|
| Posted: 08/09/2002, 1:52 AM |
|
Hello,
you can use Access select queries as grid form datasource (select ones from the tables list).
As for action queries (like update, insert) you cannot select Access query as stored procedures because you cannot pass parameters to it. The other way is to select 'SQL' from 'Custom Insert Type', open Custom Insert dialog and enter sql that will insert new record into the table. E.g.:
insert into priorities (priority_name) values ({name_val})
Then add the parameter with the "name_val" name and select proper control as its source.
|
|
|
|
|
