ISTech Support Forum - Data Fields...

ITman

Ex Member

Data Fields...
08/01/03 at 09:22:19

I'm trying to create a new Shop Traveler and was wondering where I can pull data from the database. (i.e. What field is what)

Is there a list of what fields in the database are what? I do notice that some of them have descriptions, but most don't....

Specifically, I'm looking for:

Work Order #
Part No.
Seq#
Description (of sequence)
Quantity (of work order)

Anyone?

Back to top

IP Logged

aricon Active Member Systems Consulting-See website for products! Posts: 1283 Gender:	Re: Data Fields... Reply #1 - 08/01/03 at 11:21:54 We could develop this for you as an MS Access application that would allow you significant flexibility and it would print EXACTLY what you want and where you want it. Contact me if you are interested.
Back to top	Sincerely, Lorne Rogers President Aria Consulting & Implementers Ltd. Phone: (780) 471-1430 Fax: (780) 471-4918 E-mail: lrogers@ariaconsulting.net IP Logged

ITman Ex Member	Re: Data Fields... Reply #2 - 08/01/03 at 11:33:05 Actually, we don't have Access available to us. We are thinking it would be better for us to remain within just DBA Manuf. and change the form that is already printed. Thanks for the offer -ITMan
Back to top	IP Logged

Lynn_Pantic

Administrator

evolution (n) -
gradual change to a
different form

Posts: 5681

Re: Data Fields...
Reply #3 - 08/01/03 at 12:07:12

An Excel spreadsheet listing files and fields within the files is available at www.istechsupport.com/dl/dbafile.zip

This file is offered on a "Best Effort" basis, it is not 100% complete but it is certainly better than the cryptic field names in the files themselves.

If you want to edit the existing Traveler RTM and move fields around and perhaps delete some things, you can do that with standard DBA but if you want to add fields that are not on the existing form, you will need TAS 6 Evolution and the TAS 6 forms editor.

Back to top

Lynn Pantic
IS Tech Support
lynn@istechsupport.com

IP Logged

aricon

Active Member

Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male

Re: Data Fields...
Reply #4 - 08/01/03 at 12:59:49

You don't actually need a full version of Access to run most of the applications we design. They can be run using the free "run-time" version of Access that is available from Microsoft.

Just an option that allows more flexibility than what is available with DBA itself. If you like, you can go to our website www.ariaconsulting.net , go to the Services section, then Custom Application Solutions and there is a link there that will take you to some screenshots of applications that we have designed to work with DBA in MS Access.

Back to top

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net

IP Logged

ITman Ex Member	Re: Data Fields... Reply #5 - 08/01/03 at 13:28:48 Aricon - I wasn't aware of that. I'll have a look at it tonight. Lynn - Thanks for the information, it will help alot. -ITMan
Back to top	IP Logged

David Waldmann

Active Member

Live to work, or
work to live?

Posts: 1924
Gender: male

Re: Data Fields...
Reply #6 - 08/04/03 at 07:09:19

Quote from Lynn_Pantic on 08/01/03 at 12:07:12:

An Excel spreadsheet listing files and fields within the files is available at www.istechsupport.com/dl/dbafile.zip

This file is offered on a "Best Effort" basis, it is not 100% complete but it is certainly better than the cryptic field names in the files themselves.

This is great! (and will be magnificent when complete Wink

)

Back to top

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11

IP Logged