Hello,
is someone using this combination of components sucefull?
i have a lot of problems with it and don't think it's a problem from
Elevate.

Thanks Fritz

Friedrich,

<< is someone using this combination of components sucefull?  i have a lot
of problems with it and don't think it's a problem from Elevate. >>

What are the basic functionality issues that you're having problems with ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Friedrich,
>
> What are the basic functionality issues that you're having problems
> with ?

Hello Tim,

mostly all

the DAElevateDBDrv from Remobjects is not tested i think
All fields are treaded as readonly , but this i have found a way and
fixed it,
but i have not found a way to set the correct autoincvalue for fields
like
"ID"  INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT
BY 1) NOT NULL

there must be a way for returning the lastautinc value or a
"genearator" to call

Greetings Fritz

Hello Tim,

after a lot of debuging on the Data abstract part, i have found a way
that it should work, but now i have a problem:

If a client inserts a new row his identy-column gets a value in
negative Range. Thats all ok but in the server part i have to change
the value of the identy-column to a valid value for the actual Table.

i have the table an the column but now the Question:
Is there a way tu receive a new value for a identity column via script?
I need these value for returning to the Client and also for change the
value in the server part
I have not found anything in the Docs.

Thanks
Fritz

Friedrich,

<< Is there a way tu receive a new value for a identity column via script?
>>

Sure, like this:

SCRIPT (OUT LastIdentity INTEGER)
BEGIN
  DECLARE TempStmt STATEMENT;

  PREPARE TempStmt FROM 'INSERT INTO MyTable VALUES (?, ?)';
  EXECUTE TempStmt USING LastIdentity, 'Test';
END

INSERT statements automatically use INOUT parameter types so that you can
retrieve their values after the insert in the same parameters that were
passed in.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Fritz, what has been your experience with ElevateDB and Data Abstract? We are currently trialling Data Abstract and would like to make it work with ElevateDB. However the initial testing comes up with an error:

Access violation in module DAElevateDBDrv.dad. Read of Address 00000000.

So it looks to me like it is not really available even though it is in the list?

Thanks
Rick.


"Friedrich Westermann" wrote:

Hello,
is someone using this combination of components sucefull?
i have a lot of problems with it and don't think it's a problem from
Elevate.

Thanks Fritz

Rick,

Per email: checking this out and will see what's going on later this week.

--
Tim Young
Elevate Software
www.elevatesoft.com