Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Referential integrity and null values
Message
 
 
À
12/04/2005 06:27:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00990085
Message ID:
01003687
Vues:
22
>Hi Nadya,
>
>>Are you sure it's not supported? We did a test with my colleague today in VFP8 and it worked fine, e.g. I was able to insert null. Steve Sayer's code, OTOH, doesn't support this.
>
>What RI builder did you use, AMRI or the standard VFP builder ? Here the VFP builder didn't allow me to insert null, and AMRI didn't work at all when the database was accessed through OleDb.
>
>David

Native RI builder allows to insert NULLs. At least in VFP8 it does. Basically, it gives an error on SEEK command, which is handled in rierror routine and as the end result returns true.

I'm currently writing my own RI builder where I'll try to avoid things which are not allowed in the Ole Db. Do you have link handy?

Thanks again.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform