Command is missing required clause (Error 1221)
WHEN I try :
SELECT T.cnomteleph AS 'cNomRes'
FROM TELEPH T INTO CURSOR CrystalNew READWRITE
I Have a error but if i try in my temp.txt file
SELECT T.cnomteleph AS 'cNomRes' FROM TELEPH T INTO CURSOR CrystalNew READWRITE
I have no error
>>Hi Naomi,
>>
>>
>>I try to siulate a Sql Clause.
>>
>>cf attachment please
>>
>
>
>What is the exact error? Also try to remove single quotes around a new field name, e.g.
>
>select SomeInfo as NewField from ...
>
>Try
>
>_cliptext = cfile
>
>?cFile
>
>
>Paste here the exact cFile.
>
>
>>
>>>>Hi all,
>>>>
>>>>i have temp.txt ( attachment )
>>>>
>>>>
>>>>USE C:\cdbk90\Amline\data1\Teleph IN 0
>>>> cFile = FILETOSTR( 'Temp.txt' )
>>>> =STRTRAN( cFile , CHR(10) , '' )
>>>> =STRTRAN( cFile , CHR(13) , '' )
>>>> =STRTRAN( cFile , CHR(9) , '' )
>>>> =STRTRAN( cFile , CR , '' )
>>>> =STRTRAN( cFile , CRLF , '' )
>>>> WAIT WINDOW cfile
>>>>
>>>> &cfile
>>>
>>>> BROWSE
>>>>
>>>>
>>>>
>>>>I hav always a error ?!
>>>>
>>>>Why ?
>>>>
>>>>Merry christmas.
>>>
>>>What are you trying to do here with &cFile?
>>>
>>>Can you also show the content of cFile after removing these characters?