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