Subject | Re: [firebird-support] It's all greek to me, and now you throw in the latin. What gives? |
---|---|
Author | unordained |
Post date | 2004-11-13T12:44:16Z |
Apparently, there's no existing tool for this -- we'd be happy though if you would create one and
contribute it "to the cause". It should be trivial, particularly for what you want, although I've
found that the rules for double-quotes vary by product (in fact, last I saw, MS Access and MS Excel
didn't agree on embedded double-quotes in comma-separated files.) As to XML, perhaps someone else
will extend your project with DTD-related features after the fact.
You have the option of writing such a tool in a whole host of languages for which there are
bindings to the Firebird libraries, or, as you suggested, make it a generalized solution utilizing
JDBC or ODBC (as only some examples of cross-database interfaces.) If you can't write it yourself,
you might even do some programmer a kindness and pay him to do it for you.
If you run into any problems related to Firebird while writing such a tool, feel free to ask for
help, that's what we're here for. (Martijn took care of the other type of response, I'll leave it
at that.)
-Philip
---------- Original Message -----------
From: "rocksolidrobot" <rocksolidrobot@...>
To: firebird-support@yahoogroups.com
Sent: Sat, 13 Nov 2004 05:08:01 -0000
Subject: [firebird-support] It's all greek to me, and now you throw in the latin. What gives?
contribute it "to the cause". It should be trivial, particularly for what you want, although I've
found that the rules for double-quotes vary by product (in fact, last I saw, MS Access and MS Excel
didn't agree on embedded double-quotes in comma-separated files.) As to XML, perhaps someone else
will extend your project with DTD-related features after the fact.
You have the option of writing such a tool in a whole host of languages for which there are
bindings to the Firebird libraries, or, as you suggested, make it a generalized solution utilizing
JDBC or ODBC (as only some examples of cross-database interfaces.) If you can't write it yourself,
you might even do some programmer a kindness and pay him to do it for you.
If you run into any problems related to Firebird while writing such a tool, feel free to ask for
help, that's what we're here for. (Martijn took care of the other type of response, I'll leave it
at that.)
-Philip
---------- Original Message -----------
From: "rocksolidrobot" <rocksolidrobot@...>
To: firebird-support@yahoogroups.com
Sent: Sat, 13 Nov 2004 05:08:01 -0000
Subject: [firebird-support] It's all greek to me, and now you throw in the latin. What gives?
> Thanks for the info, I followed that up & found out some------- End of Original Message -------
> things, but still haven't got the desired xml/csv output.
> It seems xml export is not a current feature, a medium priority
> for the next major release.
>
> I don't need typed data, or a DTD. Plain xml like this would be
> just fine:
>
> <table>
> <row><a>1</a><b>=</b><d></d><e></e><f></f><g></g></row>
> <row><a>2</a><b>+</b><d></d><e></e><f></f><g></g></row>
> <row><a>3</a><b>-</b><d></d><e></e><f></f><g></g></row>
> <row><a>4</a><b>*</b><d></d><e></e><f></f><g></g></row>
> </table>
>
> The export should work in a general way for *.fdb
> - so I think stored procedures are out (also I am a complete FB
> novice and I think going thru the loops and hoops to learn how to do
> that would send me completely insane).
>
> It's all geek to me, and now you throw in the latin. What gives?
>
> http://www.ai.mit.edu/projects/infolab/startfarm.cgi?query=quo%20vadis
> Main Entry: quo va·dis?
> Pronunciation: kwO-'wä-dis, -'vä-d&s
> Usage: foreign term
> Etymology: Latin
> : whither are you going?
>
> Whither I know means where, but I will let
> http://open-dictionary.com/Whither, answer that one...
> "Conjunction 1. To where. (I do not know whither I am going.)"
>
> Downloaded & installed http://www.ibobjects.com/IB_SQL_EXE.zip
> (Unimpressed. yet to find out if or how it works as a console App.)
>
> I didn't know about ibphoenix.com, so I searched
> google "site:www.ibphoenix.com xml" -- 23 hits
>
> >From 13/11/2004 --
> http://www.ibphoenix.com/downloads/OpenFeaturesDetailed.pdf
> 1439 Allow for dataset to be returned in HTML/XML format using data-
> output templates.
> 5 - Medium (next major release)
>
> Two commercial tools showed up. I decline to pay
> more money for what already is proving to be very frustrating
> (Yes, I did expected better from this Firebird thing).
>
> Quick Export for InterBase and Delphi
> Suite of Delphi components for exporting from your IB/Firebird
> database to 12 most popular formats: MS Excel, MS Word (RTF), HTML,
> XML, TXT, DBF, CSV, SYLK, DIF, LaTeX, SQL and Windows Clipboard
> without ODBC or the BDE.
> Available in two versions, for FIBPlus or IB Objects TDataset-
> compatible data access objects.
> By Vadim Vinokur Commercial
>
> IBQueryEditor V1.0
> IBQueryEditor is a graphical tool designed to allow you to quickly
> write, save, load and execute SQL scripts against any InterBase or
> Firebird database. It provides the following features.
> Edit and author SQL scripts and queries.
> Multi-threaded to allow multiple queries to be run simultaneously.
> Connection manager to manage servers and databases.
> Multiple output formats for query results including: CSV, Tab
> Delimited, and XML.
> Supports InterBase 4.x, 5.x, 6.x, 7.x
> Support for Firebird 1.x
> By SoftMosis Inc. Commercial
>
> Found an article at:
> http://www.ibphoenix.com/main.nfs?
> a=ibphoenix&s=1099850314:240221&page=ibp_news_art8
> " What's happening with Firebird and InterBase?
> As featured in the UK Borland Users Group Magazine (Mar/Apr 2002)
> By Paul Reeves
>
> XML Generation
> I'm yet to be seduced by XML so I don't know whether this is a 'must
> have' or a yawn. IB 6.5 ships with a dll that encapsulates some API
> calls and returns data wrapped in XML tags. There's no rocket science
> here, and I dare say if it was really important for a project a
> similar bit of functionality could be knocked up in a day."
> Paul Reeves
>
> This Paul Reeves geni-ass seems to think xml is a simple thing.
> I don't care if the question is simple or not, I just want a simple
> answer... and the "Relational Database for the New Millennium" has
> nada.
>
> ------------------------ Yahoo! Groups Sponsor --------------------~-->
> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
> Now with Pop-Up Blocker. Get it for free!
> http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> --------------------------------------------------------------------~->
>
> Yahoo! Groups Links
>
>
>