Re: Newbie

It is working as scripted below, thanks very much to Mr. Barrows for his
assistance. However, once the feature class is created, the script will not
update it as written. The error occurs at line:

gp.CopyFeatures_management XYWells_Layer, XYWells_end, "", "0", "0", "0"

Any idea if I can add something to either update it if it exists, or delete
it first?

Code below:


' ---------------------------------------------------------------------------
' TabletoFeatureClass.vbs
' Created on: Tue Jan 22 2008 12:22:58 PM
' (generated by ArcGIS/ModelBuilder)
' ---------------------------------------------------------------------------
Sub TableToFeatureClass()
' Create the Geoprocessor object
Set gp = CreateObject("esriGeoprocessing.GPDispatch.1")

' Load required toolboxes...
gp.AddToolbox "N:\My Documents\Application Data\ESRI\ArcToolbox\My
Toolboxes\Toolbox.tbx"


' Local variables...
Well_test = "D:\test\Well_Annotation.mdb\Well_test"
XYWells_end = "D:\test\Well_Annotation.mdb\XYWells_end"
XYWells_Layer = "Well_test_Layer"

' Process: Make XY Event Layer...
gp.MakeXYEventLayer_management Well_test, "EASTING", "NORTHING",
XYWells_Layer,
"PROJCS['NAD_1983_StatePlane_Texas_North_FIPS_4201_Feet',GEOGCS['GCS_North_American_1983',DATUM['D_North_American_1983',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Lambert_Conformal_Conic'],PARAMETER['False_Easting',656166.6666666665],PARAMETER['False_Northing',3280833.333333333],PARAMETER['Central_Meridian',-101.5],PARAMETER['Standard_Parallel_1',34.65],PARAMETER['Standard_Parallel_2',36.18333333333333],PARAMETER['Latitude_Of_Origin',34.0],UNIT['Foot_US',0.3048006096012192]];IsHighPrecision"

' Process: Copy Features...
gp.CopyFeatures_management XYWells_Layer, XYWells_end, "", "0", "0", "0"

End Sub

--
Barry Guidry


"Bob Barrows [MVP]" wrote:

Barry wrote:
Mr. Barrows,

Apparently, this was the correct newsgroup to post my message in, in
so much that it did benefit me more than anywhere else that I have
posed the same question. But, I am sorry, I did not know the
connection/dis-connection it had with ADO.

Thank you very much. I had never even heard that you must go to set
references to other objects in Access. That alone is a great step in
the right direction. I will follow your advice and see what outcome
I get. Would you like for me to follow with a reply for the outcome?

I doubt anyone would be searching this newsgroup for solutions to a VBA
problem, but just in case, someone might benefit from your posting the
outcome.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"



.

Relevant Pages

  • Re: Newbie
    ... Sub TabletoFeatureClass() ... ' Create the Geoprocessor object ... script will not update it as written. ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Calling a COM method with NULL input from script
    ... Walt Welton-Lair wrote: ... > way to make this work in script? ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.scripting.jscript)
  • Re: write arraydata to textBox
    ... > Sorry i meant a textArea. ... > direction....and i appreciate what the script is trying to do...but it ... Please reply to the newsgroup. ... header is my spam trap, so I don't check it very often. ...
    (microsoft.public.scripting.vbscript)
  • Re: IE 6 Freezes on certain webpages after SP2 install
    ... > It just hangs on those jscript webpages and I still can't figure out a way ... How to Troubleshoot Script Errors in Internet Explorer ... WinXP SP2 Support Center ... Replies are posted only to the newsgroup for the benefit or other readers. ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: User change password (command line)
    ... From your description, I know that you need to implement a script so users ... canchangetheir passwords online. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)