RE: Jet Database Driver Documentation

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 06/14/04

  • Next message: Rob Schneider: "Re: Jet Database Driver Documentation" 
    Date: Mon, 14 Jun 2004 03:28:45 GMT

    Hi Llelan D.,

    First of all, I would like to confirm my understanding of your issue. From
    your description, I understand that you need to get documentation of SQL
    syntax and SQL function that Jet 4 driver supports. If there is any
    misunderstanding, please feel free to let me know.

    Based on my research, if you have Access installed on your machine, a file
    named JETSQL40.CHM will be included in the following folder: (I have Access
    2003 installed. Please adjust according to version and language.)

    C:\Program Files\Common Files\Microsoft Shared\OFFICE11\1033\JETSQL40.CHM

    This help file contains specifications for Jet SQL statements and
    functions. For T-SQL statements, it can be easily found in SQL server book
    online of in MSDN.

    HTH.

    Kevin Yu
    =======
    "This posting is provided "AS IS" with no warranties, and confers no
    rights."

  • Next message: Rob Schneider: "Re: Jet Database Driver Documentation"

    Relevant Pages

    • Re: mysql apache - page never finish loading
      ... why should you always have one on SQL function calls? ... This method is used heavily in my production environment and has yet to fail me. ... Saves having to look through error logs. ...
      (comp.lang.php)
    • Re: What is wrong?
      ... snipped too much of that response; look again;-) The quoted snippet to ... about how to setup to call the procedure to test and debug -- using SQL. ... procedure from RPG when it could be done simply instead, ... Another would be to create an SQL function, either using the SQLP language or SQLRPGLE. ...
      (comp.sys.ibm.as400.misc)
    • Re: Obtaining SQL insert auto generated key from query within JSP
      ... Do a search on that sql function, ... The SQL for retrieving a serial number assigned by the DBMS is very specific to the DBMS. ... I've not used JSP so if JSP magically unifies this, that would be surprising but welcome! ... I couldn't find anything in the JSTL SQL section to allow access to the statement, which is what Derby uses to get generated keys. ...
      (comp.lang.java.programmer)
    • Re: mysql apache - page never finish loading
      ... probably is coming across an error but for some reason keeps ... you really should have that on all your sql queries. ... why should you always have one on SQL function calls? ...
      (comp.lang.php)
    • Re: convert Money to Words
      ... All our applications are web based. ... And they are using MS report server to ... > not in SQL, that translates the number into words. ... >> there an SQL function that can do this or am I going to have to write the ...
      (microsoft.public.sqlserver.programming)