fabricated Recordsets

[ExtraD]

Hi,

I found this code to create disconected recordsets. But how can i use a decimal value. Because he creates always a Long type of field.


Set oRS = New ADODB.Recordset
oRS.CursorLocation = adUseClient
oRS.CursorType = adStatic
oRS.LockType = adLockBatchOptimistic
'Add a few fields
With oRS.Fields
.Append "LastName", adDecimal, , adFldIsNullable
.Append "FirstName", adDecimal, , adFldIsNullable
.Append "HireDate", adDecimal
End With
oRS.Open


thanx,

 

[Golom]

Looks OK (except that adStatic should be adOpenStatic). It creates fields of type decimal (adDecimal = 14) on my system.

Bit strange though. I would assume that "LastName" and "FirstName" would be text fields and "HireDate" would be a date field ... or are you just experimenting at this point?

 

[ExtraD]

Thats correct i'm experimenting to get decimals in it. but i was to fast i think. i found the option NumericScale and Precision.

thanks for the quick response!