Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote view redefine field to support NULL
Message
De
17/05/2003 11:25:00
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00789213
Message ID:
00789678
Vues:
21
Hi Sergey,

Table1

id TINYINT identity(0,1)PRIMARY KEY -- I WANT USES FULL SQL RANGE NUMBERS
tx VARCHAR(40)

Table2

id TINYINT identity(0,1)PRIMARY KEY -- I WANT USES FULL SQL RANGE NUMBERS
tx VARCHAR(40)

Table_Data
id INT identity(MININT,1)PRIMARY KEY
....
id_Table1 tinyint NOT NULL -- NEED VALUE !!! SQL DATABASE STRONG NATIVE RULE
id_Table2 tinyint NOT NULL -- NEED VALUE !!! SQL DATABASE STRONG NATIVE RULE
....

I EXEC "SELECT*FROM Table_Data" FOR BUILD LOCAL CURSOR.
On local, i append new row for user editing:
INSERT ... ...
id ???? don't have value, any new value can be mistaken.
id_Table1 ???? don't have default value.
id_Table1 ???? don't have default value.

I want one intrinsic coherence.
If I do not have a value, then it is NULL.
I do not want trick/track/truck....
Any trick is one logical lie, any logical lie is the seed of a bug.

fabio
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform