Subject | Dynamic SQL error -901 |
---|---|
Author | Uwe Oeder |
Post date | 2004-11-18T19:46:11Z |
When I run the script below I get the following error. Can somebody help.
"Dynamic SQL Error SQL error code = -901 feature is not supported in"
Using Apache Version Apache/2.0.52 (Win32) ; PHP/5.0.2 ;Firebird
1.5.2 (Win32 Build)
PHP Script :
$SQLQuery = "SELECT WPIDSQ , WPVBSQ , WPName FROM Whitepage WHERE WPName
LIKE '%MOTOR%' AND WPName LIKE '%CAR%'" ;
$MyHost = '//dev1/:D:\Projects\CreativeInfo\Data\Data.DBF' ;
$MyUsername = 'sysdba' ;
$MyPassword = 'masterkey' ;
$MyDBHandle = ibase_connect($MyHost,$MyUsername,$MyPassword) or die('error
in db connect') ;
$SQLStatement = $SQLQuery ;
$MyDBQuery = ibase_prepare($MyDBHandle,$SQLStatement) ;
$MyDBDataset = ibase_execute($MyDBQuery) or die(ibase_errmsg());
Mr. U. Oeder
Head of IT Departement
Creative-Logic
1 Dr Michael de Kock St.
Northern Industrial Area
Windhoek
Namibia
P.O. Box 9274
Phone : 061-262 941
Fax : 061-262 130
Email : uweo@...
"Dynamic SQL Error SQL error code = -901 feature is not supported in"
Using Apache Version Apache/2.0.52 (Win32) ; PHP/5.0.2 ;Firebird
1.5.2 (Win32 Build)
PHP Script :
$SQLQuery = "SELECT WPIDSQ , WPVBSQ , WPName FROM Whitepage WHERE WPName
LIKE '%MOTOR%' AND WPName LIKE '%CAR%'" ;
$MyHost = '//dev1/:D:\Projects\CreativeInfo\Data\Data.DBF' ;
$MyUsername = 'sysdba' ;
$MyPassword = 'masterkey' ;
$MyDBHandle = ibase_connect($MyHost,$MyUsername,$MyPassword) or die('error
in db connect') ;
$SQLStatement = $SQLQuery ;
$MyDBQuery = ibase_prepare($MyDBHandle,$SQLStatement) ;
$MyDBDataset = ibase_execute($MyDBQuery) or die(ibase_errmsg());
Mr. U. Oeder
Head of IT Departement
Creative-Logic
1 Dr Michael de Kock St.
Northern Industrial Area
Windhoek
Namibia
P.O. Box 9274
Phone : 061-262 941
Fax : 061-262 130
Email : uweo@...