Thanks for your reply.
Does IDC file of IIS3.0 support that command?
The following messages have appeared when I was making an IDC file for
IIS server.
And There was no problem when I didn't use IF or Else condition.
>Yongseung-
> If you are using ODBC drivers, perhaps your code for making the ODBC connecition is incorrect. Look in your Developer's Guide under ODBC connectors for the proper way to declare connections. It seems that the error message you received is telling you that an ODBC error occurred. Also, if you're making an ODBC conneciton, I'm fairly certain that you have to use a 'create sql view' command to incorporate your select statement. Good luck on finding the solution.
>-Charlie Davies
>
>
>>I got the errer message when using ODBC and SQL stuffs.
>>
>>the error message is like the followings,
>>
>>[State=S1000][Error=300][Microsoft][ODBC Visual FoxPro Driver]
>>Function name is missing ).
>>
>>
>>My *.idc file's code is like the followings,
>>
>>datasource:rex
>>username:sa
>>template:register.htx
>>SQLStatement:
>>+IF exists (
>>+SELECT * FROM members.dbf
>>+WHERE id='%id%'
>>+ )
>>+SELECT result='already'
>>+ELSE
>>+INSERT INTO members.dbf
>>+(hname,ename,id,passwd,zipcode,hadd1,hadd2,eadd1,eadd2,
>>tel,fax,email,cash,bank,catagory,detail,idnumber,today)
>>+Values('%hname%','%ename%','%id%','%passwd%','%zipcode%'
>>,'%hadd1%','%hadd2%','%eadd1%','%eadd2%','%tel%','%fax%',
>>'%email%',10000,'%bank%','%catagory%','%extra%','',today());
>>
>>If there is anybody knows well about
>>IDC(internet database connector) of IIS?
>>
>>Pls. Help me.
>>thank you.
If you have a chance to visit Korea, Be my Guest.
rexall