Recent content by sergio7

D2009, Doa 4.1.1.0 I cannot use the query builder. When i try to use it this strange message apperar : query builder does currently sopports only select statements. If the SQL property is empty then the query builder say there is not an active session to connect to. With pl/sql developer all...

Tanks, I have found that this is true for number(n) with n

Ok, my table in this case contains only 1 record. The problem is that oracle stores the value as number(14) that is not a float and delphi treat this as float. Compare floating point is not so safe. Regards sergio sette

Hi, i have a field ('MYFIELD') defined as number(14) This number is mapped as TFloatField. I have a procedure like this : var d: Double; begin d:= 100; MyQuery['MYFIELD'].AsFloat := d; MyQuery.Post; // reloads the same record MyQuery.Open; if MyQuery['MYFIELD'].AsFloat = d then...

Hallo Markus, Delphi6 introduces new variant types and a true BCD field (TFMTBCDField). Are you planning to use bcd instead floats. Regards Sergio Sette

Markus, if i have a number like number(6, 2) this can be mapped as a TBCDField that internally is a Currency (fixed point). Why have you choosed to allways rapresents numbers as Floats ? Regards Sergio Sette

I have a problem with the TOracleDataset's IProviderSupport implementation. After a call to PSStartTransaction the PSInTransaction methods returns true but the TSession.InTransaction method returns false. Why ? Regards Sergio Sette

Hi, i have a little question. The number(x,y) oracle datatype is a fixed point type. DOA maps number(x, y) as Double (floating point type). Are there rounding errors risks ? I need to perform financial calculations and i have trouble using floats. Can i safetly use TFloatFields ? TIA Sergio Sette

Hi, i have a problem with TOracleDataset. In my application some users have a role with only select grants assigned. The OracleDataset component seems to not recognize this returning an updateable resul set. Is there a way to make the dataset read only if the user has only select rights...

The state of a component is a read only property (!!)

Ok, NUMBER(12,2) (i.e.) is not a float, but in DOA i see it as TFloatField, and not as TBCDField. This can be a problem because Float and BCD have not the same precision. Regards Sergio Sette

Why are number(x,y) fields mapped to TFloatField and not to TBCDField? Are in oracle numbers really floating point? Sergio Sette

In some cases i need to diasable automatic master/detail configuration. It's a way to do this ? TIA sergio sette