Question about .inf

[Jean Vallee]

I have converted a dataset from a client and I have one record with a number field that the IDE is telling me had a value of .inf when in fact it’s 14476.10. I’m debugging reports now, comparing the Simpol reports to the Superbase reports to make sure they match. I’ve retyped the value in the field and saved the record. I duped the original record and deleted the original. I reorged the file. What would cause this and how can I avoid it in the future? Jean Vallee

[Michael]

On 24/04/2013 13:36, Jean Vallee wrote:
> I have converted a dataset from a client and I have one record with a
> number field that the IDE is telling me had a value of .inf when in fact
> it's 14476.10.
>
> I'm debugging reports now, comparing the Simpol reports to the Superbase
> reports to make sure they match.
>
> I've retyped the value in the field and saved the record. I duped the
> original record and deleted the original. I reorged the file.
>
> What would cause this and how can I avoid it in the future?
>
> Jean Vallee
>
>

Hi Jean,

Are you saying that the data as converted using the conversion tool contained a .inf value in a field?

Ciao, Neil

[Jean Vallee]

On 4/29/2013 1:42 PM, Neil Robinson wrote:
> On 24/04/2013 13:36, Jean Vallee wrote:
>> I have converted a dataset from a client and I have one record with a
>> number field that the IDE is telling me had a value of .inf when in fact
>> it's 14476.10.
>>
>> I'm debugging reports now, comparing the Simpol reports to the Superbase
>> reports to make sure they match.
>>
>> I've retyped the value in the field and saved the record. I duped the
>> original record and deleted the original. I reorged the file.
>>
>> What would cause this and how can I avoid it in the future?
>>
>> Jean Vallee
>>
>>
>
> Hi Jean,
>
> Are you saying that the data as converted using the conversion tool contained a .inf value in a field?
>
> Ciao, Neil

Yes, I used the tools provided to convert the db's. I've found a couple
of other records like it as well (out of 4000+)

[Michael]

On 30/04/2013 01:47, JV wrote:
> On 4/29/2013 1:42 PM, Neil Robinson wrote:
>> On 24/04/2013 13:36, Jean Vallee wrote:
>>> I have converted a dataset from a client and I have one record with a
>>> number field that the IDE is telling me had a value of .inf when in fact
>>> it's 14476.10.
>>>
>>> I'm debugging reports now, comparing the Simpol reports to the Superbase
>>> reports to make sure they match.
>>>
>>> I've retyped the value in the field and saved the record. I duped the
>>> original record and deleted the original. I reorged the file.
>>>
>>> What would cause this and how can I avoid it in the future?
>>>
>>> Jean Vallee
>>>
>>>
>>
>> Hi Jean,
>>
>> Are you saying that the data as converted using the conversion tool contained a .inf value in a field?
>>
>> Ciao, Neil
>
> Yes, I used the tools provided to convert the db's. I've found a couple
> of other records like it as well (out of 4000+)
>

I would be interested in a copy of the SBF that produced this, together with enough info to identify which record we are looking
at. Can you make copy of the file and try and remove all data except maybe one record that shows this and which when converted
still has a .inf value?

Ciao, Neil

[Jean Vallee]

On 4/30/2013 9:26 AM, Neil Robinson wrote:
> On 30/04/2013 01:47, JV wrote:
>> On 4/29/2013 1:42 PM, Neil Robinson wrote:
>>> On 24/04/2013 13:36, Jean Vallee wrote:
>>>> I have converted a dataset from a client and I have one record with a
>>>> number field that the IDE is telling me had a value of .inf when in fact
>>>> it's 14476.10.
>>>>
>>>> I'm debugging reports now, comparing the Simpol reports to the Superbase
>>>> reports to make sure they match.
>>>>
>>>> I've retyped the value in the field and saved the record. I duped the
>>>> original record and deleted the original. I reorged the file.
>>>>
>>>> What would cause this and how can I avoid it in the future?
>>>>
>>>> Jean Vallee
>>>>
>>>>
>>>
>>> Hi Jean,
>>>
>>> Are you saying that the data as converted using the conversion tool contained a .inf value in a field?
>>>
>>> Ciao, Neil
>>
>> Yes, I used the tools provided to convert the db's. I've found a couple
>> of other records like it as well (out of 4000+)
>>
>
> I would be interested in a copy of the SBF that produced this, together with enough info to identify which record we are looking
> at. Can you make copy of the file and try and remove all data except maybe one record that shows this and which when converted
> still has a .inf value?
>
> Ciao, Neil

I'll work on it later this pm. It's screwing up my reports so I must
have a solution.

Jean

[Jean Vallee]

On 4/30/2013 12:58 PM, JV wrote:
> On 4/30/2013 9:26 AM, Neil Robinson wrote:
>> On 30/04/2013 01:47, JV wrote:
>>> On 4/29/2013 1:42 PM, Neil Robinson wrote:
>>>> On 24/04/2013 13:36, Jean Vallee wrote:
>>>>> I have converted a dataset from a client and I have one record with a
>>>>> number field that the IDE is telling me had a value of .inf when in
>>>>> fact
>>>>> it's 14476.10.
>>>>>
>>>>> I'm debugging reports now, comparing the Simpol reports to the
>>>>> Superbase
>>>>> reports to make sure they match.
>>>>>
>>>>> I've retyped the value in the field and saved the record. I duped the
>>>>> original record and deleted the original. I reorged the file.
>>>>>
>>>>> What would cause this and how can I avoid it in the future?
>>>>>
>>>>> Jean Vallee
>>>>>
>>>>>
>>>>
>>>> Hi Jean,
>>>>
>>>> Are you saying that the data as converted using the conversion tool
>>>> contained a .inf value in a field?
>>>>
>>>> Ciao, Neil
>>>
>>> Yes, I used the tools provided to convert the db's. I've found a couple
>>> of other records like it as well (out of 4000+)
>>>
>>
>> I would be interested in a copy of the SBF that produced this,
>> together with enough info to identify which record we are looking
>> at. Can you make copy of the file and try and remove all data except
>> maybe one record that shows this and which when converted
>> still has a .inf value?
>>
>> Ciao, Neil
>
> I'll work on it later this pm. It's screwing up my reports so I must
> have a solution.
>
> Jean

I am using a volatile db to sort records. If the user had selected a
code but not entered a value for that code, it was sometimes .inf when I
read it. I'm accumulating totals by code so .inf + anyvalue = .inf.

I will still try to replicate how they are getting .inf in the first
place but don't have time right now to create a dummy set of data to
send you. I have too many clients chomping at the bit to get the new
version.

[Michael]

On 02/05/2013 16:29, JV wrote:
> I am using a volatile db to sort records. If the user had selected a
> code but not entered a value for that code, it was sometimes .inf when I
> read it. I'm accumulating totals by code so .inf + anyvalue = .inf.
>
> I will still try to replicate how they are getting .inf in the first
> place but don't have time right now to create a dummy set of data to
> send you. I have too many clients chomping at the bit to get the new
> version.

Very strange. As far as I can tell, having had a brief look at the library that does the conversion, there is no place that
assigns .inf when reading from an SBF file.

Ciao, Neil

[Author]

Posts