I couldn't help with the code, but I can give an
information about the format of Axapta container
stored in MSSQL database.
I run a job to insert a container into a table, then I
select the table from Query Analyzer. From there, I
could see that a container is stored with beginning 07
hexadecimal code and finished with FF hexadecimal
code.
>From that definition, you could begin to try and
understand the other type of data (string, boolean,
etc.) and define the total bytes required to store
that type of data.
About the table name and field name, you could use
SqlDictionary table for lookup from tableId and
fieldId.
Anyway, hope this help and if my vs.net installation
was okay, maybe I had tried the code myself.
static void SWALearnContainerDataOutsideAxapta(Args
_args)
{
Table6 a;
;
a.Field1 =
[
'satu',
2,
3.0,
'satu',
false,
'satu',
true,
'satu',
[
'x',
'a',
1,
2,
3,
[
100,
200,
1\1\2005,
[
'abc'
]
]
],
'end'
];
a.insert();
/*0x
07
00 7361747500
01 02000000
02 00000000000000000030
00 7361747500
04 0000F0
00 7361747500
04 0100F0
00 7361747500
07
07
00 7800
00 6100
01 01000000
01 02000000
01 03000000
07
07
01 64000000
01 C8000000
03 690000
07
07
00 61626300
FF
FF
FF
00 656E6400
FF
dat 7974846
container = 07 { data }* FF
data = string | integer | real | date |
boolean | container
string = 00 { byte }* 00
integer = 01 ( byte )^4
real = 02 ( byte )^10
date = 03 ( byte )^3
boolean = 04 ( 00 | 01 ) 00 F0
*/
}
Good luck.
Best regards,
Sonny Wibawa Adi, MBSCP, MCSD.NET, MCAD.NET
--- Lars Mikkelsen <[EMAIL PROTECTED]> wrote:
> Yes. It is a serialized container of containers. You
> can see how it is
> serialized in method SysDataBaseLog.SetData and
> deserialized in method
> SysDataBaseLog.GetDataAsList.
>
>
>
> It is probably difficult to figure out the format of
> a serialized container,
> so it will be difficult to create an external
> algorithm for doing this,
> unless someone else has done this and is willing to
> publish the code.
>
>
>
> You have a couple of other options.
>
>
>
> Make a call through the COM connector and let a
> method in Axapta return the
> information in a format you can use.
>
>
>
> Overwrite Insert/update methods of SysDataBaseLog
> and store the information
> in a format that is easy for you to read and
> interpret.
>
> This could be in another table or in a new field in
> SysDataBaseLog in
> whatever format you may choose.
>
>
>
>
>
>
>
>
>
> _____
>
> From: [email protected]
> [mailto:[EMAIL PROTECTED] On
> Behalf Of Andres Janno
> Sent: Tuesday, August 23, 2005 2:49 AM
> To: [email protected]
> Subject: Re: [development-axapta] reading
> sysdatabase log outside axapta
>
>
>
> No, I mean that sysdatabaselog data field is somehow
> crypted or
> something. It is container type of field.
> Is there any outside algorithm to decode this data
> field?
>
> Regards,
> Andres
>
> Erik Hansen wrote:
>
> > You might need to install a ODBC driver on the
> computer, but otherwise
> > use the ODBCConnection in Axapta.
> >
> >
> >
> > Best regard
> >
> > Erik
> >
> >
> >
> > ________________________________
> >
> > From: [email protected]
> > [mailto:[EMAIL PROTECTED] On
> Behalf Of Andres Janno
> > Sent: 23. august 2005 10:30
> > To: [email protected]
> > Subject: [development-axapta] reading sysdatabase
> log outside axapta
> >
> >
> >
> > Hello!
> >
> > Is there any possibilities to read sysdatabaselog
> data container outside
> >
> > axapta?
> > >From sql query analyzer directly for example?
> >
> > Regards,
> > Andres
> >
> >
> >
> >
> >
> > ________________________________
> >
> > YAHOO! GROUPS LINKS
> >
> >
> >
> > * Visit your group "development-axapta
> > <http://groups.yahoo.com/group/development-axapta>
> " on the web.
> >
> > * To unsubscribe from this group, send an
> email to:
> >
> [EMAIL PROTECTED]
> >
>
<mailto:[EMAIL PROTECTED]
> > be>
> >
> > * Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of
> > Service <http://docs.yahoo.com/info/terms/> .
> >
> >
> >
> > ________________________________
> >
> >
> >
> > [Non-text portions of this message have been
> removed]
> >
> >
> >
> >
> >
> > SPONSORED LINKS
> > Computer part
> > <http://groups.yahoo.com/gads?t=ms
>
<http://groups.yahoo.com/gads?t=ms&k=Computer+part&w1=Computer+part&w2=Progr
>
amming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=yLpvc
> LTIDJ5FTkRJGsO11w>
>
&k=Computer+part&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axap
>
ta&w4=Support+exchange&c=4&s=90&.sig=yLpvcLTIDJ5FTkRJGsO11w>
>
> > Programming languages
> > <http://groups.yahoo.com/gads?t=ms
>
<http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Computer+part&
>
w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.s
> ig=cuhEClK4dU4wapXFmKisbQ>
>
&k=Programming+languages&w1=Computer+part&w2=Programming+languages&w3=Micros
>
oft+axapta&w4=Support+exchange&c=4&s=90&.sig=cuhEClK4dU4wapXFmKisbQ>
>
> > Microsoft axapta
> > <http://groups.yahoo.com/gads?t=ms
>
<http://groups.yahoo.com/gads?t=ms&k=Microsoft+axapta&w1=Computer+part&w2=Pr
>
ogramming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=yf
> eG_U6QaLfPOZZIud02Fg>
>
&k=Microsoft+axapta&w1=Computer+part&w2=Programming+languages&w3=Microsoft+a
>
xapta&w4=Support+exchange&c=4&s=90&.sig=yfeG_U6QaLfPOZZIud02Fg>
>
> >
> > Support exchange
> > <http://groups.yahoo.com/gads?t=ms
>
<http://groups.yahoo.com/gads?t=ms&k=Support+exchange&w1=Computer+part&w2=Pr
>
ogramming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=hy
> 8yRGMzrmxdphyITTUeqA>
>
&k=Support+exchange&w1=Computer+part&w2=Programming+languages&w3=Microsoft+a
>
xapta&w4=Support+exchange&c=4&s=90&.sig=hy8yRGMzrmxdphyITTUeqA>
>
> >
> >
> >
> >
>
------------------------------------------------------------------------
> > YAHOO! GROUPS LINKS
> >
> > * Visit your group "development-axapta
> >
> <http://groups.yahoo.com/group/development-axapta>"
> on the web.
> >
> > * To unsubscribe from this group, send an
> email to:
> >
> [EMAIL PROTECTED]
> >
>
<mailto:[EMAIL PROTECTED]>
> >
> > * Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of
> > Service <http://docs.yahoo.com/info/terms/>.
> >
> >
> >
>
------------------------------------------------------------------------
>
=== message truncated ===
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
