[Babase] stumped in biograph 07a update
Karl O. Pinc
kop at meme.com
Wed Jan 2 12:03:18 EST 2008
On 01/02/2008 10:48:48 AM, kfenn wrote:
> Karl O. Pinc wrote:
>>
>> On 12/20/2007 03:08:45 PM, kfenn wrote:
>>> Hi Karl,
>>>
>>> My first attempt to upload demog update data has met with total
>>> failure.
>>>
>>> I need to update the Biograph table in order to enter the census
>>> data.
>>> If I try to use your Upload program to enter a series of new
>>> records, the system complains that the bioid cannot be null.
>>> I get the same complaint if I use the import button in the column
>>> browse window for the biograph table.
>>
>> Do you have a bioid column in the data you're trying to upload?
>> If you do then you're specifying a (NULL) data value and the system
>> does not like it.
>
> I do have a bioid column.
You're probably better off not having a bioid column. That'll
ensure that the system comes up with it's own bioid. There's
ways, I don't recall exactly what, to have empty mean NULL mean
the system gets to make one up but having no column at all
is easiest.
I can't remember how I was doing things
> before, but this morning I'm not getting a complaint about the bioid
> column. Instead I get... Invalid input syntax for integer "" . (I
> think its complaining about the bstatus column).
That error means to me that you've a empty ("") bstatus data
value. It's telling you that empty is not a number.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list