Vjylku

How can we prove that any integral in the set of non-elementary integrals cannot be expressed in the form of elementary functions?

Increase performance creating Mandelbrot set in python

Two monoidal structures and copowering

Lay out the Carpet

Trouble understanding the speech of overseas colleagues

How did Doctor Strange see the winning outcome in Avengers: Infinity War?

CREATE opcode: what does it really do?

Unreliable Magic - Is it worth it?

Term for the "extreme-extension" version of a straw man fallacy?

What is the intuitive meaning of having a linear relationship between the logs of two variables?

Gears on left are inverse to gears on right?

Short story about space worker geeks who zone out by 'listening' to radiation from stars

How does the UK government determine the size of a mandate?

Why, precisely, is argon used in neutrino experiments?

You cannot touch me, but I can touch you, who am I?

How do I find the solutions of the following equation?

Sort a list by elements of another list

How to Reset Passwords on Multiple Websites Easily?

Why not increase contact surface when reentering the atmosphere?

Do sorcerers' subtle spells require a skill check to be unseen?

How to run a prison with the smallest amount of guards?

Was Spock the First Vulcan in Starfleet?

Why didn't Theresa May consult with Parliament before negotiating a deal with the EU?

How can I kill an app using Terminal?

Very Simple ArcPy script using arcpy.SearchCursor and row.getValue

GetParameterAsText() error in python scriptError when creating insert cursor in ArcPy?Trying to modify records from one shapefile to another gives Error 999999?Export attributes of shapefiles into text fileUpdate Cursor with Date IssuePerforming Project_management in batch using ArcPy?Runtime error arcpyy using fields[f].append(row.getValue(f))keep getting error while trying to insert row using insert-cursorExecuteError: ERROR 000539: Error running expression: rcexec()

3

I am trying to run a very simple script to test the usage of arcpy.SearchCursor and row.getValue.

I want to do a very simple exercise: I have a table with some fields, and I want to print the values of one of the fields (e.g. fldname) for every record.

The script is the below:

import arcpy

IN_Table = "C:/ZZtest/test.mdb/table"

Field1="fldname"

cursor=arcpy.SearchCursor(IN_Table)

for row in cursor:

    printf=row.getValue(Field1)

    print(printf)

del row, cursor

When I am running this I have the error below:

Traceback (most recent call last):

  File "C:ZZtestScriptName.py", line 28, in <module>

    printf=str(row.getValue(Field1))

  File "C:Program Files (x86)ArcGISEngine10.2arcpyarcpyarcobjectsarcobjects.py", line 1048, in getValue

    return convertArcObjectToPythonObject(self._arc_object.GetValue(*gp_fixargs(args)))

RuntimeError: ERROR 999999: Error executing function.

I tried to search for similar questions. But they all included more complicated scripts.

My ArcGIS version is 10.2.

The type of the "fldname" field is Integer.

Where is my mistake?

arcpy cursor

share|improve this question

edited Dec 20 '16 at 15:23

whyzar

10.7k92866

asked Dec 20 '16 at 12:12

PhilpPhilp

185

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Welcome to GIS SE. As a new user please take the Tour. Please edit the question to specify the exact version of ArcGIS in use. Your first mistake was using an "old" SearchCursor at all. They have been replaced by Data Access cursors (arcpy.da.SearchCursor), which use a different row access protocol. Using personal geodatabase could also be mistake (they are not compatible with 64-bit arcpy). But the problem lies with the datatype of or data within the "fldname" column (which you will need to describe in the question text)
  
  – Vince
  Dec 20 '16 at 12:29
  
  
  

  
  
  
  

add a comment | 

3

I am trying to run a very simple script to test the usage of arcpy.SearchCursor and row.getValue.

I want to do a very simple exercise: I have a table with some fields, and I want to print the values of one of the fields (e.g. fldname) for every record.

The script is the below:

import arcpy

IN_Table = "C:/ZZtest/test.mdb/table"

Field1="fldname"

cursor=arcpy.SearchCursor(IN_Table)

for row in cursor:

    printf=row.getValue(Field1)

    print(printf)

del row, cursor

When I am running this I have the error below:

Traceback (most recent call last):

  File "C:ZZtestScriptName.py", line 28, in <module>

    printf=str(row.getValue(Field1))

  File "C:Program Files (x86)ArcGISEngine10.2arcpyarcpyarcobjectsarcobjects.py", line 1048, in getValue

    return convertArcObjectToPythonObject(self._arc_object.GetValue(*gp_fixargs(args)))

RuntimeError: ERROR 999999: Error executing function.

I tried to search for similar questions. But they all included more complicated scripts.

My ArcGIS version is 10.2.

The type of the "fldname" field is Integer.

Where is my mistake?

arcpy cursor

share|improve this question

edited Dec 20 '16 at 15:23

whyzar

10.7k92866

asked Dec 20 '16 at 12:12

PhilpPhilp

185

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Welcome to GIS SE. As a new user please take the Tour. Please edit the question to specify the exact version of ArcGIS in use. Your first mistake was using an "old" SearchCursor at all. They have been replaced by Data Access cursors (arcpy.da.SearchCursor), which use a different row access protocol. Using personal geodatabase could also be mistake (they are not compatible with 64-bit arcpy). But the problem lies with the datatype of or data within the "fldname" column (which you will need to describe in the question text)
  
  – Vince
  Dec 20 '16 at 12:29
  
  
  

  
  
  
  

add a comment | 

I am trying to run a very simple script to test the usage of arcpy.SearchCursor and row.getValue.

I want to do a very simple exercise: I have a table with some fields, and I want to print the values of one of the fields (e.g. fldname) for every record.

The script is the below:

import arcpy

IN_Table = "C:/ZZtest/test.mdb/table"

Field1="fldname"

cursor=arcpy.SearchCursor(IN_Table)

for row in cursor:

    printf=row.getValue(Field1)

    print(printf)

del row, cursor

When I am running this I have the error below:

Traceback (most recent call last):

  File "C:ZZtestScriptName.py", line 28, in <module>

    printf=str(row.getValue(Field1))

  File "C:Program Files (x86)ArcGISEngine10.2arcpyarcpyarcobjectsarcobjects.py", line 1048, in getValue

    return convertArcObjectToPythonObject(self._arc_object.GetValue(*gp_fixargs(args)))

RuntimeError: ERROR 999999: Error executing function.

I tried to search for similar questions. But they all included more complicated scripts.

My ArcGIS version is 10.2.

The type of the "fldname" field is Integer.

Where is my mistake?

arcpy cursor

share|improve this question

edited Dec 20 '16 at 15:23

whyzar

10.7k92866

asked Dec 20 '16 at 12:12

PhilpPhilp

185

import arcpy

IN_Table = "C:/ZZtest/test.mdb/table"

Field1="fldname"

cursor=arcpy.SearchCursor(IN_Table)

for row in cursor:

    printf=row.getValue(Field1)

    print(printf)

del row, cursor

Traceback (most recent call last):

  File "C:ZZtestScriptName.py", line 28, in <module>

    printf=str(row.getValue(Field1))

  File "C:Program Files (x86)ArcGISEngine10.2arcpyarcpyarcobjectsarcobjects.py", line 1048, in getValue

    return convertArcObjectToPythonObject(self._arc_object.GetValue(*gp_fixargs(args)))

RuntimeError: ERROR 999999: Error executing function.

share|improve this question

edited Dec 20 '16 at 15:23

whyzar

10.7k92866

asked Dec 20 '16 at 12:12

PhilpPhilp

185

share|improve this question

edited Dec 20 '16 at 15:23

whyzar

10.7k92866

asked Dec 20 '16 at 12:12

PhilpPhilp

185

edited Dec 20 '16 at 15:23

whyzar

10.7k92866

edited Dec 20 '16 at 15:23

whyzar

10.7k92866

asked Dec 20 '16 at 12:12

PhilpPhilp

185

asked Dec 20 '16 at 12:12

PhilpPhilp

185

1 Answer
1

active

oldest

votes

4

Welcome to the GIS SE.
I have edited your script. Please note:

1. I have updated the search cursor to include the new, faster "da" approach. Please read up on using cursors here




