Hi Tilo,
> could you please check, whether SQL, TOOSMALL or NOMEDIA are
> defined in your context by inserting something like:
>
> #if defined(SQL)
> #error SQL is already defined
> #endif
>
> into your DBMSrvMsg_Error.hpp, right in front of the enum ErrorID.
I did this:
45 class DBMSrvM
I'm trying to build a c++ application to use ODBC with MaxDB and I'm finding
the ODBC Manual for MaxDB a little difficult to follow.
I have been trying to use:
#include "/opt/sapdb/indep_prog/incl/WINDOWS.H"
#include "/opt/sapdb/indep_prog/incl/sql.h"
#include "/opt/sapdb/indep_prog/incl/sqlext
>Can anyone suggest me that is it possible to create view with
>"order by"
>clause...
This is not possible. Views are Sets/Relations that have no sort order. Sorting
is applicable only to cursors. If you want only a 'canned query', then you
could create a stored procedure that executes the sel
When i try to create a Stored Procedure with the following code:
CREATE DBPROC CREATE_ESITI_TEMP (IN PID_SESSIONE FIXED(10,0))
AS
BEGIN
DELETE FROM "ATLAS"."ESITI_TEMP" WHERE ID_SESSIONE=:PID_SESSIONE;
DELETE FROM "ATLAS"."ESITI_TEMP_BOTTOM" WHERE ID_SESSIONE=:PID_SESSIONE;
INSERT INTO "ATLAS"."ES
When i try to create a Stored Procedure with the following code:
CREATE DBPROC CREATE_ESITI_TEMP (IN PID_SESSIONE FIXED(10,0))
AS
BEGIN
DELETE FROM "ATLAS"."ESITI_TEMP" WHERE ID_SESSIONE=:PID_SESSIONE;
DELETE FROM "ATLAS"."ESITI_TEMP_BOTTOM" WHERE ID_SESSIONE=:PID_SESSIONE;
INSERT INTO "ATLAS"."ES
When i try to create a Stored Procedure with the following code:
CREATE DBPROC CREATE_ESITI_TEMP (IN PID_SESSIONE FIXED(10,0))
AS
BEGIN
DELETE FROM "ATLAS"."ESITI_TEMP" WHERE ID_SESSIONE=:PID_SESSIONE;
DELETE FROM "ATLAS"."ESITI_TEMP_BOTTOM" WHERE ID_SESSIONE=:PID_SESSIONE;
INSERT INTO "ATLAS"."ES
I re-read your response ...
Your installation seems to be alright and I understand that all your
paths exists.
So let's see if there is a /etc/opt/sdb that could break the update.
If it is there, give us the contents.
> -Ursprüngliche Nachricht-
> Von: Weinmann, Alexander
> Gesendet: Di
Hello.
I have a query that works fine:
SELECT "ROOT"."t1".*,
"ROOT"."t2"."descripcion"
FROM"ROOT"."t1","ROOT"."t2"
WHERE "ROOT"."t1"."cod"= "ROOT"."t2"."cod" (+)
But when I create the corresponding view of that query:
CREATE VIEW "base"
(
"t2.field",
"t1.*"
)
AS SELEC
Hello.
Can anyone suggest me that is it possible to create view with "order by"
clause...
I have tried to create views with thah clause and I have got an error:
"Syntax error or access violation;-3014 POS(204) Invalid end of SQL
statement."
thank you very much in advance
__
Hi,
Please download the corrected DLLs (one for PHP 4, one for PHP 5) from the
following link. They should fix the error.
An official update will be available on the MySQL page soon.
http://sapmats-de.sap-ag.de/download/download.cgi?
id=52Z1TIKJY0FX2XGR9QPLJBWX50FXPCNZ4E8Y3AVC9J4N2T1ZEF
Regard
OK, it is getting more interesting now:
The _OPTSAPDB is an "internal" entry which is not relevant.
The tool says that it cannot find your
/var/opt/sapdb/indep_data - Directory
Does this directory exist? (There should also be
somewhere a subdirectory DEMO where you will find the working
directo
Hello Alexei,
there is the parameter _PACKET_SIZE defining the maximum size of
one communication packet sent by the database. The maximum length
of the statement directly depends on it, but there's no easy formula
that derives directly from the _PACKET_SIZE the maximum length of
an SQL statement
12 matches
Mail list logo
