int64

[BobGeezer]

Hi All,

The field data type of otNumber does not seem to be supported
by DOA. We get an error: "Unsupported variable type" when
trying to declare a parameter for an insert query using the
member function DeclareVariable(string, integer)

In our project, we are using DOA for Delphi to build an Oracle
database solution from an Interbase one. Owing to the fact
that int64 is now a central part of systems, please can you
help implement the basic data type of otNumber? Is there a
work-around we haven't spotted?

I can supply some simple demonstration code if needed...

 

[Marco Kalter]

You will need to use an otFloat or otString to represent an Int64.

 

[BobGeezer]

Hi Marco,
This is a poor solution. I guess it's a limitation of Oracle itself rather than a limitation of DOA? Thanks for the help. So, otFloat it is....

 

[Andrey Maximenko. Ukraine]

Hi Marco!
Are U planing to use int64 in the next versions of DOA?

uses db.pas
{ TLargeintField }
  Largeint = Int64

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Douglas MMM]

Hi!
Has anything improved on this?

 

[Douglas MMM]

UP

 

[Douglas MMM]

more than 10 years passed and nothing to improve this routine ... abandonment?