Question regarding several fields in object table.

jemmy

Navision 3.70
SQL Server 2000 SP#3
Windows 2000 Adv. Server SP#4

Dear Folks,

Anyone could explain to me what is the use of these following fields:

"BLOB Reference"
"BLOB Size"
"DBM Table No_"
"Time"

It's pretty ridiculous that Navision system separated Date and Time in 2 different fields.
I guessed this should be a limitation of Navision Standard DB, is it true?

Thanks in advance as always,

Jemmy

Arhontis

Hello,

As far as I know:

"BLOB Reference" : is the code behind the object.
"BLOB Size" : is the size of the BLOB Reference, but not sure.
"DBM Table No_" : do not know, but its all zero to me.
"Time" : The time it was last changed

the blob field contains the code in an encrypted form, is that right?

As for the seperation of the Date and Time, I guess you are right.

Anyway, I believe that the SQL-Server implementation was done a bit hasty and a lot of things could be done better.

jemmy

Hi Arhontis,

Thanks for your informations..
Can you give me an example of encrypted form? Too bad I'm quite new for all of these.. :? A brief description should be expected...

hope to hear again from you.

Jemmy

Arhontis

Hello,

Here is the Blob reference of forms:

Customer Statistics
Customer Entry Statistics
Customer Card

0x01447C5A0F4086DFAFBF7DD9956FD8EFDBEFBE2CCC6D989B067DA6188C59841B2361034B3140718DF0D366CDB2889685C124828435B6DAF8DB0E5544515544515CAAB94ED5DA0A24E5CA972AE572E57FFFDFBEFE7E3F94FCBBDABEDE77B796E797FBF79FEDCF4BAF3CEF9DF439E77CBCE7A1DF43BE5EE77FE03BD07A17B17A

0x01447C5A0F88849CF0EED5A4EED17927380C800000041000E40108084424920004042400560D8C445556A464E0114246C901452A8B4555551016B29621024249015AD528B6AAB51556AAB45E8B5554A0201455AAAAB555ABFBFF39F7C4FC878640C57275A5B8E4C4EE57987BEE5ECCEDCCB8D343B9DD035BBA0E938E97749D

0x01447C5A10807DE1787B4693779FFEE9D24E924924908420001F704380184000000000090001058702222AAF127C43924EE1EEE8082551488A22B282ABCC23CF4E92F4924032DD856DD739ADB5BAAB5CAED6DD6E73640642956E6AD75D75BB67FFFFEFBFBE87C4EFFE8C7EB3B57013CDF5D3795717DBDBD7F05F4B76F7B5DE

Perhaps I am wrong about the "code" representation of the BLOB reference. the field has about 256 chars in every table that don't has NULL to it...

:?: :roll:

Joe_Little

There are date, time and datetime variable types. Pre 2.6 there were just date and time so most of the reference in the object set uses one of the former.

DateTime is available for use and works as you would expect using a SQL back end. Date and time fields are represented as DateTime in SQL, but only use part of the information.

BLOB is a generic term meaning binary large object and can represent any binary set. In this case, I believe that it references the compiled code for the object.