| 416 | === ISQLDataReader === |
| 417 | |
| 418 | {{{ |
| 419 | /// \brief |
| 420 | /// The FdoISQLDataReader interface provides a forward-only, read-only |
| 421 | /// iterator for reading relational table data. A reference to an |
| 422 | /// FdoISQLDataReader is returned from the SQLCommands ExecuteReader method. |
| 423 | /// The initial position of the FdoISQLDataReader interface is prior to the first item. |
| 424 | /// Thus, you must call ReadNext to begin accessing any data. |
| 425 | class FdoISQLDataReader: public FdoIDisposable |
| 426 | { |
| 427 | public: |
| 428 | ... |
| 429 | ... |
| 430 | ... |
| 431 | /// \brief |
| 432 | /// Returns true if the value of the specified column is null. |
| 433 | /// |
| 434 | /// \param index |
| 435 | /// Input the position of the column. |
| 436 | /// |
| 437 | /// \return |
| 438 | /// Returns true if the value is null. |
| 439 | /// |
| 440 | FDO_API virtual FdoBoolean IsNull(FdoInt32 index); |
| 441 | |
| 442 | /// \brief |
| 443 | /// Gets the data type of the column at the specified index. |
| 444 | /// |
| 445 | /// \param index |
| 446 | /// Input the position of the column. |
| 447 | /// |
| 448 | /// \return |
| 449 | /// Returns the type of the column. |
| 450 | /// |
| 451 | FDO_API virtual FdoDataType GetColumnType(FdoInt32 index); |
| 452 | |
| 453 | /// \brief |
| 454 | /// Gets the FDO property type of the column at the specified index. This is used |
| 455 | /// to indicate if a given column is a geometric property or a data property. If the column is |
| 456 | /// a FdoPropertyType_DataProperty, then GetColumnType can be used to find the data type of the column. |
| 457 | /// |
| 458 | /// \param index |
| 459 | /// Input the position of the column. |
| 460 | /// |
| 461 | /// \return |
| 462 | /// Returns the FDO property type of the column. |
| 463 | /// |
| 464 | FDO_API virtual FdoPropertyType GetPropertyType(FdoInt32 index); |
| 465 | |
| 466 | /// \brief |
| 467 | /// Gets the Boolean value of the specified column. No conversion is |
| 468 | /// performed, thus the column must be FdoDataType_Boolean or an |
| 469 | /// exception is thrown. |
| 470 | /// |
| 471 | /// \param index |
| 472 | /// Input the position of the column. |
| 473 | /// |
| 474 | /// \return |
| 475 | /// Returns the Boolean value |
| 476 | /// |
| 477 | FDO_API virtual FdoBoolean GetBoolean(FdoInt32 index); |
| 478 | |
| 479 | /// \brief |
| 480 | /// Gets the byte value of the specified column. No conversion is |
| 481 | /// performed, thus the column must be FdoDataType_Byte or an |
| 482 | /// exception is thrown. |
| 483 | /// |
| 484 | /// \param index |
| 485 | /// Input the position of the column. |
| 486 | /// |
| 487 | /// \return |
| 488 | /// Returns the byte value. |
| 489 | /// |
| 490 | FDO_API virtual FdoByte GetByte(FdoInt32 index); |
| 491 | |
| 492 | /// \brief |
| 493 | /// Gets the date time value of the specified column. No conversion |
| 494 | /// is performed, thus the column must be FdoDataType_DateTime or |
| 495 | /// an exception is thrown. |
| 496 | /// |
| 497 | /// \param index |
| 498 | /// Input the position of the column. |
| 499 | /// |
| 500 | /// \return |
| 501 | /// Returns the date and time value. |
| 502 | /// |
| 503 | FDO_API virtual FdoDateTime GetDateTime(FdoInt32 index); |
| 504 | |
| 505 | /// \brief |
| 506 | /// Gets the double-precision floating point value of the specified column. |
| 507 | /// No conversion is performed, thus the column must be of type |
| 508 | /// Double or an exception is thrown. |
| 509 | /// |
| 510 | /// \param index |
| 511 | /// Input the position of the column. |
| 512 | /// |
| 513 | /// \return |
| 514 | /// Returns the double value. |
| 515 | /// |
| 516 | FDO_API virtual FdoDouble GetDouble(FdoInt32 index); |
| 517 | |
| 518 | /// \brief |
| 519 | /// Gets the signed 16-bit integer value of the specified column. No conversion is |
| 520 | /// performed, thus the column must be FdoDataType_Int16 or an |
| 521 | /// exception is thrown. |
| 522 | /// |
| 523 | /// \param index |
| 524 | /// Input the position of the column. |
| 525 | /// |
| 526 | /// \return |
| 527 | /// Returns the FdoInt16 value. |
| 528 | /// |
| 529 | FDO_API virtual FdoInt16 GetInt16(FdoInt32 index); |
| 530 | |
| 531 | /// \brief |
| 532 | /// Gets the signed 32-bit integer value of the specified column. No conversion is |
| 533 | /// performed, thus the column must be FdoDataType_Int32 or an |
| 534 | /// exception is thrown. |
| 535 | /// |
| 536 | /// \param index |
| 537 | /// Input the position of the column. |
| 538 | /// |
| 539 | /// \return |
| 540 | /// Returns the FdoInt32 value. |
| 541 | /// |
| 542 | FDO_API virtual FdoInt32 GetInt32(FdoInt32 index); |
| 543 | |
| 544 | /// \brief |
| 545 | /// Gets the signed 64-bit integer value of the specified column. No conversion |
| 546 | /// is performed, thus the column must be FdoDataType_Int64 or an |
| 547 | /// exception is thrown. |
| 548 | /// |
| 549 | /// \param index |
| 550 | /// Input the position of the column. |
| 551 | /// |
| 552 | /// \return |
| 553 | /// Returns the FdoInt64 value. |
| 554 | /// |
| 555 | FDO_API virtual FdoInt64 GetInt64(FdoInt32 index); |
| 556 | |
| 557 | /// \brief |
| 558 | /// Gets the single-precision floating point value of the specified column. |
| 559 | /// No conversion is performed, thus the column must be FdoDataType_Single |
| 560 | /// or an exception is thrown. |
| 561 | /// |
| 562 | /// \param index |
| 563 | /// Input the position of the column. |
| 564 | /// |
| 565 | /// \return |
| 566 | /// Returns the single value |
| 567 | /// |
| 568 | FDO_API virtual FdoFloat GetSingle(FdoInt32 index); |
| 569 | |
| 570 | /// \brief |
| 571 | /// Gets the string value of the specified column. No conversion is |
| 572 | /// performed, thus the column must be FdoDataType_String or an |
| 573 | /// exception is thrown. |
| 574 | /// |
| 575 | /// \param index |
| 576 | /// Input the position of the column. |
| 577 | /// |
| 578 | /// \return |
| 579 | /// Returns the string value. |
| 580 | /// |
| 581 | FDO_API virtual FdoString* GetString(FdoInt32 index); |
| 582 | |
| 583 | /// \brief |
| 584 | /// Gets a LOBValue reference. The LOB is fully read in and data available. |
| 585 | /// Because no conversion is performed, the property must be FdoDataType_BLOB or |
| 586 | /// FdoDataType_CLOB etc. (a LOB type) |
| 587 | /// |
| 588 | /// \param index |
| 589 | /// Input the position of the column. |
| 590 | /// |
| 591 | /// \return |
| 592 | /// Returns the reference to LOBValue |
| 593 | /// |
| 594 | FDO_API virtual FdoLOBValue* GetLOB(FdoInt32 index); |
| 595 | |
| 596 | /// \brief |
| 597 | /// Gets a reference of the specified LOB property as a FdoBLOBStreamReader or |
| 598 | /// FdoCLOBStreamReader etc. to allow reading in blocks of data. |
| 599 | /// Because no conversion is performed, the property must be FdoDataType_BLOB |
| 600 | /// or FdoDataType_CLOB etc. (a LOB type) |
| 601 | /// Cast the FdoIStreamReader to the appropiate LOB Stream Reader. |
| 602 | /// |
| 603 | /// \param index |
| 604 | /// Input the position of the column. |
| 605 | /// |
| 606 | /// \return |
| 607 | /// Returns a reference to a LOB stream reader |
| 608 | /// |
| 609 | FDO_API virtual FdoIStreamReader* GetLOBStreamReader(FdoInt32 index); |
| 610 | |
| 611 | /// \brief |
| 612 | /// Gets the geometry value of the specified column as a byte array |
| 613 | /// in FGF format. No conversion is performed, thus the column |
| 614 | /// must be of Geometric type or an exception is thrown. |
| 615 | /// |
| 616 | /// \param index |
| 617 | /// Input the position of the column. |
| 618 | /// |
| 619 | /// \return |
| 620 | /// Returns the FGF byte array value. |
| 621 | /// |
| 622 | FDO_API virtual FdoByteArray* GetGeometry(FdoInt32 index); |
| 623 | }; |
| 624 | }}} |
| 625 | |