ORACLE with jBASIC

Hi Guys and Gals,

I am just wondering is it possible to run a ORACLE command on a jBASE program and retreive the data. If any ideas please share let us know...


NJOY LIFE TO THE FULLEST

Hi,



Have you informed by the SQLSELECT command?

Try this command on jShell.

SQLSELECT * FROM FBNK.CUSTOMER

It will show all the data of customer file in tables & row format. or you can append WHERE,, EQ operand like ORACLE SQLPLUS.

Hi all,

I am a person who interest in Jbase and also about your topic for SQLSELECT command, if we need to make a statement of SQLSELECT for joining two tables the same as SQLPLUS of Oracle for example :
"SQLSELECT A.CUSTOMER.CODE,A.SHORT.NAME,B.ACCOUNT.NUMBER,B.ACCOUNT.TITLE.1
FROM FBNK.ACCOUNT B,FBNK.CUSTOMER A
WHERE A.CUSTOMER.CODE=B.CUSTOMER AND A.CUSTOMER ='100196'
"
but there is still an error appeared for this statement. And for my thinking about this, the column name "SHORT.NAME" does not recognize as column name because '.'.
Any one please help me about this.

thank you.
Somboon

We (TIS Consultants) developed a data extraction tool for Banks using jBASE with Oracle.
The tool can extract data directly from Oracle very fast.

Hi,

Could you guide me about your suggestions (instructions or any link to see more details) ?

try to replace dot to underscore, it should works.