Hi Sergio,
Sorry to have misslead you, (as usual) Norman is right, I am ashamed :-[ .
Andre.
Norman Palardy wrote:
On Jun 28, 2006, at 5:25 AM, Andre Kuiper wrote:
Hi Sergio,
You can use : rs.IdxField(i).Value.Type
where rs is the recordset containing the fieldschema
The returned numbers with the typenames are listed in the LR under
Database-Class.
An example you can find here:
http://support.realsoftware.com/feedback/download.php?file=6220&rid=19112
HTH,
Greetings,
Andre
Look up FieldSchema in the LR as part of Database
FieldSchema returns a RecordSet with five fields: ColumnName (
String), FieldType ( Integer), IsPrimary ( Boolean), NotNull (
Boolean), and Length in bytes ( Integer) for Text fields.
FieldType is described in the LR
The method above gives you the RB type for each column in the
recordset returned not the type for each column in the database table
you got the field schema for
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|