I have tried to insert a container data into a table
and select it using SQL Query Analyzer. The format of
a container I know is, it begins with 07 hex code and
end with FF hex code. I can only provide the format of
the container in image-type of the field.
This is the regular _expression_ of the container:
container = 07 { data }* FF
data = 00 string | 01 integer | 02 real
| 03 date | 04 boolean | 07 container
string = { byte }* 00
integer = ( byte )^4
real = ( byte )^10
date = ( byte )^3
boolean = ( 00 | 01 ) 00 F0
Just create a code to read the image-type of a field,
then query SqlDictionary table for the table and the
field name.
Good luck.
static void SWALearnContainerDataOutsideAxapta(Args
_args)
{
Table6 a;
;
a.Field1 =
[
'abc',
2,
3.0,
'abc',
false,
'abc',
true,
'abc',
[
'x',
'a',
1,
2,
3,
[
100,
200,
1\1\2005,
[
'abc'
]
]
],
'end'
];
a.insert();
/*0x
07
00 61626300
01 02000000
02 00000000000000000030
00 61626300
04 0000F0
00 61626300
04 0100F0
00 61626300
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 = 00 string | 01 integer | 02 real
| 03 date | 04 boolean | 07 container
string = { byte }* 00
integer = ( byte )^4
real = ( byte )^10
date = ( byte )^3
boolean = ( 00 | 01 ) 00 F0
*/
}
Btw, is there problem with the yahoogroups? I have
sent this email twice to make it work.
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
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.
