Latest Contributions by JoseSanchez

Hi all How can I connect for VBA to an Oracle database? What is the  DSN-less  connection to Oracle syntax? Regards ... View more

Hi all How to export a FC or table to a csv file with Modelbuilder ... View more

Hi all, Is there a way to fix Delta Tables (Adds Table and Deletes Table), when they look in bad shape: This is the result I see when executing: Analyze, and checking "Adds" in the component to analyze Start Time: Fri Feb 18 08:19:14 2011 ERROR 999999: Error executing function. Underlying DBMS error[ORA-20000: Unable to analyze TABLE "XXXX"."A1046", insufficient privileges or does not exist ORA-06512: at "SYS.DBMS_STATS", line 13427 ORA-06512: at "SYS.DBMS_STATS", line 13457 ORA-06512: at line 1 ] Failed to execute (Analyze) And This is the resul I see when executing: Analyze, and  checking "Deletes" in the component to analyze Start Time: Fri Feb 18 08:21:23 2011 ERROR 999999: Error executing function. Underlying DBMS error[ORA-20000: Unable to analyze TABLE "XXXX"."D1046", insufficient privileges or does not exist ORA-06512: at "SYS.DBMS_STATS", line 13427 ORA-06512: at "SYS.DBMS_STATS", line 13457 ORA-06512: at line 1 ] Failed to execute (Analyze). ... View more

Hi all Suddenly editable layers in an instance in SDE started showing the following error message: Error reading OID from table. Reading rows has been stopped. Check that the datasource is valid. Underlying DBMS error[ORA-00942: table or view does not exists ..] I checked in the oracle side and tables are full of rows, but in ArcCatalog the feature is empty. Please help!!! ... View more

Hi all I just installed Visaul Studio 2008 and ArcGIS Server 9.3 and I do not see anywhere the Visual Studio's New Project ArcgIs Visual studio installed templates please advise ... View more

Hi all, I just created a new class using the Base Toolbar template and I do not see the ItemCount property   or the Sub GetItemInfo described in the manual and samples Public Sub GetItemInfo(ByVal pos As Integer, ByVal itemDef As ESRI.ArcGIS.SystemUI.IItemDef) Implements ESRI.ArcGIS.SystemUI.IToolBarDef.GetItemInfo How do I add this missing property? is there any key shorcut or snippet? ... View more

Hi all I am getting this error message "error: There is no SDK with the name or path 'iphoneos4.0'" because my project uses iOS SDK 4.2  and not iOS SDK 4.0 I am just testing the first sample: http://help.arcgis.com/en/arcgismobile/10.0/apis/iPhone/concepts/index.html#/My_First_iOS_Application/00pw00000047000000/ Changing: -  in the window  Project-Edit Project Settings-Build tab-Base SDK from "iOS Device 4.0 (missing)" to "latest iOS currently 4.2" -  From the menu, select Project-Edit Active Target-base SDK from "iOS Device 4.0 (missing)" to "latest iOS currently 4.2" when I rebuild the application it still shows the same error message. ... View more

Hi all I am using ArcGIs 9.3 and Model Bulder. I was able to code a calculate field in VB that formats a field as follows Format("08.00.00") and converts it to "08:00:00 AM" How can I do the same thing in Python (phyton 3 or python)? Please advise! ... View more

Hi all How can I show all the records from a related table when selecting a feature from a polygon FC on the screen with the Identity button? pelase advise ... View more

Hi all I am trying to remove spaces from a string using model builder in ArcCatalog and I wrote the following in the Calculate Field, field experssion:  !W.TCIS_GIS.PREM_TYPE!.strip() It shows the following error message: Executing (Calculate Field): CalculateField PremisePoints_Layer PremisePoints.PREMTYPE " !WASD.TCIS_GIS.PREM_TYPE!.strip() " PYTHON # PremisePoints_Layer Start Time: Wed Dec 01 15:37:55 2010 ERROR 000539: Error running expression:  "TWNHOUSE".strip()  <type 'exceptions.IndentationError'>: unexpected indent (<string>, line 1) Item not found in this collection. Failed to execute (Calculate Field). End Time: Wed Dec 01 15:38:00 2010 (Elapsed Time: 5.00 seconds) ... View more