Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL statement when using IDC file
Message
From
13/09/1997 09:09:49
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Internet applications
Title:
SQL statement when using IDC file
Miscellaneous
Thread ID:
00050007
Message ID:
00050007
Views:
74
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
Next
Reply
Map
View

Click here to load this message in the networking platform