Re: Possible to get field names and types in a table without executing a query?



Matthew Persico wrote:

So now I need one for every database?

For every database you need to support yes, not all engines will return the exact same data with a query if no results and that also not in the same format.

But each database is 00% gauranteed to support what it documents it supports and return it in the format it has documented it returns it in :)
.

Relevant Pages

  • Re: How do I scroll through multiple pages of JDBC data from a servlet?
    ... >> To use this your database needs to support LIMIT. ... >don't support some syntax for limiting query results. ... So this method becomes unusable if sorting is ...
    (comp.lang.java.databases)
  • Re: Getting entries from an SQL database with datetime parameter
    ... format is what you want. ... funtion to convert date string into date time accordig to your needs. ... your database, you will run into troubles comparing date to string. ... > hard coded a query to populate the datagrid, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DateTime field showing unwanted Time
    ... The time portion is 12:17:04 AM regardless of what table or database I open. ... If I run a query on a date field and convert it to a double format, ... the system automatically changes my ...
    (microsoft.public.access.setupconfig)
  • VBScript format database query to HTML
    ... I'm trying to write a script that will query a database, format the ... results into an html table, ...
    (microsoft.public.scripting.vbscript)
  • Re: out-of-range data error (2147217913)
    ... SQL statement with this date? ... > SQL Server 2000 database. ... > settings are OK, users are set to "British English", and if you query ... you seem to have to use mm/dd/yyyy format in the ...
    (microsoft.public.vb.database.ado)