Results 1 to 3 of 3

Thread: RDB and ADO

  1. #1
    John Mulligan Guest

    Default RDB and ADO

    Hi. I am using an RDB ODBC driver with ASP and I am having a problem retrieving rows from a query that accesses a table that contains the RDB "BIGINT" data type. If I execute the following SQL statement from the table and request only the fields that are NOT of the type "BIGINT" the SQL returns the expected rows (select name, hire_date from employee.) If the SQL includes columns that are type "BIGINT" like (select * from employee) then the query returns no rows and the EOF/BOF indicators are set to TRUE. This is true for a VB app that uses ADO to fetch rows from the table.

  2. #2
    Join Date
    Dec 1969

    Default RE: RDB and ADO

    How big *is* a BIGINT in RDB? ADO (at least as used by ASP?) won&#039t handle anything larger than 32 bits. <BR><BR>If BIGINT is a DECIMAL value, you are also hosed--VBS doesn&#039t properly handle DECIMAL.<BR><BR>I don&#039t know RDB, but if its SQL processor is capable of CONVERT or CAST operations, try changing the field to a VARCHAR:<BR><BR>SELECT Convert(bigintField, VARCHAR), ..... FROM table<BR>or<BR>SELECT Cast(bigintField...) ... FROM table<BR><BR>[whatever the syntax of Cast/Convert is in RDB&#039s variant of SQL]<BR><BR>

  3. #3
    John Mulligan Guest

    Default RE: RDB and ADO

    Thanks. I will check the things you suggest. You were very helpful. John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts