Results 1 to 5 of 5

Thread: [Resolved] SQL Datatype tags

Threaded View

  1. Apr 17th, 2007, 10:10 AM #1
    Arachnid13
    Arachnid13 is offline

    Thread Starter
    Hyperactive Member Arachnid13's Avatar
    Join Date
    Jan 2003
    Location
    England
    Posts
    327

    Resolved [Resolved] SQL Datatype tags

    Does anyone know of a function which formats data from a MS Access field by adding the correct tags and converting it to a string?

    to explain a bit better say you have a field of unknown type aField

    Code:
    Select Case aField.Type
Case adDate

    strReturnString = "#" & cstr(aField.Value) & "#"
    ...
End Select
    I would make this myself however looking at the DataTypeEnum in the Object Browser reveals a number of data types i don't recognise and some are little confusing such as the fact that there is a 'adDate' and a 'adDBDate'
    Last edited by Arachnid13; Apr 25th, 2007 at 04:25 AM. Reason: Resolved
    Do you wake up in the morning feeling sleepy and grumpy? Then you must be Snow White
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width