Hello, Im using Origin 6.0 Pro SR4 German version to extract data from a Oracle database via ODBC. The script looks like this:
%Z=select a.column1, b.column2 from table1 a, table2 b where a.column3 = b. column4 and a.column4 like 'ZZA%' ; label -s -n SQL2 %Z; SQL2.show = 0; dll -a db odbc60; db.dbsource$=LE-Test; repeat wks.ncols {del col(1)}; db.wksname$=%H; db.open(); db.autosetcol=1; db.read.autoaddcol=1; db.dbsql$=SQL2.text$; type -a ********************Abfrage*****************; type %Z; type ********************************************; type ""; db.read(0); db.close(); label -r SQL2;
The problem is, that I cant use the like-operator of the Oracle-Select within my Variable-Description %Z=select ...
If I use
label -n SQL2 select ....
instead, my select will be truncated if it is a bit longer (which is not unusual, if you work with Oracle :-) )
Does anybody know a solution for the described problem?
I assume that you have %Z="select .... like 'ZZA%C'"; Since Origin substitutes %A to %Z in literal string assignments, than %C will be replaced so you can not keep it as such. If that is the case, you will need to write %% to prevent substitution, like
Using ODBC to extract data
Posted - 11/10/2000 : 04:40:03 AM
