Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax Error Or Access Violation
Message
From
29/11/2002 19:35:28
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
29/11/2002 05:00:18
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00728121
Message ID:
00728277
Views:
15
>Hi,
>
>I am suddenly getting a strange problem. This problem occurs only on
>one Oracle Database.
>
>The problem is the previously working code:
>
>lcsql='{Call UpdateColors(?lcBv)}'
>SQLEXEC(h,lsql)
>
>today returns the error 1526 : Syntax Error Or Access Violation
>
>But the code:
>lcsql="{Call UpdateColors('test')}"
>SQLEXEC(h,lsql)

Both times you stored it into lcsql, and then call SQLExec with lsql. Are you sure it's spelled correctly in your code (I assume you retyped it here)?

Second, what is the exact content of lcBv? You may need a breakpoint before the first line just to see what is really there.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform