Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field valid - works only first time
Message
From
17/01/2006 09:08:23
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Database:
Oracle
Miscellaneous
Thread ID:
01087131
Message ID:
01087490
Views:
9
In fact I think problem is when SQLEXEC executes next times because it does not
recognize value as duplicate. In fact ORACLE gets empty value and as such don't
exists in table it tries to write record but than before insert trigger fails
because field is PK and not NULL.
I can resolve problem finding duplicates in BI trigger, but I would like prevoious
situation to be solved too.
Regards, Gojko
Previous
Reply
Map
View

Click here to load this message in the networking platform