Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select into cursor
Message
De
10/09/2003 07:59:16
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
10/09/2003 07:54:26
Victor Verheij
International Film Festival Rotterdam
Rotterdam, Pays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00827788
Message ID:
00827790
Vues:
19
>When I use the following code to change de rowsource property of a combobox
>vfp8 refuses to save it. (command contains unrecognised phrase/keywords)
>
>thisform.mycombo.rowsource = "select pr.descr as descr, pr.id_priority as idpriority ;
>from priority as pr, person as perso, prior_pers as prpers ;
>where pr.id_priority = prpers.id_priority ;
>and prpers.id_person = perso.id_person ;
>and perso.name = oapp.cuserid into cursor myCursor nofilter"
>
>I've executed the query in command window with succes.
>
>Yesterday it worked fine for another combobox. Now this first combobox gives the same error.
>I think the problem lies in the 'into cursor' part, when I leave this part out it works.
>But why this 'into cursor' part didn't create a problem yesterday ....
>
>Any help is much apreciated
>
>Victor
thisform.mycombo.rowsource = ;
 "select pr.descr as descr, pr.id_priority as idpriority"+ ;
 "    from priority as pr, "+;
 "    person as perso, "+;
 "    prior_pers as prpers"+;
 "where pr.id_priority = prpers.id_priority"+ ;
 "    and prpers.id_person = perso.id_person"+ ;
 "   and perso.name = oapp.cuserid into cursor myCursor nofilter"
A literal string cannot exceed 255 bytes.
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