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.