Database web viewer

[adcpc]

Hi,

I've set up a mysql database and my teststand results are correctly saved to the database.

I would like to display these results in a web page. Is there any tool that would nicely display the results without requiring sql queries knowledge ?

I know that there are tools like phpmyadmin but I'm looking for something simpler as I don't need to manage the database through a web interface.

Is there also a description of all the tables and the links created by teststand ?

Regards,

Alex

[Norbert_B]

Alex,

the "description" of the tables and 'links' (it is indeed a 'relation' created by 'foreign keys' in the tables) is the "database schema" you are using for logging the results in the database.

So you would like to review the schema you are using in order to know the highest complexity your database can look like for the TestStand results (you might have some additional custom tables in the database which are never toughed by TestStand!).

Regarding a web based SQL Viewer: I am not familiar with any, but maybe Google is....

Norbert

[Thresh]

hello,I get the same problem just like yours,did you get the method to read data from MySQL database with a way which is esay for normal user?looking forward to your reply.

[bienieck]

TestStand installs its Database Viewer application. You might try. Is it a simple way of displaying DB? You need to judge for yourself.

Here are two help file links (run it in cmd):

hh.exe mk:@MSITStore:%TestStand%\Doc\Help\TSRef.chm::/InfoTopics/DBViewer.htm
hh.exe mk:@MSITStore:%TestStand%\Doc\Help\TSRef.chm::/InfoTopics/DBViewer_CommandLine.html

Here are the tutorials:

https://knowledge.ni.com/KnowledgeArticleDetails?id=kA03q000000x0cNCAQ

https://knowledge.ni.com/KnowledgeArticleDetails?id=kA00Z000000kKLzSAM