Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #5517

SQL Bug in ADS

From Martin <spam@spam.spam>
Newsgroups comp.lang.clipper.visual-objects
Subject SQL Bug in ADS
Message-ID <rkTEt.1$KU.0@fx22.fr7> (permalink)
Date 2013-07-15 15:05 +0100

Show all headers | View raw


Using AXSQLCDX

contents of my csql string

INSERT INTO opt351d 
(PR_Order,PR_Line,PR_Process,PR_Leaf,PR_Seq,PR_Date,PR_Time,PR_Qty) 
select 
opt012d.BC_Order,opt012d.bc_line,opt011d.pl_process,opt012d.bc_leaf,opt012d.bc_genseq,opt011d.pl_date,opt011d.pl_time,opt011d.pl_qty 
from opt011d inner join opt012d on opt011d.PL_barcode=opt012d.bc_key 
where opt011d.pl_process in('30','40','41','45','50','60','70') and 
opt011d.pl_pdate <'2010-01-01';


oSvr	:= DBServer{ csql, , , "AXSQLCDX" }
oSvr:Close()

Works in SQL in ARC32


Description:     Error 5021:  The pointer given was not valid.  Parameter 2
FileHandle:      0
FileName:
FuncPtr:         0x00000000
FuncSym:         INIT
GenCode:         27 : Undefined class
MaxSize:         0
MethodSelf:      INSERT INTO opt351d  select 
b.BC_Order,b.bc_line,l.pl_process,b.bc_leaf,b.bc_genseq,l.pl_date,l.pl_time,l.pl_qty 
from opt011d l inner join opt012d b on opt011d.PL_barcode=opt012d.bc_key 
where opt011d.pl_process in('30','40','41','45','50','60','70') and o
Operation:
OsCode:          0 : Successful completion
Severity:        ERROR
SubCode:         5021
SubCodeText:     %V1s FileHandle: %s
SubstituteType:  NIL
SubSystem:       AXSQLCDX
Tries:           0

Back to comp.lang.clipper.visual-objects | Previous | Next — Next in thread | Find similar | Unroll thread


Thread

SQL Bug in ADS Martin <spam@spam.spam> - 2013-07-15 15:05 +0100
  Re: SQL Bug in ADS Martin <spam@spam.spam> - 2013-07-19 14:11 +0100
  Re: SQL Bug in ADS Oscar Hdz <ohernandez@liasa.com> - 2013-07-26 13:54 -0700

csiph-web