Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT-SQL IN() problem
Message
De
03/11/2008 15:22:14
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SELECT-SQL IN() problem
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01359275
Message ID:
01359275
Vues:
84
Hi all,
Given the code snippet below, this one will not work in VFP8SP1. It will generate the "SQL expression is too complex (Error 1845)" error.
close databases all
create cursor xxx (fld1 i)
select * from xxx ;
	where fld1 in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25)
I know that this will work in VFP9 but what I'm wondering is that, I can't find any documentation in VFP8SP1 regarding this error. :(

Is there a VFP8 runtime fix for this?
ramil
~~ learning to stand still
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform