Thread: DB grid

DB grid

From
"Braxton Beyer"
Date:
where can I get a grid that allows you view and edit data from a database, any ideas?

Braxton Beyer
SETON Planning & Marketing
512.324.1000 x14849

RE: DB grid

From
"Tibor Laszlo"
Date:
> where can I get a grid that allows you view and edit data
> from a database, any ideas?

Where would you like? If you need a Windows client, you
can use a Delphi or C++Builder professional to make a fast
solution. There is a DBGrid in it, wich can be used with our
ODBC driver. Or you may use Kylix for Linux. Maybe there is
one in JBuilder, if your prefered platform is Java. But if you
want to make a serious system, consider to use other, non
Borland products.

We use C++Builder. Regards,

Tibor Laszlo
ltibor@mail.tiszanet.hu


Re: DB grid

From
Cedar Cox
Date:
Did you get your answer?  If not, you can try this if you have MS
Access..  (everyone else, this is interesting.. a strange alternative to
using linked tables)

Create a query in an Access database (a normal query), cancel the show
table box, set the SourceConnectStr property to a valid connect string,
then go back to show table.  Now you can use the Access query design tool
(not that you would want to..).  If you want to set the SourceConnectStr
from VB code then you only have to edit the query's SQL and set it like:

  SELECT * FROM mytable IN ''
[ODBC;DSN=pgtestdb;DATABASE=testdb;SERVER=nanu;PORT=5432;UID=pguser;PWD=password;
READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;
SHOWSYSTEMTABLES=0;CONNSETTINGS=];

and set the [ODBC;...] part to a connect string valid for your server and
database.

-Cedar


On Wed, 18 Apr 2001, Braxton Beyer wrote:

> where can I get a grid that allows you view and edit data from a database, any ideas?
>
> Braxton Beyer
> SETON Planning & Marketing
> 512.324.1000 x14849
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>