Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why did I write this code?
Message
 
 
To
15/12/2021 13:09:25
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01682961
Message ID:
01682964
Views:
64
>>Hi,
>>
>>I know I should not be admitting to writing some stupid code. But I was refactoring code in one method where I have the following, in a long SQL Select.
>>
>>isnul( table1.table_pk,11) as table1_pk  
>>
>>Since this is a PK value of a table, it should never be NULL.
>>But suppose I was being extra cautious, why "11"?
>>
>
>What's the definition of the pk field? Does it have a length of 11? Did it at some time?
>
>Tamar

The PK field is an integer, Identity field.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform