Local SQL v.s MS SQL Server

alex

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Local SQL v.s MS SQL Server

Does any one knows whether Delphi's Local SQL is compatible with MS SQL
Server.

As my experience , when you create a Blob Field using SQL , it is not
compatible.

for example

in Delphi ,

create table TableName
(
name char(12),
picture blob(1,5)
)

in MS SQL Server

create table TableName
(
name char(12),
picture image
)

How can I avoid it , and makes my app compatible accross different database
server ?

Steve Koters

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Local SQL v.s MS SQL Server

On Wed, 1 Dec 1999 23:26:14 +0800, "alex" <a...@iserver.honngi.com.tw>
wrote:

Quote

>Does any one knows whether Delphi's Local SQL is compatible with MS SQL
>Server.

>As my experience , when you create a Blob Field using SQL , it is not
>compatible.

>for example

>in Delphi ,

>create table TableName
>(
> name char(12),
> picture blob(1,5)
>)

>in MS SQL Server

>create table TableName
>(
> name char(12),
> picture image
>)

>How can I avoid it , and makes my app compatible accross different database
>server ?

Local SQL is a subset of SQL-92. But when it comes to creating tables
specialized Binary Large OBject column types (BLOB and CLOB), you will find
unreconcilable differences between the syntax of most database systems --
not just between local SQL and Microsoft SQL Server. While standards for
the SQL language have been established, there are no laws forcing software
developers to follow them (completely, partially, or at all). This is just
one area the SQL programmer has to get used to and deal with as best they
can.

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Steve Koterski "Health nuts are going to feel stupid someday,
Felton, CA lying in hospitals dying of nothing."
-- Redd Foxx

Helge Krus

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Local SQL v.s MS SQL Server

Quote

alex <a...@iserver.honngi.com.tw> wrote in message

news:823ect$jk0@netnews.hinet.net...

Quote

> Does any one knows whether Delphi's Local SQL is compatible with MS SQL
> Server.

No. Don't compare apples with pears. Delphi's Local SQL is an abstraction
layer over simple tables. SQL Server is a database server. You found one
syntax difference. This will be the same with SQL Server / Informix. But you
have to choice between the power of a database server and the no-charge BDE.
If man power is a cost, SQL Server can be the cheaper one.

Quote

> How can I avoid it , and makes my app compatible accross different
database
> server ?

If you need it, take as little as possible. Ignore most benefits and code
all by hand. If someone pays for you, compare the license cost for a server
with your salary.

Regards

Helge

Other Threads

1. Local SQL, works in MS SQL, not in local SQL

2. Using LOCAL-SQL or Transact-SQL with SQL-server and BDE

3. Delphi 3.0 - IIS ISAPI + SQL Server (MS) + BDE = SQL Server not found errors

4. MS SQL 6.5 vs Local SQL Query

5. ADOConnection String problem with TCP/IP on local MS SQL Server 7.0

6. BDE Alias to Local MS-SQL server

7. Local SQL challenge - for all you local SQL gurus:

8. SQL Databases - MS Sql Server 7 vs. Interbase

9. MS SQL Server -TCP - SQL Links

10. SQL-Link fur MS-SQL SERVER