| few questions about forms and Sql [message #86664] |
Mon, 18 October 2004 02:17  |
Naveen Thimmappa
Messages: 1
Registered: October 2004
|
Junior Member |
|
|
1) what is $$date$$ and $$dbdate$$
2) Diffrent events of D2k Windows at runtime
3) What are the lock options for a report?
4) Can we create a Record Group at Runtime?What are the
Built-ins to modify a recordgroup?
5) Is there a query to display 'o r a c l e' as
'oracle' ie to remove space between the charcters.
6) Is there a query to display number of employees
in each department without using Count
|
|
|
|
| Re: few questions about forms and Sql [message #86676 is a reply to message #86664] |
Tue, 19 October 2004 00:15  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
1.$$DATE$$ retrieves the current operating system date (client-side).
$$DBDATE$$ retrieves the current database date.
2.When-window-activated,When-window-Closed,When-window-resized,When-window-deactivated.
3.Not clear what is meant by report here.
4.Yes.
CREATE_GROUP,CREATE_GROUP_FROM_QUERY,ADD_GROUP,ADD_GROUP_ROW.
5.select replace('o r a c l e',' ','') from dual;
6.Use a summary column or create a Control item and assign it value in Post-query trigger by using
Select count(*) .... query.
HTH
Regards
Himanshu
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
