daft-support — For Daft support request notifications

[Daft-support] Re: A wish list Item

[<je...@dd...>]

> A few things you might like to consider,
> - the query history is kept but not the results history. I understand b=
eing
> concerned about the memory space but if that is a problem the results c=
ould
> be saved out to a metakit or sqlite database or the project database

This is a very nice thing to have, and may be integrated with s cache mec=
hanism
for succesfully run statements. This could look like a search hit on a go=
ogle
page that can be fetched from cache. Besides this, a simple forward and n=
ext set
of buttons on the data views is all you need. The data probably needs to =
be
compressed and stored in the project file. If you open DaFT another time,=
 you
can reuse the statements and cached data.

> - a long query is the end of using DaFT until it completes, which may b=
e
> tens of minutes. With a multithreaded interpreter you could run each qu=
ery
> in a slave interpreter, maybe keep a pool of them so that you don't nee=
d to
> establish connections each time. This would tie in with the query histo=
ry

Long queries are a fact of life, and it would be nice if one could contin=
ue
creating another one in the meantime. This means multithreading support f=
or the
tcl interpreter must be enabled, which is, as far as I know, not standard=
. This
needs some more investigation.

[Daft-support] A wish list item

[Vincent T. <vp...@gm...>]

A few things you might like to consider,
- the query history is kept but not the results history. I understand being
concerned about the memory space but if that is a problem the results could
be saved out to a metakit or sqlite database or the project database
- a long query is the end of using DaFT until it completes, which may be
tens of minutes. With a multithreaded interpreter you could run each query
in a slave interpreter, maybe keep a pool of them so that you don't need to
establish connections each time. This would tie in with the query history.

[Daft-support] Re: Error running DaFT

[Jelco H. <daf...@it...>]

Hi Geeta,

DaFT only works with User or System created datasources. So you have to s=
et up
a specific DSN via the ODBC Data Source Administrator. This can be opened=
 via
the DaFT File menu, then click on ODBC Administrator.

After you have set up a Data Source for you Informix server (incl
user/passw),this dsn will be visible in the DaFT connect/log ibn screen. =
The
fisrt time you log in you have to supply a username and password. The sec=
ond
time you log on DaFT will have this remembered , so you can open it from =
the
Connect
screen. Select previous connections from the list (upper left side) to se=
e the
previous connections.

If you want the connect screen to open by default with this list, you can=
 set
this in the DaFT Options menu.

Jelco.

[Daft-support] Re:Where is the concept of Schema

[Jelco H. <daf...@it...>]

Similar problems occur with databases like Oracle and Progress. The probl=
em is
that Double-clicking (or hit the F3 key) executes a select * from <table>=
.

The correct statement would be select * from <owner>.<table>. But this do=
esn't
work for let's say Ms Access. This problem is already fixed for the upcom=
ing
version 1.4. The new version will feature tree-views of columns, indexes,
primary keys, and the database object list, currently confined to tables =
and
views, and some other new things for the editor. I'll try to create a CVS=
 tree
from where a stable beta relased can be downloaded in the near future.

The concept of schema, user, database, and owner are similar, but not the
same. However they differ from database to database implementation.
The concept of owner and the statement to get the data (see above) works =
in
Oracle and Progress.

There was a similar issue which concerned access to different databases w=
hile
logged in as a particular user who has reading rights to several database=
s.
For the topic on this issue see https://sourceforge.net/tracker/index.php=
?
func=3Ddetail&aid=3D1215867&group_id=3D102868&atid=3D633066
There is a function for this in 1.3.2, and maybe do the job for you. You =
have
to know what the command is in DB2 to change database. (database .... ?)

Jelco

[Daft-support] Where is the concept of Schema?

[Vincent T. <vp...@gm...>]

DaFT seems an excellent piece of software that really deserves a lot more
attention than it seems to get from these mailing lists.
That said, this is about the third time I've tried to use it. My problem is
that it doesn't seem to have the concept of "schema" in it, or is that
mapped to Owner. To me they are different, I can create a table with any
schema name (given that I have the authority).
When I filter on "ALL" I can see all the tables but when I double click on
one I get an error because it can't find the table because it is using my
user schema name which is different from the table's schema name (the one
listed under owner).

