• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Re: SQL in CL

Kevin_McAlexand

Active Member
Re: SQL in CL

Yes.

Example below:

SQL STM('UPDATE CUR002P SET CUFLAG=''F'' +
WHERE CUCGSA=''BAM'' AND CUFLAG<>''P''')


______________________________ Reply Separator _________________________________
Subject: SQL in CL
Author: jdeworld@jdelist.com at INTERNET
Date: 11/16/00 2:43 PM


Is it possible to embed SQL statements within a CL program to update
database files? If it is then how to do this?

Thanks in advance.
*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
RE: SQL in CL

Thanks for this Kevin

I have tried this but it does not work. Do you need a different package to
use the SQL command?

Thanks
Vimal
 

Kevin_McAlexand

Active Member
Re[2]: SQL in CL

Not sure.

The quotes are not double quotes, but two single quotes. This is the
only problem I had figuring it out. The example I sent you is one we
have been using for several months in a CL.


______________________________ Reply Separator _________________________________
Subject: RE: SQL in CL ~~1270:1283
Author: jdeworld@jdelist.com at INTERNET
Date: 11/16/00 4:15 PM


Thanks for this Kevin

I have tried this but it does not work. Do you need a different package to
use the SQL command?

Thanks
Vimal




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=1283

*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
Top