|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Execute procedure from Access by vba
Hi,
I need some example to execute a procedure from an Access database. After to defining the object "connection" (with ODBC driver), I could do in this way: con.Execute ("execute procedure TB_del") where "con" is the object "connection". In this case TB_del deletes some records froma a table, and so the output of the procedure is not a table. Someone could help me by showing some simple example about how to execute a firebird procedure from an access database (by vba) ? thanks and sorry for my english Michele De Meo http://crea.html.it/sito/micheledemeo/ |
|
#2
|
||||
|
||||
|
Look at the examples section at http://www.praktik.km.ua/ (you'll also find the latest ODBC driver there)
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) |
|
#3
|
|||
|
|||
|
Quote:
These examples are very useful, but I am not able to solve my poroblem!!!!!! By considering these example, I use the vba code: Dim con As ADODB.Connection Dim recSet As ADODB.Recordset Set con = New ADODB.Connection con.Open "DRIVER=Firebird/InterBase(r) driver;" & _ "Database=C:\mdmDb.fdb", "sysdba", "masterkey" con.Execute ("execute procedure db_canc") obtaining this msg: count field incorrect The procedure db_canc deletes some record from a table, and so there isn't a recordset as output!!!! How to do? thanks mdm |
|
#4
|
|||||
|
|||||
|
There are other examples also, something along the lines of
vb Code:
|
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Execute procedure from Access by vba |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|