Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Case sensitive server crashes my app
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Case sensitive server crashes my app
Divers
Thread ID:
00994028
Message ID:
00994028
Vues:
79
Sergey,

Might as well ask the master:

One of my apps (VFP8) is, along with the SQL Server DB, being ported to another
installation with a Case sensitive SQL server, polish.

The problem is, that code that used to run, like:

SELECT DISTINCT Movement FROM dbo.MYTABLE now returns -1, failed.

The field is of course defined as all uppercase MOVEMENT.

Wading through the entire app and changing / checking every SELECT seems like an awful lot of work, so is there a way around this?

TIA and Regards

Peter
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform