Latest Contributions by ben_abdallahmhd

hi rebecca thank you very much, but why del don't work here. Iuse it to clean the processus of running code ... View more

Hi rebecca, I solved the problem of "no module named arcpy" by the link given by you and i run the script in pyscripter with external run. The second "problem" of the class "does not exist" i solved it by re-writing the path of connection file in the script. Final thank you very much for your help ... View more

Hi dan, I solved the problem of "no module named arcpy" by the link given by rebecca and i run the script in pyscripter with external run. The second "problem" of the class "does not exist" i solved it by re-writing the path of connection file in the script. Final thank you very muchforyour help ... View more

hi rebecca, thank for the link. no the sccript run from pyscripter as external run. No the problem is the Access to the clasa. The class exist but the message is the class "does not exist" ... View more

Hi dan, These are the python path illustrated with Pyscripter ... View more

Hi Rebecca, thank tou I will do this or reinstall ArcGis! ... View more

hi dan, thank you i use IDLE (python GUI) and Pyscripter. My code is correct and debugging. ... View more

What doesn't work? What error do you get. Have you already defined what subtypes 1 & 4 are? Cheers, Neil Thank you Neil Ayres, doesn't work = it mean there is no result, the script does nothing 🙂 What error do you get? : No i don't get an error. Have you already defined what subtypes 1 & 4 are? Yes,Subtypes are defined in the gdb. the subtypes are : 1 Cours d'eau naturel 2 Canal d'alimentation ou d'irrigation 3 Canal de drainage ou de collecte des eaux pluviales 4 Fossé d�??assèchement ou de drainage ou de collecte des eaux pluviales I use try and except to get error message but there is no message. the script with try is this: try:     axeceau = "TOP10_SIG.DBO.RHAXECEL"     fields = ['CODHYDRO', 'TYPECEAU']     with arcpy.da.UpdateCursor(axeceau, fields) as cursor8: #rows = arcpy.UpdateCursor(axeceau, fields)         for row in cursor8:             if row[0] == 3:                 row[1] = 4             elif row[0] == 4:                 row[1] = 1             elif row[0] == 5:                 row[1] = 1             else:                 row[1] = 1             cursor8.updateRow(row) except arcpy.ExecuteError:     print(arcpy.GetMessages(2)) Thank you ... View more

Try this: import arcpy from arcpy import * import sys arcpy.env.workspace = r"c:\connectionFiles\conntop10sig.sde" sql = "select * from TOP10_SIG.DBO.ABCBNIVL where TOP10_SIG.DBO.ABCBNIVL.TYPECBN = 3" sdeConn = arcpy.ArcSDESQLExecute(r"c:\connectionFiles\conntop10sig.sde") print "Execute SQL Statement: ", sql print "connecting to dba" sdeReturn = sdeConn.execute(sql) if isinstance(sdeReturn, list):     print "Number of rows returned by query: ", len(sdeReturn), "rows"     for row in sdeReturn:         print row else:     print "no selection made" If you are still getting errors, you need to confirm that there is a numeric field named TYPECBN in the table named TOP10_SIG.DBO.ABCBNIVL in the sde connection r"c:\connectionFiles\conntop10sig.sde".  Look in ArcCatalog and make sure that TOP10_SIG.DBO.ABCBNIVL is listed as the table name there.  If so, and still getting errors, you might try dropping the DBO from it ( TOP10_SIG.ABCBNIVL ) as I have seen in the FlexApp environment where links to DBO tables didn't work with that in the path. R_ hi rzufelt, you have reason the type of the field is SubtypeField, when i change the query to another field (integer) it works very good. thank you very much for the subtype field, have you please an idea how can select  it. >>> import arcpy ... from arcpy import * ... import sys ... arcpy.env.workspace = (r"c:\connectionFiles\conntop10sig.sde") ... try: ...     SQLStatement = ("select * from TOP10_SIG.DBO.ABCBNIVL where TOP10_SIG.DBO.ABCBNIVL.ALTDCRNV = 50") # ALTDCRNV = the elevation ...     sdeConn = arcpy.ArcSDESQLExecute(r"c:\connectionFiles\conntop10sig.sde")  # vital part you are missing.... ...     print "Execute SQL Statement: ", SQLStatement ...     try: ...         # Pass the SQL statement to the database. ...         # ...         print "connecting to dba" ...         sdeReturn = sdeConn.execute(SQLStatement) ...         print "Number of rows returned by query: ", len(sdeReturn) ...     except Exception, ErrorDesc: ...         print "ErrorDesc",ErrorDesc   ## added this to actually print what the error is ...         sdeReturn = False ...     # If the return value is a list (a list of lists), display each list as a row from the ...     #   table being queried. ...     if isinstance(sdeReturn, list): ...         print "Number of rows returned by query: ", len(sdeReturn), "rows" ...         for row in sdeReturn: ...             print "row" ...         print "\n" ...     else: ...         # If the return value was not a list, the statement was most likely a DDL statment. ...         #   Check its status. ...         if sdeReturn == True: ...             print "SQL statement: ", SQLStatement , " ran sucessfully." ...             print "\n" ...         else: ...             print "SQL statement: ",SQLStatement ," FAILED." ...             print "\n" ... except: ...     print "Problem executing SQL." ... ...     ... Execute SQL Statement:    select * from TOP10_SIG.DBO.ABCBNIVL where TOP10_SIG.DBO.ABCBNIVL.ALTDCRNV = 50 connecting to dba Number of rows returned by query:    38 Number of rows returned by query:    38   rows row row . . ... View more

