Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #5517
| 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 |
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
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