Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pgrandjean
Starting Member
5 Posts |
 Posted - 2009-07-30 : 15:17:56
|
| Hi.I am writing a view in sql2005. It reads data from the table SysDatabaseLog in my Axapta.Select * from SysDatabaseLog works fine, exept for the content of the field Data. Data has the datatype Picture.Somewhere in the field there is information about status before and after a change, as well as the date for the change are kept in the field. I do not know where, and all I can see is a long hex-string like: 0x07FD0707FD0103000100005600650073007400630065006E000000004C006F00670069007300740069006B000000FFFFI would like the view to show the date, the status-before and the status after in tree fields. And I like them to be shown in a regular way like 29-09-2008 3 4 (on sept 29 there was a change from 3 to 4)How can I do that. I have tried to investigate the substring command, but am not sure if that is correct.Hope to get help !!Best regards / Med venlig hilsenPeterMed venlig hilsenPeter |
|
|
SQLSoaker
Posting Yak Master
169 Posts |
Posted - 2009-07-30 : 16:36:55
|
| Hi,If you table browse sysdatabaselog WITHIN axapta and select the drop down button on the data field, I believe you can make a correlation between the long hex string you see in SQL to the physical data you see in the tree structure in Dynamics.Please note that this is just my theory however.Good luck. |
 |
|
|
SQLSoaker
Posting Yak Master
169 Posts |
Posted - 2009-07-30 : 16:41:08
|
| Looks like my theory was wrong. I believe this holds the picture for the load of the tree structure however. I doubt you will be able to extract data from it in sql, you would have to make the view within the AOT. |
|
|
|
Pgrandjean
Starting Member
5 Posts |
Posted - 2009-07-31 : 01:08:13
|
| Thanks you. Is it your oppionion, that I in know way can show the contents of an image field in sql ? I hope, but do fear that you are right.Med venlig hilsenPeter |
|
|
|
|
|
|
How to show data from a picturefield