OIC, it's not actually running and generating that string, it is merely printing what you assigned it to.  Did you try any of the changes I posted above, they are working for me just fine.  I did notice that you have quite a few errors in your script, and, without the error reporting, it just errors out and doesn't tell you why. The code in my other post is working correctly, it is the "other" errors in your script that is throwing the exceptions.  Notice the print statements, best to get away from using "+" in print statements as you were trying to concatenate (that's what the plus sign means) a number and a string. Gives an error, but without it reporting the error, just says Problem executing SQL. Use commas in print statements and you wont run into this problem.  No need to iterate through a list of SQL statements as you are "splitting" your string by ";" as there are no semicolons in your string, so you end up with an empty list. Think you got this code from the example which is showing how to deal with the getParametersAsText() when passing from a script tool. In this case, if allow multiple inputs, they would come across as a semicolon separated string that would be parsed to the list. In this case, you are defining your "single" sql statement.  Try this code, it is working. If it doesn't work for you, I'd suggest grabbing the snippet from the bottom of my earlier post and have it print the fields for you, and make sure fields in the SQL statement are correct (check CasE also, as that may sometimes matter).  Anyway, cleaned out some of the error issues and the loop. Try this, get it to work, then add all the "other" stuff in there after it is working correctly.  R_  import arcpy from arcpy import * import sys arcpy.env.workspace = (r"c:\connectionFiles\conntop10sig.sde") try:     SQLStatement = ("select * from TOP10_SIG.DBO.ABCBNIVL where TOP10_SIG.DBO.ABCBNIVL.TYPECBN = 3")     sdeConn = arcpy.ArcSDESQLExecute(r"c:\connectionFiles\conntop10sig.sde")  # vital part you are missing....     print "Execute SQL Statement: ", SQLStatement     try:         # Pass the SQL statement to the database.         #         print "connecting to dba"         sdeReturn = sdeConn.execute(SQLStatement)         print "Number of rows returned by query: ", len(sdeReturn)     except Exception, ErrorDesc:         print "ErrorDesc",ErrorDesc   ## added this to actually print what the error is         sdeReturn = False     # If the return value is a list (a list of lists), display each list as a row from the     #   table being queried.     if isinstance(sdeReturn, list):         print "Number of rows returned by query: ", len(sdeReturn), "rows"         for row in sdeReturn:             print "row"         print "\n"     else:         # If the return value was not a list, the statement was most likely a DDL statment.         #   Check its status.         if sdeReturn == True:             print "SQL statement: ", SQLStatement , " ran sucessfully."             print "\n"         else:             print "SQL statement: ",SQLStatement ," FAILED."             print "\n" except:     print "Problem executing SQL." This should work as long as the workspace.sde connection includes a table named "TOP10_SIG.DBO.ABCBNIVL", and that table has a numeric field named "TYPECBN"     R_ hi rzufelt , this is the result of the script running in arcgis python window: >>> import arcpy ... from arcpy import * ... import sys ... arcpy.env.workspace = (r"c:\connectionFiles\conntop10sig.sde") ... try: ...     SQLStatement = ("select * from TOP10_SIG.DBO.ABCBNIVL where TOP10_SIG.DBO.ABCBNIVL.TYPECBN = 3") ...     sdeConn = arcpy.ArcSDESQLExecute(r"c:\connectionFiles\conntop10sig.sde")  # vital part you are missing.... ...     print "Execute SQL Statement: ", SQLStatement ...     try: ...         # Pass the SQL statement to the database. ...         # ...         print "connecting to dba" ...         sdeReturn = sdeConn.execute(SQLStatement) ...         print "Number of rows returned by query: ", len(sdeReturn) ...     except Exception, ErrorDesc: ...         print "ErrorDesc",ErrorDesc   ## added this to actually print what the error is ...         sdeReturn = False ...     # If the return value is a list (a list of lists), display each list as a row from the ...     #   table being queried. ...     if isinstance(sdeReturn, list): ...         print "Number of rows returned by query: ", len(sdeReturn), "rows" ...         for row in sdeReturn: ...             print "row" ...         print "\n" ...     else: ...         # If the return value was not a list, the statement was most likely a DDL statment. ...         #   Check its status. ...         if sdeReturn == True: ...             print "SQL statement: ", SQLStatement , " ran sucessfully." ...             print "\n" ...         else: ...             print "SQL statement: ",SQLStatement ," FAILED." ...             print "\n" ... except: ...     print "Problem executing SQL." ... Execute SQL Statement:    select * from TOP10_SIG.DBO.ABCBNIVL where TOP10_SIG.DBO.ABCBNIVL.TYPECBN = 3 connecting to dba ErrorDesc   Problem executing SQL. ... View more

This looks like what you "want" your sql to look like, but I can't figure any way you got that from the attached code.  Are you running a different snippet than you posted? R_ hi rzuflet, this is the full script : >>> import arcpy ... from arcpy import * ... import sys ... arcpy.env.workspace = (r"c:\connectionFiles\conntop10sig.sde") ... try: ...     ...     # Two ways to create the object, which also creates the connection to ArcSDE. ...     #   Using the first method, pass a set of strings containing the connection properties: ...     #   <serverName>,<portNumber>,<version>,<userName>,<password> ...     #   sdeConn = arcpy.ArcSDESQLExecute("gpserver3","5151","#","toolbox","toolbox") ...     #   Using the second method pass the path to a valid ArcSDE connection file ...     # ...    ...     # Get the SQL statements, separated by ; from a text string. ...     # ...     SQLStatement = ("SELECT * FROM [TOP10_SIG].[dbo].[ABCBNIVL] WHERE [TOP10_SIG].[dbo].[ABCBNIVL].[TYPECBNV] = 3 ") ...     SQLStatementList = SQLStatement.split(";") ...     ...     ...     print "\n" ...     # For each SQL statement passed in, execute it. ...     # ...     for sql in SQLStatementList: ...         print "Execute SQL Statement: " + sql ...         try: ...             # Pass the SQL statement to the database. ...             # ...             sdeReturn = sdeConn.execute(sql) ...         except Exception, ErrorDesc: ...             print "ErrorDesc" ...             sdeReturn = False ...         ...         # If the return value is a list (a list of lists), display each list as a row from the ...         #   table being queried. ...         if isinstance(sdeReturn, list): ...             print "Number of rows returned by query: " + len(sdeReturn), "rows" ...             for row in sdeReturn: ...                 print "row" ...             print "\n" ...         else: ...             # If the return value was not a list, the statement was most likely a DDL statment. ...             #   Check its status. ...             if sdeReturn == True: ...                 print "SQL statement: " + sql + " ran sucessfully." ...                 print "\n" ...             else: ...                 print "SQL statement: " + sql + " FAILED." ...                 print "\n" ...                 ... except Exception, ErrorDesc: ...     print "Exception, ErrorDesc" ... except: ...     print "Problem executing SQL." ... the result is : Execute SQL Statement: SELECT * FROM [TOP10_SIG].[dbo].[ABCBNIVL] WHERE [TOP10_SIG].[dbo].[ABCBNIVL].[TYPECBNV] = 3 ErrorDesc SQL statement: SELECT * FROM [TOP10_SIG].[dbo].[ABCBNIVL] WHERE [TOP10_SIG].[dbo].[ABCBNIVL].[TYPECBNV] = 3  FAILED. thank you ... View more