The same thing happens if I select a few columns from a table with a schema
other than my user schema.

I'm using version 1.3.2 with DB2 and queries from the statement editor work
fine.

I find Advanced Query Tool, http://www.querytool.com/ , very intuitive to
use and that uses three columns the first being database objects with a tre=
e
selection of the schema under each object where appropriate. Logically, it
probably should be schema and objects within each schema but the AQT way
seems to work fine.

The more I get used to DaFT the more I like it.

[Daft-support] Re: Daft-support digest, Vol 1 #1 - 1 msg

[Jelco H. <daf...@it...>]

Hi Geeta,

DaFT only works with User or System created datasources. So you have to s=
et up
a specific DSN via the ODBC Data Source Administrator. This can be opened=
 via
the DaFT File menu, then click on ODBC Administrator.

After you have set up a Data Source for you Informix server (incl user/pa=
ssw),
this dsn will be visible in the DaFT connect/log ibn screen. The fisrt ti=
me
you log in you have to supply a username and password. The second time yo=
u log
on DaFT will have this remembered , so you can open it from the Connect
screen. Select previous connections from the list (upper left side) to se=
e the
previous connections.

If you want the connect screen to open by default with this list, you can=
 set
this in the DaFT Options menu.

Jelco.


Citeren daf...@li...:

> Send Daft-support mailing list submissions to
> 	daf...@li...
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://lists.sourceforge.net/lists/listinfo/daft-support
> or, via email, send a message with subject or body 'help' to
> 	daf...@li...
>
> You can reach the person managing the list at
> 	daf...@li...
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Daft-support digest..."
>
>
> Today's Topics:
>
>    1. Error running DaFT (Reddy, Geeta, VF-NZ)
>
> --__--__--
>
> Message: 1
> Date: Mon, 14 Nov 2005 09:39:52 +1300
> From: "Reddy, Geeta, VF-NZ" <Gee...@vo...>
> To: <daf...@li...>
> Subject: [Daft-support] Error running DaFT
>
> Hey,
>
> I have installed Daft version 1.3.2. =3D20
>
> I cannot however, connect to an Informix database on a server.  The
> Error is below:
>
> S1000 -461 [INTERSOLV][ODBC Informix driver][Informix]Cannot open file
> 'sql.iem'
>
> I have looked in the DaFT windows directory and the file is in there.
> Any ideas as to how to fix this will be much appreciated!
>
> Thanks,
> Geeta
>
>
>
>
>
> -----Original Message-----
> From: daf...@li...
> [mailto:daf...@li...] On Behalf Of
> daf...@li...
> Sent: Monday, 14 November 2005 9:26 a.m.
> To: Reddy, Geeta, VF-NZ
> Subject: Welcome to the "Daft-support" mailing list
>
>
> Welcome to the Daf...@li... mailing list!
>
> To post to this list, send your email to:
>
> =3D20 daf...@li...
>
> General information about the mailing list is at:
>
> =3D20 https://lists.sourceforge.net/lists/listinfo/daft-support
>
> If you ever want to unsubscribe or change your options (eg, switch to o=
r
> from digest mode, change your password, etc.), visit your subscription
> page at:
>
> =3D20
> https://lists.sourceforge.net/lists/options/daft-support/geeta.reddy%40=
v
> odafone.com
>
>
> You can also make such adjustments via email by sending a message to:
>
> =3D20 Daf...@li...
>
> with the word `help' in the subject or body (don't include the quotes),
> and you will get back a message with instructions.
>
> You must know your password to change your options (including changing
> the password, itself) or to unsubscribe.  It is:
>
> =3D20 reddyg
>
> If you forget your password, don't worry, you will receive a monthly
> reminder telling you what all your lists.sourceforge.net mailing list
> passwords are, and how to unsubscribe or change your options.  There is
> also a button on your options page that will email your current passwor=
d
> to you.
>
> You may also have your password mailed to you automatically off of the
> Web page noted above.
> -----------------------------------------------------------------------=
--=3D
> ----------------------
> Have you seen our website?.... http://www.vodafone.co.nz
>
> Manage Your Account, check your Vodafone Mail and send web2TXT online: =
ht=3D
> tp://www.vodafone.co.nz/myvodafone
>
> CAUTION: This correspondence is confidential and intended for the named=
 r=3D
> ecipient(s) only.
> If you are not the named recipient and receive this correspondence in e=
rr=3D
> or, you must not copy,
> distribute or take any action in reliance on it and you should delete i=
t =3D
> from your system and
> notify the sender immediately.  Thank you.
>
> Unless otherwise stated, any views or opinions expressed are solely tho=
se=3D
> =3D20of the author and do
> not represent those of Vodafone New Zealand Limited.
>
> Vodafone New Zealand Limited
> 20 Viaduct Harbour Avenue, Private Bag 92161, Auckland 1030
> Telephone + 64 9 355 2000
> Facsimile + 64 9 355 2001
>
>
>
> --__--__--
>
> _______________________________________________
> Daft-support mailing list
> Daf...@li...
> https://lists.sourceforge.net/lists/listinfo/daft-support
>
>
> End of Daft-support Digest
>

[Daft-support] Error running DaFT

[Reddy, G. VF-N. <Gee...@vo...>]

Hey,

I have installed Daft version 1.3.2. =20

I cannot however, connect to an Informix database on a server.  The
Error is below:

S1000 -461 [INTERSOLV][ODBC Informix driver][Informix]Cannot open file
'sql.iem'

I have looked in the DaFT windows directory and the file is in there.
Any ideas as to how to fix this will be much appreciated!

Thanks,
Geeta





-----Original Message-----
From: daf...@li...
[mailto:daf...@li...] On Behalf Of
daf...@li...
Sent: Monday, 14 November 2005 9:26 a.m.
To: Reddy, Geeta, VF-NZ
Subject: Welcome to the "Daft-support" mailing list


Welcome to the Daf...@li... mailing list!

To post to this list, send your email to:

=20 daf...@li...

General information about the mailing list is at:

=20 https://lists.sourceforge.net/lists/listinfo/daft-support

If you ever want to unsubscribe or change your options (eg, switch to or
from digest mode, change your password, etc.), visit your subscription
page at:

=20
https://lists.sourceforge.net/lists/options/daft-support/geeta.reddy%40v
odafone.com


You can also make such adjustments via email by sending a message to:

=20 Daf...@li...

with the word `help' in the subject or body (don't include the quotes),
and you will get back a message with instructions.

You must know your password to change your options (including changing
the password, itself) or to unsubscribe.  It is:

=20 reddyg

If you forget your password, don't worry, you will receive a monthly
reminder telling you what all your lists.sourceforge.net mailing list
passwords are, and how to unsubscribe or change your options.  There is
also a button on your options page that will email your current password
to you.

You may also have your password mailed to you automatically off of the
Web page noted above.
-------------------------------------------------------------------------=
----------------------
Have you seen our website?.... http://www.vodafone.co.nz

Manage Your Account, check your Vodafone Mail and send web2TXT online: ht=
tp://www.vodafone.co.nz/myvodafone

CAUTION: This correspondence is confidential and intended for the named r=
ecipient(s) only.
If you are not the named recipient and receive this correspondence in err=
or, you must not copy,
distribute or take any action in reliance on it and you should delete it =
from your system and
notify the sender immediately.  Thank you.

Unless otherwise stated, any views or opinions expressed are solely those=
=20of the author and do
not represent those of Vodafone New Zealand Limited.

Vodafone New Zealand Limited
20 Viaduct Harbour Avenue, Private Bag 92161, Auckland 1030
Telephone + 64 9 355 2000
Facsimile + 64 9 355 2001