T
Tommaso Cafini
Lot of Questions about this:
1.
I use docmd.outputto, exporting a SP or a view
How can I call a Sp with parameters with this command?
2.
In the mdb version i created temporary query for some exports, exported
the data and deleted it.
That because fields and criteria are variable.
Which aproach can i use with adp:
Can i put the whole sql in one stored procedure, and exporting the
resulting set ,
Or should i better create a temporary table or view or SP and exporting
this.
Do i get problem in the first case, when two users call the same SP with
different SQL in the same moment?
Thank for answers
Tommaso
1.
I use docmd.outputto, exporting a SP or a view
How can I call a Sp with parameters with this command?
2.
In the mdb version i created temporary query for some exports, exported
the data and deleted it.
That because fields and criteria are variable.
Which aproach can i use with adp:
Can i put the whole sql in one stored procedure, and exporting the
resulting set ,
Or should i better create a temporary table or view or SP and exporting
this.
Do i get problem in the first case, when two users call the same SP with
different SQL in the same moment?
Thank for answers
Tommaso