Hi Jerry and Bentley experts
I have setup my features in Bentley Map administrator with Dateticks as one of the properties using the standard workflow. Using Oracle 10g as my database and 11g as client with no problem communicating them. Normally, afler adding SQL statement Bentley Geospatial administrator creates standard SQL statement as syntax in the insert, update, query etc, and pressumed that the statements are correct and usable after completing the procedure in every feature creaton. Unfortunately with no success during the opreration in BMap.
On Date:
After adding SQL statement Bentley Geospatial administrator created this syntax on values [to_date('#[P_INSTALLED|NULL]#', 'mm/dd/yyyy')] - error (ORA-01858: a non-numeric character was found where a numeric was expected) because the # is not recognized by Oracle, taking out the # works fine - this should not supposed to be the case.
On Dateticks:
After adding SQL statement Bentley Geopatial administrator created this syntax on values [to_date('[XFM.EncloseInChar(XFM.DateFromTicks([P_REPLACED|0],"MM/dd/yyyy",true),"'")]', 'mm/dd/yyyy')]) the resultant of this syntax generates a double quotation on values (" ") of which Oracle don't understand and for me there has no workaround. - (Error ORA-00907: missing right parenthesis)
Date and Datetick on Dgn resident has no problem.
I am using Bentley Map select series1
If you already incounter the same problem like this or you already have a solution to this, would you please help me?
Jun
Hi Jeff and Jerry
Any comment for this?
Couple of questions ????
Thanks !
Jerry
Hi Jerry,
Thanks for the reply
Is this a Oracle Spatial or regular Oracle connection ? This is a regular Oracle connection not an Oracle Spatial.
How was the date field defined in the database ? I suspect as just DATE, but there are other options. Yes its just a DATE, and according to our database administrator there is no other option, in the database field creation in Oracle TIME is already part of the DATE/TIME format. But, if you have suggestions I would be glad to hear that.
Are you creating the SQL statement or is the GSA creating it when you tell it to via the Add SQL Statements for the paticular feature ? I am not creating the SQL statements in the GSA its the GSA creating it via the Add SQL Statements, only I take out the # in the statement because # is not recognized in Oracle database.
Hi Jun,
Would you please send your XFM schema and specify the problem feature definition?
Regards,
Chris