The color of NULL

Toad for Oracle & DevOps Toolkit
21

One thing about Guinness is this warning:

DON’T DRINK THE FROTH!

It is, apparently, highly bitter. You have to drink the stout through
the froth.

As told to me by an Irish Guinness maker!

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

22

att1.dat (43 Bytes)

23

image004.gif

24

Don’t buy a 4 pack.

Find an Irishman who knows how to pour a proper pint out of a tap…otherwise
you’re not really drinking Guinness.

25

image004.gif

26

att1.dat (43 Bytes)

27

It’s worth waiting a few weeks J

28

I am wondering if it’s possible to edit data in the data grid of the
Editor Window the same way as I edit data in the Data Tab of the table. Tried
changing the options around, but no luck so far.

I am using 9.7.

29

You need to include the rowid in your query to be able to do this

A toad ‘trick’ is to execute

Edit and execute with F9

30

Wow.

Thanks a lot, I did not know about edit…

Is there a reason why commit/rollback buttons on the data grid itself are
disabled? I do see insert/delete/post/cancel buttons now.

31

I don’t know why they are disabled…but I was able to COMMIT my
posted change by using the main toolbar COMMIT button.

32

Fortunately I added comments to the code in that area. :slight_smile:

It’s a context level commit that is only enabled when you have threaded
queries enabled and an active threaded session created for that Editor tab. When
you are not using the threaded queries option the main Toad commit/rollback is
used.

Michael

33

Comments in code? What a cool idea!

34

Yes, it worked for me as well by using the main commit. Thanks.

35

Real Programmers don’t comment their code. If it was hard to write, it should be
hard to understand.

http://www.guidenet.net/resources/programmers.html

36

Best code comments ever? http://twitpic.com/ocr00
pic…>

37

I'm showing off now:

Comments in code? What a cool idea!

{ How do they work in Delphi then? }

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

38

My favorite:
image001.jpeg

39

Thanks.

I did play with the threaded query option before, but it did not make any
difference. Do you know if I need to restart TOAD after this change? Is it the
‘Execute Queries in threads’ option?