Search results

+1 I've been using SQuirrel SQL for the last 3 years and it works fine with progress (9.1D, 9.1E, 10.2A, 10.2B)

I figured it out finally!!! In Windows 7, MS Sans Serif Doesn't exist, it has been replaced with MS Sans Serif Regular. That's why OpenEdge was confused, it couldn't find the font specified. To fix that problem, patch the regisrty as the following...

Hi Guys, I have a strange problem with a Progress application, here is what's happening: The application run fine on my workstation, the screen resolution is 1080*1920 and the font DPI is 96 (Screen size is 24") When I query SESSION:PIXELS-PER-ROW and SESSION:PIXELS-PER-COLUMN I get 21 and...

Alright then, I'll use substring instead. safe side is better :)

Hey Tamhas, I will try to use PREFIX and SUFFIX, I'll let you know how it goes. I'm looking at SUBSTR vs SUBSTRING. The look identical except one is a progress extension, and the other is ODBC compatible. I'm a bit confused. Which one should i be using ? Would it affect performance? Thanks, Bob

I've just found an interesting function: INSTR(). It fixed my problem, I'm using this code now: SELECT SUBSTRING(TESTSQL."Tenant_Suite_Budget"."GL_account_key",1,INSTR (TESTSQL."Tenant_Suite_Budget"."GL_account_key",':')- 1), SUBSTRING(TESTSQL."Tenant_Suite_Budget"."GL_account_key",INSTR...

Hi Guys, Unfortunately I'm getting a syntax error while trying this code: SELECT SUBSTRING(TESTSQL."Tenant_Suite_Budget"."GL_account_key",1,INDEX(TESTSQL."Tenant_Suite_Budget"."GL_account_key",':') - 1)...

Thanks mrobles, I'll give it a try and will let you know how it goes. I do realize that the database design is bad :( I'm a business intelligence specialist working on this old database, and I'm hitting serious issues with it, but changing the schema is not an option. What the developers did in...

Hi Guys, I have a problem with a field I have in one of my budget tables. The field is called GL_Account, but unfortunately it contains the GL account code and the budget key, separated using a column ":" For example: 104000:C0 Now my problem is that I can't link the budget table to the GL...