|
Home > Archive > FoxPro Help and Support > May 2005 > trigger problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| pass parameter ithrough WS 2005-04-28, 3:26 am |
| hi all
I made insert trigger in the dbc table and code like below
Procedure TESTINSERT_TRIGGER
CREATE TABLE C:\TEMPS\QQ.DBF(QQ C(10))
ENDPROC
EVERY TIME I APPEND ROW IN FOXPRO ,ALL SEEMS WORK WELL.
BUT I USE SQLPASSTHRU THE TRIGGER WONT MAKE QQ.DBF AS WELL.
| |
| pass parameter ithrough WS 2005-04-28, 3:26 am |
| CATCH ERROR MSSAGE BELOW
Connectivity error:[Microsoft][OD
BC Visual FoxPro Driver] Trigger failed
"pass parameter ithrough WS" wrote:
> hi all
> I made insert trigger in the dbc table and code like below
>
> Procedure TESTINSERT_TRIGGER
> CREATE TABLE C:\TEMPS\QQ.DBF(QQ C(10))
> ENDPROC
>
> EVERY TIME I APPEND ROW IN FOXPRO ,ALL SEEMS WORK WELL.
> BUT I USE SQLPASSTHRU THE TRIGGER WONT MAKE QQ.DBF AS WELL.
>
| |
| Anders Altberg 2005-04-28, 8:26 pm |
| Try
CREATE TABLE C:\Temps\Qq.DBF FREE (qq C(10))
Do you really have a folder called Temps?
If the database is open shared you can't add tables to it.
You could use CREATE CURSOR instead perhaps.
Are you using ODBC or OLEDB? VFP ODBC has very limited capabilities to use
stored procedures. For VFPODBC, see DRVVFP.HLP for supported and not
supported commands and functions, and when the are supported or not.
Are you using ODBC or OLEDB from a VFP application to talk to a VFP
database?
-Anders
"pass parameter ithrough WS"
< passparameterithroug
hWS@discussions.microsoft.com> wrote in message
news:2105AA5F-CC62-44C4-A3FD- BF5425C2E1D3@microso
ft.com...[color=darkred]
> CATCH ERROR MSSAGE BELOW
> Connectivity error:[Microsoft][OD
BC Visual FoxPro Driver] Trigger failed
>
> "pass parameter ithrough WS" wrote:
>
| |
| Cheng-RAY 2005-05-03, 3:24 am |
| I detected each command line in my stored procedure behind dbc. "&" and
'insert into ..sql' commands arise error through odbc driver.But i looking
for information in DRVVFP.HLP ,they both supproted by vfpodbc driver.
CONFUSE ME LOTS........................................
"Anders Altberg" wrote:
> Try
> CREATE TABLE C:\Temps\Qq.DBF FREE (qq C(10))
> Do you really have a folder called Temps?
> If the database is open shared you can't add tables to it.
> You could use CREATE CURSOR instead perhaps.
> Are you using ODBC or OLEDB? VFP ODBC has very limited capabilities to use
> stored procedures. For VFPODBC, see DRVVFP.HLP for supported and not
> supported commands and functions, and when the are supported or not.
> Are you using ODBC or OLEDB from a VFP application to talk to a VFP
> database?
> -Anders
>
> "pass parameter ithrough WS"
> < passparameterithroug
hWS@discussions.microsoft.com> wrote in message
> news:2105AA5F-CC62-44C4-A3FD- BF5425C2E1D3@microso
ft.com...
>
>
|
|
|
|
|