How to pass a variable to a trigger by odbc

[Florian Hofmann]

Hi,
I am not so familiar with VFP. I have an VFP-Database, which use a
variable (MyVariable) in a trigger. I want to set a value for this
MyVariable in the SQL-Statement (e.g. used from MS-Querry).

So i am looking for a sql-expression like:

DECLARE MyVariable int
Set MyVariable = 123

update MyTable Set Nickname="Donald" where Surname="Duck"

But... unfortunately, it does not work...

How can i pass this value to the trigger using ODBC and MS Querry?

Thanks in advance,

Florian

***@web.de

[Anders Altberg]

VFPODBC has not been updated since VFP6 and it never allowed calling general
stored procedures or passing parameters to the triggered database procedures
it does support.
Since VFP7 Mixcrosoft distributes VFPOLEDB with VFP. VFPOLEDB allows you
you to call any stored procedure, with parameters if you like.
The help for VFPODBC is called DRVVFP.HLP and should bge found somewhere in
the Windows system folders.
The help for VFPOLEDB is integrated with the Help file and partially in the
MSDN Library.
-Anders

Post by Florian Hofmann
Hi,
I am not so familiar with VFP. I have an VFP-Database, which use a
variable (MyVariable) in a trigger. I want to set a value for this
MyVariable in the SQL-Statement (e.g. used from MS-Querry).
DECLARE MyVariable int
Set MyVariable = 123
update MyTable Set Nickname="Donald" where Surname="Duck"
But... unfortunately, it does not work...
How can i pass this value to the trigger using ODBC and MS Querry?
Thanks in advance,
Florian