Own IWBasic 2.x ? -----> Get your free upgrade to 3.x now.........
Started by Rock Ridge Farm (Larry), May 09, 2006, 07:11:30 AM
0 Members and 1 Guest are viewing this topic.
QuoteImportant The tables throughout this appendix are only guidelines and show commonly used names, ranges, and limits of SQL data types. A given data source might support only some of the listed data types, and the characteristics of the supported data types can differ from those listed.
QuoteText Use for text or combinations of text and numbers, such as addresses, or for numbers that do not require calculations, such as phone numbers, part numbers, or postal codes. Stores up to 255 characters. The FieldSize property controls the maximum number of characters that can be entered. Memo Use for lengthy text and numbers, such as notes or descriptions. Stores up to 63,999 characters. Number Use for data to be included in mathematical calculations, except calculations involving money (use Currency type). Stores 1, 2, 4, or 8 bytes; stores 16 bytes for Replication ID (GUID). The FieldSize property defines the specific Number type. Date/Time Use for dates and times. Stores 8 bytes. Currency Use for currency values and to prevent rounding off during calculations. Stores 8 bytes. AutoNumber Use for unique sequential (incrementing by 1) or random numbers that are automatically inserted when a record is added. Stores 4 bytes; stores 16 bytes for Replication ID (GUID). Yes/No Use for data that can be only one of two possible values, such as Yes/No, True/False, On/Off. Null (Null: A value you can enter in a field or use in expressions or queries to indicate missing or unknown data. In Visual Basic, the Null keyword indicates a Null value. Some fields, such as primary key fields, can't contain Null.) values are not allowed. Stores 1 bit. OLE Object Use for OLE objects (such as Microsoft Word documents, Microsoft Excel spreadsheets, pictures, sounds, or other binary data) that were created in other programs using the OLE (OLE: A program-integration technology that you can use to share information between programs. All Office programs support OLE, so you can share information through linked and embedded objects.) protocol. Stores up to 1 gigabyte (limited by disk space). Hyperlink Use for hyperlinks (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.). A hyperlink can be a UNC path (universal naming convention (UNC): A naming convention for files that provides a machine-independent means of locating the file. Rather than specifying a drive letter and path, a UNC name uses the syntax \\server\share\path\filename.) or a URL (Uniform Resource Locator (URL): An address that specifies a protocol (such as HTTP or FTP) and a location of an object, document, World Wide Web page, or other destination on the Internet or an intranet, for example: http://www.microsoft.com/.). Stores up to 2048 characters. There is one more data type but it calls an Access wizard which I won't work I suppose unless you are building in Access. It's name is Lookup.SQL Data Types....http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsql_data_types.aspVikkiÃƒâ€šÃ,Â
Quote from: Vikki on June 15, 2006, 06:02:29 PMI know I'm jumping in late but I just thought I'd add the following information to this thread just in case it might be helpful to someone else.