SQL Sentences in Tribon

How to set-up and maintenance Tribon system and Tribon projects

Moderator: m.minchev

SQL Sentences in Tribon

Postby ellerysammy » Fri Mar 05, 2010 5:17 pm

Is posible to execute querys in Tribon Databank ???...
if this is posible i want to know how can i do it...
Thanks in advence for your help..... :roll:


ellerysammy
 
Posts: 23
Joined: Tue Dec 30, 2008 1:06 pm
Location: Cartagena - Colombia

Re: SQL Sentences in Tribon

Postby dhiggins » Mon Mar 08, 2010 2:37 pm

What kind of data are you looking for?

You can use data extraction to access a wide variety of data from every model object in any databank.

You can use sa004 to list databank content and key information against any record in that databank.

You can incorporate these abilities into a vitesse program and create customized or batch routines.

Dana
dhiggins
 
Posts: 143
Joined: Wed Aug 30, 2006 6:46 pm
Location: San Diego, CA, USA

Re: SQL Sentences in Tribon

Postby ellerysammy » Tue Mar 09, 2010 1:18 pm

HI...
Thanks for your help...
Really that i want to do is a excel macro like outfiting list or nesting list, but customize according to my request
some idea ??
ellerysammy
 
Posts: 23
Joined: Tue Dec 30, 2008 1:06 pm
Location: Cartagena - Colombia

Re: SQL Sentences in Tribon

Postby dhiggins » Tue Mar 09, 2010 2:29 pm

I would write a vitesse/python code that allows for the input that you desire, performs data extraction or some type of calculations, and then exports to an excel file.
dhiggins
 
Posts: 143
Joined: Wed Aug 30, 2006 6:46 pm
Location: San Diego, CA, USA

Re: SQL Sentences in Tribon

Postby Ovidiu » Wed Mar 10, 2010 9:24 am

I can write Tribon Data extraction excel macro customized acording to clients needs...
Ovidiu
 
Posts: 59
Joined: Tue Sep 05, 2006 4:12 am
Location: Romania

Re: SQL Sentences in Tribon

Postby mark » Thu Mar 11, 2010 9:31 am

I can be your help.... :wink:
mark
 
Posts: 371
Joined: Wed Sep 06, 2006 5:12 am
Location: Philippines


Return to Tribon system administration

Who is online

Users browsing this forum: No registered users and 1 guest