topic Customizing Related Table Sample .vbs Script in ArcPad Questions

Customizing Related Table Sample .vbs Script

DaytonPoff — Mon, 05 Apr 2010 16:37:13 GMT

I have an ArcPad project with a geodatbase feature class linked via relationship to another table.

I have taken the sample "Inspections.vbs" script included in the Riverside project with ArcPad 8.0 and customized it to fit my data.

I've also used ArcPad Studio to mirror the sample .axf setup as much as possible, yet when I open my project in ArcPad the script throws an error.

If anyone can help I would greatly appreciate it!

Customizing Related Table Sample .vbs Script

JaneOnorati — Fri, 09 Apr 2010 15:33:49 GMT

I'd like to do the same, but can't find Inspections.vbs you refer to. Where did you find it?

-Jane

Customizing Related Table Sample .vbs Script

DaytonPoff — Fri, 09 Apr 2010 16:37:55 GMT

Hi Jane,

If ArcPad is installed in the default directory then here is the path to the script.

C:\Program Files\ArcPad 8.0\Developer\Samples\RelatedTables\RelatedTablesForm\Inspections.vbs

Customizing Related Table Sample .vbs Script

JaneOnorati — Fri, 09 Apr 2010 18:24:16 GMT

I have ArcPad 8.0 installed, but do not have any directory called RelatedTables in the developer samples directory. I also searched the whole ArcPad folder for Inspections.vbs and found nothing.

Customizing Related Table Sample .vbs Script

DaytonPoff — Fri, 09 Apr 2010 19:05:18 GMT

This sample may have been included with Service Pack 3. Open ArcPad and Click the glowing ArcPad button. Then click About ArcPad to see if you have Version 8.0 SP3 (Build 7).

I downloaded the service pack from ESRI's website at the following link.
http://resources.arcgis.com/content/patches-and-service-packs?fa=listPatches&PID=26

Unfortunately you have to completey uninstall ArcPad and then reinstall the service pack. If you want to do that and let me know how it goes you can email me or just reply back on this forum.

-Dayton

Customizing Related Table Sample .vbs Script

JaneOnorati — Mon, 12 Apr 2010 20:19:43 GMT

Dayton,

I don't have SP3 installed, and would rather not upgrade at this time. Could you post the file to this thread?

-Jane

Customizing Related Table Sample .vbs Script

DaytonPoff — Thu, 15 Apr 2010 19:39:18 GMT

Jane,

I am checking with ESRI to make sure there are no legal ramifications for posting the sample to this thread.
I'll know something soon.

Thanks,
Dayton

Customizing Related Table Sample .vbs Script

JayKappy — Fri, 16 Apr 2010 14:13:11 GMT

I am also trying this.....and dotn have the example....maybe I will download SP3....but dotn know if that is going to mess anything else up.....Fix one thing and break 5 others...

I can grab some form varaibles
Build the SQL statement
Execute the statement

I then verifyed that the record was in the related table in ArcPAD (related Table Tab)
BUT when I import it back into ArcMap the record does not coem in

The only way I can get it to import in is if I create it manually in the Related table tab....The SQL statement is creating the record but not coming back when import to ArcMap

SEE MY POST "Update Related Table " for code examples etc......

Customizing Related Table Sample .vbs Script

JayKappy — Fri, 16 Apr 2010 14:44:39 GMT

I GOT IT...LOOK AT my post if you want the code I used to do this...."Update Related Table "

Again I am updating a related table that was brought out to ArcPAD through the ArcPAD data manager.

Customizing Related Table Sample .vbs Script

JaneOnorati — Tue, 20 Apr 2010 15:25:37 GMT

Dayton, I went ahead and upgraded to ArcPad 8.0.3, so you don't need to upload Inspections.vbs for me. Thanks for trying to help! Now I've started trying to reuse the code for my project. I thought it was funny that this script was described as being created to be as simple as possible - with slightly over 600 lines of code (including comments)! Mine will need to work for multiple pages since I have a lot of fields, but otherwise should be similar. I'm going to look at jaykappy's post he mentioned also.

Customizing Related Table Sample .vbs Script

DaytonPoff — Wed, 21 Apr 2010 12:01:18 GMT

Jane,

I'm sorry I wasn't able to upload the script. There is licensing agreement included with the code samples that says I'm not allowed to post the code to the forum.

I agree the code isn't very simple. And after customizing it to fit my data I have well over 1000 lines of code.

Good luck with making it work. I'm still working on mine as well.

Please give us updates on how you are progressing.

Customizing Related Table Sample .vbs Script

DaytonPoff — Mon, 26 Apr 2010 14:06:37 GMT

Finally got the code to work. Turns out I forgot to initiate one of my controls and forgot to add the index control to my signs page. In the Riverside sample it is the #/# on the Inspections form that signifies what inspection is currently being edited.

I still have to go through the entire check out/edit/check in process, but so far so good!

Customizing Related Table Sample .vbs Script

JaneOnorati — Mon, 26 Apr 2010 19:23:15 GMT

I picked out parts of the script to use so I can debug it piece-by-piece and make sure each part works. I'm only using the form to add related table records for existing features, so I did not include the functionality to also view existing records or update records, etc. So far I've got it to work for a one-page form, so now I'll modify to work for a multiple-page form.

Re: Customizing Related Table Sample .vbs Script

MeredithDutlinger — Tue, 01 Jun 2010 19:57:12 GMT

I picked out parts of the script to use so I can debug it piece-by-piece and make sure each part works. I'm only using the form to add related table records for existing features, so I did not include the functionality to also view existing records or update records, etc. So far I've got it to work for a one-page form, so now I'll modify to work for a multiple-page form.

Did you get your multipage form to work? I've been trying and trying to do the same thing, but I can't get it coded right in my vbscript. Frusterating!

Re: Customizing Related Table Sample .vbs Script

SueJohnston — Mon, 30 May 2011 18:26:44 GMT

I have not been able to modify the riverside sample and get it to actually work. Does anyone have any sight on this? The form will open but the domains won't populate and the records don't seem to write. I pretty much just used find and replace to modify to my needs (or so i thought). I'm trying to create a hydrant inspection. Any info would be great. I'm using ArcPad 8 right now.
Thanks,
Sue