Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax error
Message
 
 
To
15/08/2007 02:42:34
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01247986
Message ID:
01248219
Views:
30
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform