nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Customizing Related Table Sample .vbs Script

DaytonPoff

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!

Vind meer berichten getagd met

Accepted answers

All comments

SueJohnston

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

MeredithDutlinger

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!

JaneOnorati

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.

DaytonPoff

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!

DaytonPoff

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.

JaneOnorati

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.

JayKappy

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.

JayKappy

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......

DaytonPoff

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

JaneOnorati

Dayton,

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

-Jane

DaytonPoff

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

JaneOnorati

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.

DaytonPoff

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

JaneOnorati

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

-Jane

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.