Board index » delphi » Delphi4 with ORACLE, MSSQL and SYSBASE simultanously

Fran?ois Mori

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Delphi4 with ORACLE, MSSQL and SYSBASE simultanously

Hi !

I have an application that already support SYBASE and MSSQL 6.5 and
MSSQL 7.
Now, this application must also support ORACLE (New for me).

I know that a Number(6,0) is supposed to be an integer.

Delphi seems to declare NUMBER(6,0) as a TFloatField the probleme is
that the TField is already declared as a TIntegerField to support MSSQL
and SYBASE.
An error that meens "Waiting for an INTEGER but FLOAT was find" occurs
when I open my query, which is normal.

Question : How can I force delphi to declare a TIntegerField when a
NUMBER(6,0) is declared in ORACLE ?

 
Lush

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Delphi4 with ORACLE, MSSQL and SYSBASE simultanously


Fran?ois Morin <fra...@interlinx.qc.ca> ??? a
????:3A25BD9F.F4C41...@interlinx.qc.ca...

Quote
> Hi !

> I have an application that already support SYBASE and MSSQL 6.5 and
> MSSQL 7.
> Now, this application must also support ORACLE (New for me).

> I know that a Number(6,0) is supposed to be an integer.

> Delphi seems to declare NUMBER(6,0) as a TFloatField the probleme is
> that the TField is already declared as a TIntegerField to support MSSQL
> and SYBASE.

> An error that meens "Waiting for an INTEGER but FLOAT was find" occurs
> when I open my query, which is normal.

> Question : How can I force delphi to declare a TIntegerField when a
> NUMBER(6,0) is declared in ORACLE ?

Hi!
Set parameter ENABLE INTEGERS to TRUE in your Oracle alias. Unfortunaly only
Oracle SQL Link has this parameter. I didn't find anything like one in
another Oracle ODBC drivers. That is why I think you have to use only Oracle
SQL Link. It's very large limitation but you haven't other choice.

Regards. Lusha.

Lush

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Delphi4 with ORACLE, MSSQL and SYSBASE simultanously


Fran?ois Morin <fra...@interlinx.qc.ca> ??? a
????:3A25BD9F.F4C41...@interlinx.qc.ca...

Quote
> Hi !

> I have an application that already support SYBASE and MSSQL 6.5 and
> MSSQL 7.
> Now, this application must also support ORACLE (New for me).

> I know that a Number(6,0) is supposed to be an integer.

> Delphi seems to declare NUMBER(6,0) as a TFloatField the probleme is
> that the TField is already declared as a TIntegerField to support MSSQL
> and SYBASE.

> An error that meens "Waiting for an INTEGER but FLOAT was find" occurs
> when I open my query, which is normal.

> Question : How can I force delphi to declare a TIntegerField when a
> NUMBER(6,0) is declared in ORACLE ?

Hi!
Set parameter ENABLE INTEGERS to TRUE in your Oracle alias. Unfortunaly only
Oracle SQL Link has this parameter. I didn't find anything like one in
another Oracle ODBC drivers. That is why I think you have to use only Oracle
SQL Link. It's very large limitation but you haven't other choice.

Regards. Lusha.

Fran?ois Mori

Delphi Developer
Wed, 21 May 2003 07:36:08 GMT

Re:Delphi4 with ORACLE, MSSQL and SYSBASE simultanously


Thank you !
  I think I will be able to do something with that.

Quote
Lusha wrote:
> Fran?ois Morin <fra...@interlinx.qc.ca> ??? a
> ????:3A25BD9F.F4C41...@interlinx.qc.ca...

>> Hi !

>> I have an application that already support SYBASE and MSSQL 6.5 and
>> MSSQL 7.
>> Now, this application must also support ORACLE (New for me).

>> I know that a Number(6,0) is supposed to be an integer.

>> Delphi seems to declare NUMBER(6,0) as a TFloatField the probleme is
>> that the TField is already declared as a TIntegerField to support MSSQL
>> and SYBASE.

>> An error that meens "Waiting for an INTEGER but FLOAT was find" occurs
>> when I open my query, which is normal.

>> Question : How can I force delphi to declare a TIntegerField when a
>> NUMBER(6,0) is declared in ORACLE ?

> Hi!
> Set parameter ENABLE INTEGERS to TRUE in your Oracle alias. Unfortunaly only
> Oracle SQL Link has this parameter. I didn't find anything like one in
> another Oracle ODBC drivers. That is why I

Other Threads

1. Select a SQL Database , Interbase , Oracle , Sysbase or MSSQL ? Easy , Reliable and Fast ?

2. MSSQL DMO and Delphi4

3. Anyone using delphi4 and MSSQL 7 without problems?????

4. Delphi4, MSSQL server7, UpdateSQL and memo fields problem

5. Problem to open a query in Delphi4 for MSSQL server 7.0

6. MsSQL server 6,5 and Delphi4

7. ** TQuery VS TTable Delphi4 MSSQL

8. Delphi4 and msSQL Server

9. Delphi 3+2+ CPP-Builder simultanously

10. Using multilple Ports on client simultanously?