pocketpete

Yes you click the button but its not saving. It seems to ‘click’ then you see the java script(0) bottom left. It’s not a major problem as I will be ordering the full version in the next week.
I’ve finally sorted all those little problems.
I wanted to use vb6 to create an odbc remote connection to wordpress. Took me best part of a week to get the connection settings working. Was using the 64bit odbc instead of 32. Damn. But now I can use it to enter the data straight into the tables in wordpress. Wpdata access can handle all the displaying of the data and some minor querys that can’t be done remotely so looking good. Just I had time to learn php.

The sql works fine in the query builder but you cannot save the query in the version I have downloaded when you hover over ‘save’ you get JavaScript void appearing at the bottom of the screen. if i have to create a view its another step in the process which i am trying to avoid.

I thought the program would allow you to display a table based upon a sql search

Creating a view has sorted it. Many thanks

Is that within wpdata tables? or as a separate view with the database?

• This reply was modified 3 years ago by pocketpete.

Im not particularly technical. many years ago I used to do a little visual basic stuff with access which is not that much removed from modern sql stuff.

Many years vb I wrote an app which allow people to select a list of clubs in a league from a drop down list (combo box) these were sorted into alpabetic order.

A club was selected from the list and below the combo box in a table/grid appeared all the players who played at the club with all their detail match wins etc.

in this case there were 12 clubs each assigned a number 1-12 (the names were used in the drop down combo box)

once a club was select I excecuted an small SQL statement to pick up the players details.

Select * from players where club-id = what ever number they selected in the box

The players data was then displayed in the grid/table below the combo box.

———————————————————————

As Iam looking at the support forum writing this on my right i can see a ‘Report this topic for’ dropdown with a button underneath for reporting a topic violations etc.
my request is similar once a topic is selected the sql is selected.

I know the table has a search facility but it would save having to type the full name in the search this is a problem when you have for example we may have two clubs at the same venue.

Castleton A team
Castleton B Team

you would have to type the full name to get a result.

You program is the closest thing i have found to my needs. Im sure if I have time I could learn php and manage eventually to create a sql front end that allows me to do this. Basically I want a relational database that can be embedded in wordpress rather than a separate thing. Considering wordpress is a sql database there are very few programs/plugins which allow you to store your own data and perform complex tasks with the data.

in my case all my data comes from a 15 year old access database linked to vb4 which produces all the league results and i can pop these onto my wordpress site either in a spreadsheet and embed it or in csv and import it straight in using your program. I just need a better method of finding the data.