Strange behavior in PowerShell function returning DataSet/DataTable

by

You can use the comma operator to wrap the rows collection in an array so that when the array is unrolled you wind up with the original rows collection e.g.:

function lib_open_table([string] $sql) {
    $ds = lib_open_dataset $sql    
    return ,$ds.Tables[0]
}

Essentially you can’t prevent PowerShell from unrolling arrays/collections. The best you can do is workaround that behavior by wrapping the array/collection within another, single element array.

More Related Contents:

  1. Normalization in database management system
  2. Database development mistakes made by application developers [closed]
  3. Copying PostgreSQL database to another server
  4. Surrogate vs. natural/business keys [closed]
  5. Do you use source control for your database items? [closed]
  6. What is NoSQL, how does it work, and what benefits does it provide? [closed]
  7. database vs. flat files
  8. First name, middle name, last name. Why not Full Name?
  9. What are the design criteria for primary keys?
  10. Oracle (ORA-02270) : no matching unique or primary key for this column-list error
  11. How do I output the results of a HiveQL query to CSV?
  12. SQLite UPSERT / UPDATE OR INSERT
  13. Elastic search, multiple indexes vs one index and types for different data sets?
  14. In terms of databases, is “Normalize for correctness, denormalize for performance” a right mantra?
  15. Full-text search in NoSQL databases [closed]
  16. Can I do transactions and locks in CouchDB?
  17. Multivalued Fields a Good Idea?
  18. Elasticsearch query to return all records
  19. How to login and authenticate to Postgresql after a fresh install?
  20. Update the value of a field in database by 1 using codeigniter
  21. Versioning Database Persisted Objects, How would you? [closed]
  22. Sqlite in flutter, how database assets work
  23. What are the differences between B trees and B+ trees?
  24. Best design for a changelog / auditing database table? [closed]
  25. What is the default Precision and Scale for a Number in Oracle?
  26. What is caching?
  27. How to make a UUID in DynamoDB?
  28. Populating Spinner From SQLite Database Android
  29. CAP theorem – Availability and Partition Tolerance
  30. DB design for microservice architecture [closed]

Leave a Comment