Toad World® Forums

Problem Inversion Order Number vs. Letters

Hi,

I have Toad 9.5 installed on a laptop and Toad 9.7 installed on a desktop.

On the first one once using order by on a field containing IDs being numbers or Text , numbers are ranked first. On the desktop it is the reverse.

How do I set-up things to get the same way of ranking / ordering?

Thanks

Pierre LECOCQ

Principal Scientist,

Janssen Diagnostics BVBA (JnJ / Virco),

Turnhoutseweg 30

B-2340 Beerse, Belgium

Email: plecocq@its.jnj.com

WEB: www.janssendiagnostics.com

Tel. +32 14 641276

Mob. +32 498 532496

Private:

Rue des Hausseurs 10.

B-4550 Nandrin

Belgium

Email : Piecoq23@Piecoq23.be

WEB: www.piecoq23.be

Tel. +32 4 3715983

Mob. +32 498 532496

are you talking about the sorting of the objects in the schema browser left hand side?

If so, we use the windows “CompareString” function to sort there. So Regional Settings in Control Panel could have an effect on this. Make sure the settings are the same on the two computers.