2. The script below will print out the value of the fld_name for each row in the table.



3. 
   

   Please use the raw input format when trying to identify file locations.

   
   
   

   import arcpy
   
   in_table = r"c:/ZZtest/test.mdb/table"
   
   with arcpy.da.SearchCursor(in_table, ["fld_name"]) as scursor:
   
       for srow in scursor:
   
           print srow[0]
   
   

   
   

share|improve this answer

edited 2 mins ago

Miro

5,24953464

answered Dec 20 '16 at 12:59

MacroZEDMacroZED

2,074519

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you for your suggestions. I used this script and also changed the .mdb to a .gdb and it worked.
  
  – Philp
  Dec 20 '16 at 13:40
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  no problem. Please mark the question as answered to close it.
  
  – MacroZED
  Dec 20 '16 at 13:41
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f222063%2fvery-simple-arcpy-script-using-arcpy-searchcursor-and-row-getvalue%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

4

Welcome to the GIS SE.
I have edited your script. Please note:

1. I have updated the search cursor to include the new, faster "da" approach. Please read up on using cursors here




2. The script below will print out the value of the fld_name for each row in the table.



3. 
   

   Please use the raw input format when trying to identify file locations.

   
   
   

   import arcpy
   
   in_table = r"c:/ZZtest/test.mdb/table"
   
   with arcpy.da.SearchCursor(in_table, ["fld_name"]) as scursor:
   
       for srow in scursor:
   
           print srow[0]
   
   

   
   

share|improve this answer

edited 2 mins ago

Miro

5,24953464

answered Dec 20 '16 at 12:59

MacroZEDMacroZED

2,074519

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you for your suggestions. I used this script and also changed the .mdb to a .gdb and it worked.
  
  – Philp
  Dec 20 '16 at 13:40
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  no problem. Please mark the question as answered to close it.
  
  – MacroZED
  Dec 20 '16 at 13:41
  

  
  
  
  

add a comment | 

4

Welcome to the GIS SE.
I have edited your script. Please note:

1. I have updated the search cursor to include the new, faster "da" approach. Please read up on using cursors here




2. The script below will print out the value of the fld_name for each row in the table.



3. 
   

   Please use the raw input format when trying to identify file locations.

   
   
   

   import arcpy
   
   in_table = r"c:/ZZtest/test.mdb/table"
   
   with arcpy.da.SearchCursor(in_table, ["fld_name"]) as scursor:
   
       for srow in scursor:
   
           print srow[0]
   
   

   
   

share|improve this answer

edited 2 mins ago

Miro

5,24953464

answered Dec 20 '16 at 12:59

MacroZEDMacroZED

2,074519

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you for your suggestions. I used this script and also changed the .mdb to a .gdb and it worked.
  
  – Philp
  Dec 20 '16 at 13:40
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  no problem. Please mark the question as answered to close it.
  
  – MacroZED
  Dec 20 '16 at 13:41
  

  
  
  
  

add a comment | 

Welcome to the GIS SE.
I have edited your script. Please note:

1. I have updated the search cursor to include the new, faster "da" approach. Please read up on using cursors here




2. The script below will print out the value of the fld_name for each row in the table.



3. 
   

   Please use the raw input format when trying to identify file locations.

   
   
   

   import arcpy
   
   in_table = r"c:/ZZtest/test.mdb/table"
   
   with arcpy.da.SearchCursor(in_table, ["fld_name"]) as scursor:
   
       for srow in scursor:
   
           print srow[0]
   
   

   
   

share|improve this answer

edited 2 mins ago

Miro

5,24953464

answered Dec 20 '16 at 12:59

MacroZEDMacroZED

2,074519

share|improve this answer

edited 2 mins ago

Miro

5,24953464

answered Dec 20 '16 at 12:59

MacroZEDMacroZED

2,074519

edited 2 mins ago

Miro

5,24953464

edited 2 mins ago

Miro

5,24953464

answered Dec 20 '16 at 12:59

MacroZEDMacroZED

2,074519

answered Dec 20 '16 at 12:59

MacroZEDMacroZED

2,074519