delphi2010 使用oracle连接符号报错,报符号无效,是不是使用+号需要特殊的处理方式,
代码:
ClientDataSet1.CommandText:='SELECT a.work_order "Work Order", f.part_no "Part No", '
+'d.pdline_name "Production Line", b.process_name "Process", '
+'DECODE (current_status, ''1'', ''NG'', '''') "Status",'
+'e.terminal_name "Terminal",'
+'TO_CHAR (a.out_process_time, ''YYYY/MM/DD HH24:MI'') "Time", '
+'c.emp_name "Operator", k.customer_name "Customer",'
+'a.customer_sn "Customer SN", a.box_no "Box No",'
+'a.carton_no "Carton No", a.pallet_no "Pallet No", a.qc_no "QC Lot",'
+'a.rework_no "Rework No", a.wip_qty "WIP QTY", a.VERSION "Version",'
+'j.customer_partno "Customer PartNo" '
+'FROM sajet.g_sn_travel a,'
+'sajet.sys_process@pro b, '
+'sajet.sys_emp@pro c,'
+'sajet.sys_pdline@pro d,'
+'sajet.sys_terminal@pro e,'
+'sajet.sys_part@pro f, '
+'sajet.sys_customer@pro k,'
+'sajet.g_sn_customer_partno j '
+'WHERE a.serial_number in ('+mmo1
+') AND a.process_id = b.process_id '
+' AND a.terminal_id = j.terminal_id(+)'
+' AND a.serial_number = j.serial_number(+)'
+' AND a.emp_id = c.emp_id(+) '
+' AND a.pdline_id = d.pdline_id(+)'
+' AND a.terminal_id = e.terminal_id(+)'
+' AND a.model_id = f.part_id(+)'
+' AND a.customer_id = k.customer_id(+)'
+' ORDER BY out_process_time;' ;delphioracle
代码:
ClientDataSet1.CommandText:='SELECT a.work_order "Work Order", f.part_no "Part No", '
+'d.pdline_name "Production Line", b.process_name "Process", '
+'DECODE (current_status, ''1'', ''NG'', '''') "Status",'
+'e.terminal_name "Terminal",'
+'TO_CHAR (a.out_process_time, ''YYYY/MM/DD HH24:MI'') "Time", '
+'c.emp_name "Operator", k.customer_name "Customer",'
+'a.customer_sn "Customer SN", a.box_no "Box No",'
+'a.carton_no "Carton No", a.pallet_no "Pallet No", a.qc_no "QC Lot",'
+'a.rework_no "Rework No", a.wip_qty "WIP QTY", a.VERSION "Version",'
+'j.customer_partno "Customer PartNo" '
+'FROM sajet.g_sn_travel a,'
+'sajet.sys_process@pro b, '
+'sajet.sys_emp@pro c,'
+'sajet.sys_pdline@pro d,'
+'sajet.sys_terminal@pro e,'
+'sajet.sys_part@pro f, '
+'sajet.sys_customer@pro k,'
+'sajet.g_sn_customer_partno j '
+'WHERE a.serial_number in ('+mmo1
+') AND a.process_id = b.process_id '
+' AND a.terminal_id = j.terminal_id(+)'
+' AND a.serial_number = j.serial_number(+)'
+' AND a.emp_id = c.emp_id(+) '
+' AND a.pdline_id = d.pdline_id(+)'
+' AND a.terminal_id = e.terminal_id(+)'
+' AND a.model_id = f.part_id(+)'
+' AND a.customer_id = k.customer_id(+)'
+' ORDER BY out_process_time;' ;delphioracle
解决方案 »
- 请教大侠,delphi7应用程序从SQL Server2000下载数据丢失的问题!急!..
- delphi 用API实现套接字断开重连(主要是在客户端检测服务器是否断开)
- 怎样调用人家写好的基类
- 我写了一个小程序,但关闭运行的exe后线程中却还有
- 如何在Delphi中安装PGraphic控件?在线等
- DELPHI如何调用VC做的COM?
- 菜鸟问:DBGRID的用法,马上结帖。
- 查找符合条件的记录
- 为什么TServerSocket有时不能连接???急。。。
- 深圳某外资企业招聘软件工程师一名,有意者请联系[email protected]
- Delphi7 三层架构 连接数据库
- 想再学多门语言扩宽门路,大大们给点意见
+应该不会有问题,可能是SQl的连接没处理好。
SELECT a.work_order "Work Order", f.part_no "Part No", d.pdline_name "Production Line", b.process_name "Process", DECODE (current_status, '1', 'NG', '') "Status",e.terminal_name "Terminal",TO_CHAR (a.out_process_time, 'YYYY/MM/DD HH24:MI') "Time", c.emp_name "Operator", k.customer_name "Customer",a.customer_sn "Customer SN", a.box_no "Box No",a.carton_no "Carton No", a.pallet_no "Pallet No", a.qc_no "QC Lot",a.rework_no "Rework No", a.wip_qty "WIP QTY", a.VERSION "Version",j.customer_partno "Customer PartNo" FROM sajet.g_sn_travel a,sajet.sys_process@pro b, sajet.sys_emp@pro c,sajet.sys_pdline@pro d,sajet.sys_terminal@pro e,sajet.sys_part@pro f, sajet.sys_customer@pro k,sajet.g_sn_customer_partno j WHERE a.serial_number in ('2B2401SAN9PLG',
'2B2400XNB9PLG',
'2B2400YTB9PLG',
'2B2401DVY9PLG',
'2B2401A499PLG',
'2B2399XSHDFSG') AND a.process_id = b.process_id AND a.terminal_id = j.terminal_id(+) AND a.serial_number = j.serial_number(+) AND a.emp_id = c.emp_id(+) AND a.pdline_id = d.pdline_id(+) AND a.terminal_id = e.terminal_id(+) AND a.model_id = f.part_id(+) AND a.customer_id = k.customer_id(+) ORDER BY out_process_time;
'2B2400XNB9PLG',
'2B2400YTB9PLG',
'2B2401DVY9PLG',
'2B2401A499PLG',
'2B2399XSHDFSG') AND a.process_id = b.process_id AND a.terminal_id = j.terminal_id(+) AND a.serial_number = j.serial_number(+) AND a.emp_id = c.emp_id(+) AND a.pdline_id = d.pdline_id(+) AND a.terminal_id = e.terminal_id(+) AND a.model_id = f.part_id(+) AND a.customer_id = k.customer_id(+) ORDER BY out_process_time;
这句应该有问题,试试:
+'WHERE a.serial_number in ('+''''+mmo1+''''+')