Need help on direction

[narayana...@yahoo.com]

Here is the setup.

We have a Desktop Application that uses Paradox tables. This
application is for ticket sales. Now we developed online web
application to sell the tickets in ASP.NET. We desinged new database
in SQL Server for all the web functionalties. But the core events and
seating data resides in Paradox. Both Desktop application and the new
Web application are going to use the same data in Paradox for Ticket
sales.

We have a logic developed in SQL Server stored procedure for Best
Available seating. When a user selects events and no of seats, a SQL
Server SP is called and data is updated for hold. All these stuff
happens in SQL Server. So no worries as we thought of sync'ing the
data with script that can run once a day.

But now the Client wants all the seat holds and updates happen
realtime in Paradox first when a Sale happens online, and then update
the SQL Server Database (if our program needs). I don't know how to go
from here. Because all the logic resides in SQL Server.

I am thinking of the following solutions to this:

1. Add Paradox as Linked Server to the SQL Server database, and grab
the main event and seating data from Paradox and pass it on to the
Stored Procedure logic that was alraedy developed for Best Available
seating search.
Here:
a. I can add Paradox as Linked Server
b. I don't know how to call Paradox from SP. We can use OpenQuery.
I am not sure how efficiant is that. Also, I don't know whether it
really works when 2 applications using the Paradox database.

2. Accessing Paradox from .NET Directly and passing on the the data to
a Temporary SQL Server table and then calling the SP that was already
written.
a. Not sure whether its possible to call .Paradox from .NET
without any problems.

3. Writing some scripts in Delphi to communicate with Paradox, and
write the requried query results to a table in SQL Server and then SQL
Server starts using that table for existing logic. Delphi script
(proc/func), will be caled by .NET or SP (If possible), passing
arguments.

a. Does it make any sense? Is it a good solution? Is it possible at
all?

4. Any other best solution? We cannot re-write code in Paradox again
for this. We cannot trash the logic written in SPs.

Paradox 9, IIS 6, SQL Server 2000 all reside in one Win 2k3 box.

Any gurus? Veterans? who can suggest the best move?

I would really appreciate your genious input on this.

Thanks a lot

-KLN

[narayan...@gmail.com]

On Aug 3, 12:17 pm, narayanankatw...@yahoo.com wrote:
> Here is the setup.
>

> We have a Desktop Application that usesParadoxtables. This

> application is for ticket sales. Now we developed online web
> application to sell the tickets in ASP.NET. We desinged new database

> inSQLServerfor all the web functionalties. But the core events and
> seating data resides inParadox. Both Desktop application and the new
> Web application are going to use the same data inParadoxfor Ticket
> sales.
>
> We have a logic developed inSQLServerstoredprocedurefor Best
> Available seating. When a user selects events and no of seats, aSQLServerSP is called and data is updated for hold. All these stuff
> happens inSQLServer. So no worries as we thought of sync'ing the

> data with script that can run once a day.
>
> But now the Client wants all the seat holds and updates happen

> realtime inParadoxfirst when a Sale happens online, and then update
> theSQLServerDatabase (if our program needs). I don't know how to go

> from here. Because all the logic resides inSQLServer.
>
> I am thinking of the following solutions to this:
>

> 1. AddParadoxas LinkedServerto theSQLServerdatabase, and grab
> the main event and seating data fromParadoxand pass it on to theStoredProcedurelogic that was alraedy developed for Best Available

> seating search.
> Here:
> a. I can addParadoxas LinkedServer

> b. I don't know how to callParadoxfrom SP. We can use OpenQuery.

> I am not sure how efficiant is that. Also, I don't know whether it
> really works when 2 applications using theParadoxdatabase.
>

> 2. AccessingParadoxfrom .NET Directly and passing on the the data to
> a TemporarySQLServertable and then calling the SP that was already
> written.
> a. Not sure whether its possible to call .Paradoxfrom .NET
> without any problems.
>
> 3. Writing some scripts in Delphi to communicate withParadox, and
> write the requried query results to a table inSQLServerand thenSQLServerstarts using that table for existing logic. Delphi script

> (proc/func), will be caled by .NET or SP (If possible), passing
> arguments.
>
> a. Does it make any sense? Is it a good solution? Is it possible at
> all?
>
> 4. Any other best solution? We cannot re-write code inParadoxagain
> for this. We cannot trash the logic written in SPs.
>

> Paradox9, IIS 6,SQLServer2000 all reside in one Win 2k3 box.

>
> Any gurus? Veterans? who can suggest the best move?
>
> I would really appreciate your genious input on this.
>
> Thanks a lot
>
> -KLN

Anyone? Any help? No thoughts et all?

[narayan...@gmail.com]

Anyone pls?
-KLN

[Inabón Yunes]

For the past 5 years I've been entering data using Pdx9.
My data is almost ready to be publish but I need a little help here. I want
to accompany it with an application where users can do intelligent searches
in the database.
The information includes wildlife species and I users to be able to enter a
criteria (10 total) where an undelying table updates according to the
entries made.
For example, a person saw a bird and only got to see the color of its legs,
bill and eyes.
How do I make a form where a person enters the color of eyes he/she saw and
the table is filtered for only those species that have black eyes, for
example. Then when the same user enters the color of its legs, the table
updates to only those species that have black eyes and yellow legs, if that
is the color entered. Again, when the person enters the color of its bill,
it only sees in the table the species that meet all the three criteria.
I was working with variables for the field and using queries to display the
result on the canDepart method but everytime I run a query and use the
table, it erases the index keys, actually, no record is erased it just
doesn't have the index keys anymore. The result is a non indexed answer
table.

If any of you can help me and direct me in the right direction, I think I
can do this.

Thanks!