Home » SQL & PL/SQL » SQL & PL/SQL » From Access2002 to Oracle (10g / win)
From Access2002 to Oracle [message #428117] Tue, 27 October 2009 05:18 Go to next message
Pepask2000
Messages: 10
Registered: October 2009
Junior Member
Hello everybody!

i am a real beginner in oracle. Nearly 2 years before i started with php and sql and now i have to change our existing environment to oracle.

I have created a php view for our oracle database. At this moment we are doing subquerys in access2002. But i got the order to leave access and directly do the querys in oracle.

I am a little stuck at this point as i am using >= = and <= restrictions.

My old access query looks like this:

SELECT DISTINCT
  SUM(IIF(DATE()-DATEVALUE(A.DSP_VK_DSP_APO_LIEFERDATUM_G)<= 1 ,1,0)),
  SUM(IIF(DATE()-DATEVALUE(A.DSP_VK_DSP_APO_LIEFERDATUM_G) = 2 ,1,0)),
  SUM(IIF(DATE()-DATEVALUE(A.DSP_VK_DSP_APO_LIEFERDATUM_G)>= 3 ,1,0))
FROM
    pas_ABSTIMM as A
WHERE
  A.DLG_EK_APO_ART_ID = '00000'
  AND A.DLG_VK_ABW_STATUS_ID < 95
  AND A.DLG_VK_APO_LIEFERDATUM_GEPLANT >= $adat2
  AND A.DLG_VK_APO_LIEFERDATUM_GEPLANT <= $edat2


and i tried to switch it to oracle. But i think i did some errors that you would find immediately.

Here is how i created the new query:

SELECT DISTINCT
  SUM(CASE WHEN trunc(DATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') <= 1 ,1,0)),
  SUM(CASE WHEN trunc(DATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')  = 2 ,1,0)),
  SUM(CASE WHEN trunc(DATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') >= 3 ,1,0))
FROM
    ABSTIMM
WHERE
  DLG_EK_APO_ART_ID = '00000'
  AND DLG_VK_ABW_STATUS_ID < 95
  AND DLG_VK_APO_LIEFERDATUM_GEPLANT >= $adat2
  AND DLG_VK_APO_LIEFERDATUM_GEPLANT <= $edat2


Could you give me a helping hand?

Thanks for your Help

Sebastian

[Updated on: Tue, 27 October 2009 05:29]

Report message to a moderator

Re: From Access2002 to Oracle [message #428118 is a reply to message #428117] Tue, 27 October 2009 05:30 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
DATE() is sysdate in Oracle
Re: From Access2002 to Oracle [message #428120 is a reply to message #428117] Tue, 27 October 2009 05:34 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well. A few points :

1) Case syntax is wrong

2) There is no "DATE()" function in oracle, it "sysdate"

3) You should use a DATE datatype for the DSP_VK_DSP_APO_LIEFERDATUM_G, then the to_date wouldn't be neccessary.

The Documentation to look up specific commands is here. (There are usually examples in every command description, for example for CASE)

Re: From Access2002 to Oracle [message #428124 is a reply to message #428117] Tue, 27 October 2009 05:38 Go to previous messageGo to next message
Pepask2000
Messages: 10
Registered: October 2009
Junior Member
Hello Frank,

thank you very much for you help. This information brings me a little step closer to solving my problem.

When i open my php file that contains the querys then i get the error message:

Warning: ociexecute() [function.ociexecute]: ORA-00907: missing right parenthesis in C:\wamp\www\shared\adodb5\drivers\adodb-oci8.inc.php on line 1073
907: ORA-00907: missing right parenthesis

A colleague of mine told me that this might be of missing brackets but i can not find the missing one.

Should i give you the whole code or is that not necessary?

Sebastian
Re: From Access2002 to Oracle [message #428126 is a reply to message #428124] Tue, 27 October 2009 05:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Without the code it is hard to know where the parenthesis is missing.

Use SQL*PLus and copy and paste your queries in it, then you will know where something is wrong.

Regards
Michel
Re: From Access2002 to Oracle [message #428127 is a reply to message #428124] Tue, 27 October 2009 05:43 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You should use the documentation to get the syntax, not guessing.
CASE <..>
WHEN ..
THEN ..
<ELSE ..>
END
is how you should use case
Re: From Access2002 to Oracle [message #428130 is a reply to message #428120] Tue, 27 October 2009 05:46 Go to previous messageGo to next message
Pepask2000
Messages: 10
Registered: October 2009
Junior Member
ThomasG wrote on Tue, 27 October 2009 11:34
Well. A few points :

1) Case syntax is wrong

2) There is no "DATE()" function in oracle, it "sysdate"

3) You should use a DATE datatype for the DSP_VK_DSP_APO_LIEFERDATUM_G, then the to_date wouldn't be neccessary.



Hello Thomas,

thank you for your help.

I didn´t work with CASE WHEN before so i dont understand it completely unless i get it to work and have the direct difference. I think the field DSP_VK_DSP_APO_LIEFERDATUM_G is TEXT and may not be changed by me. We are using a software called PAS2000 that uses the oracle database. So if i change something in the database structure i can go an get my papers.

So it´s a little bit complicated.

Sebastian
Re: From Access2002 to Oracle [message #428133 is a reply to message #428117] Tue, 27 October 2009 05:53 Go to previous messageGo to next message
Pepask2000
Messages: 10
Registered: October 2009
Junior Member
Hello Michel,

here is the whole code:

<?php
$startzeit = explode(" ", microtime());
$startzeit = $startzeit[0]+$startzeit[1];

	include('../../shared/adodb5/adodb.inc.php');
	include('../../shared/adodb5/tohtml.inc.php');
	include('../../CRM/includes/mod_db4_pas.inc.php');

	$db4->debug=true;  
	
$apo_produkte = $_GET['pr'];
if (is_null($apo_produkte)) $apo_produkte=0;

$apo_adat = $_GET['adat'];
if (is_null($apo_adat)) $apo_adat=date("01.m.Y");

$apo_edat = $_GET['edat'];
if (is_null($apo_edat)) $apo_edat=date("d.m.Y");

$adat2 = "'".substr($apo_adat,6,11)."-".substr($apo_adat,3,2)."-".substr($apo_adat,0,2)."'";
$edat2 = "'".substr($apo_edat,6,11)."-".substr($apo_edat,3,2)."-".substr($apo_edat,0,2)."'";

if ($apo_adat == "") {
   $apo_adat_where ="";
   $apo_adat_text="";   
} Else {
   $apo_adat_where = " AND (DLG_VK_APO_LIEFERDATUM_GEPLANT >= $adat2) ";
   $apo_adat_text=" Auftragpositionsnummer=$apo_adat";
} 

if ($apo_edat == "") {
   $apo_edat_where ="";
   $apo_edat_text="";   
} Else {
   $apo_edat_where = " AND (DLG_VK_APO_LIEFERDATUM_GEPLANT <= $edat2) ";
   $apo_edat_text=" Auftragpositionsnummer=$apo_edat";
} 

switch ($apo_produkte) {
 case 0:
  $apo_whereprodukte="DLG_EK_APO_ART_ID = '00000'"; 
  $apo_ifclause="
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') <= 1 ,1,0),
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')  = 2 ,1,0),
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') >= 3 ,1,0)";
  $apo_text="Magermilch";
  break;
 case 1:
  $apo_whereprodukte="DLG_EK_APO_ART_ID = '01000'"; 
  $apo_ifclause="
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') <= 3 ,1,0),
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')  = 4 ,1,0),
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') >= 4 ,1,0)";
  $apo_text="Magermilchkonzentrat";
  break;
 case 2:
  $apo_whereprodukte="DLG_EK_APO_ART_ID = '02000'"; 
  $apo_ifclause="
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') <= 3 ,1,0),
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')  = 4 ,1,0),
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') >= 4 ,1,0)";
  $apo_text="Rohmilch";
  break;
 case 3:
  $apo_whereprodukte="DLG_EK_APO_ART_ID = '03000'"; 
  $apo_ifclause="
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') <= 3 ,1,0),
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')  = 4 ,1,0),
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') >= 4 ,1,0)";
  $apo_text="Sahne";
  break;
 case 4:
  $apo_whereprodukte="DLG_EK_APO_ART_ID = '09000'"; 
  $apo_ifclause="
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') <= 3 ,1,0),
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')  = 4 ,1,0),
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') >= 4 ,1,0)";
  $apo_text="Ziegenrohmilch";
  break;
 case 5:
  $apo_whereprodukte="DLG_EK_APO_ART_ID IN 
	('00001','00005','00006','02001','02002','02003','02004','02006','02007','02012','02100','02010',
	 '02200','03001','03002','03003','03005','04000','04001','04003','04004','04005','04006','04007',
	 '04008','04009','04010','04011','04100','09020','09100','09200','09220','09235')"; 
  $apo_ifclause="
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') <= 1 ,1,0),
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')  = 2 ,1,0),
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') >= 3 ,1,0)";
  $apo_text="&Uuml;brig Fl&uuml;ssig";
  break;
 case 6:
  $apo_whereprodukte="(DLG_EK_APO_ART_ID BETWEEN '05000' AND '08999' OR
	A.DLG_EK_APO_ART_ID IN ('09001','09060','09065','09080','09090','09230','09240') OR
	A.DLG_EK_APO_ART_ID BETWEEN '80135' AND '82550')"; 
  $apo_ifclause="
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') <= 1 ,1,0),
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')  = 2 ,1,0),
	CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') >= 3 ,1,0)";
  $apo_text="Fest";
  break;
}

$apo_dbmm_sql="
SELECT DISTINCT
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') <= 3 ,1,0)),
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')  = 4 ,1,0)),
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') >= 4 ,1,0))
FROM
    ABSTIMM
WHERE
    DLG_EK_APO_ART_ID = '00000'
	AND DLG_VK_ABW_STATUS_ID < 95
	AND DLG_VK_APO_LIEFERDATUM_GEPLANT >= $adat2
	AND DLG_VK_APO_LIEFERDATUM_GEPLANT <= $edat2";

$apo_dbmmk_sql="
SELECT DISTINCT
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') <= 3 ,1,0)),
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')  = 4 ,1,0)),
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') >= 4 ,1,0))
FROM
    ABSTIMM
WHERE
    DLG_EK_APO_ART_ID = '01000'
	AND DLG_VK_ABW_STATUS_ID < 95
	AND DLG_VK_APO_LIEFERDATUM_GEPLANT >= $adat2
	AND DLG_VK_APO_LIEFERDATUM_GEPLANT <= $edat2";

$apo_dbrm_sql="
SELECT DISTINCT
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') <= 3 ,1,0)),
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')  = 4 ,1,0)),
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') >= 4 ,1,0))
FROM
    ABSTIMM
WHERE
    DLG_EK_APO_ART_ID = '02000'
	AND DLG_VK_ABW_STATUS_ID < 95
	AND DLG_VK_APO_LIEFERDATUM_GEPLANT >= $adat2
	AND DLG_VK_APO_LIEFERDATUM_GEPLANT <= $edat2";
	
$apo_dbsahne_sql="
SELECT DISTINCT
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') <= 3 ,1,0)),
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')  = 4 ,1,0)),
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') >= 4 ,1,0))
FROM
    ABSTIMM
WHERE
    DLG_EK_APO_ART_ID = '03000'
	AND DLG_VK_ABW_STATUS_ID < 95
	AND DLG_VK_APO_LIEFERDATUM_GEPLANT >= $adat2
	AND DLG_VK_APO_LIEFERDATUM_GEPLANT <= $edat2";

$apo_dbzrm_sql="
SELECT DISTINCT
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') <= 3 ,1,0)),
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')  = 4 ,1,0)),
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') >= 4 ,1,0))
FROM
    ABSTIMM
WHERE
    DLG_EK_APO_ART_ID = '09000'
	AND DLG_VK_ABW_STATUS_ID < 95
	AND DLG_VK_APO_LIEFERDATUM_GEPLANT >= $adat2
	AND DLG_VK_APO_LIEFERDATUM_GEPLANT <= $edat2";

$apo_dbubr_sql="
SELECT DISTINCT
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') <= 1 ,1,0)),
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')  = 2 ,1,0)),
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') >= 3 ,1,0))
FROM
    ABSTIMM
WHERE
    DLG_EK_APO_ART_ID IN 
	('00001','00005','00006','02001','02002','02003','02004','02006','02007','02012','02100','02010',
	 '02200','03001','03002','03003','03005','04000','04001','04003','04004','04005','04006','04007',
	 '04008','04009','04010','04011','04100','09020','09100','09200','09220','09235')
	AND DLG_VK_ABW_STATUS_ID < 95
	AND DLG_VK_APO_LIEFERDATUM_GEPLANT >= $adat2
	AND DLG_VK_APO_LIEFERDATUM_GEPLANT <= $edat2";
	
$apo_dbfest_sql="
SELECT DISTINCT
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') <= 1 ,1,0)),
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')  = 2 ,1,0)),
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') >= 3 ,1,0))
FROM
    ABSTIMM
WHERE
    (DLG_EK_APO_ART_ID BETWEEN '05000' AND '08999' OR
	DLG_EK_APO_ART_ID IN ('09001','09060','09065','09080','09090','09230','09240') OR
	DLG_EK_APO_ART_ID BETWEEN '80135' AND '82550')
	AND DLG_VK_ABW_STATUS_ID < 95
	AND DLG_VK_APO_LIEFERDATUM_GEPLANT >= $adat2
	AND DLG_VK_APO_LIEFERDATUM_GEPLANT <= $edat2";
		
	$ADODB_FETCH_MODE = ADODB_FETCH_NUM;
	
	include('../../CRM/includes/mod_functions.inc.php');
	
	$recordSet = $db4->Execute($apo_dbmm_sql); 
    
    if ($recordSet == false) {
		die ('error');
	}
	
	$rsdbmmk = $db4->Execute($apo_dbmmk_sql); 
    
    if ($rsdbmmk == false) {
		die ('error2');
	}

	$rsdbrm = $db4->Execute($apo_dbrm_sql); 
    
    if ($rsdbrm == false) {
		die ('error3');
	}
	
	$rsdbsahne = $db4->Execute($apo_dbsahne_sql); 
    
    if ($rsdbsahne == false) {
		die ('error4');
	}
	
	$rsdbzrm = $db4->Execute($apo_dbzrm_sql); 
    
    if ($rsdbzrm == false) {
		die ('error5');
	}
	
	$rsdbubr = $db4->Execute($apo_dbubr_sql); 
    
    if ($rsdbubr == false) {
		die ('error6');
	}
	
	$rsdbfest = $db4->Execute($apo_dbfest_sql); 
    
    if ($rsdbfest == false) {
		die ('error7');
	}
?>
Re: From Access2002 to Oracle [message #428138 is a reply to message #428117] Tue, 27 October 2009 06:06 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
As previously stated look up CASE in the oracle documentation, it contains examples. There's a link in ThomasG's post above.
Re: From Access2002 to Oracle [message #428146 is a reply to message #428117] Tue, 27 October 2009 06:26 Go to previous messageGo to next message
Pepask2000
Messages: 10
Registered: October 2009
Junior Member
Hi everybody.

I suppose it is this part that is wrong:

SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') <= 1 THEN 1 ELSE 0 END)),
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')  = 2 THEN 1 ELSE 0 END)),
	SUM(CASE WHEN trunc(SYSDATE()-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy') >= 3 THEN 1 ELSE 0 END))


because the case when does not work. That is what i understood.

But the point is, i can look as often on the page with the case expressions but i don´t find the point where i am wrong. I think i wrote it exactly like on the helping page.

I am going nuts!

Sebastian
Re: From Access2002 to Oracle [message #428150 is a reply to message #428146] Tue, 27 October 2009 06:29 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Sysdate is still wrong. Dont use "()" after it.

On each line there is one more closing bracket than opening bracket, so that is wrong too.

You have to run the query in SQL*Plus until you get it right. There oracle will show you exactly what is wrong where.
Re: From Access2002 to Oracle [message #428171 is a reply to message #428117] Tue, 27 October 2009 07:04 Go to previous message
Pepask2000
Messages: 10
Registered: October 2009
Junior Member
Ah! Damn, sometimes you are the horse, not the rider!

After changing it to:

SUM(CASE WHEN trunc(SYSDATE-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')) <= 1 THEN 1 ELSE 0 END),
	SUM(CASE WHEN trunc(SYSDATE-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy'))  = 2 THEN 1 ELSE 0 END),
	SUM(CASE WHEN trunc(SYSDATE-TO_DATE(DSP_VK_DSP_APO_LIEFERDATUM_G, 'dd.mm.yyyy')) >= 3 THEN 1 ELSE 0 END)


It works!

Thank you very much

Sebastian
Previous Topic: Foreign key constraint error
Next Topic: How to save cm² ?
Goto Forum:
  


Current Time: Sun Dec 04 02:55:52 CST 2016

Total time taken to generate the page: 0.10288 seconds