1. Erick Siliezar
  2. PowerBuilder
  3. Friday, 29 May 2020 17:09 PM UTC

Hi everyone, currently I migrated my PowerBuilder 2019 code from 32 bit to 64 bit. Unfortunately I was using codemax20.ocx 32bit. Now my application is failing because I don't have codemax20.ocx 64bit. I was wondering if there is a "power builder SQL syntax highlighter" component, or something that I can use to Highlight my SQL syntax.

Something like this:

//My comments

SELECT Field1, Field2

FROM Table

WHERE Field1 > 0;

 

Any advise will be appreciated 

Accepted Answer
Brad Wery Accepted Answer Pending Moderation
  1. Friday, 29 May 2020 17:58 PM UTC
  2. PowerBuilder
  3. # Permalink

It looks like Scintilla has a 64 bit version. Look for the - Full 64-bit download (1.8M) - link (you'll be interested in the SciLexer.dll file found in the zip file):

https://www.scintilla.org/SciTEDownload.html

Roland has an example of how to use it in a PB application. His editor object is very well written:

https://www.topwizprogramming.com/freecode_pbeditor.html

He has a method already developed to set the syntax to SQL.

Although not 64 bit, here's an example of it being used in a PB application:

https://powertothebuilder.com/UltimateSuiteSQL.html

Comment
  1. Erick Siliezar
  2. Friday, 29 May 2020 20:15 PM UTC
I will review it, thank you
  1. Helpful
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Friday, 29 May 2020 17:32 PM UTC
  2. PowerBuilder
  3. # 1

Greetings, Erick - 

Unless you have to change for some reason, I would consider keeping my app as 32-bit if the SQL syntax highlighting provided by this OCX is important.

Regards, John

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.