Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rule Validation Violated (only with ODBC)
Message
From
11/12/2000 16:08:25
 
 
To
11/12/2000 15:40:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00451727
Message ID:
00451862
Views:
25
Here you have more details about my problem.
My function (in stored procedures section of my database) is:
----------------
FUNCTION UpdateSearchField
LPARAMETERS tcTableName, tcField1, tcField2, tcFieldSearch
LOCAL lcNameSearch, llOk, lcOnError, llError, lcField1Val, lcField2Val
llOk=.T.
RETURN llOk
----------------
The call of the function is put in the "Record Validation Rule" field
of my table (like below).
UpdateSearchField("MyTable","cname","cname2","cnamesearch")
----------------
Like you can see, I have simplified my function by returning only
a true value. No error possibility???? I got the same error:
"Record Validation Rule is violated". All the parameters are characters
type. As you know, the field iCle already calls a NewId function. Why
my very simple function refuse to work (or cannot be called)?
Marc Levesque
La Prairie, Quebec (CANADA)
marc.levesque@videotron.ca
Previous
Reply
Map
View

Click here to load this message in the networking platform