Problem with Trigger

[l***@gmail.com]

I have a problem with a trigger...
In the database i have a store procedure that contain the
expression :

Scatter MEMO NAME oRg

if the record is modified from a vfp program i have no problem...
but if i modified by a vb .net program that line return me an error...

how can i resolve it ?

Thank You
Luca

[Dan Freeman]

What version of VFP? The scatter command may not be supported via OLEDB.

See the topic "
OLE DB Provider for Visual FoxPro" in the help file for more information.

Post by l***@gmail.com
I have a problem with a trigger...
In the database i have a store procedure that contain the
Scatter MEMO NAME oRg
if the record is modified from a vfp program i have no problem...
but if i modified by a vb .net program that line return me an error...
how can i resolve it ?
Thank You
Luca

[l***@gmail.com]

vfp 9... or vfp 6 ...it's ok with vfp

Post by Dan Freeman
What version of VFP? The scatter command may not be supported via OLEDB.
See the topic "
OLE DB Provider for Visual FoxPro" in the help file for more information.

Post by l***@gmail.com
I have a problem with a trigger...
In the database i have a store procedure that contain the
Scatter MEMO NAME oRg
if the record is modified from a  vfp program i have no problem...
but if i modified by a vb .net program that line return me an error...
how can i resolve it ?
Thank You
Luca- Nascondi testo citato

- Mostra testo citato -

[Dan Freeman]

If it's 6, it isn't OLEDB.

I'm kinda guessing what you're really doing here. Any clarification would
help us help you. Are you using OLEDB (VFP7 or higher) or ODBC (VFP6 max)?

Dan

Post by l***@gmail.com
vfp 9... or vfp 6 ...it's ok with vfp

Post by Dan Freeman
What version of VFP? The scatter command may not be supported via OLEDB.
See the topic "
OLE DB Provider for Visual FoxPro" in the help file for more
information.

Post by l***@gmail.com
I have a problem with a trigger...
In the database i have a store procedure that contain the
Scatter MEMO NAME oRg
if the record is modified from a vfp program i have no problem...
but if i modified by a vb .net program that line return me an error...
how can i resolve it ?
Thank You
Luca- Nascondi testo citato

- Mostra testo citato -

[Olaf Doschke]

Post by Dan Freeman
I'm kinda guessing what you're really doing here. Any clarification would
help us help you. Are you using OLEDB (VFP7 or higher) or ODBC (VFP6 max)?

Luca may access the tables natively
by VFP6 and 9, and via OLEDB
by VB.NET

The fact is, that SCATTER is supported by OLEDB
according to the VFP help. I assume by ODBC too.

There may be something else not being
supported by ODBC or OLEDB in the
stored procedure code.

Luca, please provide your
trigger code and we may find out,
what is not working from the VB.NET
side. My guess is, it's something different
than the scatter line.

Bye, Olaf.

[Dan Freeman]

But is SCATTER NAME supported?

There were "object issues" in some versions of the OLEDB provider.

Dan

Post by Olaf Doschke

Post by Dan Freeman
I'm kinda guessing what you're really doing here. Any clarification
would help us help you. Are you using OLEDB (VFP7 or higher) or ODBC
(VFP6 max)?

Luca may access the tables natively
by VFP6 and 9, and via OLEDB
by VB.NET
The fact is, that SCATTER is supported by OLEDB
according to the VFP help. I assume by ODBC too.
There may be something else not being
supported by ODBC or OLEDB in the
stored procedure code.
Luca, please provide your
trigger code and we may find out,
what is not working from the VB.NET
side. My guess is, it's something different
than the scatter line.
Bye, Olaf.