Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Syntax error
Message
 
 
À
15/08/2007 02:42:34
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01247986
Message ID:
01248219
Vues:
32
Hard to say why you're getting errors. Ok, let's try few changes (see inside)

>hi,
>
>i try it, same error??
>
>SET STATUS OFF
>SET TALK OFF
>SET ECHO OFF
>SET SAFETY off
>ma=JUSTSTEM(thisform.text1.value)
select 0
>USE (ma) alias WorkTable
>COUNT TO thisform.text3.value
>*total = "8000"
>total = Val(THISFORM.TEXT2.VALUE)
>RAND(-1)
>INDEX ON RAND() TO SYS(2023)+'\RANDOM'
>COPY TO NEWADSL NEXT total
>SET INDEX TO
>ERASE SYS(2023)+'\RANDOM'
use newAdsl in 0 alias RecToDelete
>****************************************
>delete from WorkTable inner join RecToDelete on WorkTable.telNo = RecToDelete.TelNo &&syntax error
>


* If the above would not work for some unknown reason, let's do
select RecToDelete
scan
  if seek(TelNo,'WorkTable','TelNo') && If we have index tag on TelNo
    delete in WorkTable
  endif 
endscan
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform