A little poll concerning Paradox
Côme de Christen
[Cross post message on P10, P11 and developer group, follow up redirected to
corel.wpoffice.paradox-dev]
Hello everybody
The real SP2 (so not the cumulative SP2 patch, you can check this executing
winver where you should see Service Pack 2 at the end) makes Paradox not
more compatible with anything else than standard alias for the interactive
mode. No more SQL or ODBC alias.Quick test : Menu file/open/table and try
selecting a non standard alias. Not more possible so you cannot pick an ODBC
or SQL alias.
FWIW the problem seems to be tied to Corel dialog box. Borland P7-32 does
not have this problem.
This problem could concern all the Corel edition of Paradox (Tested in P10)
Bertil Isberg , C-Tech, has already transmitted this to Corel but what is
your opinion :
I can verify this : Yes [ ] No [ ] (if No please
give your precise configuration)
If Yes (now multiple answers possible) :
it's not important to me since :
[ ] I don't use anymore Paradox
[ ] I will never use ODBC or SQL table
[ ] I only work in OPAL
[ ] I don't use Alias, what is an alias ?
It's important to me and I believe :
[ ] Paradox just lost 50% of its power
[ ] Corel should correct with a free patch all the versions concerned
[ ] Corel should prepare a new commercial release with the patch
[ ] This is not a Corel problem but a Microsoft one
By the way, there is in Frankfort at the end of October 2004 an
International Paradox Convention
(Second editon after the real success in Paris)
http://www.babstsoft.com/Paradox/Convention04/StartConvention.htm
Corel representatives just say that they will not be present at this
convention
[ ] This is not a problem they must be very busy
[ ] This is not normal to say le least
Thank you in advance
[Cross post message on P10, P11 and developer group, follow up redirected to
corel.wpoffice.paradox-dev]
Côme de Christen
"Côme de Christen" <come.de...@wanadoo.fr> a écrit dans le message de
news: 416b906f_2@cnews...
>
> [Cross post message on P10, P11 and developer group, follow up redirected
> to corel.wpoffice.paradox-dev]
>
> Hello everybody
>
> The real SP2 (so not the cumulative SP2 patch, you can check this
> executing winver where you should see Service Pack 2 at the end) makes
> Paradox not more compatible with anything else than standard alias for the
> interactive mode. No more SQL or ODBC alias.Quick test : Menu
> file/open/table and try selecting a non standard alias. Not more possible
> so you cannot pick an ODBC or SQL alias.
>
> FWIW the problem seems to be tied to Corel dialog box. Borland P7-32 does
> not have this problem.
> This problem could concern all the Corel edition of Paradox (Tested in
> P10)
>
> Bertil Isberg , C-Tech, has already transmitted this to Corel but what is
> your opinion :
>
> I can verify this : Yes [ X ] No [ ] (if No please
> give your precise configuration)
>
> If Yes (now multiple answers possible) :
>
> it's not important to me since :
>
> [ ] I don't use anymore Paradox
> [ ] I will never use ODBC or SQL table
> [ ] I only work in OPAL
> [ ] I don't use Alias, what is an alias ?
>
> It's important to me and I believe :
>
> [ X ] Paradox just lost 50% of its power
> [ X ] Corel should correct with a free patch all the versions concerned
> [ X ] Corel should prepare a new commercial release with the patch
> [ ] This is not a Corel problem but a Microsoft one
>
> By the way, there is in Frankfort at the end of October 2004 an
> International Paradox Convention
> (Second editon after the real success in Paris)
> http://www.babstsoft.com/Paradox/Convention04/StartConvention.htm
>
> Corel representatives just say that they will not be present at this
> convention
>
> [ ] This is not a problem they must be very busy
> [ X ] This is not normal to say le least
Bertil Isberg
Côme
Just a couple of questions as I don't have Win XP.
1) Can you select the alias when creating a SQL statement manually?
2) Can you select the alias and the tables when working in Visual Query
Builder?
3) Can you access the remote alias using ObjectPAL? eg database.open()
4) Can you enum the tables in a remote alias? eg enumDatabaseTables()
5) Can you open a tableview on a remote table from ObjectPAL?
--
Bertil Isberg
CTECH
FAQ newsgroup: corel.wpoffice.paradox-faq
Paradox Buglist: http://w1.826.comhem.se/~u82608896/
remove spamfilter (reversed) to reply
Bertil Isberg
Côme
<<
>What happens if you create the query based on a saved datmodel?
It's ok (even if it's a bit...well you know...)
>>
The features lost are basically Create table, InfoStructure, and
Restructure.
Copy and add tables should be rather easy to implement.
You can create queries by creating a datamodel and use that for the query.
As the problem obviously is caused by XP SP2, you have to wait for the
the lost features to be added back to Paradox. In the mean time, try the
other ways to do these operations that Paradox provides. E g using
datamodels as a base for new queries is not very well known.
Bertil Isberg
Côme
<<
Table.open,
Table.SaveAs (after creation of a new Sql table)
Query.new
all the important functionnalities under tool/utilities...
>>
Table.open can easily be replaced by form.open
Query.New can easily be replaced by creating a datamodel containing the
tables and using the datamodel for the query.
Copy, and add should be easy to implement using ObjectPAL.
Côme de Christen
I simply hope Corel will patch quickly these dialog...
As is Paradox will be hard to sell anymore, that was my real point.
Now I can't do anything more on it , let see Corel reaction.
"Bertil Isberg" <bertil...@retlifmapsSCB.se> a écrit dans le message de
news: 416beb88$1_1@cnews...
[...]
Tony McGuire
: Now I can't do anything more on it , let see Corel reaction.
You've probably already seen their total reaction.
--
--
Paradox Support http://www.thedbcommunity.com/support/
Tony McGuire
_____________
Anders Jonsson
I agree with Bertil that the problem can easily be worked around.
I wouldn't be surprised if Vladimirs PorView allready worsk around it (I
don't use it myself).
I use MySQL and MSSQL as a backend in several of my applications. The are
all based on Runtime and so far I haven't noticed any problems after
upgrading to XP SP2.
As to interactive use - OK Paradox has lost a little of it's functionality
but to be honest, I have never seen Paradox as the perfect tool to use
interactively against an SQL database. I think there are beeter tools for
interactive use.
Just my opinion.
Anders
Larry DiGiovanni
Frederic G. MARAND wrote:
> Would you mind mentioning what tools you are thinking of as better for
> interactive use with a variable SQL database ? This is a problem many
> of us have, with little success.
If you are talking about a single interactive front end that works with
many back ends, I have not found one, but both Paradox and Access work
okay, particularly for interactive data fixes and
query/analysis/reporting.
For development and administrative tasks, specific purpose tools are
usually best. I use SQLYog for MySQL, Enterprise Manager and Query
Analyzer for MS SQL Server, and SQL Navigator for Oracle, though I am
prepared to believe TOAD is a better tool for Oracle, though I've not used
it.
--
Larry DiGiovanni
Digico, Inc
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources
Anders Jonsson
> Would you mind mentioning what tools you are thinking of as better for
> interactive use with a variable SQL database ? This is a problem many of
> us
> have, with little success.
My experience with SQL databases is limited and is mainly with MSSQL. For
work like restructuring and creating tables I use the Enterprise manager.
For queries I use the same or the Query Analyzer. Sometimes I work from
Paradox as well to creat queries and I then just write plain SQL - that
function is not affected.
In one of my applications I have the need ot open up the SQL tables and then
I have actually made a very simple form which either queries the tables with
some prefixed selections or open up a tableview. To create that form was
just small work and it sill works even after SP2.
However, if your backend is MSSQL and you need do to a lot of interactive
work but no coding I would assume that MS Access would be the prefered tool.
I must admit I haven't done much work in Access but I have a feeling that it
might be a better tool for interactive use.
I'm in the lucky (?) situation that all my clients are only interested in
contained applications and are not interested/capable of using any
interactive tools.
Have you checked if Vladimirs ProView will solve the problem?
Anders
Ken Loomis
On Thu, 14 Oct 2004 12:38:39 -0400, "Larry DiGiovanni" <nospam@nospam>
wrote:
>
>For development and administrative tasks, specific purpose tools are
>From the SQLyog website:
"Furthermore, you don't require installing extra tools like web
servers and PHP to run SQLyog. You just need to have access to the
remote host on which MySQL is running."
Does this mean SSH for Apache systems?
Ken
Anders Jonsson
I think in Sweden there are many that will allow it but probably some will
not.
Anders
"Larry DiGiovanni" <nospam@nospam> skrev i meddelandet
news:41700ab5$1_3@cnews...
>
> Côme de Christen wrote:
>
>> But , AFAIK, you 'll not find many ISP accepting this
>> (Connexion to MySql from outside)
>
> That's funny, I've found just the opposite to be true, but perhaps you
> have dealt with more ISPs than I have.
Côme de Christen
Hi Larry
No I'm sure not ! But in France for instance such ISP (they exist of course)
are exception
"Larry DiGiovanni" <nospam@nospam> a écrit dans le message de news:
41700ab5$1_3@cnews...
>
> Côme de Christen wrote:
>
>> But , AFAIK, you 'll not find many ISP accepting this
>> (Connexion to MySql from outside)
>
> That's funny, I've found just the opposite to be true, but perhaps you
> have dealt with more ISPs than I have.
>
Côme de Christen
"Anders Jonsson" <g...@takethisawaybredband.net> a écrit dans le message de
news: 416d7d42_2@cnews...
[...]
> Have you checked if Vladimirs ProView will solve the problem?
[...]
AFAIK (gloups !) , Proview will help you opening the tables
For the others operation (Query new,copy table...) Proview call Corel
dialogs
Côme de Christen
ok ok
As usual France can't do as the rest of the world ? :-)
"Anders Jonsson" <g...@takethisawaybredband.net> a écrit dans le message de
news: 4170210d_3@cnews...
Vladimir Menkin
> AFAIK (gloups !) , Proview will help you opening the tables
> For the others operation (Query new,copy table...) Proview call Corel
> dialogs
To avoid built-in Corel dialog for table copy/rename you can copy/rename tables
using drag'n'drop in ProView. As for New Query - unfortunately, I don't know how
to avoid Corel dialog... :(
Vladimir Menkin
Côme de Christen
By builing new proview dialogs (and rewrite little by little Paradox !) ?
At then end we could use Proview in runtime without Paradox...
(You'll then have a star product even for Delphi's users...)
Thanks for your tip with drag'n'drop
"Vladimir Menkin" <vmenki...@ITS-surveys.com> a écrit dans le message de
news: 4170ed06$1_3@cnews...
Vladimir Menkin
> By builing new proview dialogs (and rewrite little by little Paradox !) ?
:) The problem is that there is no way (at least, i don't know) to open, for
example,a new query bypassing this dialog. So, we really need to rewrite Paradox
a bit ;)
> At then end we could use Proview in runtime without Paradox...
> (You'll then have a star product even for Delphi's users...)
BTW, iProView allows a lot of direct operations with tables and queries and it
works under Runtime.
Vladimir
Côme de Christen
"Vladimir Menkin" <vmenki...@ITS-surveys.com> a écrit dans le message de
news: 417122d3$1_1@cnews...
>
>> By builing new proview dialogs (and rewrite little by little Paradox !) ?
>
> :) The problem is that there is no way (at least, i don't know) to open,
> for example,a new query bypassing this dialog. So, we really need to
> rewrite Paradox a bit ;)
Yes but this visual part of QBE seems to me not so hard (at least for you
:-)))
as it's only a really simple GUI on a simple qbe text file. After that you
call the
BDE with ExecuteQBE... and hop !
>> At then end we could use Proview in runtime without Paradox...
>> (You'll then have a star product even for Delphi's users...)
>
> BTW, iProView allows a lot of direct operations with tables and queries
> and it works under Runtime.
I've never tried it (shame on me !),but iProview does not let you create
news query does it ?
Vladimir Menkin
> I've never tried it (shame on me !),but iProview does not let you create
> news query does it ?
It does :-) You can create a new query using usual QBE interface :)
Vladimir
Côme de Christen
"Vladimir Menkin" <vmenki...@ITS-surveys.com> a écrit dans le message de news:
>> I've never tried it (shame on me !),but iProview does not let you create
>> news query does it ?
>
> It does :-) You can create a new query using usual QBE interface :)
Under runtime ? Then I'm lost...
Vladimir Menkin
> Do you mean a query itself? Or another dialog?
I meant dialog for selecting a table for a new query
Vladimir
Vladimir Menkin
> Under runtime ? Then I'm lost...
Under runtime :) It allows also directly view and edit tables, to do a lot of
other things, even to edit method source in forms and libraries via Internet.
There is no difference for iProView to work under Runtime or under full Paradox.
Vladimir
Tony McGuire
Why not present your own 'dialog' for selecting the table, then write a
..qbe, then open on the .qbe?
Now, multiple tables linked on one or more fields might be touchy. But it
sounds like you just want a 'new' query to open, and that we can do without
the dialog.
Côme de Christen
I've just tested menuaction(MenuQueryNew) in runtime and it doesn't work
Have you got a secret Vladimir ?
"Côme de Christen" <come.de...@wanadoo.fr> a écrit dans le message de news:
41712b7e$1_3@cnews...
Vladimir Menkin
Cфme de Christen wrote:
> I've just tested menuaction(MenuQueryNew) in runtime and it doesn't work
> Have you got a secret Vladimir ?
:-)
I made comlete emulation of QBE interface via HTML. I still don't see my last
message, so I repeat it here:
-----------
iProView allows also directly view and edit tables, to do a lot of other things,
even to edit method source in forms and libraries using browser. There is no
Come de Christen
Of course...you already have done the job !!
You have all my admiration, once again :-)
"Vladimir Menkin" <vmenki...@ITS-surveys.com> a ecrit dans le message de news:
4171434f_3@cnews...
Larry DiGiovanni
Côme de Christen wrote:
> No I'm sure not ! But in France for instance such ISP (they exist of
course)
> are exception
Well, I've only worked with Interland and Verio over here.
The rate of mergers/acquisitions in the ISP market makes spotting trends
hard and relying on them perilous. So EMMV.
--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources.