DQL and API

A simple example by using DQL:

create dm_document object set object_name = 'test', setfile 'C:\Test\testing_dql.xml' with content_format = 'xml'

update dm_document object set title = 'File created via DQL', set keywords = 'first' where object_name = 'test'

update dm_document object append keywords = 'second' where object_name = 'test'

update dm_document object insert keywords[1] = 'middle' where object_name = 'test'

update dm_document object link '/Testing_API_DQL' where object_name = 'test'

select r_object_id, object_name, title, r_version_label from dm_document where object_name = 'test'

select r_object_id, object_name, title, r_version_label from dm_document (all ) where object_name = 'test'
select object_name, title from dm_document where object_name like '%e%'

select object_name, title from dm_document where object_name like tes_

select object_name, title from dm_document where any keywords = 'middle'

delect dm_document object where object_name = 'test'


API:

create ,c,dm_document

note: api_command,c,,,,<value of fourth argument>

Command: set ,c,<value of r_object_id>,object_name(or set,c,l,object_name)
Data:         test

Command: set ,c,l,keywords[0]
Data:         document

Command: set ,c,l,keywords[1]
Data:         api

Command: setfile ,c,l,C:\Test\testing_api.xml,xml
Data:  

Command: link ,c,l,'/Testing_API_DQL'
Data:             

Command: save ,c,l
Data:   

Command: id ,c,dm_document where object_name = 'test'
Data:
     
Command: get ,c,l,keywords[1]
Data:

Command: dump ,c,<value of r_object_id>
Data:

Command: destory ,c,<value of r_object_id>
Data:

评论

3 楼 tenn 2010-02-24  

Actually, you also get the information you want in my blog.

2 楼 tenn 2010-02-24  

Hi, you can use the dql below to get it:
select DATE(now) as systime from dm_server_config;

comment: DATE is a keyword in DQL.

1 楼 jy00257874 2010-02-24  

请问当前时间如何用DQL描述出来，EMAIL:[e-mail]