Recent content by Avaatar

Sounds very nice, thank you for your answer Paul. How about the security stuff? In the past, i heard much stuff about SQL servers (negative ones). Got the security (hacking and such things) better? And how is it about backup/restore? Im really grateful for your advises, thank you. Helge.

Hello all, i hope this is the correct forum, because my question belongs a bit to administration and other stuff. My company uses at the moment right now Unix machines, with Oracle 8i on it. We will migrate now to Oracle 10g, on Windows 2003 Server (Noone here cant handle Unix well, so we...

Hello, i hope this is the correct forum for my issue. Im starting to learn VB with the Visual Studio 2005. I installed it at home on my Win XP SP2 machine, and i configued it, that it will save the projects on my homeserver, which is located in the same LAN. On the server is a Windows 2003 SP1...

Hi, thanks for your hints. My problem is, i cant reproduce this phenomen really. I reinstalled my whole system, no result. Now im working on a second computer, where this error happens too, but more rare. I think, it happens, if there some kind of "runtime error" in the form, or something else...

Hello all, i have a strange behauvior, which makes me go nuts slowly. Im programming Forms 6i, and often i have the problem, that after i saved a form, the filesize(of the source) change dramatically, and the form is destroyed. I am compiling that form then, and when i run the compiled file, i...

Thanks a lot, i will check this out :-)

Hello all, i am trying to do following: I have a form(Forms 6i), where i want to make a doubleclick into a field. When this is done, i want an eMail created, with recipient, sender, and so on filled. This is not the biggest problem. The problem is, now i would like to add an attachment(txt oder...

Thank you :-) I still need to learn a lot it seems.

Hello, one(late) question please again: I didnt noticed it before really, but what does the # do in the query you suggested? IF :block.date_field IS NOT NULL THEN :block.date_field := '#>= ''' || :block.date_field || ''''; END IF; Is it some type of implizit type conversion? Thank you :-)

Thank you for your help :-)

Thank you :-)

Another question please, i am experiencing now a heavy performance hit(i think because of the casting varchar2 -> date). How can i do this without a casting?

Thank you, it worked very well :-)

Hello all, i have at the moment following problem: I have a record block, which is filled with a FROM clausel. In this Record Block is a field, which contains a date. The user can type in a date, to find all records from this date. Now i would like to modify this, so that Forms bring out all...

It is now: SELECT DISTINCT a.ptno, a.pcode, a.geo2, a.site4, a.ptname, b.release FROM pt a, rs b WHERE a.ptno = b.ptno AND b.release = (SELECT MAX(b.release) FROM RS b WHERE a.ptno = b.ptno) The interesting was, it took so long to execute this query, because Oracle perfomed a full table scan...