Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter and Null values
Message
From
29/06/2007 12:29:32
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01236827
Message ID:
01236849
Views:
16
>Hi Boris.
>
>>I just wandering why you allow NULLs in fields other then DateTime?
>
>I have two tables, and this field is used to create a relation between tables. The most cases, this relation have to exist, but in some cases, I can add a record in TableA, but I will not add a record in TableB.
>
>In this case, I have to keep the value NULL, or SQL will return an error. I'm starting with MS-SQL, maybe there is other way to do it, but I don't know!

If I understood you correctly TableA is the Parent table, right?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform