Re: How to use COLLATE to SORT ADO table by international sorting rules?

From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 03/04/04

  • Next message: Richard Speiss: "Re: The Trouble With Transactions" 
    Date: Thu, 4 Mar 2004 16:02:56 +0300

    ADO does not accept SQL at all and pass command text to OLEDB provider. Look
    documentation for your DBMS for SQL syntax - it is different for different
    OLEDB providers.

    //------------------------------------------
    Regards,
    Vassiliev V. V.
    http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
    ADO.Net
    http://www.oledbdirect.com - The fastest way to access MS SQL Server,
    MS Jet (Access) and Interbase (through OLEDB)

    "Pavel Polesny" <arnie@atlas.cz> ???????/???????? ? ???????? ?????????:
    news:opr4b5lyzgibbtzu@localhost...
    I ned to sort tables by international sorting rules, but Delphi ADO does
    seem to accept COLLATE SQL statement...

    Can anybody help?

    Pavel

  • Next message: Richard Speiss: "Re: The Trouble With Transactions"

    Relevant Pages

    • Re: Using parameters with the low level ADO API, trying to avoid the memory leaks.
      ... MS ADO passes SQL directly to OLEDB provider. ...
      (borland.public.delphi.database.ado)
    • Re: ADO call to user defined function
      ... support all the features, which supported by OLEDB. ... OLEDB provider for SQL ... Server was developed some time ago, when SQL Server did not have UDF's. ... is why ADO does not support them as well. ...
      (microsoft.public.data.ado)
    • Re: ALTER (or CREATE) TABLE/Ole Object Data Type in MS Access
      ... "Ole Object" data type, but I need to be able to do it using SQL syntax ... My database is an Access 2003 database, and the SQL ... ADOX is an "extension" to ADO intended for creating/modifying schema and security. ...
      (microsoft.public.vb.general.discussion)
    • Re: C# Windows Service Problem
      ... Note that connecting to SQL server and using DSO are ... I don't use an OLEDB provider anywhere in the program.. ... The error message refers to the OLEDB provider for DSO, ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: Insert Field Database only fails when I try to use filters
      ... you should be able to see the SQL it has generated by using ... because the OLEDB provider that gets the data /probably/ ... the OLEDB provider seems to require that you specify a "table alias" (which ... or even cut out the \c parameter altogether, ...
      (microsoft.public.word.mailmerge.fields)