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: [email protected] 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
*************************************************************
Yes.
Example below:
SQL STM('UPDATE CUR002P SET CUFLAG=''F'' +
WHERE CUCGSA=''BAM'' AND CUFLAG<>''P''')
______________________________ Reply Separator _________________________________
Subject: SQL in CL
Author: [email protected] 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
*************************************************************