BDE Migration to UniDAC with Sybase

AlexP · Post by **AlexP** » Thu 21 Apr 2011 09:15

Hello,

We have added the Size property for parameters; this feature will be included in the next build.
We plan to add support for working with the sql.ini file in the next nearest build.

sasdua · Post by **sasdua** » Thu 21 Apr 2011 12:36

Thanks for the information.

Can you please let me know any deadline when the next nearest build will be ready. I can inform to my leads.

Thanks
AS

AlexP · Post by **AlexP** » Thu 21 Apr 2011 12:50

Hello,

The next nearest build will be released approximately in two months.

sasdua · Post by **sasdua** » Thu 19 May 2011 14:53

Hi ,

I am using the below statement in Tuniquery component

if exists(select * from table where col1 ='test)
select A else select B

The above was working fine in BDE and not with Unidac

Can you please let us know the issue

Thanks
AS

AlexP · Post by **AlexP** » Fri 20 May 2011 08:02

Hello,

I cannot reproduce the problem.
The following SQL code:

Code: Select all

if exists(select * from test where ID = 1)  
select 'A' else select 'B'

is executed in UniQUery without errors.
Please specify the error message you are getting when executing this query.

sasdua · Post by **sasdua** » Fri 20 May 2011 13:58

Hi Alex,

I am getting the error message SQL statement doesn't return rows

Regards
AS

AlexP · Post by **AlexP** » Mon 23 May 2011 06:45

Hello,

I could not reproduce the problem.
Please send a complete small sample to alexp*devart*com to demonstrate it including a script to create and fill a table.

sasdua · Post by **sasdua** » Mon 23 May 2011 10:19

Hi Alex ,

Please find a sample code

create table temp123 (
cconsol int not null,
message varchar(255)
)

insert into temp123 ( cconsol, message )
values ( 1234, 'test message' )

In Tuniquery component, we have include the below query
if exists (select 1 from temp123 where cconsol= 1234)
select reviewable="Y" else select reviewable="N"

And once its executed, in the data editor we are getting the error msg
SQL Statement doesnt return rows

Please let us know what can be the issue.

When we run the query in BDE or backend we get the output as
reviewable as N

AlexP · Post by **AlexP** » Mon 23 May 2011 12:18

Hello,

I was able to reproduce this error only with Sybase 12.5, but I could not reproduce it with Sybase 15. We will notify you when we solve the problem.

sasdua · Post by **sasdua** » Mon 23 May 2011 12:36

Thanks Alex,

Yeah we are using Sybase 12.5 client to connect to sybase database from unidac.

sasdua · Post by **sasdua** » Tue 31 May 2011 14:58

Hi Alex,

Any update on the above issue

Also , while running the stored proc on Windows 7 Machine with Sybase 15 client , we are getting the error msg Output Parameters will only be returned from this stored procedure when you use only parameter markers to pass parameter values.

Any idea what can be the issue?

Regards
AS

AlexP · Post by **AlexP** » Wed 01 Jun 2011 11:22

Hello,

I cannot reproduce this problem.
I created the following procedure on the 12.5 and 15 servers:

Code: Select all

CREATE PROCEDURE dbo.sp_test(@a_in int, @a_out int output)
AS
BEGIN
     SET @a_out = @a_in+1 
END

and it was executed without errors from the client of the 15 version on win7.
Please send us the procedure script and I will try to reproduce this error once more.

sasdua · Post by **sasdua** » Thu 02 Jun 2011 14:33

Hi Alex,

There is no variable got Result generated on Win7 with Sybase 15 for a stored proc and Sybase 12.5 used to generate a parameter called Result. Hence the issue has been resolved now and we are not getting the error.

Can you please let us know if Unidac supports Rave Reports. We need to migrate to Rave 7.7 on Delphi 10 and also with Unidac?

AlexP · Post by **AlexP** » Mon 06 Jun 2011 11:47

Hello,

To create reports in Rave Report using UniDAC components as data access components, you should use the Rave Report component of TrvDataSetConnection bound to UniDAC DataSet components (TUniTable, TUniQuery, etc).

sasdua · Post by **sasdua** » Mon 06 Jun 2011 16:13

Thanks Alex. We are able to use it.

Can you please update us on the solution to the Uniquery which was working on Sybase 15 Client and not on Sybase 12.5 as we are stuck on it for sometime.

Regards
AS