Seeing the data in tables?

[JonathonBevan1342106235]

Hi

I am new-ish to Servoy. As you work with data you sometimes want to see the contents of the table (whilst testing) in a browse - something like what VFP provides. I can create a quick form in Servoy to do this but is there an easy way?

PS the more I use Servoy the happier I am that I selected it as my next development language - thanks OMAR - if you look at this...

Kind Regards
Jonathon

[ptalbot]

To be able to see data from your tables, all you need is to install the SQLExplorer plugin. It should already be in your 'Available Software Sites'.
Go to "Help > Install New Software...", in the 'Work with...'' comboBox, choose 'SQLExplorer Updates - http://eclipsesql.sourceforge.net/", you will see the SQLExplrer plugin in the list, click on deploy to check the latest version, then click 'Next>' and follow the installation instructions.
After installation and restart, you will be able to open a table in your 'Database servers', you will see a (last) tab Data in the table definition editor...

[omar]

Hi

I am new-ish to Servoy. As you work with data you sometimes want to see the contents of the table (whilst testing) in a browse - something like what VFP provides. I can create a quick form in Servoy to do this but is there an easy way?

PS the more I use Servoy the happier I am that I selected it as my next development language - thanks OMAR - if you look at this...

Kind Regards
Jonathon

Hi Jonathon,

Glad you like it! If you have the SQLExplorer plugin installed correctly, like Patrick described then follow these steps:

Click the database connection node
Right-click the table in the left-lower window
Choose edit table/view
In the screen that opens there are tabs at the bottom
The last one should be the Data tab that Patrick mentioned
Click it and you should see the data

However, this is readonly data, so it's not as flexible as in VFP. A tool I like to use on the side is Navicat Premium. It supports al major databases including VFP and works a bit like SQL Server Management Studio. In time I expect you will want to switch to PostgreSQL or SQL Server because they are faster and more reliable.

Cheers,

[ptalbot]

SQL Explorer also have a perspective where you can use a Servoy Database server connection and run SQL queries directly, so updates are possible this way without and extra tool. But as Omar said, there are dedicated tools (some open source, some commercial) for each database vendors that will give you extended options to administer you database and more conveniently browse/update data amongst other thing.

[JonathonBevan1343755645]

Hi

Thank you guys.. really...

I am not working with Foxpro tables. I chose Postgresql straight away.

I am having to get more familiar with Eclipse and add-ons.

When I try to install sql I get an error - over and over again.

This is the error.
"Contacting Software Sites" has encountered a problem.

Unable to read repository at http://download.eclipse.org/releases/in ... ontent.jar.
Read timed out

I have no idea what this means and how to solve it.

I would really appreciate help.

Kind Regards
Jonathon

[JonathonBevan1342106235]

Here are some screen dumps that show I have a problem installing SQLExplorer. I don't know what to do from here?

Any help would be grately appreciated...

Kind Regartds
Jonathon

[grahamg]

Hi Jonathon

Untick the 2nd Eclipse SQL Explorer - the one that ends in ...SR5_p1 - and just import the 1st one.

That worked fine for me.

Regards

[JonathonBevan1342106235]

Thanks for trying to help. I have unticked the lesser version and tried to install v6. But when I get to the license screen I cannot click the <next> button.

Please see image I have uploaded.

Cheers Jonathon

[grahamg]

Have just installed SQl Explorer again and worked OK - as soon as I click the "Accept ..." tickbox the Finish button is enabled.

Have attached three screenshots so that you can compare your experience - they are displayed in reverse order but I'm sure you can follow the flow -:)

Hope this helps

[JonathonBevan1342106235]

Thanks for trying to help me on this problem (just my luck to get a strange problem )...

If you see from my first screen pictures I don't get the <finish> button being enabled after accepting terms and conditions...

Last night I tried to install a number of times and I got the error -> see the attached file.

Thnak again for your help.
Kind Regards
#j

[pbakker]

Most likely you're running On Java 7, 64bit, right?

The version of Eclipse that ships with Servoy is not 100% compatibly with this Java version. Either try running under Java 6 or a 32bit Java and that will most likely cure the problem.

Paul

[lwjwillemsen]

Most likely you're running On Java 7, 64bit, right?

The version of Eclipse that ships with Servoy is not 100% compatibly with this Java version.

Servoy, please make it right for Java 7 64 bit for Servoy 5 + 6.

[omar]

I am using this on Java 7, 64 bit without any problems...

[pbakker]

Upgrading the bundled Eclipse will not happen until the next major Servoy release, as upgrading Eclipse requires a clean installation of Servoy, which we avoid in minor and maintenance releases.

@omar: the issue with Java 7 64bit is with updates sites and the behavior is erratic, so if it worked for you, you should count yourself lucky

[JonathonBevan1342106235]

Hi Everyone

Thanks so much for the help.

I downgraded from version Java 1.7 to 1.6. I got a different error message that I did not capture. After installation I rebooted and SQL Explorer seemed to install itself happily - at last!

Of course (knowing my luck) I still have a problem. In the "data" tab provided by SQL explorer of my only table so far "Projects". I get what you can see on my attachment. Doesn't look healthy. Maybe I haven't solved this problem so far?

Thanks for your help because I am stuck!

Without the Forum I would be stuck on a number of issues right now... I really appreciate the help.

Cheers
Jonathon