Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need translation of basic foxpro commands into T/SQL
Message
De
04/09/2009 10:34:38
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
04/09/2009 01:12:26
Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01422348
Message ID:
01422665
Vues:
50
>Well basically I don't have the authority to upgrade the SQL servers...Those are the clients responsibility... BTW, if you want to create serverside cursors (SELECT * INTO #CURSOR FROM ...), you cannot even use parameters. I know the risk of SQL injection is serious and we use paramerters where applicable, but there are circumstances where we simply cannot use them and are doing what we can to prevent SQL injection.

Sorry I don't understand what you mean by "(SELECT * INTO #CURSOR FROM ...), you cannot even use parameters". I can. I really don't know a case where I can't use parameters (and there are even ways to pass 2100 parameters limit by passing say a string or xml to be parsed - for example IN query implementation via string is efficient and fast), there might be.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform