> last time I checked dbworkbench doesn't run on unix :)

It runs in Wine :-)

Besides, if you have a Windows workstation, you can connect to the server
just fine.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

> Thanks for the string construction idea
>
> 2008/7/31 Martijn Tonies <m.tonies@...>
>
> > Hello Nick,
> >
> > > before I start thinking about writing something that does this, is

anyone

> > > aware of one that already exists.
> > >
> > > I want to do "select a,b from mytable where c < 97" and have the

output

> > as
> > > insert statements, automatically, on unix (fedora 8 to be precise)
> >
> > Well, a tool like Database Workbench could do that for you :-)
> >
> > As a workaround, you could also write:
> >
> > SELECT 'INSERT INTO mytable (a, b) VALUES (' || A || ', ' || B || ');'
> > from mytable where c < 97
> >
> > Export the resultset to file and you should have your script.
> >
>
>
> [Non-text portions of this message have been removed]
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>